Bruger oprettet side system .

PHP kode 

 <?php
 
 class cms_core
 {
     private $link;
 
     function __construct()
     {
         $this->link = mysql_connect($mysqlserver, $mysqluser, $mysqlpass) or die(mysql_error());
         mysql_select_db($mysqldata, $this->link);
     }
     
     function newPage($name)
     {
         $queryNewPage = "INSERT INTO pages (name) VALUES('$name')";
         $queryNewContent = "INSERT INTO contentPage(id) VALUES(LAST_INSERT_ID())";
         
         if(mysql_query($queryNewPage)&&mysql_query($queryNewContent))
         {
             print "Siden `" . $name "` blev oprettet";
         }
     }
     
     function editContent($id)
     {
         $query = mysql_query("SELECT content FROM contentPage WHERE id = $id");
         
         $data = mysql_fetch_array($query);
         
         print "<form action=\"". $_SERVER['PHP_SELF']."?page=update&id=$id\" method=\"post\">
                 <textarea>".$data['content']."</textarea>
                 <input type=\"submit\" name=\"submit\" value=\"Opdater\">
                </form>";
     }
     
     function update($id)
     {
         $update = mysql_query("UPDATE contentPage SET content = '$_POST[content]' WHERE id = $id");
         
         if($update)
             print "Siden blev opdateret";
     }
 }
 
 ?>

PHP kode 

 <?php
 
 class cms_core
 {
     private $link;
 
     function __construct()
     {
         $this->link = mysql_connect($mysqlserver, $mysqluser, $mysqlpass) or die(mysql_error());
         mysql_select_db($mysqldata, $link);
     }
     
     function newPage($name)
     {
         $queryNewPage = "INSERT INTO pages (name) VALUES('$name')";
         $queryNewContent = "INSERT INTO contentPage(id) VALUES(LAST_INSERT_ID())";
         
         if(mysql_query($queryNewPage)&&mysql_query($queryNewContent))
         {
             print "Siden `" . $name "` blev oprettet";
         }
     }
     
     function editContent($id)
     {
         $query = mysql_query("SELECT content FROM contentPage WHERE id = $id");
         
         $data = mysql_fetch_array($query);
         
         print "<form action=\"". $_SERVER['PHP_SELF']."?id=$id\" method=\"post\">
                 <textarea>".$data['content']."</textarea>
                 <input type=\"submit\" name=\"update\" value=\"Opdater\">
                </form>";
     }
     
     function getPages()
     {
         $query = mysql_query("SELECT * FROM pages ORDER BY name");
         
         while($data = mysql_fetch_array($query))
         {
             print "<a href=\"".$_SERVER['PHP_SELF']."?id=".$data[id]."\">".$data['name']."</a>";
         }
     }
     
     function update($id)
     {
         $update = mysql_query("UPDATE contentPage SET content = '$_POST[content]' WHERE id = $id");
         
         if($update)
             print "Siden blev opdateret";
     }
 }
 
 ?>

PHP kode 

 <?php
 
 include("core.php");
 
 $core = new cms_core();
 
 if($_POST['opret'])
     $core->newPage($_POST['pageName']);
 
 print "<h2>Opret side</h2>
         <form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
             Sidenavn: <input type=\"text\" name=\"pageName\"><input type=\"submit\" value=\"Opret\" name=\"opret\">
         </form>";
         
 print "<h2>Eksisterende sider</h2>";
 
 $core->getPages();
 
 if(isset($_GET[id]))
 {
     $core->editContent($_GET[id]);
 }
 
 if($_POST['update'])
 {
     $core->update($_GET[id]);
 }
 
 ?>