login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Overige scripts > Artikelen systeem

Artikelen systeem

Auteur: Carpmadness - 11 september 2004 - 17:35 - Gekeurd door: Dennisvb - Hits: 10872 - Aantal punten: 3.60 (5 stemmen)



Vrij simpel, config even aanpassen en run install.php

Code:
install.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <? 
  2. require_once('config.php'); 
  3.  
  4. $tabel =  'CREATE TABLE '.$arr['tnam'].' ( 
  5.                 `aid` INT(11) AUTO_INCREMENT PRIMARY KEY, 
  6.                 `aname` VARCHAR(100), 
  7.                 `aauthor` VARCHAR(100), 
  8.                 `aip` VARCHAR(100), 
  9.                 `adate` VARCHAR(100), 
  10.                 `acat` VARCHAR(100), 
  11.                 `acomment` TEXT, 
  12.                 `aartikel` LONGTEXT 
  13.                 )'; 
  14.  
  15. mysql_query($tabel) or die("Fout bij het installeren"); 
  16.  
  17. ?>


config.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <? 
  2. $arr['host'] = 'localhost'; // Je host 
  3. $arr['user'] = ''; // Je database gebruikers gebruikersnaam 
  4. $arr['pass'] = ''; // Je database gebruikers wachtwoord 
  5. $arr['dbsl'] = ''; // Je database naam 
  6. $arr['tnam'] = 'artikelen'; // Naam van de tabel die je hiervoor gaat gebruiken 
  7.  
  8. // Stel de categorien van de artikelen in doormiddel van  een array 
  9. // Voeg er meer toe door , 'Categorie naam' 
  10. // laat de eerste leeg om te zorgen zodat de check of alles is ingevuldt goed functioneert 
  11. $arr['arra'] = array('Categorie1', 'Categorie2', 'Categorie3', 'Categorie4', 'Categorie5'); 
  12.  
  13. // Simpel connecten met de genoemde database 
  14. mysql_connect($arr['host'], $arr['user'], $arr['pass'], $arr['dbsl']) or die('Er is helaas iets misgegaan tijdens het connecten met de database '.$arr['dbsl'].' Dit komt door:<br>'.mysql_error()); 
  15. mysql_select_db($arr['dbsl']); 
  16.  
  17. function simpele_ubb($bericht){ 
  18.  
  19.         $bericht = htmlspecialchars($bericht); 
  20.          // en nog meer ubb 
  21.         return $bericht; 
  22.  
  23. } 
  24. ?>


