login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Fora/Discussieborden > forum zo te gebruiken in een ledensysteem met admi

forum zo te gebruiken in een ledensysteem met admi

Auteur: riekele - 02 januari 2005 - 10:50 - Gekeurd door: Dennisvb - Hits: 13093 - Aantal punten: 1.45 (10 stemmen)



voor alle mensen die geen zin hebben om een forum te scripten voor in hun ledensysteem.

aller eerst moet je 2 tabels maken in je database: forum en forumreacties
CREATE TABLE forum (
id int(11) NOT NULL auto_increment,
forumid int(11) NOT NULL default '1',
onderwerp varchar(100) default '0',
van varchar(25) default '0',
bericht text,
datum varchar(22) default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

en
CREATE TABLE forumreacties (
id int(11) NOT NULL auto_increment,
forumid int(10) NOT NULL default '0',
van varchar(20) NOT NULL default '',
datum varchar(22) NOT NULL default '',
bericht text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

bij de admin moet je even het password en de gebruikersnaam veranderen
en mijn login cookie heet 'login' dit moeten jullie even verranderen als dit bij jullie niet zo is. helaas kan ik moeilijk een voorbeeld geven omdat jullie je dan eerst moeten registreren op mijn site.

Code:
##forum.php##
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <html>
  2. <head>
  3. </head>
  4. <body>
  5. <center>
  6. <?php
  7. if ( !isset($_COOKIE['login'])){
  8. 	header("location: ?p=aanmelden");}
  9. if ($actie == "opstellen")
  10. {
  11.     ?>
  12. <form method="post">
  13. <table border="0" width="50%" cellspacing="0" cellpadding="0">
  14.   <tr>
  15.     <td width="100%">
  16.       <table border="1" width="100%" cellspacing="0" cellpadding="0">
  17.         <tr>
  18.           <td width="8%">Onderwerp</td>
  19.           <td width="92%"><input type="text" name="onderwerp"></td>
  20.         </tr>
  21.         <tr>
  22.           <td width="8%">Bericht</td>
  23.           <td width="92%" rowspan="3"><textarea name="bericht" rows=3 cols=20 wrap="on"></textarea></td>
  24.         </tr>
  25.         <tr>
  26.           <td width="8%">&nbsp;</td>
  27.         </tr>
  28.         <tr>
  29.           <td width="8%">&nbsp;</td>
  30.         </tr>
  31.         <tr>
  32.           <td width="100%" colspan="2">
  33.             <p align="center"><input type="submit" name="Verstuur" value="Verstuur"></td>
  34.         </tr>
  35.       </table>
  36.     </td>
  37.   </tr>
  38. </table>
  39. </form>
  40. <?
  41. if(!empty($_POST['Verstuur'])){
  42. $datum = date("d/m/Y h:i");
  43.  
  44. 	if($_POST["onderwerp"] != "" && $_POST["bericht"] != "")
  45. 	{
  46.         mysql_query("insert into forum (onderwerp,van,datum,bericht) values ('".$_POST["onderwerp"]."','".$_COOKIE["login"]."','".$datum."','".$_POST["bericht"]."')") or die(mysql_error());
  47. 		echo "Bericht verstuurd";
  48.  
  49. 	}
  50. 	else
  51. 	{
  52. 		echo "U moet alles wel goed invullen";
  53. 	}
  54. }
  55. }
  56. elseif ($actie == "bekijk")
  57. {
  58.  
  59.     $query4 = mysql_query("select * FROM forum WHERE id='".$_GET["id"]."' ORDER BY datum DESC");
  60.     $query2 = mysql_query("select * FROM forumreacties WHERE forumid='".$_GET["forumid"]."' ORDER BY datum DESC");
  61.     $row4 = mysql_fetch_object($query4);
  62.  
  63. ?>
  64. <table border="0" width="70%" cellspacing="0" cellpadding="0">
  65.   <tr>
  66.     <td width="100%">
  67.       <table border="1" width="100%" cellspacing="0" cellpadding="0">
  68.         <tr>
  69.           <td width="8%">Door</td>
  70.           <td width="92%"><? echo $row4->van; ?></td>
  71.         </tr>
  72.         <tr>
  73.           <td width="8%">Onderwerp</td>
  74.           <td width="92%"><? echo $row4->onderwerp; ?></td>
  75.         </tr>
  76.         <tr>
  77.           <td width="8%">Bericht</td>
  78.           <td width="92%" valign="top" rowspan="3"><?$row4->bericht; ?></td>
  79.         </tr>
  80.         <tr>
  81.           <td width="8%">&nbsp;</td>
  82.         </tr>
  83.         <tr>
  84.           <td width="8%">&nbsp;</td>
  85.         </tr>
  86.         <br><br><br>
  87.         <tr>
  88.         <td width="8%">&nbsp;</td>
  89.         <td width="92%"><b>Reacties:</b></td>
  90.          </tr>
  91.        <? while($row2 = mysql_fetch_object($query2)){ ?>
  92.          <tr>
  93.          <td width="8%">&nbsp;</td>
  94.          <td width="92%">&nbsp;</td>
  95.          <tr>
  96.           <td width="8%">Door</td>
  97.           <td width="92%"><? echo $row2->van; ?></td>
  98.         </tr>
  99.         <tr>
  100.           <td width="8%">Datum</td>
  101.           <td width="92%"><? echo $row2->datum; ?></td>
  102.         </tr>
  103.         <tr>
  104.           <td width="8%">Reactie</td>
  105.           <td width="92%"><? echo $row2->bericht; ?></td>
  106.         </tr>
  107.         <tr>
  108.         <td width="8%">&nbsp;</td>
  109.         <td width="92%">&nbsp;</td>
  110.         </tr>
  111.        <?
  112.         }
  113.         ?>
  114.         <tr>
  115.         <td width="8%">&nbsp;</td>
  116.         <td width="92%"><b>Plaats een reactie<b></td>
  117.         </tr>
  118.          <form method="post">
  119.        <tr>
  120.         <td width="8%">Bericht</td>
  121.           <td width="92%" rowspan="3"><textarea name="bericht" rows=3 cols=20 wrap="on"></textarea></td>
  122.         </tr>
  123.         <tr>
  124.           <td width="8%">&nbsp;</td>
  125.         </tr>
  126.         <tr>
  127.           <td width="8%">&nbsp;</td>
  128.         </tr>
  129.         <tr>
  130.           <td width="100%" colspan="2">
  131.             <p align="center"><input type="submit" name="reageer" value="reageer"></td>
  132.         </tr>
  133.       </table>
  134.     </td>
  135.   </tr>
  136. </form>
  137.  
  138.         <?
  139.     }
  140. if(!empty($_POST['reageer'])){
  141. $datum = date("d/m/Y h:i");
  142.  
  143. if($_POST["bericht"] != "")
  144.     {
  145. mysql_query("insert INTO forumreacties (forumid,van,bericht,datum) values('".$_GET["forumid"]."','".$_COOKIE["login"]."','".$_POST[bericht]."','".$datum."')") or die(mysql_error());
  146.     echo "Reactie verzonden";
  147.     }
  148.     else
  149.     {
  150.         echo "U moet wel alles goed invullen!";
  151. }
  152. }
  153. elseif ($actie == "")
  154. {
  155. ?>
  156.     <p align="left"><a href="?p=forum&actie=opstellen">Bericht toevoegen</a></p>
  157.  
  158.     <table border="0" width="70%" cellspacing="0" cellpadding="0">
  159.   <tr>
  160.     <td width="100%">
  161.       <table border="1" width="100%" cellspacing="0" cellpadding="0">
  162.         <tr>
  163.           <td width="2%">&nbsp;</td>
  164.           <td width="25%"><b>Onderwerp</b></td>
  165.           <td width="26%"><b>Van</b></td>
  166.          <td width="2%">&nbsp;</td>
  167.         </tr>
  168.         <?
  169.  $query = mysql_query("select * from forum order BY datum DESC");
  170.  while($row = mysql_fetch_object($query)){
  171.         ?>
  172.         <tr>
  173.           <td width="2%">&nbsp;</td>
  174.           <td width="25%"><a href="?p=forum&actie=bekijk&forumid=<? echo $row->id; ?>&id=<? echo $row->id;?>"><?echo $row->onderwerp; ?></a></td>
  175.           <td width="26%"><? echo $row->van; ?></td>
  176.           <td width="2%">&nbsp;</td>
  177.           </tr>
  178. <?
  179. }
  180. }
  181. ?>
  182. </body>
  183. </html>



##forumadmin.php##
php code - Bekijk de code zonder highlighting - Klap code in 
  2. include('config.php')
  3. ?>
  4. <html>
  5. <head>
  6. <title>FORUM</title>
  7. </head>
  8. <body>
  9. <?
  10. $admin = "****";
  11. $wachtwoord = "*****";
  12.   //uitloggen
  13. 	if (isset($uitloggen))
  14. 		{
  16. 	echo "<script>location.href='?P=forum'</script>";
  17.         }
  18. 	//logincheck
  19. 	if ($_POST['login']) 
  20. 	    {
  21. 		if ($_POST['naam'] == $admin AND $_POST['wachtwoord'] == $wachtwoord)
  22. 		{
  23. 		session_register(forumadmin);
  24. 		}
  25.   else
  26.         {
  27.       echo "<table><tr><td align=center><b>Fout!</b></td></tr></table><br>";
  28.         }
  29.         }
  30. 	//ff kijken of sessie is aangemaakt
  31. 	if(session_is_registered("forumadmin"))
  32. {
  33.  
  34. //bericht edit-form
  35. 		if (isset($editid))
  36.         {
  37. 		$sql = "SELECT * FROM forum  WHERE id='$editid'";
  38. 		$resultaat = mysql_query($sql) or die ("query mislukt");
  39. 		$rij = mysql_fetch_object($resultaat);
  40.         $van = htmlspecialchars($rij->van);
  41.         $bericht = htmlspecialchars($rij->bericht);?>
  42. 		<table><form method="post" action="<? echo "$PHP_SELF"; ?>" name="forum"><input type="hidden" name="editid" value="<? echo "$editid"; ?>">
  43.         <tr><td width="150">Onderwerp:</td><td><textarea name="onderwerp" cols="34" rows="1"><? echo "$onderwerp"; ?></textarea><br></td></tr>
  44.         <tr><td valign="top">Bericht:</td><td><textarea name="bericht" cols="34" rows="5"><? echo "$bericht"; ?></textarea><br></td></tr>
  45. 		<tr><td></td><td><input type="submit" name="submit" value="wijzigen"></td></tr></form></table><br>
  46. 		<?
  47.         }
  48.  
  49.         if (isset($editforumid))
  50.         {
  51.         $sql2 = "SELECT * FROM forumreacties WHERE id='$editforumid'";
  52.         $resultaat2 = mysql_query($sql2) or die ("query mislukt");
  53.         $rij2 = mysql_fetch_object($resultaat2);
  54.         $van2 = htmlspecialchars($rij2->van);
  55.         $bericht2 = htmlspecialchars($rij2->bericht);?>
  56.         <table><form method="post" action="<? echo "$PHP_SELF"; ?>" name="forum"><input type="hidden" name="editforumid" value="<? echo "$editforumid"; ?>">
  57.         <tr><td width="150">Door:</td><td><textarea name="van" cols="34" rows="1"><? echo "$van2"; ?></textarea><br></td></tr>
  58.         <tr><td valign="top">Bericht:</td><td><textarea name="bericht" cols="34" rows="5"><? echo "$bericht2"; ?></textarea><br></td></tr>
  59. 		<tr><td></td><td><input type="submit" name="submit1" value="wijzigen"></td></tr></form></table><br>
  60.         <?
  61.         }
  62.         //bericht deleten
  63. 		if (isset($deleteid))
  64.         {
  65. 		mysql_query ("DELETE FROM forum WHERE id='$deleteid'");
  66.         }
  67.  
  68.         if (isset($deleteforumid))
  69.         {
  70.         mysql_query ("DELETE FROM forumreacties WHERE forumid='$deleteforumid'");
  71.         }
  72.  
  73.         if ($_POST['submit'])
  74.         {
  75. 		mysql_query("UPDATE forum SET onderwerp='".$_POST[onderwerp]."',bericht='".$_POST[bericht]."' WHERE id = '".$editid."'") or die(mysql_error());
  76. 		echo "<script>location.href='$PHP_SELF'</script>";
  77.         } 
  78.  
  79.         if ($_POST['submit1'])
  80.         {
  81.        mysql_query("UPDATE forumreacties SET bericht='".$_POST[bericht]."' WHERE forumid = '".$editforumid."'") or die(mysql_error());
  82.        echo "<script>location.href='$PHP_SELF'</script>";
  83.         }
  84.  
  85.         //alle berichten weergeven
  86.         $sql = "SELECT * FROM forum ORDER BY datum DESC";
  87. 		$resultaat = mysql_query($sql) or die ("query mislukt");
  88.         while ($rij = mysql_fetch_object($resultaat))
  89. 		{
  90.         $onderwerp = htmlspecialchars($rij->onderwerp);
  91. 		$naam = htmlspecialchars($rij->van);
  92. 		$bericht = htmlspecialchars($rij->bericht);
  93.  
  94.  
  95. 		echo "<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\"><tr><td width=60><a href=$PHP_SELF?editid=".$rij->id."><img src=\"img/edit.png\" border=\"0\"></a><a href=$PHP_SELF?deleteid=".$rij->id."><img src=\"img/del.png\" border=\"0\"></a></td><td width=120><b>".$naam."</b></a><br><font size=1>";
  96.         echo "</font></td><td width=\"220\">".$onderwerp."</td><td width=\"220\">".$naam."</td><td width=\"220\">".$bericht."</td><td><a href=forumadmin.php?actie=reactie&forumid=".$rij->id.">Reacties</A></tr></table><br>";
  97.         }   
  98.  
  99.         if ($actie == "reactie")
  100.         {
  101.         $sql2 = "SELECT * FROM forumreacties WHERE forumid='".$_GET["forumid"]."' ORDER BY datum DESC";
  102.         $resultaat2 = mysql_query($sql2) or die ("query mislukt");
  103. 	    while ($rij2 = mysql_fetch_object($resultaat2))
  104.         {
  105. 		$naam2 = htmlspecialchars($rij2->van);
  106.         $bericht2 = htmlspecialchars($rij2->bericht);
  107.  
  108.         echo "<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><h4>Reactie op onderwerp:</h4></td><td>".$onderwerp."<tr><td width=60><a href=$PHP_SELF?actie=reactie&editforumid=".$rij2->id."><img src=\"img/edit.png\" border=\"0\"></a><a href=$PHP_SELF?actie=reactie&deleteforumid=".$rij2->id."><img src=\"img/del.png\" border=\"0\"></a></td><td   width=120><b>".$naam2."</b></a><br>";
  109.         echo"</font><td width=\"220\">".$naam2."</td><td width=\"220\">".$bericht2."</td></tr></table><br>";
  110.         }
  111.         }
  112.  
  113.         echo "<a href=$PHP_SELF?uitloggen=0>Log uit</a>";
  114. }
  115. else
  116. {
  117.       //login-form        ?>
  118. 		<table width="400"><form method="post" action="forumadmin.php">
  119. 		<tr>
  120.         <td width="150"><b><font color="#666666">Inloggen</font></b></td>
  121.         <td width="250"></td></tr>
  122. 		<tr><td>Naam:</td><td><input type="text" name="naam" size="35"></td></tr>
  123. 		<tr><td>Wachtwoord:</td><td><input type="password" name="wachtwoord" size="35"></td></tr>
  124. 		<tr><td></td><td><input type="submit" name="login" value="login"></td></tr>
  125. 		</form></table>
  126.  <?
  127. }
  128. ?>
  129. </center></body>
  130. </html>


##config.php##
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  2. #mysql gegevens
  3. $host = "localhost";
  4. $user = "db_user";
  5. $pass = "db_pass";
  6. $db = "db_naam";
  7.  
  8. #verander hier verder niets
  9. mysql_connect("$host","$user","$pass");
  11. $actie = $_GET["actie"];
  12. $datum = date("d/m/Y h:i");
  13. ?>
Download code! Download code (.txt)

 Stemmen
Niet ingelogd.

 Reacties
Post een reactie
Lees de reacties (10)
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.061s