login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Fora/Discussieborden > F.A.Q. Systeem V1.0

F.A.Q. Systeem V1.0

Auteur: Rens - 21 december 2005 - 17:50 - Gekeurd door: nemesiskoen - Hits: 11084 - Aantal punten: 4.83 (6 stemmen)




(Het script staat tussen Fora/Discussieborden omdat ze daar vaak gebruikt worden en ik wist niet waar ik het script anders bij moest zetten)

Citaat:
Het voorbeeld werkt alleen als mijn computer aanstaat!
F.A.Q.
Admin
Gebruikersnaam: SiMa
Wachtwoord: test


Een F.A.Q. systeem met MySQL en admin.
Je kunt makkelijk vragen en categoriën toevoegen via het admin systeem.
Ze kunnen tevens aangepast en/of verwijderd worden.

Eerst even de MySQL tabellen aanmaken (code staat bovenaan bij de code).
Daarna de gegevens in includes/config.inc.php aanpassen.
En je kunt het systeem gebruiken.

Als er fouten zijn, stuur ze via PM of zet ze hier tussen de reacties.

Veel plezier ermee :-)

Code:
MySQL bestand:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. CREATE TABLE cat (
  2.   id int(11) NOT NULL auto_increment,
  3.   cat varchar(255) NOT NULL,
  4.   PRIMARY KEY  (id)
  5. );
  6.  
  7. CREATE TABLE vragen (
  8.   id int(11) NOT NULL auto_increment,
  9.   cat int(11) NOT NULL,
  10.   vraag varchar(255) NOT NULL,
  11.   antwoord text NOT NULL,
  12.   PRIMARY KEY  (id)
  13. );


index.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. 	<?PHP
  23. 	if(!IsSet($_GET['cat']) || !Is_Numeric($_GET['cat']))
  24. 	{
  25. 		$iCat = 1;
  26. 	} else
  27. 	{
  28. 		$iCat = (int)$_GET['cat'];
  29. 	}
  30.  
  31. 	$sQueryVragen = "SELECT id, vraag FROM vragen WHERE cat=".$iCat." ORDER BY vraag ASC";
  32. 	if(!$rResultVragen = MySQL_Query($sQueryVragen))
  33. 	{
  34. 		echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br /><br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  35. 	} else
  36. 	{
  37. 	?>
  38. <table class="containerTable">
  39. 	<tr>
  40. 		<td class="tableLinks" valign="top">
  41. <table class="vragen">
  42. <?PHP
  43. 		while($aFetchVragen = MySQL_Fetch_Assoc($rResultVragen))
  44. 		{
  45. ?>
  46. 	<tr>
  47. 		<td class="vragen">
  48. 			<a href="<?=$_SERVER['PHP_SELF'];?>?cat=<?=$iCat;?>#a<?=$aFetchVragen['id'];?>"><?=$aFetchVragen['vraag'];?></a>
  49. 		</td>
  50. 	</tr>
  51. <?PHP
  52. 		}
  53. ?>
  54. </table>
  55. <br />
  56. <?PHP
  57. 		$sQueryAntwoord = "SELECT id, vraag, antwoord FROM vragen WHERE cat=".$iCat." ORDER BY vraag ASC";
  58. 		if(!$rResultAntwoord = MySQL_Query($sQueryAntwoord))
  59. 		{
  60. 			echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br /><br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  61. 		} else
  62. 		{
  63. ?>
  64. <table class="vragen">
  65. <?PHP
  66. 			while($aFetchAntwoord = MySQL_Fetch_Assoc($rResultAntwoord))
  67. 			{
  68. ?>
  69. 	<tr>
  70. 		<td class="vragen">
  71. 			<b><a name="a<?=$aFetchAntwoord['id'];?>" id="a<?=$aFetchAntwoord['id'];?>"><?=$aFetchAntwoord['vraag'];?></a></b><br />
  72. 			<i><?=nl2br($aFetchAntwoord['antwoord']);?></i>
  73. 		</td>
  74. 	</tr>
  75. <?PHP
  76. 			}
  77. ?>
  78. </table>
  79. <?PHP
  80. 		}
  81. 	}
  82. ?>
  83. 		</td>
  84. 		<td class="tableRechts" valign="top">
  85. <?PHP
  86. 	$sQueryCat = "SELECT * FROM cat ORDER BY cat ASC";
  87. 	if(!$rResultCat = MySQL_Query($sQueryCat))
  88. 	{
  89. 		echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br /><br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  90. 	} else
  91. 	{
  92. ?>
  93. <table class="vragen">
  94. <?PHP
  95. 		while($aFetchCat = MySQL_Fetch_Assoc($rResultCat))
  96. 		{
  97. ?>
  98. 	<tr>
  99. 		<td class="vragen">
  100. 			<a href="<?=$_SERVER['PHP_SELF'];?>?cat=<?=$aFetchCat['id'];?>"><?=$aFetchCat['cat'];?></a>
  101. 		</td>
  102. 	</tr>
  103. <?PHP
  104. 		}
  105. ?>
  106. </table>
  107. <?PHP
  108. 	}
  109. ?>
  110. 		</td>
  111. 	</tr>
  112. </table>
  113. <?PHP
  114. }
  115. ?>
  116. </body>
  117. </html>


