Der Inhalt der Datei (labdeletesubcategories.php)

<?php
session_start();
if(isset($_POST['send'])){
	if(isset($_POST["activ"])) {
		$activ=1;	
	}else {
		$activ=0;
	}
	$catid = get_cgi_param ("catid", 0);
	if($catid){
		$sqlstr = "delete from lab_tblsubcategories where id = " . $_POST["oripn"]; 
		$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
		$num = mysql_affected_rows();
		if ($num<=0) {
	   	echo "<div id='page-wrapper'><div class='container-fluid'>";
			echo "<div class='bg-darkred fg-white'>";
			echo "No record has been added to the database!";		
			echo "</div>";
			echo "</div></div>";	
		} 	
		mysql_free_result($res);
	} else {
	   echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "You must selected a Category!";		
		echo "</div>";
		echo "</div></div>";		
	}
}
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblsubcategories where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res); 
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete subcategory - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=DeleteSubcategories'>";
	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Category name:</label>";
	echo "<select name='catid' class='form-control' data-role='select'>";
	   $sqlstr = "SELECT id, name FROM lab_tblcategories ORDER BY name ASC";
	   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
	   while (list ($catid, $name) = mysql_fetch_row ($res)) {
	      echo ("<option value=\"$catid\">$name (catid: $catid)</option>\n");
	   }
	echo "</select>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Link:</label>";
	echo "<input type='text' name='link' class='form-control' value='".$row['link']."'>";
	echo "</div>";	
	if ($row['activ'] ==1){
		echo "<div class='form-group'>";
		echo "<label>Activ: </label>";
		echo "<input type='checkbox' name='activ' checked>";
		echo "</div>";
	} else {
		echo "<div class='form-group'>";
		echo "<label>Activ: </label>";
		echo "<input type='checkbox' name='activ'>";
		echo "</div>";
	}
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Description:</label>";
	echo "<textarea  name='description' class='form-control' data-role='textarea'>".$row['description']."</textarea>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";	
	   echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Delete the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
} else {
	display_delete_subcategories();
}

function display_delete_subcategories(){
	
   $sqlstr = "select * from lab_tblsubcategories ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete the database: <small>lab_tblsubcategories</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=DeleteSubcategories'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Name</th>";
	echo "<th>Catid</th>";
	echo "<th>Link</th>";
	echo "<th>Activ</th>";
	echo "<th>Description</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   $n=1;
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
      echo "<td>" . $row["catid"] . "</td>";
		echo "<td>" . $row["link"] . "</td>";
		echo "<td>" . $row["activ"] . "</td>";
		echo "<td>" . $row["description"] . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
				<span class='fa  fa-edit'></span> View the record</button>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labinsertarticles.php)

<?php
session_start();
if(isset($_POST['send'])){
	$subcatid = get_cgi_param ("subcatid", 0);
	$number = $_POST['number'];
	$name = $_POST['name'];
	$price = $_POST['price'];
	$description = $_POST['description'];
	$modified = date('Y-m-d', strtotime(str_replace('.', '-', $_POST['modified'])));
	$file = $_FILES['pic']['name']; // Dies hab ich noch nicht getestet, da ich den Namen immer nach datum und user id abgespeichert hab.
	$file = str_replace(" ", "_", "$file");
	$file = htmlentities($file); // Mit leerzeichen -> _ hab ich auch noch nicht getestet, sollte so klappen
	$file_type = GetImageSize($_FILES['pic']['tmp_name']);
	if ( (($_FILES["pic"]["type"] == "image/gif") || 
     ($_FILES["pic"]["type"] == "image/jpeg") || 
     ($_FILES["pic"]["type"] == "image/png")) && 
     ($_FILES["file"]["size"] < 2048000) ) {  // Dateitype nur gif, jpeg und png und max. Größe in bytes 
      move_uploaded_file($_FILES['pic']['tmp_name'], "uploads/temp-$file");
      $file        = "uploads/temp-$file";
      $target    	 = "uploads/$file";
      $max_width   = "800"; //Breite ändern
      $max_height  = "800"; //Höhe ändern
      $quality     = "90"; //Qualität ändern (max. 100)
      $src_img     = imagecreatefromjpeg($file);
      $picsize     = getimagesize($file);
      $src_width   = $picsize[0];
      $src_height  = $picsize[1];
		if($src_width > $src_height){
			if($src_width > $max_width){
	        $convert = $max_width/$src_width;
	        $dest_width = $max_width;
	        $dest_height = ceil($src_height*$convert);
	      } else {
	        $dest_width = $src_width;
	        $dest_height = $src_height;
	      }
	    } else {
	      if($src_height > $max_height) {
	        $convert = $max_height/$src_height;
	        $dest_height = $max_height;
	        $dest_width = ceil($src_width*$convert);
	      } else {
	        $dest_height = $src_height;
	        $dest_width = $src_width;
	      }     
      }
		$dst_img = imagecreatetruecolor($dest_width,$dest_height);
      imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $dest_width, $dest_height, $src_width, $src_height);
      imagejpeg($dst_img, "$target", $quality); 	
		$sqlstr="INSERT INTO lab_tblarticles(number, name, pic, subcatid, modified, price, description) VALUES('$number', '$name', '$file', '$subcatid',  '$modified', '$price', '$description')";$res = mysql_query($sqlstr) or die ("erroror inserting data ".mysql_error()); 
    $num = mysql_affected_rows(); 
		if ($num>0) { 
			echo "<div id='page-wrapper'><div class='container-fluid'>";
			echo "<div class='bg-darkgreen fg-white'>";
			echo "record has been added to the database!";		
			echo "</div>";
			echo "</div></div>";		     
		} else { 
			echo "<div id='page-wrapper'><div class='container-fluid'>";
			echo "<div class='bg-darkred fg-white'>";
			echo "No record has been added to the database!";		
			echo "</div>";
			echo "</div></div>";	
		} 
		mysql_free_result($res);
	} else {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "File types may only be gif, jpeg or png and the picture may not be larger than 2MB!";		
		echo "</div>";
		echo "</div></div>";
	}
	display_list_articles();
}else {
	$sqlstr = "select * from lab_tblsubcategories";
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res); 
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Insert article - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=InsertArticles'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputNumber'>Number:</label>";
	echo "<input type='text' name='number' class='form-control' id='inputNumber' placeholder='Enter article number'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputName'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' id='inputName' placeholder='Enter article name'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPrice'>Price:</label>";
	echo "<input type='text' name='price' class='form-control' id='inputPrice' placeholder='Enter article price'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputSubcategory'>Subcategory name:</label>";
	echo "<select name='subcatid' class='form-control' id='inputSubcategory' data-role='select'>";
	   $sqlstr = "SELECT id, name FROM lab_tblsubcategories ORDER BY name ASC";
	   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
	   while (list ($subcatid, $name) = mysql_fetch_row ($res)) {
	      echo ("<option value=\"$subcatid\">$name (subatid: $subcatid)</option>\n");
	   }
	echo "</select>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputDate'>Date:</label>";
	echo "<input type='text' name='modified' class='form-control' id='inputDate' data-format='%d %B %Y'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputDescription'>Description:</label>";
	echo "<textarea  name='description' class='form-control' id='inputDescription' data-role='textarea'></textarea>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<input type='file' name='pic' data-role='file' data-caption='Choose file' required  /></p>";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-send'></span> Insert the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
}
function display_list_articles(){
   $sqlstr = "select * from lab_tblarticles ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>List the database: <small>lab_tblarticles</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Number</th>";
	echo "<th>Name</th>";
	echo "<th>Subcatid</th>";
	echo "<th>Date</th>";
	echo "<th>Price</th>";
	echo "<th>description</th>";
	echo "<th>Pic</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   while ($row = mysql_fetch_assoc($res)) {
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["number"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
      echo "<td>" . $row["subcatid"] . "</td>";
		echo "<td>" . date('d.m.Y', strtotime($row["modified"])) . "</td>";
      echo "<td>" . $row["price"] . "&nbsp;&euro;</td>";
		echo "<td>" . $row["description"] . "</td>";
		echo "<td>" . "<img style='float: left; margin-right: 25px; margin-bottom: 10px; width:50px; height:50px;' src='" .  $row['pic'] ."'></td>";
		echo "</tr>";          
   } 
   echo "</tbody></table>";
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labeditarticles.php)