admin.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <? 
  3. ?> 
  4. <link href="style.css" rel="stylesheet" type="text/css"> 
  5. <? 
  6. require_once'config.php'; 
  7.     if (isset ($_GET['a'])){ 
  8.  
  9.         if ($_GET['a'] == 'add'){ 
  10.             if (isset($_POST['opslaan'])){ 
  11.             if (!$_POST['aauthor'] || !$_POST['aname'] || !$_POST['acat'] || !$_POST['acomment'] || !$_POST['aartikel']){ 
  12.                     echo'Je hebt niet alles ingevuldt..!<br><a href="javascript:history.go(-1)">Klik hier om terug te gaan en om het nog is te proberen'; 
  13.             }else { 
  14.                     $arr['input'] = 'INSERT INTO '.$arr['tnam'].' (aname, aauthor, aip, adate, acat, acomment, aartikel) VALUES ("'.$_POST['aname'].'", "'.$_POST['aauthor'].'", "'.$_SERVER['REMOTE_ADDR'].'", "'.date('d-m-Y | H:i:s').'", "'.$_POST['acat'].'", "'.$_POST['acomment'].'", "'.$_POST['aartikel'].'")'; 
  15.                     $arr['putin'] = mysql_query($arr['input']); 
  16.  
  17.                     if ($arr['putin'] === true){ 
  18.                         header('location: admin.php'); 
  19.                     }else { 
  20.                         echo'Het is helaas niet gelukt om het op te slaan in de database '.$arr['tnam'].'...<br><a href="javascript:history.go(-1)">Klik hier om terug te gaan en om het nog is te proberen</a>'; 
  21.                     } 
  22.                 } 
  23.             }else { 
  24.  
  25. ?> 
  26. <form action="admin.php?a=add" method="post"> 
  27.   <table width="600" border="0" cellpadding="0" cellspacing="0"> 
  28.     <tr> 
  29.       <td height="20" colspan="2"><strong>Artikelen Admin Panel :: TOEVOEGEN</strong></td> 
  30.     </tr> 
  31.     <tr> 
  32.       <td height="20" colspan="2">&nbsp;</td> 
  33.     </tr> 
  34.     <tr> 
  35.       <td height="20" colspan="2"><strong>Auteur: </strong></td> 
  36.     </tr> 
  37.     <tr> 
  38.       <td height="20" colspan="2"><strong> 
  39.         <input name="aauthor" type="text" id="aauthor" size="30"> 
  40.         </strong></td> 
  41.     </tr> 
  42.     <tr> 
  43.       <td height="20" colspan="2"><strong>Artikel naam:</strong></td> 
  44.     </tr> 
  45.     <tr> 
  46.       <td height="20" colspan="2"><strong> 
  47.         <input name="aname" type="text" id="aname" size="93"> 
  48.         </strong></td> 
  49.     </tr> 
  50.     <tr> 
  51.       <td height="20" colspan="2"><strong>Artikel categorie:</strong></td> 
  52.     </tr> 
  53.     <tr> 
  54.       <td height="20" colspan="2"><strong> 
  55.         <select name="acat" id="acat"> 
  56.           <? 
  57.     foreach ($arr['arra'] as $val) { 
  58.     echo'<option value="'.$val.'">'.$val.'</option>'; 
  59.     }      
  60. ?> 
  61.         </select> 
  62.         </strong></td> 
  63.     </tr> 
  64.     <tr> 
  65.       <td height="20" colspan="2"><strong>Artikel commentaar:</strong></td> 
  66.     </tr> 
  67.     <tr> 
  68.       <td height="20" colspan="2"><textarea name="acomment" cols="92" rows="5" wrap="VIRTUAL" id="textarea5"></textarea></td> 
  69.     </tr> 
  70.     <tr> 
  71.       <td height="20" colspan="2"><strong>Artikel:</strong> (het hele artikel)</td> 
  72.     </tr> 
  73.     <tr> 
  74.       <td height="20" colspan="2"><textarea name="aartikel" cols="117" rows="30" wrap="VIRTUAL" id="textarea6"></textarea></td> 
  75.     </tr> 
  76.     <tr> 
  77.       <td height="20" colspan="2">&nbsp;</td> 
  78.     </tr> 
  79.     <tr> 
  80.       <td width="300" height="20" valign="middle"> 
  81.         <input name="refresh" type="reset" id="refresh" value="[ Refrehs ]"> 
  82.       </td> 
  83.       <td width="300" align="center" valign="middle"> 
  84.         <input name="opslaan" type="submit" id="opslaan" value="[ Opslaan ]"></td> 
  85.     </tr> 
  86.     <tr> 
  87.       <td height="20" colspan="2">&nbsp;</td> 
  88.     </tr> 
  89.   </table>    
  90. </form> 
  91. <?        } 
  92.     }else if ($_GET['a'] == 'delete'){ 
  93.         if (isset($_GET['id'])){ 
  94.             if ($_GET['id'] !== ''){ 
  95.             $arr['delete'] = 'DELETE FROM '.$arr['tnam'].' WHERE aid="'.$_GET['id'].'"'; 
  96.             $arr['eteled'] = mysql_query($arr['delete']); 
  97.                 if ($arr['eteled'] === true){ 
  98.                     header('location: admin.php'); 
  99.                 }else { 
  100.                     echo'Het is helaas niet gelukt om het gewenste artikel te verwijderen uit de tabel '.$arr['tnam'].'...<br><a href="javascript:history.go(-1)">Klik hier om terug te gaan en om het nog is te proberen</a>'; 
  101.                 } 
  102.             }else { 
  103.                 echo'Je moet wel een artikel id kiezen om te verwijderen...<br><a href="javascript:history.go(-1)">Klik hier om terug te gaan en om het nog is te proberen</a>'; 
  104.             } 
  105.         } 
  106.  
  107.     }else if ($_GET['a'] == 'edit'){ 
  108.         if (isset($_GET['id'])){ 
  109.             if ($_GET['id'] !== ''){ 
  110.                 if (isset($_POST['edit'])){ 
  111.                     $arr['update'] = 'UPDATE '.$arr['tnam'].' SET aname="'.$_POST['aname'].'", aip="'.$_SERVER['REMOTE_ADDR'].'", adate="'.date('d-m-Y | H:i:s').'", acat="'.$_POST['acat'].'", acomment="'.$_POST['acomment'].'", aartikel="'.$_POST['aartikel'].'"  WHERE aid="'.$_GET['id'].'"'; 
  112.                     $arr['dateup'] = mysql_query($arr['update']); 
  113.  
  114.                     if ($arr['dateup'] === true){ 
  115.                         header('location: admin.php'); 
  116.                     }else { 
  117.                         echo'Het is helaas niet gelukt om het gewenste artikel te verwijderen uit de tabel '.$arr['tnam'].'...<br><a href="javascript:history.go(-1)">Klik hier om terug te gaan en om het nog is te proberen</a>'; 
  118.                     } 
  119.                 }else { 
  120.                     $arr['select'] = 'SELECT * FROM '.$arr['tnam'].' WHERE aid="'.$_GET['id'].'"'; 
  121.                     $arr['getsel'] = mysql_query($arr['select']); 
  122.                     $arr['info'] = mysql_fetch_object($arr['getsel']); 
  123.  
  124. ?> 
  125.     <form action="admin.php?a=edit&id=<? echo $_GET['id']; ?>" method="post"> 
  126.   <table width="600" border="0" cellpadding="0" cellspacing="0"> 
  127.     <tr> 
  128.       <td height="20" colspan="2"><strong>Artikelen Admin Panel :: TOEVOEGEN</strong></td> 
  129.     </tr> 
  130.     <tr> 
  131.       <td height="20" colspan="2">&nbsp;</td> 
  132.     </tr> 
  133.     <tr> 
  134.       <td height="20" colspan="2"><strong>Artikel naam:</strong></td> 
  135.     </tr> 
  136.     <tr> 
  137.       <td height="20" colspan="2"><strong> 
  138.         <input name="aname" type="text" id="aname" size="93" value="<? echo $arr['info']->aname; ?>"> 
  139.         </strong></td> 
  140.     </tr> 
  141.     <tr> 
  142.       <td height="20" colspan="2"><strong>Artikel categorie:</strong></td> 
  143.     </tr> 
  144.     <tr> 
  145.       <td height="20" colspan="2"><strong> 
  146.         <select name="acat" id="acat"> 
  147.         <option value="<? echo $arr['info']->acat; ?>"><? echo $arr['info']->acat; ?></option> 
  148.           <? 
  149.     foreach ($arr['arra'] as $val) { 
  150.     echo'<option value="'.$val.'">'.$val.'</option>'; 
  151.     }      
  152. ?> 
  153.         </select> 
  154.         </strong></td> 
  155.     </tr> 
  156.     <tr> 
  157.       <td height="20" colspan="2"><strong>Artikel commentaar:</strong></td> 
  158.     </tr> 
  159.     <tr> 
  160.       <td height="20" colspan="2"><textarea name="acomment" cols="92" rows="5" wrap="VIRTUAL" id="textarea5"><? echo $arr['info']->acomment; ?></textarea></td> 
  161.     </tr> 
  162.     <tr> 
  163.       <td height="20" colspan="2"><strong>Artikel:</strong> (het hele artikel)</td> 
  164.     </tr> 
  165.     <tr> 
  166.       <td height="20" colspan="2"><textarea name="aartikel" cols="117" rows="30" wrap="VIRTUAL" id="textarea6"><? echo $arr['info']->aartikel; ?></textarea></td> 
  167.     </tr> 
  168.     <tr> 
  169.       <td height="20" colspan="2">&nbsp;</td> 
  170.     </tr> 
  171.     <tr> 
  172.       <td width="300" height="20" valign="middle"> <input name="refresh" type="reset" id="refresh" value="[ Refrehs ]"> 
  173.       </td> 
  174.       <td width="300" align="center" valign="middle"> <input name="edit" type="submit" id="edit" value="[ Bewerk ]"></td> 
  175.     </tr> 
  176.     <tr> 
  177.       <td height="20" colspan="2">&nbsp;</td> 
  178.     </tr> 
  179.   </table>    
  180. </form> 
  181.  
  182. <?                  
  183.  
  184.                 } 
  185.             }else { 
  186.                 echo'Je moet wel een artikel id kiezen om te bewerken...<br><a href="javascript:history.go(-1)">Klik hier om terug te gaan en om het nog is te proberen</a>'; 
  187.             } 
  188.         } 
  189.     }else { 
  190.         header('location: index.php'); 
  191.     } 
  192. }else { 
  193. ?> 
  194. <table width="600" border="0" cellpadding="0" cellspacing="0"> 
  195.   <tr> 
  196.     <td height="20"><strong>Artikelen Admin Panel :: KIES ACTIE</strong></td> 
  197.   </tr> 
  198.   <tr> 
  199.     <td height="20" align="center" valign="middle"><a href="admin.php?a=add"><strong>Nieuw 
  200.       artikel toevoegen?</strong></a></td> 
  201.   </tr> 
  202.   <tr> 
  203.     <td height="20">&nbsp;</td> 
  204.   </tr> 
  205. <? 
  206.       $arr['select'] = 'SELECT * FROM '.$arr['tnam']; 
  207.     $arr['getsel'] = mysql_query($arr['select']); 
  208.     while ($arr['info'] = mysql_fetch_object($arr['getsel'])){ 
  209. ?> 
  210.   <tr> 
  211.     <td height="20"><strong># 
  212.       <? 
  213. echo $arr['info']->aid; 
  214. ?> 
  215.       : 
  216.       <? 
  217. echo $arr['info']->aname; 
  218. ?> 
  219.       </strong><br> 
  220.       [ <a href="admin.php?a=delete&id=<? echo $arr['info']->aid; ?>">Verwijderen</a> 
  221.       | <a href="admin.php?a=edit&id=<? echo $arr['info']->aid; ?>">Bewerken</a> 
  222.       ]</td> 
  223.   </tr> 
  224. <? 
  225. } 
  226. ?> 
  227.   <tr> 
  228.     <td height="20">&nbsp;</td> 
  229.   </tr> 
  230. </table> 
  231. <? 
  232. } 
  233. ?>