style.css:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. a:link.werkt
  2. {
  3. 	color: green;
  4. }
  5.  
  6. a:link.niet
  7. {
  8. 	color: red;
  9. }
  10.  
  11. table.containerTable
  12. {
  13. 	width:				80%;
  14. 	border:				1px solid #000000;
  15. }
  16.  
  17. table.vragen
  18. {
  19. 	margin-top:			2px;
  20. 	margin-bottom:		2px;
  21. 	width:				100%;
  22. 	height:				100%;
  23. 	border:				1px solid #000000;
  24. }
  25.  
  26. table.inner
  27. {
  28. 	width:				100%;
  29. }
  30.  
  31. td.tableLinks
  32. {
  33. 	width:				80%;
  34. 	border:				1px;
  35. }
  36.  
  37. td.tableRechts
  38. {
  39. 	width:				20%;
  40. 	border:				1px;
  41. }
  42.  
  43. td.vragen
  44. {
  45. 	margin-top:			2px;
  46. 	margin-left:		2px;
  47. 	margin-right:		2px;
  48. 	margin-bottom:		2px;
  49. 	width:				100%;
  50. 	border:				1px solid #000000;
  51. }
  52.  
  53. th.head
  54. {
  55. 	width:				100%;
  56. 	border:				1px solid #000000;
  57. }
  58.  
  59. td.subHead
  60. {
  61. 	width:				100%;
  62. 	border-top:			0px;
  63. 	border-left:		1px solid #000000;
  64. 	border-right:		1px solid #000000;
  65. 	border-bottom:		1px solid #000000;
  66. }
  67.  
  68. td.formLinks
  69. {
  70. 	width:				20%;
  71. 	border-top:			0px;
  72. 	border-left:		1px solid #000000;
  73. 	border-right:		1px solid #000000;
  74. 	border-bottom:		1px solid #000000;
  75. }
  76.  
  77. td.formRechts
  78. {
  79. 	width:				80%;
  80. 	border-top:			0px;
  81. 	border-left:		0px;
  82. 	border-right:		1px solid #000000;
  83. 	border-bottom:		1px solid #000000;
  84. }
  85.  
  86. input.field
  87. {
  88. 	width:				80%;
  89. 	margin-top:			2px;
  90. 	margin-left:		2px;
  91. 	margin-right:		2px;
  92. 	margin-bottom:		2px;
  93. 	border:				1px solid #000000;
  94. }
  95.  
  96. input.submit
  97. {
  98. 	margin-top:			2px;
  99. 	border:				1px solid #000000;
  100. }
  101.  
  102. input.reset
  103. {
  104. 	border:				1px solid #000000;
  105. }
  106.  
  107. textarea.text
  108. {
  109. 	border:				1px solid #000000;
  110. 	width:				80%;
  111. 	height:				125px;
  112. }
  113.  
  114. select
  115. {
  116. 	margin-top:			2px;
  117. 	margin-bottom:		2px;
  118. 	border:				1px solid #000000;
  119. 	width:				80%;
  120. }
  121.  
  122. div.center
  123. {
  124. 	text-align:			center;
  125. }


admin/index.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. ?>
  61. <table class="inner" cellpadding="0" cellspacing="0">
  62. 	<tr>
  63. 		<th class="head">
  64. 			Admin Menu
  65. 		</th>
  66. 	</tr>
  67. 	<tr>
  68. 		<td class="subHead">
  69. 			<a href="cat/toevoegen.php" title="Categorie toevoegen">Categorie toevoegen</a><br />
  70. 			<a href="cat/verwijderen.php" title="Categorie verwijderen">Categorie verwijderen</a><br />
  71. 			<a href="cat/aanpassen.php" title="Categorie aanpassen">Categorie aanpassen</a><br />
  72. 			<hr />
  73. 			<a href="vraag/toevoegen.php" title="Vraag toevoegen">Vraag toevoegen</a><br />
  74. 			<a href="vraag/verwijderen.php" title="Vraag verwijderen">Vraag verwijderen</a><br />
  75. 			<a href="vraag/aanpassen.php" title="Vraag aanpassen">Vraag aanpassen</a><br />
  76. 			<hr />
  77. 			<a href="loguit.php" title="Uitloggen">Uitloggen</a>
  78. 			<hr />
  79. 			<a href="../index.php" title="Naar de F.A.Q.">Naar de F.A.Q.</a>
  80. 		</td>
  81. 	</tr>
  82. </table>
  83. <?PHP
  84. 		}
  85. 	}
  86. ?>
  87. 		</td>
  88. 	</tr>
  89. </table>
  90. </body>
  91. </html>
  92. <?PHP
  93. }
  94. ?>


admin/login.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if($_SERVER['REQUEST_METHOD'] == "POST")
  27. 	{
  28. 		if(empty($_POST['gebr']))
  29. 		{
  30. 			$aError[] = "Je hebt geen gebruikersnaam ingevuld!";
  31. 		} else
  32. 		{
  33. 			if(Is_Array($adminGebr))
  34. 			{
  35. 				if(In_Array($_POST['gebr'], $adminGebr))
  36. 				{
  37. 					$bAdminGebr = true;
  38. 				}
  39. 			} else
  40. 			{
  41. 				if($_POST['gebr'] == $adminGebr)
  42. 				{
  43. 					$bAdminGebr = true;
  44. 				}
  45. 			}
  46. 		}
  47.  
  48. 		if(IsSet($bAdminGebr) && $bAdminGebr === false)
  49. 		{
  50. 			$aError[] = "Je hebt een verkeerde gebruikersnaam ingevuld!";
  51. 		}
  52.  
  53. 		if(empty($_POST['wwrd']))
  54. 		{
  55. 			$aError[] = "Je hebt geen wachtwoord ingevuld!";
  56. 		} else
  57. 		{
  58. 			$sWwrd = md5($_POST['wwrd']);
  59. 			if(Is_Array($adminWwrd))
  60. 			{
  61. 				if(In_Array($_POST['wwrd'], $adminWwrd))
  62. 				{
  63. 					$bAdminGebr = true;
  64. 				}
  65. 			} else
  66. 			{
  67. 				if($_POST['wwrd'] == $adminWwrd)
  68. 				{
  69. 					$bAdminWwrd = true;
  70. 				}
  71. 			}
  72. 		}
  73. 		if(IsSet($bAdminWwrd) && $bAdminWwrd === false)
  74. 		{
  75. 			$aError[] = "Je hebt een verkeerd wachtwoord ingevuld!";
  76. 		}
  77.  
  78. 		if(IsSet($aError))
  79. 		{
  80. ?>
  81. <table class="inner" cellpadding="0" cellspacing="0">
  82. 	<tr>
  83. 		<th class="head">
  84. 			Inloggen
  85. 		</th>
  86. 	</tr>
  87. 	<tr>
  88. 		<td class="subHead">
  89. 			U kunt niet worden ingelogd.<br />
  90. 			Dit kan door de volgende fouten komen:<br />
  91. 			<ul>
  92. <?PHP
  93. 			for($i = 0; $i < count($aError); $i++)
  94. 			{
  95. 				echo "<li>".$aError[$i]."</li>";
  96. 			}
  97. ?>
  98. 			</ul>
  99. 			<a href="javascript:history.go(-1);">Keer terug</a>
  100. 		</td>
  101. 	</tr>
  102. </table>
  103. <?PHP
  104. 		} else
  105. 		{
  106. 			$_SESSION['admin'] = htmlEntities($_POST['gebr']);
  107. 			$_SESSION['ip'] = $_SERVER['REMOTE_ADDR'];
  108. ?><table class="inner" cellpadding="0" cellspacing="0">
  109. 	<tr>
  110. 		<th class="head">
  111. 			Inloggen
  112. 		</th>
  113. 	</tr>
  114. 	<tr>
  115. 		<td class="subHead">
  116. 			U bent succesvol ingelogd!<br />
  117. 			U word nu automatisch doorgestuurd naar het menu.<br />
  118. <?PHP
  119. 			header("Refresh: 2; URL=index.php");
  120. ?>
  121. 		</td>
  122. 	</tr>
  123. </table>
  124. <?PHP
  125. 		}
  126. 	} else
  127. 	{
  128. ?>
  129. <form method="post" action="<?=str_replace("&", "&amp;", $_SERVER['REQUEST_URI']);?>">
  130. <table class="inner" cellpadding="0" cellspacing="0">
  131. 	<tr>
  132. 		<th colspan="2" class="head">
  133. 			Inloggen
  134. 		</th>
  135. 	</tr>
  136. 	<tr>
  137. 		<td colspan="2" class="subHead">
  138. 			Velden met een * zijn verplicht!
  139. 		</td>
  140. 	</tr>
  141. 	<tr>
  142. 		<td class="formLinks">
  143. 			Gebruikersnaam: *
  144. 		</td>
  145. 		<td class="formRechts">
  146. 			<div class="center">
  147. 			<input type="text" name="gebr" value="" maxlength="255" class="field" />
  148. 			</div>
  149. 		</td>
  150. 	</tr>
  151. 	<tr>
  152. 		<td class="formLinks">
  153. 			Wachtwoord: *
  154. 		</td>
  155. 		<td class="formRechts">
  156. 			<div class="center">
  157. 			<input type="password" name="wwrd" value="" maxlength="255" class="field" />
  158. 			</div>
  159. 		</td>
  160. 	</tr>
  161. 	<tr>
  162. 		<td colspan="2">
  163. 			<div class="center">
  164. 			<input type="submit" name="submit" value="Inloggen" class="submit" />
  165. 			<input type="reset" name="reset" value="Leeg velden" class="reset" />
  166. 			</div>
  167. 		</td>
  168. 	</tr>
  169. </table>
  170. </form>
  171. <?PHP
  172. 	}
  173. ?>
  174. 		</td>
  175. 	</tr>
  176. </table>
  177. </body>
  178. </html>
  179. <?PHP
  180. }
  181. ?>