<?php
session_start();
if(isset($_POST['send'])){
	$subcatid = get_cgi_param ("subcatid", 0);
	$number = $_POST['number'];
	$name = $_POST['name'];
	$price = $_POST['price'];
	$description = $_POST['description'];
	$modified = date('Y-m-d', strtotime(str_replace('.', '-', $_POST['modified'])));
	if (picdelelte($_SESSION['picalt'])==false){
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkgreen fg-white'>";
		echo "Image file not find!";		
		echo "</div>";
		echo "</div></div>";		
	}
	$file = $_FILES['pic']['name']; // Dies hab ich noch nicht getestet, da ich den Namen immer nach datum und user id abgespeichert hab.
	$file = str_replace(" ", "_", "$file");
	$file = htmlentities($file); // Mit leerzeichen -> _ hab ich auch noch nicht getestet, sollte aba klappen
	$file_type = GetImageSize($_FILES['pic']['tmp_name']);
	if ((($_FILES["pic"]["type"] == "image/gif") || 
     ($_FILES["pic"]["type"] == "image/jpeg") || 
     ($_FILES["pic"]["type"] == "image/png")) && 
     ($_FILES["file"]["size"] < 2048000) ) {  // Dateitype nur gif, jpeg und png und max. Größe in bytes 
      move_uploaded_file($_FILES['pic']['tmp_name'], "uploads/temp-$file");
      $file        = "uploads/temp-$file";
      $target    	 = "uploads/$file";
      $max_width   = "800"; //Breite ändern
      $max_height  = "800"; //Höhe ändern
      $quality     = "90"; //Qualität ändern (max. 100)
      $src_img     = imagecreatefromjpeg($file);
      $picsize     = getimagesize($file);
      $src_width   = $picsize[0];
      $src_height  = $picsize[1];
		if($src_width > $src_height){
			if($src_width > $max_width){
	        $convert = $max_width/$src_width;
	        $dest_width = $max_width;
	        $dest_height = ceil($src_height*$convert);
	      } else {
	        $dest_width = $src_width;
	        $dest_height = $src_height;
	      }
	    } else {
	      if($src_height > $max_height) {
	        $convert = $max_height/$src_height;
	        $dest_height = $max_height;
	        $dest_width = ceil($src_width*$convert);
	      } else {
	        $dest_height = $src_height;
	        $dest_width = $src_width;
	      }     
      }
		$dst_img = imagecreatetruecolor($dest_width,$dest_height);
      imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $dest_width, $dest_height, $src_width, $src_height);
      imagejpeg($dst_img, "$target", $quality); 
				
		$sqlstr = "update lab_tblarticles set "
             . " number = '" . $_POST["number"] . "',"
             . " name = '" . $_POST["name"] . "',"
             . " pic = '" . $file . "'," 
             . " subcatid = '" . $subcatid.  "',"
             . " modified = '" . $modified.  "',"
             . " price = '" . $_POST["price"] . "',"        
             . " description = '" . $_POST["description"] . "'"
             . " where id = " . $_POST["oripn"]; 	
		
			$res = mysql_query($sqlstr) or die ("erroror inserting data ".mysql_error()); 
	    	$num = mysql_affected_rows($res); 
			if ($num>0) { 
	      	echo "<div id='page-wrapper'><div class='container-fluid'>";
				echo "<div class='bg-darkgreen fg-white'>";
				echo "record has been added to the database!";		
				echo "</div>";
				echo "</div></div>";		     
	 
			} else { 
		   	echo "<div id='page-wrapper'><div class='container-fluid'>";
				echo "<div class='bg-darkred fg-white'>";
				echo "No record has been added to the database!";		
				echo "</div>";
				echo "</div></div>";		
			} 
	} else {
   	echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been added to the database!";		
		echo "</div>";
		echo "</div></div>";	
	}
	mysql_free_result($res);
}
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblarticles where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res);
	$_SESSION['picalt']=$row['pic'];
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit article - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' action='".$url."?section=EditArticles' enctype='multipart/form-data'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Number:</label>";
	echo "<input type='text' name='number' class='form-control' value='".$row['number']."'>";
	echo "</div>";		
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control'  value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Subcategory name:</label>";
	echo "<select name='subcatid' class='form-control' data-role='select'>";
   $sqlstr = "SELECT id, name FROM lab_tblsubcategories ORDER BY name ASC";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   while (list ($subcatid, $name) = mysql_fetch_row ($res)) {
      echo ("<option value=\"$subcatid\">$name (subcatid: $subcatid)</option>\n");
   }
	echo "</select>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Date:</label>";
	echo "<input type='text' name='modified' class='form-control'  value='".$row['modified']."' data-role='calendarpicker' data-format='%d %B %Y'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Price:</label>";
	echo "<input type='text' name='price' class='form-control' value='".$row['price']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Image:</label>";
	echo "<img style='float: left; margin-right: 25px; margin-bottom: 10px; width:50px; height:50px;' src='" .  $_SESSION['picalt'] ."'>";
	echo "<input type='file' name='pic' placeholder='load image' required />";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Description:</label>";
	echo "<textarea  name='description' class='form-control' data-role='textarea'>".$row['description']."</textarea>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";	
   echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Edit the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
	
}else {
	 display_edit_articles();
}
function display_edit_articles(){
   $sqlstr = "select * from lab_tblarticles ORDER BY id";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit the database: <small>lab_tblarticles</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=EditArticles'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Number</th>";
	echo "<th>Name</th>";
	echo "<th>Subcatid</th>";
	echo "<th>Date</th>";
	echo "<th>Pic</th>";
	echo "<th>Price</th>";
	echo "<th>Description</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["number"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
		echo "<td>" . $row["subcatid"] . "</td>";
		echo "<td>" . date('d.m.Y', strtotime($row["modified"])) . "</td>";	  
		echo "<td><img style='float: left; margin-right: 25px; margin-bottom: 10px; width:50px; height:50px;' src='" .  $row['pic'] ."'></td>";
		echo "<td>" . $row['price'] . "</td>";
		echo "<td>" . $row["description"] . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
				<span class='fa  fa-edit'></span> View the record</button>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
function picdelelte($pic) {
	if ( file_exists($pic) ) {

        if( @unlink($pic) !== true )
            throw new Exception('Could not delete file: ' . $pic . ' Please close all applications that are using it.');
   } 
   return true; 

}
?>

Der Inhalt der Datei (labdeletearticles.php)

<?php
session_start();
if(isset($_POST['send'])){
	$sqlstr = "delete from lab_tblarticles where id = " . $_POST["oripn"]; 
	$res = mysql_query($sqlstr) or die ("erroror inserting data ".mysql_error()); 
	$num = mysql_affected_rows(); 
	if ($num>0) { 
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkgreen fg-white'>";
		echo "record has been added to the database!";		
		echo "</div>";
		echo "</div></div>";	     
	} else { 
   	echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been added to the database!";		
		echo "</div>";
		echo "</div></div>";	
	} 	
        mysql_free_result($res);		
}
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblarticles where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete article - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' action='".$url."?section=DeleteArticles' enctype='multipart/form-data'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Number:</label>";
	echo "<input type='text' name='number' class='form-control' value='".$row['number']."'>";
	echo "</div>";		
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control'  value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Subcategory name:</label>";
	echo "<select name='subcatid' class='form-control' data-role='select'>";
   $sqlstr = "SELECT id, name FROM lab_tblsubcategories ORDER BY name ASC";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   while (list ($subcatid, $name) = mysql_fetch_row ($res)) {
      echo ("<option value=\"$subcatid\">$name (subcatid: $subcatid)</option>\n");
   }
	echo "</select>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Date:</label>";
	echo "<input type='text' name='modified' class='form-control'  value='".$row['modified']."' data-role='calendarpicker' data-format='%d %B %Y'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Price:</label>";
	echo "<input type='text' name='price' class='form-control' value='".$row['price']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Image:</label>";
	echo "<img style='float: left; margin-right: 25px; margin-bottom: 10px; width:50px; height:50px;' src='" .  $row['pic'] ."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Description:</label>";
	echo "<textarea  name='description' class='form-control' data-role='textarea'>".$row['description']."</textarea>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";	
   echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Delete the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
	
}else {
	 display_delete_articles();
}
function display_delete_articles(){
   $sqlstr = "select * from lab_tblarticles ORDER BY id";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);

	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete the database: <small>lab_tblarticles</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=DeleteArticles'>";
	
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Number</th>";
	echo "<th>Name</th>";
	echo "<th>Subcatid</th>";
	echo "<th>Date</th>";
	echo "<th>Pic</th>";
	echo "<th>Price</th>";
	echo "<th>Description</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["number"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
		echo "<td>" . $row["subcatid"] . "</td>";
		echo "<td>" . date('d.m.Y', strtotime($row["modified"])) . "</td>";	  
		echo "<td><img style='float: left; margin-right: 25px; margin-bottom: 10px; width:50px; height:50px;' src='" .  $row['pic'] ."'></td>";
		echo "<td>" . $row['price'] . "</td>";
		echo "<td>" . $row["description"] . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
				<span class='fa  fa-edit'></span> View the record</button>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labinsertcustomers.php)

