Templates database Website Project

Thu Jan 31, 2013 8:37 pm

* 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.

TD.gif
Styles database Project Code ScreenShot
TD.gif (113.73 KiB) Viewed 16251 times

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.
Code:
http://yourdomain/templatesdragon/adminstration.php


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


Attachments
templatesdragon.zip
Templates Database Project
(348.16 KiB) Downloaded 1449 times

  Related Posts  to : Templates database Website Project
 How to import your website dump database script     -  
 Java Library Database Management System Project     -  
 need code for my website     -  
 Website designer     -  
 make website by flash     -  
 Web content & Website Design     -  
 Help needed in website design     -  
 Make A Website In Flash     -  
 Arabic website partner     -  
 Make A Website In Flash 2     -  

Topic Tags

PHP Project