admin/loguit.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. ?>
  61. <table class="inner" cellpadding="0" cellspacing="0">
  62. 	<tr>
  63. 		<th class="head">
  64. 			Uitloggen
  65. 		</th>
  66. 	</tr>
  67. 	<tr>
  68. 		<td class="subHead">
  69. <?PHP
  72. 			header("Refresh: 2; URL=../index.php");
  73. ?>
  74. 			U bent succesvol uitgelogd!
  75. 		</td>
  76. 	</tr>
  77. </table>
  78. <?PHP
  79. 		}
  80. 	}
  81. ?>
  82. 		</td>
  83. 	</tr>
  84. </table>
  85. </body>
  86. </html>
  87. <?PHP
  88. }
  89. ?>


admin/cat/aanpassen.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. 			if(IsSet($_GET['cat']) && Is_Numeric($_GET['cat']))
  61. 			{
  62. 				if($_SERVER['REQUEST_METHOD'] == "POST")
  63. 				{
  64. 					if(empty($_POST['naam']))
  65. 					{
  66. 						$aError[] = "Je hebt geen naam ingevuld!";
  67. 					}
  68. 					if(IsSet($aError))
  69. 					{
  70. ?>
  71. <table class="inner" cellpadding="0" cellspacing="0">
  72. 	<tr>
  73. 		<th class="head">
  74. 			Categorie aanpassen
  75. 		</th>
  76. 	</tr>
  77. 	<tr>
  78. 		<td class="subHead">
  79. 			De categorie kan niet worden aangepast!<br />
  80. 			Dit kan door de volgende fouten komen:<br />
  81. 			<ul>
  82. <?PHP
  83. 			for($i = 0; $i < count($aError); $i++)
  84. 			{
  85. 				echo "<li>".$aError[$i]."</li>";
  86. 			}
  87. ?>
  88. 			</ul>
  89. 			<a href="javascript:history.go(-1);">Keer terug</a>
  90. 		</td>
  91. 	</tr>
  92. </table>
  93. <?PHP
  94. 					} else
  95. 					{
  96. 						$sQueryCatAanpassen = "UPDATE cat SET cat='".htmlEntities($_POST['naam'], ENT_QUOTES)."' WHERE id=".$_GET['cat'];
  97. 						if(!$rResultCatAanpassen = MySQL_Query($sQueryCatAanpassen))
  98. 						{
  99. ?>
  100. <table class="inner" cellpadding="0" cellspacing="0">
  101. 	<tr>
  102. 		<th class="head">
  103. 			Categorie aanpassen
  104. 		</th>
  105. 	</tr>
  106. 	<tr>
  107. 		<td class="subHead">
  108. 			MySQL Error!<br />
  109. 			<?=MySQL_Error();?><br />
  110. 			<?=MySQL_Errno();?><br />
  111. 			<br />
  112. 			Bestand: <?=__FILE__;?><br />
  113. 			Lijn: <?=(__LINE__-3);?>
  114. 		</td>
  115. 	</tr>
  116. </table>
  117. <?PHP
  118. 						} else
  119. 						{
  120. ?>
  121. <table class="inner" cellpadding="0" cellspacing="0">
  122. 	<tr>
  123. 		<th class="head">
  124. 			Categorie aanpassen
  125. 		</th>
  126. 	</tr>
  127. 	<tr>
  128. 		<td class="subHead">
  129. 			De categorie is succesvol aangepast!<br />
  130. 			U word nu doorgestuurd naar het menu.<br />
  131. 			<?PHP
  132. 			header("Refresh: 2; URL=../index.php");
  133. 			?>
  134. 		</td>
  135. 	</tr>
  136. </table>
  137. <?PHP
  138. 						}
  139. 					}
  140. 				} else
  141. 				{
  142. 					$sQueryCatOphalen = "SELECT * FROM cat WHERE id=".$_GET['cat'];
  143. 					if(!$rResultCatOphalen = MySQL_Query($sQueryCatOphalen))
  144. 					{
  145. ?>
  146. <table class="inner" cellpadding="0" cellspacing="0">
  147. 	<tr>
  148. 		<th class="head">
  149. 			Categorie aanpassen
  150. 		</th>
  151. 	</tr>
  152. 	<tr>
  153. 		<td class="subHead">
  154. 			MySQL Error!<br />
  155. 			<?=MySQL_Error();?><br />
  156. 			<?=MySQL_Errno();?><br />
  157. 			<br />
  158. 			Bestand: <?=__FILE__;?><br />
  159. 			Lijn: <?=(__LINE__-3);?>
  160. 		</td>
  161. 	</tr>
  162. </table>
  163. <?PHP
  164. 					} else
  165. 					{
  166. ?>
  167. <form method="post" action="<?=$_SERVER['REQUEST_URI'];?>">
  168. <table class="inner" cellpadding="0" cellspacing="0">
  169. 	<tr>
  170. 		<th colspan="2" class="head">
  171. 			Categorie aanpassen
  172. 		</th>
  173. 	</tr>
  174. 	<tr>
  175. 		<td colspan="2" class="subHead">
  176. 			Velden met een * zijn verplicht!
  177. 		</td>
  178. 	</tr>
  179. 	<tr>
  180. 		<td class="formLinks">
  181. 			Naam: *
  182. 		</td>
  183. 		<td class="formRechts">
  184. 			<div class="center">
  185. 			<input type="text" name="naam" value="<?=MySQL_Result($rResultCatOphalen, 0, "cat");?>" maxlength="255" class="field" />
  186. 			</div>
  187. 	</tr>
  188. 	<tr>
  189. 		<td colspan="2">
  190. 			<div class="center">
  191. 			<input type="submit" name="submit" value="Aanpassen" class="submit" />
  192. 			<input type="reset" name="reset" value="Leeg velden" class="reset" />
  193. 			</div>
  194. 		</td>
  195. 	</tr>
  196. </table>
  197. </form>
  198. <?PHP
  199. 					}
  200. 				}
  201. 			} else
  202. 			{
  203. 				$sQueryCatOphalen = "SELECT * FROM cat ORDER BY cat ASC";
  204. 				if(!$rResultCatOphalen = MySQL_Query($sQueryCatOphalen))
  205. 				{
  206. ?>
  207. <table class="inner" cellpadding="0" cellspacing="0">
  208. 	<tr>
  209. 		<th class="head">
  210. 			Categorie aanpassen
  211. 		</th>
  212. 	</tr>
  213. 	<tr>
  214. 		<td class="subHead">
  215. 			MySQL Error!<br />
  216. 			<?=MySQL_Error();?><br />
  217. 			<?=MySQL_Errno();?><br />
  218. 			<br />
  219. 			<?=$rResultCatOphalen;?>
  220. 		</td>
  221. 	</tr>
  222. </table>
  223. <?PHP
  224. 				} else
  225. 				{
  226. ?>
  227. <table class="inner" cellpadding="0" cellspacing="0">
  228. 	<tr>
  229. 		<th class="head">
  230. 			Categorie aanpassen
  231. 		</th>
  232. 	</tr>
  233. 	<tr>
  234. 		<td class="subHead">
  235. 			Klik hieronder op een categorie
  236. 		</td>
  237. 	</tr>
  238. 	<tr>
  239. 		<td>
  240. <table class="vragen">
  241. <?PHP
  242. 					while($aFetchCatOphalen = MySQL_Fetch_Assoc($rResultCatOphalen))
  243. 					{
  244. ?>
  245. 	<tr>
  246. 		<td class="vragen">
  247. 			<a href="aanpassen.php?cat=<?=$aFetchCatOphalen['id'];?>"><?=$aFetchCatOphalen['cat'];?></a>
  248. 		</td>
  249. 	</tr>
  250. <?PHP
  251. 					}
  252. ?>
  253. </table>
  254. <?PHP
  255. 				}
  256. ?>
  257. 		</td>
  258. 	</tr>
  259. </table>
  260. <?PHP
  261. 			}
  262. 		}
  263. 	}
  264. ?>
  265. 		</td>
  266. 	</tr>
  267. </table>
  268. </body>
  269. </html>
  270. <?PHP
  271. }
  272. ?>