<?php
session_start();
if(isset($_POST['send'])){
	if(isset($_POST["registered"])) {
		$registered=1;	
	}else {
		$registered=0;
	}
   $sqlstr = "insert lab_tblcustomers"
        . "(name, prename, address, postcode, city, region, country, phone, email, password, registered) values "
        . "('" . $_POST["name"] . "', "
        . "'" . $_POST["prename"] . "', "
        . "'" . $_POST["address"] . "', "
        . "'" . $_POST["postcode"] . "', "
        . "'" . $_POST["city"] . "', "
        . "'" . $_POST["region"] . "', "
        . "'" . $_POST["country"] . "', "
        . "'" . $_POST["phone"] . "', "
        . "'" . $_POST["email"] . "', "
        . "'" . MD5($_POST["password"]) . "', "
        . "'" . $_POST["registered"] . "')"; 
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num>0) {
		display_list_customers();
	} else {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been added to the database!";		
		echo "</div>";
		echo "</div></div>";	
   }   
	mysql_free_result($res);
}else {	

	echo "<div id='page-wrapper'><div class='container-fluid'>";	
	echo "<div class='row'>
		<div class='col-md-6'>
		<div class='panel panel-primary'>	
     <div class='panel-heading'>
       <h2 class='panel-title'>Insert Customer - Form</h2>
     </div>
     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=InsertCustomers'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputName'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' id='inputName' placeholder='Enter Name'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPrename'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' id='inputPrename' placeholder='Enter Prename'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputAddress'>Address:</label>";
	echo "<input type='text' name='address' class='form-control' id='inputAddress' placeholder='Enter Address'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPostcode'>Postcode:</label>";
	echo "<input type='text' name='postcode' class='form-control' id='inputPostcode' placeholder='Enter Postcode'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputCity'>City:</label>";
	echo "<input type='text' name='city' class='form-control' id='inputCity' placeholder='Enter City'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputRegion'>Region:</label>";
	echo "<input type='text' name='region' class='form-control' id='inputRegion' placeholder='Enter Region'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputCountry'>Country:</label>";
	echo "<input type='text' name='country' class='form-control' id='inputCountry' placeholder='Enter Country'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPhonenumber'>Phonenumber:</label>";
	echo "<input type='text' name='phone' class='form-control' id='inputPhonenumber' placeholder='Enter Phonenumber'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputEmail'>Email-Address:</label>";
	echo "<input type='text' name='email' class='form-control' id='inputEmail' placeholder='Enter Email-Address'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPassword'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' id='inputPassword' placeholder='Enter Password'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label>Registered	: </label>";
	echo "<input type='checkbox' name='registered'>";
	echo "<small class='text-muted'>If the customer should be registered, the checkbox must be clicked!</small>";
	echo "</div>";


	echo "<div class='form-group'>";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-send'></span> Insert the record</button>";
	echo "</div>";
	echo "</form>";        
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
}
function display_list_customers(){
   $sqlstr = "select * from lab_tblcustomers ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
  	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit the database: <small>lab_tblcustomers</small></h2>
	     </div>
	     <div class='panel-body'>";
   echo "<h2>Insert the database: <small>lab_tblcustomers</small><h2><br />";
	echo "<div class='table-responsive'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Address</th>";
	echo "<th>Postcode</th>";
	echo "<th>City</th>";
	echo "<th>Region</th>";
	echo "<th>Country</th>";
	echo "<th>Phone</th>";
	echo "<th>Email</th>";
	echo "<th>password</th>";
	echo "<th>Registered</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";
   while ($row = mysql_fetch_assoc($res)) {
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
      echo "<td>" . $row["prename"] . "</td>";
      echo "<td>" . $row["address"] . "</td>";
      echo "<td>" . $row["postcode"] . "</td>";
      echo "<td>" . $row["city"] . "</td>";
      echo "<td>" . $row["region"] . "</td>";
      echo "<td>" . $row["country"] . "</td>";
      echo "<td>" . $row["phone"] . "</td>";
      echo "<td>" . MD5($row["email"]) . "</td>";
      echo "<td>" . $row["password"] . "</td>";
      echo "<td>" . $row["registered"] . "</td>";
      echo "</tr>";          
   } 
   echo "</tbody></table>";
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labeditcustomers.php)

