login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Fora/Discussieborden > Forum 1.3

Forum 1.3

Auteur: FangorN - 31 augustus 2004 - 19:39 - Gekeurd door: Dennisvb - Hits: 23869 - Aantal punten: 4.31 (45 stemmen)




Opmerkingen:
* Voordat het forum werkt, dien je ZELF ten minste één categorie aan te maken
dit doe je rechtstreeks in de database - of je gebruikt de nog-zelf-te-beveiligen
pagina addcategory.php
* categorieen.php is de 'startplaats' van het forum, NIET forum.php

Code:
config.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. // make connection 
  3. if(mysql_connect("host", "user", "pass")) { 
  4.   mysql_select_db("database"); 
  5. } else { 
  6.   echo "connection to database failed.\n"; 
  7.   exit; 
  8. } 
  9.  
  10. // name of forum 
  11. $forumname = "Forum 1.3"; 
  12.  
  13. // maximum number of topics per page 
  14. $max = 10; 
  15.  
  16. // colors used for topicrows 
  17. $kleur1 ="#eeeeee"; 
  18. $kleur2 ="#cccccc"; 
  19.  
  20. // Na hoeveel posten moet het mapje branden en warm? 
  21. $mapwarm  = 10; 
  22. $mapbrand = 20; 
  23.  
  24. // stel hier je fototjes in bv. nieuws_map.gif 
  25. $gif1 = "new_thread.gif"; 
  26. $gif2 = "thread.gif"; 
  27. $gif3 = "hot_thread.gif"; 
  28. ?>