admin/cat/toevoegen.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. 			if($_SERVER['REQUEST_METHOD'] == "POST")
  61. 			{
  62. 				if(empty($_POST['naam']))
  63. 				{
  64. 					$aError[] = "Je hebt geen naam ingevuld!";
  65. 				}
  66. 				if(IsSet($aError))
  67. 				{
  68. ?>
  69. <table class="inner" cellpadding="0" cellspacing="0">
  70. 	<tr>
  71. 		<th class="head">
  72. 			Categorie toevoegen
  73. 		</th>
  74. 	</tr>
  75. 	<tr>
  76. 		<td class="subHead">
  77. 			De categorie kan niet worden toegevoegd!<br />
  78. 			Dit kan door de volgende fouten komen:<br />
  79. 			<ul>
  80. <?PHP
  81. 			for($i = 0; $i < count($aError); $i++)
  82. 			{
  83. 				echo "<li>".$aError[$i]."</li>";
  84. 			}
  85. ?>
  86. 			</ul>
  87. 			<a href="javascript:history.go(-1);">Keer terug</a>
  88. 		</td>
  89. 	</tr>
  90. </table>
  91. <?PHP
  92. 				} else
  93. 				{
  94. ?>
  95. <table class="inner" cellpadding="0" cellspacing="0">
  96. 	<tr>
  97. 		<th class="head">
  98. 			Categorie toevoegen
  99. 		</th>
  100. 	</tr>
  101. 	<tr>
  102. 		<td class="subHead">
  103. <?PHP
  104. 					$sQueryCatToevoegen = "INSERT INTO cat (cat) VALUES ('".htmlEntities($_POST['naam'], ENT_QUOTES)."')";
  105. 					if(!$rResultCatToevoegen = MySQL_Query($sQueryCatToevoegen))
  106. 					{
  107. 						echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br /><br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  108. 					} else
  109. 					{
  110. 						echo "De categorie is succesvol toegevoegd!<br />";
  111. 						echo "U word nu teruggestuurd naar het menu.<br />";
  112. 						header("Refresh: 2; URL=../index.php");
  113. 					}
  114. ?>
  115. 		</td>
  116. 	</tr>
  117. </table>
  118. <?PHP
  119. 				}
  120. 			} else
  121. 			{
  122. ?>
  123. <form method="post" action="<?=str_replace("&", "&amp;", $_SERVER['REQUEST_URI']);?>">
  124. <table class="inner" cellpadding="0" cellspacing="0">
  125. 	<tr>
  126. 		<th colspan="2" class="head">
  127. 			Categorie toevoegen
  128. 		</th>
  129. 	</tr>
  130. 	<tr>
  131. 		<td colspan="2" class="subHead">
  132. 			Velden met een * zijn verplicht!
  133. 		</td>
  134. 	</tr>
  135. 	<tr>
  136. 		<td class="formLinks">
  137. 			Naam: *
  138. 		</td>
  139. 		<td class="formRechts">
  140. 			<div class="center">
  141. 			<input type="text" name="naam" value="" maxlength="255" class="field" />
  142. 			</div>
  143. 		</td>
  144. 	</tr>
  145. 	<tr>
  146. 		<td colspan="2">
  147. 			<div class="center">
  148. 			<input type="submit" name="submit" value="Toevoegen" class="submit" />
  149. 			<input type="reset" name="reset" value="Leeg velden" class="reset" />
  150. 			</div>
  151. 		</td>
  152. 	</tr>
  153. </table>
  154. </form>
  155. <?PHP
  156. 			}
  157. 		}
  158. 	}
  159. ?>
  160. 		</td>
  161. 	</tr>
  162. </table>
  163. </body>
  164. </html>
  165. <?PHP
  166. }
  167. ?>