<?php
session_start();
if(isset($_POST['send'])){
	if(isset($_POST["registered"])) {
		$registered=1;	
	}else {
		$registered=0;
	}
	$sqlstr = "update lab_tblcustomers set "
             . " name = '" . $_POST["name"] . "',"
             . " prename = '" . $_POST["prename"] . "',"
             . " address = '" . $_POST["address"] . "',"
             . " postcode = '" . $_POST["postcode"] . "',"
             . " city = '" . $_POST["city"] . "',"
             . " region = '" . $_POST["region"] . "',"
             . " country = '" . $_POST["country"] . "',"
             . " phone = '" . $_POST["phone"] . "',"
             . " email = '" . $_POST["email"] . "',"
             . " password = '" . MD5($_POST["password"]) . "',"
             . " registered = '" . $_POST["registered"] . "'"
             . " where id = " . $_POST["oripn"]; 
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num<=0) {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "The record has not  been changed!";		
		echo "</div>";
		echo "</div></div>";
   }   	
	mysql_free_result($res);
}
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblcustomers where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res);
		echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit customer - Form</h2>
	     </div>
	     <div class='panel-body'>"; 
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=EditCustomers'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' value='".$row['prename']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Address:</label>";
	echo "<input type='text' name='address' class='form-control' value='".$row['address']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Postcode:</label>";
	echo "<input type='text' name='postcode' class='form-control' value='".$row['postcode']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>City:</label>";
	echo "<input type='text' name='city' class='form-control' value='".$row['city']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Region:</label>";
	echo "<input type='text' name='region' class='form-control' value='".$row['region']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Country:</label>";
	echo "<input type='text' name='country' class='form-control' value='".$row['country']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Phonenumber:</label>";
	echo "<input type='text' name='phone' class='form-control' value='".$row['phone']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Email-address:</label>";
	echo "<input type='email' name='email' class='form-control' value='".$row['email']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' value='".$row['password']."'>";
	echo "</div>";
	if ($row['activ'] ==1){
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='registered' checked>";
		echo "</div>";
	} else {
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='registered'>";
		echo "</div>";
	}	
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Edit the record</button>";	
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);	
} else {
	display_edit_customers();
}
function display_edit_customers(){
   $sqlstr = "select * from lab_tblcustomers ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit the database: <small>lab_tblcustomers</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=EditCustomers'>";
	echo "<div class='table-responsive'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Idd</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Address</th>";
	echo "<th>Postcode</th>";
	echo "<th>City</th>";
	echo "<th>Region</th>";
	echo "<th>Country</th>";
	echo "<th>Phone</th>";
	echo "<th>Email</th>";
	echo "<th>password</th>";
	echo "<th>Registered</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   $n=1;
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
		echo "<td>" . $row["id"] . "</td>";
		echo "<td>" . $row["name"] . "</td>";
		echo "<td>" . $row["prename"] . "</td>";
		echo "<td>" . $row["address"] . "</td>";
		echo "<td>" . $row["postcode"] . "</td>";
		echo "<td>" . $row["city"] . "</td>";
		echo "<td>" . $row["region"] . "</td>";
		echo "<td>" . $row["country"] . "</td>";
 		echo "<td>" . $row["phone"] . "</td>";
		echo "<td>" . $row["email"] . "</td>";
  		echo "<td>" . MD5($row["password"]) . "</td>";
		echo "<td>" . $row["registered"] . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
		<span class='fa  fa-edit'></span> View the record</button>";
   echo "</div>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labdeletecustomers.php)

<?php
session_start();
if(isset($_POST['send'])){
	$sqlstr = "delete from lab_tblcustomers where id = " . $_POST["oripn"]; 	
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num<=0) {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "The record has not  been changed!";		
		echo "</div>";
		echo "</div></div>";
   }   	
	mysql_free_result($res);
} 
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblcustomers where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res); 	
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete customer - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=DeleteCustomers'>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' value='".$row['prename']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Address:</label>";
	echo "<input type='text' name='address' class='form-control' value='".$row['address']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Postcode:</label>";
	echo "<input type='text' name='postcode' class='form-control' value='".$row['postcode']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>City:</label>";
	echo "<input type='text' name='city' class='form-control' value='".$row['city']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Region:</label>";
	echo "<input type='text' name='region' class='form-control' value='".$row['region']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Country:</label>";
	echo "<input type='text' name='country' class='form-control' value='".$row['country']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Phonenumber:</label>";
	echo "<input type='text' name='phone' class='form-control' value='".$row['phone']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Email:</label>";
	echo "<input type='email' name='email' class='form-control' value='".$row['email']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' value='".$row['password']."'>";
	echo "</div>";
	if ($row['activ'] ==1){
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='activ' checked>";
		echo "</div>";
	} else {
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='activ'>";
		echo "</div>";
	}	
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Delete the record</button>";	
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
} else {
	display_delete_categories();
}