style.css
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. BODY {FONT-FAMILY: Verdana, Arial, Helvetica; 
  2.       FONT-SIZE: 8pt; 
  3.       COLOR: #000000;} 
  4.  
  5. TABLE, TD {BORDER-STYLE: solid; 
  6.            BORDER-COLOR: #aaaaaa; 
  7.            BORDER-WIDTH: 1px;} 
  8.  
  9. TD {FONT-FAMILY: Verdana, Arial, Helvetica; 
  10.     FONT-SIZE: 8pt; 
  11.     COLOR: #000000;} 
  12.  
  13. A:LINK {FONT-WEIGHT: bold; 
  14.         TEXT-DECORATION: underline; 
  15.         COLOR: #ff0000;} 
  16.  
  17. A:VISITED {FONT-WEIGHT: bold; 
  18.         TEXT-DECORATION: underline; 
  19.         COLOR: #ff0000;} 
  20.  
  21. A:ACTIVE {FONT-WEIGHT: bold; 
  22.           TEXT-DECORATION: underline; 
  23.           COLOR: #ff0000;} 
  24.  
  25. A:HOVER {FONT-WEIGHT: bold; 
  26.          TEXT-DECORATION: underline; 
  27.          COLOR: #ff0000;} 
  28.  
  29. .def {FONT-FAMILY: Verdana, Arial, Helvetica; 
  30.       FONT-SIZE: 8pt; 
  31.       COLOR: #000000;} 
  32.  
  33. .tf {BORDER-STYLE: none; 
  34.      BORDER-WIDTH: 0;}


addcategory.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. include("config.php"); 
  3. ?> 
  4. <HTML> 
  5. <HEAD> 
  6. <TITLE><?php echo $forumname; ?></TITLE> 
  7. <LINK HREF="style.css" TYPE="text/css" REL="stylesheet"> 
  8. </HEAD> 
  9.  
  10. <BODY> 
  11. <?php 
  12. // LET OP ! 
  13. // Omdat niet iedereen categorieën zou mogen toevoegen, word hier (met 
  14. // behulp van de *** login check ***) bepaald of iemand toegang krijgt tot 
  15. // het categorie-toevoeg deel. Het is de verantwoordelijkheid van de 
  16. // programmeur/webmaster om ervoor te zorgen dat dit stuk beveiligd wordt. 
  17.  
  18. if(*** login check ***) { 
  19.   echo "Log in first.<BR>\n"; 
  20. } else { 
  21.   if(!isset($_POST['submit'])) { 
  22.     // bepaal nummer van laatste toegevoegde categorie en 
  23.     // tel hier 1 bij op. Hiervoor had het id-veld in de 
  24.     // tabel categories ook auto_increment kunnen zijn... 
  25.     $res = mysql_query("SELECT MAX(id) FROM categories") or die(mysql_error()); 
  26.     if(mysql_num_rows($res)) { 
  27.       $id = mysql_result($res, 0) + 1; 
  28.     } else { 
  29.       // er waren blijkbaar nog geen categorieen 
  30.       $id = 0; 
  31.     } 
  32. ?> 
  33. <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2"> 
  34. <TR> 
  35. <TD WIDTH="500" COLSPAN="2"><B><?php echo $forumname; ?> &gt; Categorie toevoegen</B><BR></TD> 
  36. </TR> 
  37. <TR> 
  38. <FORM ACTION="" METHOD="post"> 
  39. <TD WIDTH="125">naam<BR></TD> 
  40. <TD WIDTH="375"><INPUT TYPE="text" NAME="naam" SIZE="40" MAXLENGTH="100"><BR></TD> 
  41. </TR> 
  42. <TR> 
  43. <TD WIDTH="125">omschrijving<BR></TD> 
  44. <TD WIDTH="375"><INPUT TYPE="text" NAME="descr" SIZE="40" MAXLENGTH="200"><BR></TD> 
  45. </TR> 
  46. <TR> 
  47. <TD COLSPAN="2"> 
  48. <INPUT TYPE="hidden" NAME="id" VALUE="<?php echo $id; ?>"> 
  49. <INPUT TYPE="submit" NAME="submit" VALUE="submit"><BR> 
  50. </TD> 
  51. </FORM> 
  52. </TR> 
  53. </TABLE> 
  54. <?php 
  55.   } else { 
  56.     $naam  = $_POST['naam']; 
  57.     $descr = $_POST['descr']; 
  58.     $id    = $_POST['id']; 
  59.  
  60.     $error = ""; 
  61.     if(trim($naam) == "") $error  = "Geen naam ingevuld..."; 
  62.     elseif(trim($descr) == "") $error = "Geen omschrijving ingevuld..."; 
  63.  
  64.     if($error == "") { 
  65.       // update database 
  66.       $naam = htmlentities($naam); 
  67.  
  68.       $descr = htmlentities($descr); 
  69.       mysql_query("INSERT INTO categories (id, naam, descr) VALUES ($id, '$naam', '$descr')") or die(mysql_error()); 
  70.       echo "Succes!<BR>\n"; 
  71.       echo "De categorie is toegevoegd.<BR>\n"; 
  72.       echo "<A HREF=\"categorieen.php\">naar categorieen</A><BR>\n"; 
  73.     } else { 
  74.       // errors! 
  75.       echo "ERROR: ".$error."<BR>\n"; 
  76.       echo "Druk op de \"back\" knop van je browser.<BR>\n"; 
  77.     } 
  78.   } 
  79. } // end login test 
  80. ?> 
  81. </BODY> 
  82. </HTML>


categorieen.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. include("config.php"); 
  3. ?> 
  4. <HTML> 
  5. <HEAD> 
  6. <TITLE><?php echo $forumname; ?> - categorieën</TITLE> 
  7. <LINK HREF="style.css" TYPE="text/css" REL="stylesheet"> 
  8. </HEAD> 
  9.  
  10. <BODY> 
  11. <B><?php echo $forumname; ?></B><BR> 
  12. <BR> 
  13. <TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2"> 
  14. <?php 
  15. $query = mysql_query("SELECT * FROM categories ORDER BY id ASC") or die(mysql_error()); 
  16. if(mysql_num_rows($query)) { 
  17.   while($row = mysql_fetch_row($query)) { 
  18.  
  19.     $cat = $row[0]; 
  20.     echo "<TR><TD WIDTH=\"500\">\n"; 
  21.     // topic name 
  22.     echo "<A HREF=\"forum.php?cat=".$cat."\">".$row[1]."</A> "; 
  23.  
  24.     // number of topics 
  25.     $topics = mysql_query("SELECT COUNT(*) FROM forum WHERE cat=$cat") or die(mysql_error()); 
  26.     echo "(".mysql_result($topics, 0).")<BR>\n"; 
  27.     mysql_free_result($topics); 
  28.  
  29.     // description of each topic 
  30.     echo $row[2]."<BR>\n"; 
  31.     echo "</TD></TR>\n"; 
  32.   } 
  34. } else { 
  35.   echo "<TR><TD WIDTH=\"500\">\n"; 
  36.   echo "Er zijn nog geen categorieën.<BR>\n"; 
  37.   echo "</TD></TR>\n"; 
  38. } 
  39. ?> 
  40. </TABLE> 
  41. </BODY> 
  42. </HTML>


forum.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. include ("config.php"); 
  3.  
  4. $cat = $_GET['cat']; 
  5. $pagina = (isset($_GET['pagina']) ? $_GET['pagina'] : 0); 
  6. ?> 
  7. <HTML> 
  8. <HEAD> 
  9. <TITLE><?php echo $forumname; ?></TITLE> 
  10. <LINK HREF="style.css" TYPE="text/css" REL="stylesheet"> 
  11. </HEAD> 
  12.  
  13. <BODY> 
  14. <?php 
  15. $query = mysql_query("SELECT naam FROM categories WHERE id=$cat") or die(mysql_error()); 
  16.  
  17. // category check 
  18. if(!mysql_num_rows($query)) { 
  19.   echo "<CENTER>De geselecteerde categorie bestaat niet (meer).<BR>\n"; 
  20.   echo "<A HREF=\"categorieen.php\">Terug naar Categorieën</A><BR></CENTER>\n"; 
  21. } else { 
  22. echo "<A HREF=\"categorieen.php\">".$forumname."</A> &gt; <B>".mysql_result($query, 0, "naam")."</B><BR>\n"; 
  24. ?> 
  25. <BR> 
  26. <TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2"> 
  27. <?php 
  28. $query1 = mysql_query("SELECT COUNT(*) FROM forum WHERE cat=$cat") or die(mysql_error()); 
  29. $aantal_berichten = mysql_result($query1, 0); 
  31.  
  32. $start = $pagina * $max; 
  33. $query2 = mysql_query("SELECT * FROM forum where cat=$cat ORDER BY id DESC LIMIT $start, $max") or die(mysql_error()); 
  34.  
  35. if(mysql_num_rows($query2)) { 
  36.   $i = 0; 
  37. ?> 
  38. <TR> 
  39. <TD WIDTH="25"> 
  40. <BR> 
  41. </TD> 
  42.  
  43. <TD WIDTH="200"> 
  44. <B>Titel</B><BR> 
  45. </TD> 
  46.  
  47. <TD WIDTH="100" ALIGN="center"> 
  48. <B>Gepost door</B><BR> 
  49. </TD> 
  50.  
  51. <TD WIDTH="100" ALIGN="center"> 
  52. <B>Gepost op<B><BR> 
  53. </TD> 
  54.  
  55. <TD WIDTH="75" ALIGN="center"> 
  56. <B>Reacties</B><BR> 
  57. </TD> 
  58. </TR> 
  59. <?php 
  60.   while($row = mysql_fetch_row($query2)) { 
  61.     $forumid = $row[0]; 
  62.     $query3 = mysql_query("SELECT COUNT(*) FROM forumreplys WHERE forumid=$forumid") or die("q3: ".mysql_error()); 
  63.     $replys = mysql_result($query3, 0); 
  64.     if($replys == 0) { 
  65.       $thread = $gif1; 
  66.     } elseif($replys > 0 && $replys < $mapbrand) { 
  67.       $thread = $gif2; 
  68.     } elseif($replys >= $mapbrand) { 
  69.       $thread = $gif3; 
  70.     } 
  71.  
  72.     // per rij zal het van kleur verwisselen 
  73.     $kleur = ($i % 2 ? $kleur1 : $kleur2); //aanpassen in config 
  74.     echo "<TR BGCOLOR=\"".$kleur."\">"; 
  75.     echo "<TD WIDTH=\"25\" ALIGN=\"center\"><IMG SRC=\"".$thread."\" WIDTH=\"13\" HEIGHT=\"16\" ALT=\""; 
  76.     echo $row[7]." hit".($row[7] == 1 ? "" : "s")."\"><BR></TD>"; 
  77.     echo "<TD WIDTH=\"200\"><A HREF=\"forumbericht.php?cat=".$cat."&forumid=$forumid\">".$row[1]."</A><BR></TD>"; 
  78.     echo "<TD WIDTH=\"100\" ALIGN=\"center\"><A HREF=\"mailto:".$row[5]."\">".$row[3]."</A></TD>"; 
  79.     echo "<TD WIDTH=\"100\" ALIGN=\"center\">".date("d/m/Y H:i", $row[4])."</TD>"; 
  80.     echo "<TD WIDTH=\"75\" ALIGN=\"center\">".$replys."</TD></TR>"; 
  81.     $i++; 
  82.   } // end while 
  83.   mysql_free_result($query2); 
  84. ?> 
  85.  
  86. <?php 
  87.   // navigatie 
  88.   if($aantal_berichten > $max) { 
  89.     // laat alleen navigatie zien als er meer berichten zijn dan dat er op een pagina passen 
  90.     // aantal pagina's: 
  91.     if(!($aantal_berichten % $max)) { 
  92.       // pagina's passen precies 
  93.       $npaginas = $aantal_berichten/$max; 
  94.     } else { 
  95.       // rest na deling 
  96.       $npaginas = (integer)($aantal_berichten/$max) + 1; 
  97.     } 
  98.     echo "<TR><TD WIDTH=\"500\" COLSPAN=\"5\" ALIGN=\"center\">\n"; 
  99.     echo "Pagina's "; 
  100.     for($p=0; $p < $npaginas; $p++) { 
  101.       if($p == $pagina) { 
  102.         echo "<B>$p</B>"; 
  103.       } else { 
  104.         echo "<A HREF=\"forum.php?pagina=".$p."&cat=".$cat."\">".$p."</A>"; 
  105.       } 
  106.       echo (($p+1) < $npaginas ? "|" : ""); 
  107.     } 
  108.     echo "</TD></TR>\n"; 
  109.   } 
  110. } elseif(!$pagina) { 
  111.   // nog geen forumids in deze categorie OF 
  112.   // een persoon zit op een niet-bestaande pagina 
  113. ?> 
  114. <TR> 
  115. <TD WIDTH="500" COLSPAN="5" ALIGN="center"> 
  116. <B>Er zijn nog geen forumberichten toegevoegd in deze categorie!</B> 
  117. </TD> 
  118. </TR> 
  119. <?php 
  120. } else { 
  121. ?> 
  122. <TR> 
  123. <TD WIDTH="500" COLSPAN="5" ALIGN="center"> 
  124. <B>Er staan geen berichten op deze pagina!</B> 
  125. </TD> 
  126. </TR> 
  127. <?php 
  128. } 
  129. ?> 
  130. <TR> 
  131. <TD COLSPAN="5" ALIGN="center"> 
  132. <A HREF="nieuwbericht.php?cat=<?php echo $cat; ?>">Nieuw Topic</A> | 
  133. <A HREF="categorieen.php">Terug naar '<?php echo $forumname; ?>'</A><BR> 
  134. </TD> 
  135. </TR> 
  136. </TABLE> 
  137. <?php 
  138. } // end category exists check 
  139. ?> 
  140. </BODY> 
  141. </HTML>


forumbericht.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. include ("config.php"); 
  3.  
  4. $cat = $_GET['cat']; 
  5. $forumid = $_GET['forumid']; 
  6. ?> 
  7. <HTML> 
  8. <HEAD> 
  9. <TITLE><?php echo $forumname; ?></TITLE> 
  10. <LINK HREF="style.css" TYPE="text/css" REL="stylesheet"> 
  11. </HEAD> 
  12.  
  13. <BODY> 
  14. <?php 
  15. $query = mysql_query("SELECT naam FROM categories WHERE id=$cat") or die(mysql_error()); 
  16. if(!mysql_num_rows($query)) { 
  17.   echo "<CENTER>De geselecteerde categorie bestaat niet (meer).<BR>\n"; 
  18.   echo "<A HREF=\"categorieen.php\">Terug naar Categorieën</A><BR></CENTER>\n"; 
  19. } else { 
  20. $naam = mysql_result($query, 0, "naam"); 
  22. echo "<A HREF=\"categorieen.php\">".$forumname."</A> &gt; "; 
  23. echo "<A HREF=\"forum.php?cat=".$cat."\">".$naam."</A>"; 
  24.  
  25. $res = mysql_query("SELECT * FROM forum where id=$forumid") or die(mysql_error()); 
  26. if(!mysql_num_rows($res)) { 
  27.   echo "<CENTER>Het geselecteerde forumid bestaat niet (meer).<BR>\n"; 
  28.   echo "<A HREF=\"forum.php?cat=".$cat."\">Terug naar '".$naam."'</A><BR></CENTER>\n"; 
  29. } else { 
  30. mysql_query("UPDATE forum SET hits=hits+1 where id=$forumid") or die(mysql_error()); 
  31. if(mysql_num_rows($res)) { 
  32.   $row = mysql_fetch_row($res); 
  33.   echo " &gt; <B>".$row[1]."</B><BR>\n"; 
  34. ?> 
  35. <BR> 
  36. <TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2"> 
  37. <TR> 
  38. <TD WIDTH="500"> 
  39. <B>Onderwerp:</B> <?php echo $row[1]; ?><BR> 
  40. </TD> 
  41. </TR> 
  42.  
  43. <TR> 
  44. <TD WIDTH="500"> 
  45. <B>Gepost door:</B> <?php echo "<A HREF=\"mailto:".$row[5]."\">".$row[3]."</A>"; ?><BR> 
  46. <B>Gepost op:</B> <?php echo date("d/m/Y H:i", $row[4]); ?> 
  47. </TD> 
  48. </TR> 
  49.  
  50. <TR> 
  51. <TD WIDTH="500"> 
  52. <?php 
  53. echo nl2br($row[6]); 
  54. ?> 
  55. </TD> 
  56. </TR> 
  57. </TABLE> 
  58.  
  59. <br> 
  60. <?php 
  62.   $res2 = mysql_query("SELECT * FROM forumreplys where forumid=$forumid") or die(mysql_error()); 
  63.  
  64.   if (mysql_num_rows($res2)) { 
  65.     while($row = mysql_fetch_row($res2)) { 
  66. ?> 
  67. <TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2"> 
  68. <TR> 
  69. <TD WIDTH="500"> 
  70. <B>Reply:</B> <?php echo $row[2]; ?><BR> 
  71. </TD> 
  72. </TR> 
  73.  
  74. <TR> 
  75. <TD WIDTH="500"> 
  76. <B>Gepost door:</B> <?php echo "<A HREF=\"mailto: ".$row[4]."\">".$row[3]."</A>"; ?><BR> 
  77. <B>Gepost op:</B> <?php echo date("d/m/Y H:i", $row[5]); ?><BR> 
  78. </TD> 
  79. </TR> 
  80.  
  81. <TR> 
  82. <TD WIDTH="500"> 
  83. <?php 
  84. echo nl2br($row[6]); 
  85. ?> 
  86. </TD> 
  87. </TR> 
  88. </TABLE> 
  89. <BR> 
  90. <?php 
  91.     } // end while 
  93.   } // end $aantal > 0 
  94. } // end message exists 
  95. ?> 
  96. <BR> 
  97. <TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2"> 
  98. <TR> 
  99. <TD WIDTH="500" ALIGN="center"> 
  100. <A HREF="postreactie.php?cat=<?php echo $cat."&forumid=".$forumid; ?>">Post Reactie</A> | 
  101. <A HREF="nieuwbericht.php?cat=<?php echo $cat; ?>">Nieuw Topic</A> | 
  102. <A HREF="forum.php?cat=<?php echo $cat; ?>">Terug naar '<?php echo $naam; ?>'</A><BR> 
  103. </TD> 
  104. </TR> 
  105. </TABLE> 
  106. <?php 
  107. } // end forumid exists check 
  108. } // end category exists check 
  109. ?> 
  110. </BODY> 
  111. </HTML>


nieuwbericht.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. include ("config.php"); 
  3. $cat = $_GET['cat']; 
  4. ?> 
  5. <HTML> 
  6. <HEAD> 
  7. <TITLE><?php echo $forumname; ?></TITLE> 
  8. <LINK HREF="style.css" TYPE="text/css" REL="stylesheet"> 
  9. </HEAD> 
  10.  
  11. <BODY> 
  12. <?php 
  13. $query = mysql_query("SELECT naam FROM categories WHERE id=$cat") or die("q: ".mysql_error()); 
  14. if(!mysql_num_rows($query)) { 
  15.   echo "<CENTER>De geselecteerde categorie bestaat niet (meer).<BR>\n"; 
  16.   echo "<A HREF=\"categorieen.php\">Terug naar Categorieën</A><BR></CENTER>\n"; 
  17. } else { 
  18. $naam = mysql_result($query, 0, "naam"); 
  20. echo "<A HREF=\"categorieen.php\">".$forumname."</A> &gt; "; 
  21. echo "<A HREF=\"forum.php?cat=".$cat."\">".$naam."</A> &gt; <B>Nieuw bericht</B><BR>\n"; 
  22. ?> 
  23. <BR> 
  24. <TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2"> 
  25. <TR> 
  26. <TD WIDTH="500" ALIGN="center"> 
  27. <?php 
  28. if ($_POST['submit']) { 
  29.   $error = ""; 
  30.   if(trim($_POST['naam']) == "") $error = "Je moet een naam invullen<BR><BR>"; 
  31.   elseif(trim($_POST['email']) == "") $error = "Je moet je emailadres invullen<BR><BR>"; 
  32.   elseif(trim($_POST['titel']) == "") $error = "Je moet een titel invullen<BR><BR>"; 
  33.   elseif(trim($_POST['bericht']) == "") $error = "Je moet een bericht invullen<BR><BR>"; 
  34.   if (!$error) { 
  35.     $titel   = htmlentities($_POST['titel']); 
  36.     $naam    = htmlentities($_POST['naam']); 
  37.     $datum   = time(); 
  38.     $email   = htmlentities($_POST['email']); 
  39.     $bericht = htmlentities($_POST['bericht']); 
  40.  
  41.     $query = "INSERT INTO forum (id, titel, cat, naam, datum, email, bericht, hits) 
  42.              VALUES ('', '$titel', $cat, '$naam', $datum, '$email', '$bericht', 0)"; 
  43.     mysql_query($query) or die(mysql_error()); 
  44.  
  45.     echo "Het bericht is verzonden.<BR>\n"; 
  46.     echo "klik <A HREF=\"forum.php?cat=".$cat."\">hier</A> om terug naar het forum te gaan.<BR>\n"; 
  47.   } else { 
  48.     // errors 
  49.     echo "<B>".$error."</B><BR>\n"; 
  50.     echo "<FORM ACTION=\"".$_SERVER['PHP_SELF']."?cat=".$cat."\" METHOD=\"post\">\n"; 
  51.     echo "<INPUT TYPE=\"submit\" VALUE=\"Terug\">\n"; 
  52.     echo "</FORM>"; 
  53.   } 
  54. } else { 
  55. ?> 
  56. <TABLE CLASS="tf" WIDTH="500" BORDER="0" CELLSPACING="0" CELLPADDING="2"> 
  57. <FORM ACTION="<?php echo $_SERVER['PHP_SELF']."?cat=".$cat; ?>" METHOD="post"> 
  58. <TR> 
  59. <TD CLASS="tf" WIDTH="125" ALIGN="right"><B>Naam</B>&nbsp;</TD> 
  60. <TD CLASS="tf" WIDTH="375"><INPUT TYPE="text" CLASS="def" NAME="naam" SIZE="30" MAXLENGTH="30"></TD> 
  61. </TR> 
  62.  
  63. <TR> 
  64. <TD CLASS="tf" WIDTH="125" ALIGN="right"><B>Email</B>&nbsp;</TD> 
  65. <TD CLASS="tf" WIDTH="375"><INPUT TYPE="text" CLASS="def" NAME="email" SIZE="30" MAXLENGTH="50"></TD> 
  66. </TR> 
  67.  
  68. <TR> 
  69. <TD CLASS="tf" WIDTH="125" ALIGN="right"><B>Titel</B>&nbsp;</TD> 
  70. <TD CLASS="tf" WIDTH="375"><INPUT TYPE="text" CLASS="def" NAME="titel" SIZE="30" MAXLENGTH="50"></TD> 
  71. </TR> 
  72.  
  73. <TR> 
  74. <TD CLASS="tf" WIDTH="125" ALIGN="right" VALIGN="top"><B>Bericht</B>&nbsp;</TD> 
  75. <TD CLASS="tf" WIDTH="375"><TEXTAREA NAME="bericht" CLASS="def" COLS="30" ROWS="4"></TEXTAREA><BR></TD> 
  76. </TR> 
  77.  
  78. <TR> 
  79. <TD CLASS="tf" WIDTH="500" COLSPAN="2" ALIGN="center"> 
  80. <INPUT TYPE="submit" CLASS="def" NAME="submit" VALUE="Post topic"> 
  81. </TD> 
  82. </TR> 
  83. </FORM> 
  84. </TABLE> 
  85.  
  86. <?php 
  87. } // end else 
  88. ?> 
  89. <BR> 
  90. </TD> 
  91. </TR> 
  92.  
  93. <TR> 
  94. <TD WIDTH="500" ALIGN="center"><A HREF="forum.php?cat=<?php echo $cat; ?>">Terug naar Forum</A></TD> 
  95. </TR> 
  96. </TABLE> 
  97. <?php 
  98. } // end category exists check 
  99. ?> 
  100. </BODY> 
  101. </HTML>


postreactie.php
-------------------------------------------------------------------
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php 
  2. include("config.php"); 
  3. $cat = $_GET['cat']; 
  4. $forumid = $_GET['forumid']; 
  5. ?> 
  6. <HTML> 
  7. <HEAD> 
  8. <TITLE><?php echo $forumname; ?></TITLE> 
  9. <LINK HREF="style.css" TYPE="text/css" REL="stylesheet"> 
  10. </HEAD> 
  11.  
  12. <BODY> 
  13. <?php 
  14. $query = mysql_query("SELECT naam FROM categories WHERE id=$cat") or die(mysql_error()); 
  15. if(!mysql_num_rows($query)) { 
  16.   echo "<CENTER>De geselecteerde categorie bestaat niet (meer).<BR>\n"; 
  17.   echo "<A HREF=\"categorieen.php\">Terug naar Categorieën</A><BR></CENTER>\n"; 
  18. } else { 
  19. $naam =  mysql_result($query, 0, "naam"); 
  21.  
  22. $res = mysql_query("SELECT * FROM forum where id=$forumid") or die(mysql_error()); 
  23. if(!mysql_num_rows($res)) { 
  24.   echo "<CENTER>Het geselecteerde forumid bestaat niet (meer).<BR>\n"; 
  25.   echo "<A HREF=\"forum.php?cat=".$cat."\">Terug naar '".$naam."'</A><BR></CENTER>\n"; 
  26. } else { 
  27. echo "<A HREF=\"categorieen.php\">".$forumname."</A> &gt; "; 
  28. echo "<A HREF=\"forum.php?cat=".$cat."\">".$naam."</A> &gt; "; 
  29. echo "<B>Post reactie</B><BR>\n"; 
  30. ?> 
  31. <BR> 
  32. <TABLE WIDTH="500" BORDER="0" CELLSPACING="0" CELLPADDING="2"> 
  33. <TR> 
  34. <TD WIDTH="500" ALIGN="center"> 
  35. <?php 
  36. if($_POST['submit']) { 
  37.   if(trim($_POST['naam']) == "") $error = "Je moet je naam invullen<BR><BR>"; 
  38.   elseif(trim($_POST['email']) == "") $error = "Je moet je e-mailadres invullen<BR><BR>"; 
  39.   elseif(trim($_POST['titel']) == "") $error = "Je moet een titel invullen<BR><BR>"; 
  40.   elseif(trim($_POST['bericht']) == "") $error = "Je moet een bericht invullen<BR><BR>"; 
  41.   if (!$error) { 
  42.     $titel   = htmlentities($_POST['titel']); 
  43.     $naam    = htmlentities($_POST['naam']); 
  44.     $email   = htmlentities($_POST['email']); 
  45.     $datum   = time(); 
  46.     $bericht = htmlentities($_POST['bericht']); 
  47.  
  48.     $query ="INSERT INTO forumreplys (id, forumid, titel, naam, email, datum, bericht) 
  49.              VALUES ('', $forumid, '$titel', '$naam', '$email', $datum, '$bericht')"; 
  50.     mysql_query($query) or die(mysql_error()); 
  51.     echo "De reactie is verzonden.<BR>\n"; 
  52.     echo "klik <A HREF=\"forumbericht.php?cat=".$cat."&forumid=".$forumid."\">hier</A> "; 
  53.     echo "om terug naar het forumbericht te gaan.<BR>\n"; 
  54.   } else { 
  55.     // errors 
  56.     echo "<B>".$error."</B><BR>\n"; 
  57.     echo "<FORM ACTION=\"".$_SERVER['PHP_SELF']."?cat=".$cat."&forumid=".$forumid."\" METHOD=\"post\">\n"; 
  58.     echo "<INPUT TYPE=\"submit\" CLASS=\"def\" VALUE=\"Terug\">\n"; 
  59.     echo "</FORM>"; 
  60.   } 
  61. } else { 
  62. ?> 
  63. <TABLE CLASS="tf" WIDTH="500" BORDER="0" CELLSPACING="0" CELLPADDING="2"> 
  64. <FORM ACTION="<?php echo $_SERVER['PHP_SELF']."?cat=".$cat."&forumid=".$forumid;?>" METHOD="post"> 
  65. <TR> 
  66. <TD CLASS="tf" WIDTH="125" ALIGN="right"><B>Naam</B>&nbsp;</TD> 
  67. <TD CLASS="tf" WIDTH="375"><INPUT TYPE="text" CLASS="def" NAME="naam" SIZE="30" MAXLENGTH="30"></TD> 
  68. </TR> 
  69.  
  70. <TR> 
  71. <TD CLASS="tf" WIDTH="125" ALIGN="right"><B>Email</B>&nbsp;</TD> 
  72. <TD CLASS="tf" WIDTH="375"><INPUT TYPE="text" CLASS="def" NAME="email" SIZE="30" MAXLENGTH="50"></TD> 
  73. </TR> 
  74.  
  75. <TR> 
  76. <TD CLASS="tf" WIDTH="125" ALIGN="right"><B>Titel</B>&nbsp;</TD> 
  77. <TD CLASS="tf" WIDTH="375"><INPUT TYPE="text" CLASS="def" NAME="titel" SIZE="30" MAXLENGTH="50"></TD> 
  78. </TR> 
  79.  
  80. <TR> 
  81. <TD CLASS="tf" WIDTH="125" ALIGN="right" VALIGN="top"><B>Bericht</B>&nbsp;</TD> 
  82. <TD CLASS="tf" WIDTH="375"><TEXTAREA NAME="bericht" CLASS="def" COLS="30" ROWS="4"></TEXTAREA><BR></TD> 
  83. </TR> 
  84.  
  85. <TR> 
  86. <TD CLASS="tf" WIDTH="500" COLSPAN="2" ALIGN="center"> 
  87. <INPUT TYPE="submit" CLASS="def" NAME="submit" VALUE="Post reactie"> 
  88. </TD> 
  89. </TR> 
  90. </FORM> 
  91. </TABLE> 
  92. <?php 
  93. } // end else 
  94. ?>     
  95. <BR> 
  96. </TD> 
  97. </TR> 
  98.  
  99. <TR> 
  100. <TD WIDTH="500" ALIGN="center"><A HREF="forumbericht.php?cat=<?php echo $cat."&forumid=".$forumid; ?>">Terug naar Forum</A></TD> 
  101. </TR> 
  102. </TABLE> 
  103. <?php 
  104. } // end forumid exists check 
  105. } // end category exists check 
  106. ?> 
  107. </BODY> 
  108. </HTML>


De Mysql db's
--------------------------------------------------

php code - Bekijk de code zonder highlighting - Klap code in 
  1. CREATE TABLE categories ( 
  2.   id int(10) NOT NULL, 
  3.   naam varchar(100) NOT NULL, 
  4.   descr varchar(200) NOT NULL, 
  5.   PRIMARY KEY (id) 
  6. ) TYPE=MyISAM; 
  7.  
  8. CREATE TABLE forum ( 
  9.   id int(10) NOT NULL auto_increment, 
  10.   titel varchar(50) NOT NULL, 
  11.   cat int(10) NOT NULL, 
  12.   naam varchar(30) NOT NULL, 
  13.   datum int(10) NOT NULL, 
  14.   email varchar(50) NOT NULL, 
  15.   bericht text NOT NULL, 
  16.   hits int(10) NOT NULL, 
  17.   PRIMARY KEY (id) 
  18. ) TYPE=MyISAM; 
  19.  
  20. CREATE TABLE forumreplys ( 
  21.   id int(10) NOT NULL auto_increment, 
  22.   forumid int(10) NOT NULL, 
  23.   titel varchar(50) NOT NULL, 
  24.   naam varchar(30) NOT NULL, 
  25.   email varchar(50) NOT NULL, 
  26.   datum varchar(10) NOT NULL, 
  27.   bericht text NOT NULL, 
  28.   PRIMARY KEY (id) 
  29. ) TYPE=MyISAM;
Download code! Download code (.txt)

 Stemmen
Niet ingelogd.

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