admin/cat/verwijderen.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. 			if(IsSet($_GET['cat']) && Is_Numeric($_GET['cat']))
  61. 			{
  62. 				if(IsSet($_GET['true']))
  63. 				{
  64. ?>
  65. <table class="inner" cellpadding="0" cellspacing="0">
  66. 	<tr>
  67. 		<th class="head">
  68. 			Categorie verwijderen
  69. 		</th>
  70. 	</tr>
  71. 	<tr>
  72. 		<td class="subHead">
  73. <?PHP
  74. 					$sQueryCatVerwijderen = "DELETE FROM cat WHERE id=".$_GET['cat'];
  75. 					if(!$rResultCatVerwijderen = MySQL_Query($sQueryCatVerwijderen))
  76. 					{
  77. 						echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br /><br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  78. 					} else
  79. 					{
  80. 						echo "De categorie is succesvol verwijderd!<br />";
  81. 						echo "U word nu teruggestuurd naar het menu.<br />";
  82. 						header("Refresh: 2; URL=../index.php");
  83. 					}
  84. ?>
  85. 		</td>
  86. 	</tr>
  87. </table>
  88. <?PHP
  89. 				} else
  90. 				{
  91. ?>
  92. <script language="javascript" type="text/javascript">
  93. if(window.confirm("Weet je zeker dat je de categorie wilt verwijderen!"))
  94. {
  95. 	window.location.href = "verwijderen.php?cat=<?=$_GET['cat'];?>&true";
  96. } else
  97. {
  98. 	window.location.href = "verwijderen.php";
  99. }
  100. </script>
  101. <?PHP
  102. 				}
  103. 			} else
  104. 			{
  105. 				$sQueryCatOphalen = "SELECT * FROM cat ORDER BY cat ASC";
  106. 				if(!$rResultCatOphalen = MySQL_Query($sQueryCatOphalen))
  107. 				{
  108. ?>
  109. <table class="inner" cellpadding="0" cellspacing="0">
  110. 	<tr>
  111. 		<th class="head">
  112. 			Categorie aanpassen
  113. 		</th>
  114. 	</tr>
  115. 	<tr>
  116. 		<td class="subHead">
  117. 			MySQL Error!<br />
  118. 			<?=MySQL_Error();?><br />
  119. 			<?=MySQL_Errno();?><br />
  120. 			<br />
  121. 			Bestand: <?=__FILE__;?><br />
  122. 			Lijn: <?=(__LINE__-3);?>
  123. 		</td>
  124. 	</tr>
  125. </table>
  126. <?PHP
  127. 				} else
  128. 				{
  129. ?>
  130. <table class="inner" cellpadding="0" cellspacing="0">
  131. 	<tr>
  132. 		<th class="head">
  133. 			Categorie aanpassen
  134. 		</th>
  135. 	</tr>
  136. 	<tr>
  137. 		<td class="subHead">
  138. 			Klik hieronder op een categorie
  139. 		</td>
  140. 	</tr>
  141. 	<tr>
  142. 		<td>
  143. <table class="vragen">
  144. <?PHP
  145. 					while($aFetchCatOphalen = MySQL_Fetch_Assoc($rResultCatOphalen))
  146. 					{
  147. ?>
  148. 	<tr>
  149. 		<td class="vragen">
  150. 			<a href="aanpassen.php?cat=<?=$aFetchCatOphalen['id'];?>"><?=$aFetchCatOphalen['cat'];?></a>
  151. 		</td>
  152. 	</tr>
  153. <?PHP
  154. 					}
  155. ?>
  156. </table>
  157. <?PHP
  158. 				}
  159. ?>
  160. 		</td>
  161. 	</tr>
  162. </table>
  163. <?PHP
  164. 			}
  165. 		}
  166. 	}
  167. ?>
  168. 		</td>
  169. 	</tr>
  170. </table>
  171. </body>
  172. </html>
  173. <?PHP
  174. }
  175. ?>