function display_delete_categories(){   
	$sqlstr = "select * from lab_tblcustomers ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete the database: <small>lab_tblcustomers</small></h2>
	     </div>
	     <div class='panel-body'>"; 
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=DeleteCustomers'>";
	echo "<div class='table-responsive'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Idd</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Address</th>";
	echo "<th>Postcode</th>";
	echo "<th>City</th>";
	echo "<th>Region</th>";
	echo "<th>Country</th>";
	echo "<th>Phone</th>";
	echo "<th>Email</th>";
	echo "<th>password</th>";
	echo "<th>Registered</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   $n=1;
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
        echo "<td>" . $row["id"] . "</td>";
        echo "<td>" . $row["name"] . "</td>";
        echo "<td>" . $row["prename"] . "</td>";
        echo "<td>" . $row["address"] . "</td>";
        echo "<td>" . $row["postcode"] . "</td>";
        echo "<td>" . $row["city"] . "</td>";
        echo "<td>" . $row["region"] . "</td>";
        echo "<td>" . $row["country"] . "</td>";
        echo "<td>" . $row["phone"] . "</td>";
        echo "<td>" . $row["email"] . "</td>";
        echo "<td>" . MD5($row["password"]) . "</td>";
	echo "<td>" . $row["registered"] . "</td>";
	echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
	echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
		<span class='fa  fa-edit'></span> View the record</button>";
   echo "</div>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labinsertdeliveries.php)

<?php
session_start();
if(isset($_POST['send'])){
	if(isset($_POST["registered"])) {
		$registered=1;	
	}else {
		$registered=0;
	}
   $sqlstr = "insert lab_tbldeliveries"
        . "(name, prename, address, postcode, city, region, country, phone, email, password, registered) values "
        . "('" . $_POST["name"] . "', "
        . "'" . $_POST["prename"] . "', "
        . "'" . $_POST["address"] . "', "
        . "'" . $_POST["postcode"] . "', "
        . "'" . $_POST["city"] . "', "
        . "'" . $_POST["region"] . "', "
        . "'" . $_POST["country"] . "', "
        . "'" . $_POST["phone"] . "', "
        . "'" . $_POST["email"] . "', "
        . "'" . MD5($_POST["password"]) . "', "
        . "'" . $_POST["registered"] . "')"; 
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num>0) {
		display_list_deliveries();
	} else {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been added to the database!";		
		echo "</div>";
		echo "</div></div>";	
   }   
	mysql_free_result($res);
}else {	

	echo "<div id='page-wrapper'><div class='container-fluid'>";	
	echo "<div class='row'>
		<div class='col-md-6'>
		<div class='panel panel-primary'>	
     <div class='panel-heading'>
       <h2 class='panel-title'>Insert Customer - Form</h2>
     </div>
     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=InsertDeliveries'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputName'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' id='inputName' placeholder='Enter Name'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPrename'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' id='inputPrename' placeholder='Enter Prename'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputAddress'>Address:</label>";
	echo "<input type='text' name='address' class='form-control' id='inputAddress' placeholder='Enter Address'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPostcode'>Postcode:</label>";
	echo "<input type='text' name='postcode' class='form-control' id='inputPostcode' placeholder='Enter Postcode'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputCity'>City:</label>";
	echo "<input type='text' name='city' class='form-control' id='inputCity' placeholder='Enter City'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputRegion'>Region:</label>";
	echo "<input type='text' name='region' class='form-control' id='inputRegion' placeholder='Enter Region'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputCountry'>Country:</label>";
	echo "<input type='text' name='country' class='form-control' id='inputCountry' placeholder='Enter Country'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPhonenumber'>Phonenumber:</label>";
	echo "<input type='text' name='phone' class='form-control' id='inputPhonenumber' placeholder='Enter Phonenumber'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputEmail'>Email-Address:</label>";
	echo "<input type='text' name='email' class='form-control' id='inputEmail' placeholder='Enter Email-Address'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPassword'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' id='inputPassword' placeholder='Enter Password'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label>Registered	: </label>";
	echo "<input type='checkbox' name='registered'>";
	echo "<small class='text-muted'>If the customer should be registered, the checkbox must be clicked!</small>";
	echo "</div>";


	echo "<div class='form-group'>";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-send'></span> Insert the record</button>";
	echo "</div>";
	echo "</form>";        
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
}
function display_list_deliveries(){
   $sqlstr = "select * from lab_tbldeliveries ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
  	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit the database: <small>lab_tbldeliveries</small></h2>
	     </div>
	     <div class='panel-body'>";
   echo "<h2>Insert the database: <small>lab_tbldeliveries</small><h2><br />";
	echo "<div class='table-responsive'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Address</th>";
	echo "<th>Postcode</th>";
	echo "<th>City</th>";
	echo "<th>Region</th>";
	echo "<th>Country</th>";
	echo "<th>Phone</th>";
	echo "<th>Email</th>";
	echo "<th>password</th>";
	echo "<th>Registered</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";
   while ($row = mysql_fetch_assoc($res)) {
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
      echo "<td>" . $row["prename"] . "</td>";
      echo "<td>" . $row["address"] . "</td>";
      echo "<td>" . $row["postcode"] . "</td>";
      echo "<td>" . $row["city"] . "</td>";
      echo "<td>" . $row["region"] . "</td>";
      echo "<td>" . $row["country"] . "</td>";
      echo "<td>" . $row["phone"] . "</td>";
      echo "<td>" . MD5($row["email"]) . "</td>";
      echo "<td>" . $row["password"] . "</td>";
      echo "<td>" . $row["registered"] . "</td>";
      echo "</tr>";          
   } 
   echo "</tbody></table>";
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labeditdeliveries.php)

<?php
session_start();
if(isset($_POST['send'])){
	if(isset($_POST["activ"])) {
		$registered=1;	
	}else {
		$registered=0;
	}
	$sqlstr = "update lab_tbldeliveries set "
             . " name = '" . $_POST["name"] . "',"
             . " prename = '" . $_POST["prename"] . "',"
             . " address = '" . $_POST["address"] . "',"
             . " postcode = '" . $_POST["postcode"] . "',"
             . " city = '" . $_POST["city"] . "',"
             . " region = '" . $_POST["region"] . "',"
             . " country = '" . $_POST["country"] . "',"
             . " phone = '" . $_POST["phone"] . "',"
             . " email = '" . $_POST["email"] . "',"
             . " registered = '" . $registered . "'"
             . " where id = " . $_POST["oripn"]; 
	
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();  
	if ($num<=0) {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "The record has not  been changed!";		
		echo "</div>";
		echo "</div></div>";
   }  	
	mysql_free_result($res);
}
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tbldeliveries where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit delivery - Form</h2>
	     </div>
	     <div class='panel-body'>";	
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=EditDeliveries'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' value='".$row['prename']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Address:</label>";
	echo "<input type='text' name='address' class='form-control' value='".$row['address']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Postcode:</label>";
	echo "<input type='text' name='postcode' class='form-control' value='".$row['postcode']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Delivery city:</label>";
	echo "<input type='text' name='city' class='form-control' value='".$row['city']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Region:</label>";
	echo "<input type='text' name='region' class='form-control' value='".$row['region']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Country:</label>";
	echo "<input type='text' name='country' class='form-control' value='".$row['country']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Phonenumber:</label>";
	echo "<input type='text' name='phone' class='form-control' value='".$row['phone']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Email-address:</label>";
	echo "<input type='email' name='email' class='form-control' value='".$row['email']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' value='".$row['password']."'>";
	echo "</div>";
	if ($row['activ'] ==1){
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='registered' checked>";
		echo "</div>";
	} else {
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='registered'>";
		echo "</div>";
	}	
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Edit the record</button>";	
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);	
} else {
	display_edit_deliveries();
}
function display_edit_deliveries(){
   $sqlstr = "select * from lab_tbldeliveries ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
   echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit the database: <small>lab_tbldeliveries</small></h2>
	     </div>
	     <div class='panel-body'>"; 
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=EditDeliveries'>";

echo "<div class='table-responsive'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Idd</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Address</th>";
	echo "<th>Postcode</th>";
	echo "<th>City</th>";
	echo "<th>Region</th>";
	echo "<th>Country</th>";
	echo "<th>Phone</th>";
	echo "<th>Email</th>";
	echo "<th>password</th>";
	echo "<th>Registered</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   $n=1;
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
		echo "<td>" . $row["id"] . "</td>";
		echo "<td>" . $row["name"] . "</td>";
		echo "<td>" . $row["prename"] . "</td>";
		echo "<td>" . $row["address"] . "</td>";
		echo "<td>" . $row["postcode"] . "</td>";
		echo "<td>" . $row["city"] . "</td>";
		echo "<td>" . $row["region"] . "</td>";
		echo "<td>" . $row["country"] . "</td>";
		echo "<td>" . $row["phone"] . "</td>";
		echo "<td>" . $row["email"] . "</td>";
		echo "<td>" . MD5($row["password"]) . "</td>";
		echo "<td>" . $row["registered"] . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
		<span class='fa  fa-edit'></span> View the record</button>";
   echo "</div>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labdeletedeliveries.php)

<?php
session_start();
if(isset($_POST['send'])){
	$sqlstr = "delete from lab_tbldeliveries where id = " . $_POST["oripn"]; 	
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num<=0) {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "The record has not  been changed!";		
		echo "</div>";
		echo "</div></div>";
   }   	
	mysql_free_result($res);
} 
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tbldeliveries where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res); 	
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete delivery - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=DeleteDeliveries'>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' value='".$row['prename']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Address:</label>";
	echo "<input type='text' name='address' class='form-control' value='".$row['address']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Postcode:</label>";
	echo "<input type='text' name='postcode' class='form-control' value='".$row['postcode']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>City:</label>";
	echo "<input type='text' name='city' class='form-control' value='".$row['city']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Region:</label>";
	echo "<input type='text' name='region' class='form-control' value='".$row['region']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Country:</label>";
	echo "<input type='text' name='country' class='form-control' value='".$row['country']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Delivery phonenumber:</label>";
	echo "<input type='text' name='phone' class='form-control' value='".$row['phone']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Email:</label>";
	echo "<input type='email' name='email' class='form-control' value='".$row['email']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' value='".$row['password']."'>";
	echo "</div>";
	if ($row['activ'] ==1){
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='activ' checked>";
		echo "</div>";
	} else {
		echo "<div class='form-group'>";
		echo "<label>Registered	: </label>";
		echo "<input type='checkbox' name='activ'>";
		echo "</div>";
	}	
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-edit'></span> Delete the record</button>";	
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
} else {
	display_delete_categories();
}

