Templates database Website Project

* Project Name:   Templates database Website Project PHP/HTML/JavaScript/MySQL code
* Programmer:   msi_333
* Type:   Website
* Technology:  PHP/HTML/JavaScript/MySQL
* IDE:   Any
 Description:   This is a free open for online templates database and libraries under GPL2.0, this project can carry any templates for any type of software and CMS. Examples of templates for : PHPBB3, PHPBB2, Joomla, Drupal, Wordpress , this project provide the following features :

• Allow administrator to upload new templates ( Files,Images) , update templates, delete templates, and modify templates.
• Insert any new template type.
• Insert new template with small and large image screenshots.
• Show the latest styles inserted for each style at home page.
• Special page to view style and its information.
• Allow user to comment on each style.
• Allow user to vote style.
• Pagination for styles list.
• Allow user to download the styles files.
• Sort styles list by parameters such as (downloads,name,data,views,last update and style version).
• JavaScript validation for HTML forms.
• Search the templates database using style type,category and name.
• MySQL database with four tables : vote, comment, style, type.

Fixes that may be needed :

• Voting uniquely by saving IP-address into database.
• Add more validation for admin login, and add Captcha.
• Make the style more advanced.

Code sample from the project :
php code

<?php
 // Declair the HTML title variable, changed later
   $html_title ="PHPBB3 Styles database";
include '../head_handler.php';

 
 if(isset($_POST['booleaninsert']))
  {
      $flag=$_POST['booleaninsert'];
	  if($flag="yes")
	     {
		 include('Controllers/styleinsertcontrol.php');
		 echo "Style updated .<br/>";
		 }
		 
  }
?>
<table>
     <form method="post" action="#" />
     <b>StyleID : </b><input type="text" name="STYLE_ID" size="10" maxlength="10"  /><br />
	 <input type="submit"	value="show" />
	 </form>
	
<?php 
	  $STYLE_ID="-1";
		 if(isset($_POST['STYLE_ID']))
		 {
	  include 'Controllers/styleupdatecontrol.php'; 
	   include 'Controllers/typeshowcontrol.php';  		
	  
	  ?>
		<form method="post" action="#"  >
		<?php		
		if(isset($STYLE_NAME) &isset($STYLE_VR)&isset($TYPE_ID)&isset($AUOTHER))
		{
		echo"<tr><td colspan=2><img name='$image' alt=$STYLE_NAME src='$image'   /></td></tr>";
	  echo "<tr><td><b>Style Name:</b>&nbsp;</td><td><input type='text' maxlength=40 size=40

 name='STYLE_NAME' value='$STYLE_NAME' /><br/></td></tr>";

	   echo "<tr><td><b>Style VR:</b>&nbsp;</td><td><input type='text' maxlength=40 size=40 

name='STYLE_VR' value='$STYLE_VR' /><br/></td></tr>";

	    echo "<tr><td><b>Type VR:</b>&nbsp;</td><td><input type='text' maxlength=40 size=40 

name='TYPE_VR' value='$TYPE_VR' /><br/></td></tr>";
	 
		 ?>
		 <tr><td><b>Style Type:</b>&nbsp;</td><td>
		 <select name="STYLE_TYPE" >

<?php 
  
     echo $typescontent; 
  ?>
 </select></td></tr>
  <tr><td><b>Style Category:</b>&nbsp;</td><td>
<?php
    include 'Categoryselector.php'; ?> 

		 <?php
		  echo "<tr><td><b>Auother:</b>&nbsp;</td><td><textarea  rows=6 cols=30 

name='AUOTHER'>$AUOTHER</textarea><br/></td></tr>";
		  }
		  else echo "Please enter correct ID , no data for this ID";
	   ?>
	   
	    <tr><td><input type="submit" value="update" />
		<input type="hidden" name="STYLE_ID" value="<?php echo $STYLE_ID; ?>">
		<input type="hidden" name="insertype" value="update">
		
<input type="hidden" name="booleaninsert" value="yes"/>
	    </form>
    </td><td> <form action="deletestyle.php" method="post" >
	 <input type="submit" value="delete" />
 
		<input type="hidden" name="STYLE_ID" value="<?php echo $STYLE_ID; ?>">
		<input type="hidden" name="STYLE_NAME" value="<?php echo $STYLE_NAME; ?>">
		<input type="hidden" name="STYLE_TYPE" value="<?php echo $currentType; ?>">
	 </form></td></tr>
	 	</table>
		 <?php	 
		 }
	?>

To enter the administrator list , use username="codemiles" not it is hardcode , you may need to encrypt it. The database SQL- UML is included in the zip folder.


To configure the database connection , you need to edit config.php.