admin/vraag/aanpassen.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. 			if(!IsSet($_GET['id']) || !Is_Numeric($_GET['id']))
  61. 			{
  62. 				$sQueryCat = "SELECT * FROM cat ORDER BY cat ASC";
  63. 				if(!$rResultCat = MySQL_Query($sQueryCat))
  64. 				{
  65. 					echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  66. 				} else
  67. 				{
  68. 					while($aFetchCat = MySQL_Fetch_Assoc($rResultCat))
  69. 					{
  70. ?>
  71. <table class="inner" cellpadding="0" cellspacing="0">
  72. 	<tr>
  73. 		<th class="head">
  74. 			Vraag Aanpassen - <?=$aFetchCat['cat'];?>
  75. 		</th>
  76. 	</tr>
  77. <?PHP
  78. 						$sQueryVragen = "SELECT * FROM vragen WHERE cat=".$aFetchCat['id'];
  79. 						if(!$rResultVragen = MySQL_Query($sQueryVragen))
  80. 						{
  81. 							echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  82. 						} else
  83. 						{
  84. 							while($aFetchVragen = MySQL_Fetch_Assoc($rResultVragen))
  85. 							{
  86. ?>
  87. 	<tr>
  88. 		<td class="subHead">
  89. 			<b><?=$aFetchVragen['vraag'];?></b><br />
  90. 			<i><?=$aFetchVragen['antwoord'];?></i><br />
  91. 			<a href="aanpassen.php?id=<?=$aFetchVragen['id'];?>">Aanpassen</a>
  92. 		</td>
  93. 	</tr>
  94. <?PHP
  95. 							}
  96. 						}
  97. ?>
  98. </table><br />
  99. <?PHP
  100. 					}
  101. 				}
  102. 			} else
  103. 			{
  104. 				if($_SERVER['REQUEST_METHOD'] == "POST")
  105. 				{
  106. 					if(empty($_POST['vraag']))
  107. 					{
  108. 						$aError[] = "Je hebt geen vraag ingevuld!";
  109. 					}
  110. 					if(empty($_POST['antw']))
  111. 					{
  112. 						$aError[] = "Je hebt geen antwoord ingevuld!";
  113. 					}
  114. 					if(empty($_POST['cat']) || !Is_Numeric($_POST['cat']))
  115. 					{
  116. 						$aError[] = "Je hebt geen (correcte) categorie geselecteerd!";
  117. 					}
  118. 					if(empty($_POST['id']) || !Is_Numeric($_POST['id']))
  119. 					{
  120. 						$aError[] = "Er is geen of een onjuist ID meegestuurd!";
  121. 					}
  122. 					if(IsSet($aError))
  123. 					{
  124. ?>
  125. <table class="inner" cellpadding="0" cellspacing="0">
  126. 	<tr>
  127. 		<th class="head">
  128. 			Vraag aanpassen
  129. 		</th>
  130. 	</tr>
  131. 	<tr>
  132. 		<td class="subHead">
  133. 			De vraag kan niet worden aangepast!<br />
  134. 			Dit kan door de volgende fouten komen:<br />
  135. 			<ul>
  136. <?PHP
  137. 						for($i = 0; $i < count($aError); $i++)
  138. 						{
  139. 							echo "<li>".$aError[$i]."</li>";
  140. 						}
  141. ?>
  142. 			</ul>
  143. 			<a href="javascript:history.go(-1);">Keer terug</a>
  144. 		</td>
  145. 	</tr>
  146. </table>
  147. <?PHP
  148. 					} else
  149. 					{
  150. ?>
  151. <table class="inner" cellpadding="0" cellspacing="0">
  152. 	<tr>
  153. 		<th class="head">
  154. 			Vraag aanpassen
  155. 		</th>
  156. 	</tr>
  157. 	<tr>
  158. 		<td class="subHead">
  159. <?PHP
  160. 						$iCat = htmlEntities($_POST['cat'], ENT_QUOTES);
  161. 						$sVraag = htmlEntities($_POST['vraag'], ENT_QUOTES);
  162. 						$sAntw = htmlEntities($_POST['antw'], ENT_QUOTES);
  163. 						$iId = htmlEntities($_POST['id'], ENT_QUOTES);
  164.  
  165. 						$sQueryVraagAanpassen = "UPDATE vragen SET cat='".$iCat."', vraag='".$sVraag."', antwoord='".$sAntw."' WHERE id=".$iId;
  166. 						if(!$rResultVraagAanpassen = MySQL_Query($sQueryVraagAanpassen))
  167. 						{
  168. 							echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  169. 						} else
  170. 						{
  171. 							echo "De vraag is succesvol aangepast!<br />";
  172. 							echo "U word automatisch doorgestuurd naar het menu.";
  173. 							header("Refresh: 2; URL=../index.php");
  174. 						}
  175. ?>
  176. 		</td>
  177. 	</tr>
  178. </table>
  179. <?PHP
  180. 					}
  181. 				} else
  182. 				{
  183. 					$sQueryVraag = "SELECT * FROM vragen WHERE id=".$_GET['id'];
  184. 					if(!$rResultVraag = MySQL_Query($sQueryVraag))
  185. 					{
  186. 						echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  187. 					} else
  188. 					{
  189. 						while($aFetchVraag = MySQL_Fetch_Assoc($rResultVraag))
  190. 						{
  191. ?>
  192. <form method="post" action="<?=$_SERVER['REQUEST_URI'];?>">
  193. <input type="hidden" name="id" value="<?=$aFetchVraag['id'];?>" />
  194. <table class="inner" cellpadding="0" cellspacing="0">
  195. 	<tr>
  196. 		<th colspan="2" class="head">
  197. 			Vraag Aanpassen
  198. 		</th>
  199. 	</tr>
  200. 	<tr>
  201. 		<td colspan="2" class="subHead">
  202. 			Velden met een * zijn verplicht!
  203. 		</td>
  204. 	</tr>
  205. 	<tr>
  206. 		<td class="formLinks">
  207. 			Vraag: *
  208. 		</td>
  209. 		<td class="formRechts">
  210. 			<div class="center">
  211. 			<input type="text" name="vraag" value="<?=$aFetchVraag['vraag'];?>" class="field" />
  212. 			</div>
  213. 		</td>
  214. 	</tr>
  215. 	<tr>
  216. 		<td class="formLinks" valign="top">
  217. 			Antwoord: *
  218. 		</td>
  219. 		<td class="formRechts">
  220. 			<div class="center">
  221. 			<textarea name="antw" cols="0" rows="0" class="text"><?=$aFetchVraag['antwoord'];?></textarea>
  222. 			</div>
  223. 		</td>
  224. 	</tr>
  225. 	<tr>
  226. 		<td class="formLinks">
  227. 			Categorie: *
  228. 		</td>
  229. 		<td class="formRechts">
  230. 			<div class="center">
  231. <?PHP
  232. 							$sOption = "";
  233. 							$sQueryCatOphalen = "SELECT * FROM cat ORDER BY cat ASC";
  234. 							if(!$rResultCatOphalen = MySQL_Query($sQueryCatOphalen))
  235. 							{
  236. 								echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  237. 							} else
  238. 							{
  239. 								while($aFetchCatOphalen = MySQL_Fetch_Assoc($rResultCatOphalen))
  240. 								{
  241. 									if($aFetchVraag['cat'] == $aFetchCatOphalen['id'])
  242. 									{
  243. 										$sOption .= "<option value=\"".$aFetchCatOphalen['id']."\" selected=\"selected\">".$aFetchCatOphalen['cat']."</option>";
  244. 									} else
  245. 									{
  246. 										$sOption .= "<option value=\"".$aFetchCatOphalen['id']."\">".$aFetchCatOphalen['cat']."</option>";
  247. 									}
  248. 								}
  249. 							}
  250. ?>
  251. 			<select name="cat">
  252. 			<option value="" selected="selected">Kies een categorie</option>
  253. 			<option value="">----------------------------------------</option>
  254. 			<?=$sOption;?>
  255. 			</select>
  256. 			</div>
  257. 		</td>
  258. 	</tr>
  259. 	<tr>
  260. 		<td colspan="2">
  261. 			<div class="center">
  262. 			<input type="submit" name="submit" value="Aanpassen" class="submit" />
  263. 			<input type="reset" name="reset" value="Leeg velden" class="reset" />
  264. 			</div>
  265. 		</td>
  266. 	</tr>
  267. </table>
  268. </form>
  269. <?PHP
  270. 						}
  271. 					}
  272. 				}
  273. 			}
  274. 		}
  275. 	}
  276. ?>
  277. 		</td>
  278. 	</tr>
  279. </table>
  280. </body>
  281. </html>
  282. <?PHP
  283. }
  284. ?>