function display_delete_categories(){   
	$sqlstr = "select * from lab_tbldeliveries ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete the database: <small>lab_tbldeliveries</small></h2>
	     </div>
	     <div class='panel-body'>"; 
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=DeleteDeliveries'>";
	echo "<div class='table-responsive'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Idd</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Address</th>";
	echo "<th>Postcode</th>";
	echo "<th>City</th>";
	echo "<th>Region</th>";
	echo "<th>Country</th>";
	echo "<th>Phone</th>";
	echo "<th>Email</th>";
	echo "<th>password</th>";
	echo "<th>Registered</th>";
	echo "<th>Select</th>";
	echo "</tr>";
   echo "</thead><tbody>";  
   $n=1;
   while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
        echo "<td>" . $row["id"] . "</td>";
        echo "<td>" . $row["name"] . "</td>";
        echo "<td>" . $row["prename"] . "</td>";
        echo "<td>" . $row["address"] . "</td>";
        echo "<td>" . $row["postcode"] . "</td>";
        echo "<td>" . $row["city"] . "</td>";
        echo "<td>" . $row["region"] . "</td>";
        echo "<td>" . $row["country"] . "</td>";
        echo "<td>" . $row["phone"] . "</td>";
        echo "<td>" . $row["email"] . "</td>";
        echo "<td>" . MD5($row["password"]) . "</td>";
	echo "<td>" . $row["registered"] . "</td>";
	echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
	echo "</tr>";                    
   } 
   echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
		<span class='fa  fa-edit'></span> View the record</button>";
   echo "</div>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labinsertusers.php)

<?php
session_start();
if(isset($_POST['send'])){
   $sqlstr = "insert lab_tblusers"
        . "(name, prename, modified, email, password) values "
        . "('" . $_POST["name"] . "', "
        . "'" . $_POST["prename"] . "', "
        . "'" . $_POST["modified"] . "', "
        . "'" . $_POST["email"] . "', "
        . "'" . md5($row['password']) . "')"; 
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num>0) {
		display_list_users();
	} else {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been added to the database!";		
		echo "</div>";
		echo "</div></div>";	
   }   
	mysql_free_result($res);
}else {	
	echo "<div id='page-wrapper'><div class='container-fluid'>";	
	echo "<div class='row'>
		<div class='col-md-6'>
		<div class='panel panel-primary'>	
     <div class='panel-heading'>
       <h2 class='panel-title'>Insert user - Form</h2>
     </div>
     <div class='panel-body'>";	
	echo "<form method='post' enctype='multipart/form-data' action='".$url."?section=InsertUsers'>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputName'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' id='inputName' placeholder='Enter name'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPrename'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' id='inputPrename' placeholder='Enter prename'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputModified'>Modified:</label>";
	echo "<input type='text' name='modified' class='form-control' id='inputModified' placeholder='Enter modified'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputEmail'>Email:</label>";
	echo "<input type='email' name='email' class='form-control' id='inputEmail' placeholder='Enter email'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label' for='inputPassword'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' id='inputPassword' placeholder='Enter password'>";
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<button type='submit' name='send' class='btn btn-primary'>
			<span class='fa  fa-send'></span> Insert the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
}
function display_list_users(){
   $sqlstr = "select * from lab_tblusers ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
   echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>List the database: <small>lab_tblusers</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Modified</th>";
	echo "<th>Email</th>";
	echo "<th>Password</th>";
	echo "</tr>";	
   echo "</thead><tbody>";
   while ($row = mysql_fetch_assoc($res)) {
		echo "<tr>";
      echo "<td>" . $row["id"] . "</td>";
      echo "<td>" . $row["name"] . "</td>";
      echo "<td>" . $row["prename"] . "</td>";
      echo "<td>" . $row["modified"] . "</td>";
		echo "<td>" . $row["email"] . "</td>";
		echo "<td>" . $row["password"] . "</td>";
		echo "</tr>";          
   } 
   echo "</tbody></table>";
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
   mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labeditusers.php)