index.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <? 
  3.  
  4. require_once('config.php'); 
  5.  
  6. if (isset ($_GET['cat'])){ 
  7.  
  8.     if (isset ($_GET['id'])){ 
  9.         if (empty($_GET['id'])) 
  10.                 header('location: index.php'); 
  11.         else { 
  12.             $arr['select'] = 'SELECT * FROM '.$arr['tnam'].' WHERE acat="'.$_GET['cat'].'" AND aid="'.$_GET['id'].'"'; 
  13.             $arr['getsel'] = mysql_query($arr['select']); 
  14.             $arr['info'] = mysql_fetch_object($arr['getsel']); 
  15.  
  16.         echo'<table width="600" border="0" cellpadding="0" cellspacing="0"> 
  17.               <tr> 
  18.                 <td height="20" colspan="2">&nbsp;</td> 
  19.               </tr> 
  20.               <tr> 
  21.                 <td height="20" colspan="2"><strong>Auteur: </strong></td> 
  22.               </tr> 
  23.               <tr> 
  24.                 <td height="20" colspan="2">'.$arr['info']->aauthor.'</td> 
  25.               </tr> 
  26.               <tr> 
  27.                 <td height="20" colspan="2"><strong>Artikel naam:</strong></td> 
  28.               </tr> 
  29.               <tr> 
  30.                 <td height="20" colspan="2">'.$arr['info']->aname.'</td> 
  31.               </tr> 
  32.               <tr> 
  33.                 <td height="20" colspan="2"><strong>Artikel categorie:</strong></td> 
  34.               </tr> 
  35.               <tr> 
  36.                 <td height="20" colspan="2">'.$arr['info']->acat.'</td> 
  37.               </tr> 
  38.               <tr> 
  39.                 <td height="20" colspan="2"><strong>Artikel commentaar:</strong></td> 
  40.               </tr> 
  41.               <tr> 
  42.                 <td height="20" colspan="2">'.$arr['info']->acomment.'</td> 
  43.               </tr> 
  44.               <tr> 
  45.                 <td height="20" colspan="2"><strong>Artikel:</strong> (het hele artikel)</td> 
  46.               </tr> 
  47.               <tr> 
  48.                 <td height="20" colspan="2">'.simpele_ubb($arr['info']->aartikel).'</td> 
  49.               </tr> 
  50.               <tr> 
  51.                 <td height="20" colspan="2">&nbsp;</td> 
  52.               </tr> 
  53.               <tr> 
  54.                 <td height="20" colspan="2">&nbsp;</td> 
  55.               </tr> 
  56.             </table>'; 
  57.  
  58.         } 
  59.  
  60.     }else { 
  61.         if (empty($_GET['cat'])) 
  62.             header('location: index.php'); 
  63.  
  64.  
  65.         $arr['select'] = 'SELECT * FROM '.$arr['tnam'].' WHERE acat="'.$_GET['cat'].'"'; 
  66.         $arr['getsel'] = mysql_query($arr['select']); 
  67.         while ($arr['info'] = mysql_fetch_object($arr['getsel'])){ 
  68.     ?> 
  69.  
  70. <table width="600" border="0" cellspacing="0" cellpadding="0"> 
  71.   <tr> 
  72.     <td><strong>Categorie:</strong></td> 
  73.     <td><strong>Auteur:</strong></td> 
  74.   <tr> 
  75.     <td><a href="index.php?cat=<? echo $arr['info']->acat; ?>&id=<? echo $arr['info']->aid; ?>"><? echo $arr['info']->aname; ?></a></td> 
  76.     <td><? echo $arr['info']->aauthor; ?></td> 
  77.   <tr> 
  78.     <td colspan="4">&nbsp;</td> 
  79.   </tr> 
  80. </table> 
  81.  
  82. <? 
  83.         } 
  84.     } 
  85. }else{ 
  86.       $arr['select'] = 'SELECT * FROM '.$arr['tnam']; 
  87.     $arr['getsel'] = mysql_query($arr['select']); 
  88.     $arr['info'] = mysql_fetch_object($arr['getsel']) 
  89.  
  90. ?> 
  91. <table width="600" border="0" cellspacing="0" cellpadding="0"> 
  92.   <tr> 
  93.     <td><strong>Categorie:</strong></td> 
  94.     <td><strong>Aantal:</strong></td> 
  95.   </tr> 
  96.   <? 
  97.         foreach ($arr['arra'] as $val) { 
  98. ?> 
  99.   <tr> 
  100.     <td width="79%"><a href="index.php?cat=<? echo $val; ?>"><? echo $val; ?></a></td> 
  101.     <td width="21%"> 
  102.       <? 
  103.     $query = mysql_query('SELECT * FROM '.$arr['tnam'].' WHERE acat="'.$val.'"'); 
  104.     $arr['count'] = mysql_num_rows($array); 
  105.     echo $arr['count']; 
  106.     ?> 
  107.     </td> 
  108.   </tr> 
  109.       <? 
  110.       } 
  111.       ?> 
  112.   <tr> 
  113.     <td colspan="4">&nbsp;</td> 
  114.   </tr> 
  115. </table> 
  116. <?          
  117.  
  118. } 
  119. ?>


Enjoy Download code! Download code (.txt)

 Stemmen
Niet ingelogd.

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