admin/vraag/toevoegen.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. 			if($_SERVER['REQUEST_METHOD'] == "POST")
  61. 			{
  62. 				if(empty($_POST['vraag']))
  63. 				{
  64. 					$aError[] = "Je hebt geen vraag ingevuld!";
  65. 				}
  66. 				if(empty($_POST['antw']))
  67. 				{
  68. 					$aError[] = "Je hebt geen antwoord ingevuld!";
  69. 				}
  70. 				if(empty($_POST['cat']) || !Is_Numeric($_POST['cat']))
  71. 				{
  72. 					$aError[] = "Je hebt geen (correcte) categorie geselecteerd!";
  73. 				}
  74. 				if(IsSet($aError))
  75. 				{
  76. ?>
  77. <table class="inner" cellpadding="0" cellspacing="0">
  78. 	<tr>
  79. 		<th class="head">
  80. 			Vraag toevoegen
  81. 		</th>
  82. 	</tr>
  83. 	<tr>
  84. 		<td class="subHead">
  85. 			De vraag kan niet worden toegevoegd!<br />
  86. 			Dit kan door de volgende fouten komen:<br />
  87. 			<ul>
  88. <?PHP
  89. 			for($i = 0; $i < count($aError); $i++)
  90. 			{
  91. 				echo "<li>".$aError[$i]."</li>";
  92. 			}
  93. ?>
  94. 			</ul>
  95. 			<a href="javascript:history.go(-1);">Keer terug</a>
  96. 		</td>
  97. 	</tr>
  98. </table>
  99. <?PHP
  100. 				} else
  101. 				{
  102. ?>
  103. <table class="inner" cellpadding="0" cellspacing="0">
  104. 	<tr>
  105. 		<th class="head">
  106. 			Vraag toevoegen
  107. 		</th>
  108. 	</tr>
  109. 	<tr>
  110. 		<td class="subHead">
  111. <?PHP
  112. 					$sVraag = htmlEntities($_POST['vraag'], ENT_QUOTES);
  113. 					$sAntw = htmlEntities($_POST['antw'], ENT_QUOTES);
  114. 					$iCat = htmlEntities($_POST['cat'], ENT_QUOTES);
  115. 					$sQueryVraagToevoegen = "INSERT INTO vragen (cat, vraag, antwoord) VALUES ('".$iCat."', '".$sVraag."', '".$sAntw."')";
  116. 					if(!$rResultVraagToevoegen = MySQL_Query($sQueryVraagToevoegen))
  117. 					{
  118. 						echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  119. 					} else
  120. 					{
  121. 						echo "De vraag is succesvol toegevoegd!<br />";
  122. 						echo "U word automatisch doorgestuurd naar het menu.";
  123. 						header("Refresh: 2; URL=../index.php");
  124. 					}
  125. ?>
  126. 		</td>
  127. 	</tr>
  128. </table>
  129. <?PHP
  130. 				}
  131. 			} else
  132. 			{
  133. ?>
  134. <form method="post" action="<?=str_replace("&", "&amp;", $_SERVER['REQUEST_URI']);?>">
  135. <table class="inner" cellpadding="0" cellspacing="0">
  136. 	<tr>
  137. 		<th colspan="2" class="head">
  138. 			Vraag toevoegen
  139. 		</th>
  140. 	</tr>
  141. 	<tr>
  142. 		<td colspan="2" class="subHead">
  143. 			Velden met een * zijn verplicht!
  144. 		</td>
  145. 	</tr>
  146. 	<tr>
  147. 		<td class="formLinks">
  148. 			Vraag: *
  149. 		</td>
  150. 		<td class="formRechts">
  151. 			<div class="center">
  152. 			<input type="text" name="vraag" value="" maxlength="255" class="field" />
  153. 			</div>
  154. 		</td>
  155. 	</tr>
  156. 	<tr>
  157. 		<td class="formLinks" valign="top">
  158. 			Antwoord: *
  159. 		</td>
  160. 		<td class="formRechts">
  161. 			<div class="center">
  162. 			<textarea name="antw" cols="0" rows="0" class="text"></textarea>
  163. 			</div>
  164. 		</td>
  165. 	</tr>
  166. 	<tr>
  167. 		<td class="formLinks" valign="top">
  168. 			Categorie: *
  169. 		</td>
  170. 		<td class="formRechts">
  171. 			<div class="center">
  172. <?PHP
  173. 				$sOption = "";
  174. 				$sQueryCatOphalen = "SELECT * FROM cat ORDER BY cat ASC";
  175. 				if(!$rResultCatOphalen = MySQL_Query($sQueryCatOphalen))
  176. 				{
  177. 					echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  178. 				} else
  179. 				{
  180. 					while($aFetchCatOphalen = MySQL_Fetch_Assoc($rResultCatOphalen))
  181. 					{
  182. 						$sOption .= "<option value='".$aFetchCatOphalen['id']."'>".$aFetchCatOphalen['cat']."</option>";
  183. 					}
  184. 				}
  185. ?>
  186. 			<select name="cat">
  187. 			<option value="" selected="selected">Kies een categorie</option>
  188. 			<option value="">----------------------------------------</option>
  189. 			<?=$sOption;?>
  190. 			</select>
  191. 			</div>
  192. 		</td>
  193. 	</tr>
  194. 	<tr>
  195. 		<td colspan="2">
  196. 			<div class="center">
  197. 			<input type="submit" name="submit" value="Toevoegen" class="submit" />
  198. 			<input type="reset" name="reset" value="Leeg velden" class="reset" />
  199. 			</div>
  200. 		</td>
  201. 	</tr>
  202. </table>
  203. </form>
  204. <?PHP
  205. 			}
  206. 		}
  207. 	}
  208. ?>
  209. 		</td>
  210. 	</tr>
  211. </table>
  212. </body>
  213. </html>
  214. <?PHP
  215. }
  216. ?>