<?php
session_start();
if(isset($_POST['send']) && check_admin_user()){
	$sqlstr = "update lab_tblusers set "
		. " name = '" . $_POST["name"] . "',"
		. " prename = '" . $_POST["prename"] . "',"
		. " modified = '" . $_POST["modified"] . "',"
		. " email = '" . $_POST["email"] . "',"
		. " password = '" . md5($_POST["password"]) . "'"
		. " where id = " . $_POST["oripn"]; 		
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num<=0) {
	   echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been changed!";		
		echo "</div>";
		echo "</div></div>";	
	} 
} 
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblusers where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res);
	 echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit user - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=EditUsers'>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' value='".$row['prename']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Modified:</label>";
	echo "<input type='text' name='modified' class='form-control' value='".$row['modified']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Email:</label>";
	echo "<input type='email' name='email' class='form-control' value='".$row['email']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' value='".$row['password']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";	
   echo "<button type='submit' name='send' class='btn btn-primary'>
		<span class='fa  fa-edit'></span> Delete the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
} else {
	display_edit_users();
}
function display_edit_users(){
   $sqlstr = "select * from lab_tblusers ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
   echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Edit the database: <small>lab_tblusers</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=EditUsers'>";	
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Modified</th>";
	echo "<th>Email</th>";
	echo "<th>Password</th>";
	echo "<th>Select</th>";
	echo "</tr>";
	echo "</thead><tbody>";  
	$n=1;
	while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
		echo "<td>" . $row["id"] . "</td>";
		echo "<td>" . $row["name"] . "</td>";
		echo "<td>" . $row["prename"] . "</td>";
		echo "<td>" . $row["modified"] . "</td>";
		echo "<td>" . $row["email"] . "</td>";
		echo "<td>" . md5($row["password"]) . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
	echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
				<span class='fa  fa-edit'></span> View the record</button>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res); 
}
?>

Der Inhalt der Datei (labdeleteusers.php)

<?php
session_start();
if(isset($_POST['send']) && check_admin_user()){
	$sqlstr = $sqlstr = "delete from lab_tblusers where id = " . $_POST["oripn"]; 
	$res = mysql_query($sqlstr) or die ("no connection to the database ".mysql_error());
	$num = mysql_affected_rows();
	if ($num<=0) {	
	   echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo "<div class='bg-darkred fg-white'>";
		echo "No record has been changed!";		
		echo "</div>";
		echo "</div></div>";	
	} 
}
if (isset($_POST["selectID"])) { 
	$sqlstr = "select * from lab_tblusers where id = " . $_POST["selectID"];
	$res = mysql_query($sqlstr);
	$row = mysql_fetch_assoc($res); 
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-6'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete user - Form</h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=DeleteUsers'>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Id:</label>";
	echo "<input type='text' name='id' class='form-control' value='" . $_POST["selectID"] . "' disabled />"; 
	echo "</div>";	
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Name:</label>";
	echo "<input type='text' name='name' class='form-control' value='".$row['name']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Prename:</label>";
	echo "<input type='text' name='prename' class='form-control' value='".$row['prename']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Modified:</label>";
	echo "<input type='text' name='modified' class='form-control' value='".$row['modified']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Email:</label>";
	echo "<input type='email' name='email' class='form-control' value='".$row['email']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<label class='control-label'>Password:</label>";
	echo "<input type='password' name='password' class='form-control' value='".$row['password']."'>";
	echo "</div>";
	echo "<div class='form-group'>";
	echo "<input type='hidden' name='oripn' value='" . $_POST["selectID"] . "'  />";	
   echo "<button type='submit' name='send' class='btn btn-primary'>
		<span class='fa  fa-edit'></span> Delete the record</button>";
	echo "</div>";
	echo "</form>";    
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res);
	
}
 else {
	display_edit_users();
}
function display_edit_users(){
   $sqlstr = "select * from lab_tblusers ORDER BY id ";
   $res = mysql_query($sqlstr) or die ("no connection to the database  ".mysql_error());
   $num = mysql_num_rows($res);
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='row'>
			<div class='col-md-12'>
			<div class='panel panel-primary'>	
	     <div class='panel-heading'>
	       <h2 class='panel-title'>Delete the database: <small>lab_tblusers</small></h2>
	     </div>
	     <div class='panel-body'>";
	echo "<form method='post' enctype='multipart/form-data'  action='".$url."?section=DeleteUsers'>";	
	echo "<table class='table'>";
	echo "<thead>";
	echo "<tr><th>Id</th>";
	echo "<th>Name</th>";
	echo "<th>Prename</th>";
	echo "<th>Modified</th>";
	echo "<th>Email</th>";
	echo "<th>Password</th>";
	echo "<th>Select</th>";
	echo "</tr>";
	echo "</thead><tbody>";  
	$n=1;
	while ($row = mysql_fetch_assoc($res)) {     
		echo "<tr>";
		echo "<td>" . $row["id"] . "</td>";
		echo "<td>" . $row["name"] . "</td>";
		echo "<td>" . $row["prename"] . "</td>";
		echo "<td>" . $row["modified"] . "</td>";
		echo "<td>" . $row["email"] . "</td>";
		echo "<td>" . md5($row["password"]) . "</td>";
		echo "<td><input type='checkbox' name='selectID' value='" . $row["id"] . "' data-role='checkbox'></td>"; 
		echo "</tr>";                    
   } 
	echo "</tbody></table>";
   echo "<button type='submit' class='btn btn-primary'>
				<span class='fa  fa-edit'></span> View the record</button>";
   echo "</form>"; 
	echo "</div>";
	echo "</div>";
	echo "</div></div>";
	echo "</div></div>";
	mysql_free_result($res); 
}?>

CREATE TABLE IF NOT EXISTS `lab_tblcustomers` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET latin1 NOT NULL,
  `prename` varchar(50) CHARACTER SET latin1 NOT NULL,
  `address` varchar(50) CHARACTER SET latin1 NOT NULL,
  `postcode` varchar(10) CHARACTER SET latin1 NOT NULL,
  `city` varchar(50) CHARACTER SET latin1 NOT NULL,
  `region` varchar(50) NOT NULL,
  `country` varchar(50) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(20) CHARACTER SET latin1 NOT NULL,
  `email` varchar(150) CHARACTER SET latin1 NOT NULL,
  `password` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `registered` tinyint(1) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `lab_tblcustomers`
 ADD PRIMARY KEY (`id`);

4.10.2 Versandtabelle

Abb. 4.10.2 Datenbanktabelle (lab_tbldeliveries)

Hier der SQL-Code zur Erzeugung der Datenbanktabelle (lab_tbldeliveries).