admin/vraag/verwijderen.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  4. DEFINE("IN_FAQ", true);
  5. include "../../includes/config.inc.php";
  6. if(!DEFINED("CONNECT") === true)
  7. {
  8. 	die("Error!- Hack poging!");
  9. } else
  10. {
  11. ?>
  12. <!DOCTYPE html 
  13.      PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  14.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <link rel="stylesheet" type="text/css" href="../../style.css" />
  19. <title> -= F.A.Q. Systeem =- </title>
  20. </head>
  21. <body>
  22. <table class="containerTable">
  23. 	<tr>
  24. 		<td class="tableLinks" valign="top">
  25. <?PHP
  26. 	if(!IsSet($_SESSION['admin']))
  27. 	{
  28. 		header("Location: login.php");
  29. 	} else
  30. 	{
  31. 		if(Is_Array($adminGebr))
  32. 		{
  33. 			if(!In_Array($_SESSION['admin'], $adminGebr))
  34. 			{
  35. 				$bAdmin = false;
  36. 			} else
  37. 			{
  38. 				$bAdmin = true;
  39. 			}
  40. 		} else
  41. 		{
  42. 			if($_SESSION['admin'] != $adminGebr)
  43. 			{
  44. 				$bAdmin = false;
  45. 			} else
  46. 			{
  47. 				$bAdmin = true;
  48. 			}
  49. 		}
  50. 		if($_SESSION['ip'] != $_SERVER['REMOTE_ADDR'])
  51. 		{
  52. 			$bAdmin = false;
  53. 		}
  54.  
  55. 		if($bAdmin === false)
  56. 		{
  57. 			header("Location: login.php");
  58. 		} else
  59. 		{
  60. 			if(!IsSet($_GET['id']) || !Is_Numeric($_GET['id']))
  61. 			{
  62. 				$sQueryCat = "SELECT * FROM cat ORDER BY cat ASC";
  63. 				if(!$rResultCat = MySQL_Query($sQueryCat))
  64. 				{
  65. 					echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  66. 				} else
  67. 				{
  68. 					while($aFetchCat = MySQL_Fetch_Assoc($rResultCat))
  69. 					{
  70. ?>
  71. <table class="inner" cellpadding="0" cellspacing="0">
  72. 	<tr>
  73. 		<th class="head">
  74. 			Vraag Aanpassen - <?=$aFetchCat['cat'];?>
  75. 		</th>
  76. 	</tr>
  77. <?PHP
  78. 						$sQueryVragen = "SELECT * FROM vragen WHERE cat=".$aFetchCat['id'];
  79. 						if(!$rResultVragen = MySQL_Query($sQueryVragen))
  80. 						{
  81. 							echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  82. 						} else
  83. 						{
  84. 							while($aFetchVragen = MySQL_Fetch_Assoc($rResultVragen))
  85. 							{
  86. ?>
  87. 	<tr>
  88. 		<td class="subHead">
  89. 			<b><?=$aFetchVragen['vraag'];?></b><br />
  90. 			<i><?=$aFetchVragen['antwoord'];?></i><br />
  91. 			<a href="verwijderen.php?id=<?=$aFetchVragen['id'];?>">Verwijderen</a>
  92. 		</td>
  93. 	</tr>
  94. <?PHP
  95. 							}
  96. 						}
  97. ?>
  98. </table><br />
  99. <?PHP
  100. 					}
  101. 				}
  102. 			} else
  103. 			{
  104. 				if(IsSet($_GET['true']))
  105. 				{
  106. ?>
  107. <table class="inner" cellpadding="0" cellspacing="0">
  108. 	<tr>
  109. 		<th class="head">
  110. 			Vraag verwijderen
  111. 		</th>
  112. 	</tr>
  113. 	<tr>
  114. 		<td class="subHead">
  115. <?PHP
  116. 					$sQueryVraagVerwijderen = "DELETE FROM vragen WHERE id=".$_GET['id'];
  117. 					if(!$rResultVraagVerwijderen = MySQL_Query($sQueryVraagVerwijderen))
  118. 					{
  119. 						echo "MySQL Error!<br />".MySQL_Error()."<br />".MySQL_Errno()."<br /><br />Bestand: ".__FILE__."<br />Lijn: ".(__LINE__-3);
  120. 					} else
  121. 					{
  122. 						echo "De vraag is succesvol verwijderd!<br />";
  123. 						echo "U word nu teruggestuurd naar het menu.<br />";
  124. 						header("Refresh: 2; URL=../index.php");
  125. 					}
  126. ?>
  127. 		</td>
  128. 	</tr>
  129. </table>
  130. <?PHP
  131. 				} else
  132. 				{
  133. ?>
  134. <script language="javascript" type="text/javascript">
  135. if(window.confirm("Weet je zeker dat je de vraag wilt verwijderen!"))
  136. {
  137. 	window.location.href = "verwijderen.php?id=<?=$_GET['id'];?>&true";
  138. } else
  139. {
  140. 	window.location.href = "verwijderen.php";
  141. }
  142. </script>
  143. <?PHP
  144. 				}
  145. 			}
  146. 		}
  147. 	}
  148. ?>
  149. 		</td>
  150. 	</tr>
  151. </table>
  152. </body>
  153. </html>
  154. <?PHP
  155. }
  156. ?>


includes/config.inc.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?PHP
  2. if(!DEFINED("IN_FAQ") === true)
  3. {
  4. 	die("Error!- Hack poging!");
  5. } else
  6. {
  7. 	$aMySQL['host'] = ""; // MySQL host
  8. 	$aMySQL['user'] = ""; // MySQL gebruikersnaam
  9. 	$aMySQL['pass'] = ""; // MySQL wachtwoord
  10. 	$aMySQL['daba'] = ""; // MySQL database
  11.  
  12. 	$adminGebr = "";
  13. 	$adminWwrd = ""; // LET OP:	WACHTWOORD IN MD5
  14. 	/*
  15. 		Als je meerdere admins wilt hebben gebruik dan het volgende:
  16. 		$adminGebr[0] = "Gebruikersnaam 1";
  17. 		$adminWwrd[0] = "Wachtwoord 1"; // LET OP:	WACHTWOORD IN MD5
  18.  
  19. 		$adminGebr[1] = "Gebruikersnaam 2";
  20. 		$adminWwrd[1] = "Wachtwoord 2"; // LET OP:	WACHTWOORD IN MD5
  21.  
  22. 	*/
  23.  
  24. 	if(!$aMySQL['conn'] = MySQL_Connect($aMySQL['host'], $aMySQL['user'], $aMySQL['pass']))
  25. 	{
  26. 		die("Error!- Kan geen verbinding maken met de MySQL server!<br />".MySQL_Error()."<br />".MySQL_Errno());
  27. 	} else
  28. 	{
  29. 		if(!$aMySQL['sele'] = MySQL_Select_DB($aMySQL['daba'], $aMySQL['conn']))
  30. 		{
  31. 			die("Error!- Kan de database niet selecteren!<br />".MySQL_Error()."<br />".MySQL_Errno());
  32. 		} else
  33. 		{
  34. 			DEFINE("CONNECT", true);
  35. 		}
  36. 	}
  37. }
  38. ?>
Download code! Download code (.txt)

Download dit script! Bekijk een voorbeeld van dit script!
 Stemmen
Niet ingelogd.

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