CREATE TABLE IF NOT EXISTS `lab_tbldeliveries` (
 `id` int(11) NOT NULL,
 `name` varchar(50) CHARACTER SET latin1 NOT NULL,
  `prename` varchar(50) CHARACTER SET latin1 NOT NULL,
  `address` varchar(50) CHARACTER SET latin1 NOT NULL,
  `postcode` varchar(10) CHARACTER SET latin1 NOT NULL,
  `city` varchar(50) CHARACTER SET latin1 NOT NULL,
  `region` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `country` varchar(50) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(20) CHARACTER SET latin1 NOT NULL,
  `email` varchar(150) CHARACTER SET latin1 NOT NULL,
  `registered` tinyint(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

ALTER TABLE `lab_tbldeliveries`
 ADD PRIMARY KEY (`id`);

Die Inhalte der Tabelle (lab_tbldeliveries) kann wie folgt aussehen. Dabei hat das Feld (registered) die Aufgabe, eine Lieferfirma anzuzeigen(registered=1) oder auszublenden(registered=0)

4.10.3 Auftragstabelle

Abb. 4.10.3 Datenbanktabelle (lab_tblorders)

Hier der SQL-Code zur Erzeugung der Datenbanktabelle (lab_tblorders).

CREATE TABLE IF NOT EXISTS `lab_tblorders` (
 `id` int(11) NOT NULL,
 `customerid` int(11) NOT NULL,
  `deliveryid` int(11) NOT NULL,
  `registernumber` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  `session` varchar(100) CHARACTER SET utf8 NOT NULL,
  `total` float NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

ALTER TABLE `lab_tblorders`
 ADD PRIMARY KEY (`id`);

Die Inhalte der Tabelle (lab_tblorders) kann wie folgt aussehen. Dabei hat das Feld (status) die Aufgabe, den Auftragsstatus anzuzeigen(status=1) oder auszublenden(status=0)

4.10.4 Bestellartikel-Tabelle

Abb. 4.10.4 Datenbanktabelle (lab_tblorderitems)

Hier der SQL-Code zur Erzeugung der Datenbanktabelle (lab_tblorderitems).

CREATE TABLE IF NOT EXISTS `lab_tblorderitems` (
 `id` int(11) NOT NULL,
 `orderid` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` float(5,2) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

ALTER TABLE `lab_tblorderitems`
 ADD PRIMARY KEY (`id`);

Die Inhalte der Tabelle (lab_tblorderitems) kann wie folgt aussehen.

4.10.5 Shop-Start

Abb. 4.10.5 Das Layout vom Shopsystem

<?php
session_start();
include("labconfig.php");
// Set session variables that we want to access within the function

if(!$_SESSION['items']) $_SESSION['items'] = '0';

if(!$_SESSION['totalprice']) $_SESSION['totalprice'] = '0.00';
$subcatid = $_GET['subcatid'];
do_shop_header('Shopsystem by Mehdi Bandegani');
display_shop_nav("labshop.php"); 
$url="labshowarticles.php";	

if ($subcatid<=0 ) { 
	$subcatid=1;  	
}
$article_array = get_articles($subcatid);
display_shop_articles($article_array, $url);  	
do_shop_footer();
?>

4.10.6 labshowarticles.php

<?php
session_start();
include("labconfig.php");
$id = $_GET['id'];
$url = 'labshop.php';
do_shop_header('Shopsystem by Mehdi Bandegani');
display_shop_nav($url);
$article = get_articlesdetails($id);
display_articlesdetails($article, $id);
if ($url['subcatid']) {
    $url = 'labshop.php?subcatid=' . $url['subcatid'];
}
do_shop_footer();
?>

4.10.7 labshowcart.php

<?php
session_start();
include("labconfig.php");
@ $new = $_GET['new'];
if ($new) {
    // new article has been selected
    if (!isset($_SESSION['cart'])) {
        $_SESSION['cart'] = array();
        $_SESSION['items'] = 0;
        $_SESSION['totalprice'] = '0.00';
    }
    if (isset($_SESSION['cart'][$new]))
        $_SESSION['cart'][$new]++;
    else
        $_SESSION['cart'][$new] = 1;
    $_SESSION['totalprice'] = calculate_price($_SESSION['cart']);
    $_SESSION['items'] = calculate_items($_SESSION['cart']);
}
if (isset($_POST['save'])) {
    foreach ($_SESSION['cart'] as $nummer => $qty) {
        if ($_POST[$nummer] == '0')
            unset($_SESSION['cart'][$nummer]);
        else
            $_SESSION['cart'][$nummer] = $_POST[$nummer];
    }
    $_SESSION['totalprice'] = calculate_price($_SESSION['cart']);
    $_SESSION['items'] = calculate_items($_SESSION['cart']);
}
$url = 'labshop.php';
do_shop_header('Shopsystem by Mehdi Bandegani');
display_shop_nav($url);
if ($_SESSION['cart'] && array_count_values($_SESSION['cart']))
    display_cart($_SESSION['cart'], $url);
else {
	echo "<div id='page-wrapper'><div class='container-fluid'>";
	echo "<div class='bg-darkred fg-white'>";
   echo "You have no items in your shopping cart";
	echo "</div>";
	echo "</div></div>";	
}
if ($url['subcatid']) {
    $url = 'labshop.php?subcatid=' . $url['subcatid'];
}
if ($new) {
    $details = get_articlesdetails($new);
    if ($details['subcatid'])
        $url = 'labshop.php?subcatid=' . $details['subcatid'];
}
do_shop_footer();
?>

4.10.8 labcheckout.php

<?php
session_start();
include("labconfig.php");
$url = 'labshop.php';
do_shop_header('Shopsystem by Mehdi Bandegani');
display_shop_nav($url);
if ($_SESSION['cart'] && array_count_values($_SESSION['cart'])) {
	display_cart($_SESSION['cart'], FALSE, 1);
	display_checkout_form();
} else {
?>
	<div class='row'>
	<div class="col-md-4 col-sm-4 col-xs-12"></div>
	<div class='col-md-4'>
	<span class='label label-success'>You have no items in your shopping cart.</span>
	</div></div>
<?php
}
do_shop_footer();
?>

4.10.9 labpurchase.php

<?php
include("labconfig.php");
$url = 'labshop.php';
do_shop_header('Shopsystem by Mehdi Bandegani');
display_shop_nav($url);
$name    = $_POST['name'];
$prename    = $_POST['prename'];
$address = $_POST['address'];
$postcode     = $_POST['postcode'];
$city    = $_POST['city'];
$region = $_POST['region'];
$country = $_POST['country'];
$phone = $_POST['phone'];
$email    = $_POST['email'];
$password     = md5($_POST['password']);
$registered     = $_POST['registered'];
if ($_SESSION['cart'] && $name && $prename && $address && $postcode && $city  && $region && $country && $phone && $email && $password && $registered) {
    // Data record in database
	if (insert_order($_POST) != FALSE) {
        // Schopping cart
		display_cart($_SESSION['cart'], FALSE, 1);
		display_shipping(calculate_shipping_cost());
		// Data for credit card
		display_card_form($name);
		echo "<a href='labshowcart.php' class='button'><span class='mif-add-shopping-cart'></span>&nbsp;&nbsp;add shopping</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
	} else {
		echo "<div id='page-wrapper'><div class='container-fluid'>";
		echo 'Could not save your data, please try again.';
		echo "<a href='labcheckout.php' class='button'><span class='mif-paypal'></span>&nbsp;&nbsp;Continue to pay</a>";
		echo "</div>";
		echo "</div>";
	}
} else {
	echo "<div id='page-wrapper'><div class='container-fluid'>";
   echo 'You have not filled out all fields, please try again.<hr />';
	echo "<a href='labcheckout.php' class='button'><span class='mif-paypal'></span>&nbsp;&nbsp;Continue to pay</a>";
	echo "</div>";
	echo "</div>";
}
do_shop_footer();
?>

4.11.1 Anwesenheit von den Kursteilnehmern überprüfen

4.11.2 Mainbereich festlegen

4.11.3 Mainbereich mit Artikeldaten belegen