» (Upload download files) Build PHP Database Driven Websites – Tutorial 4b PHPJavascript Web Development Guide – My Personal Library of Tutorials and Scripts

(Upload download files) Build PHP Database Driven Websites – Tutorial 4b

September15

Upload files in form of games from CMS and download from the website.

Previously we had build the database structure, CMS and website interface for an online egames website and now we will add extra features to our website.
Recap:

We are adding files or games to our egames website
So far we have build a database structure, CMS and website interface
Download file 79.rar. “start” folder consist of the work done previously and “final” folder consist of the complete work done in this tutorial

Download “start” folder copy paste at c:/wwwroot/inetpub and rename it to “egames”. Create folder “file” in the “egames” folder.

Now we want to add games to our egames website. We will write scripts to upload files on the CMS and then simply download the file from the egames website. The coding will be similar to our Photo Gallery discussed before.

We have to make changes at 3 locations in order to upload files on our dynamic website:

The database structure
The CMS admin panel of the website
The website itself

The database structure

Open PHPmyadmin and type the following code to change the table structure of the table “product”

ALTER TABLE 'product' ADD 'file' VARCHAR( 255 ) NULL AFTER 'photo' ;

The CMS admin panel of the website

I assume that you are following the flow of my tutorials and have the “egames” website installed and running on your computer. If you want click here to view the first CMS tutorial.

Extract the file and rename the folder “start” to “egames” and copy it to c:/wwwroot/inetpub.

Add File

Open file admin/addproduct.php and type the following below the “Photo” field.

<tr> <td width="200" height="21" valign="middle" align="left"><font class=tablackb>File</font></td> <td width="8"> : </td> <td width="350" align="left"><font><input name="file" type="file" size="36"></font></td> </tr>

Save File

Open admin/saveproduct.php; find <!– listing –> delete the existing text and type the following:

<? $product=$_POST["product"]; $productcat=$_POST["productcat"]; $bdesc=$_POST["bdesc"]; $ddesc=$_POST["ddesc"]; $res=mysql_query(”select productid from product order by productid desc”)or die(”product not select”); $totrow=mysql_num_rows($res); $row=mysql_fetch_array($res); if ($totrow==0) $productid=”1″; else $productid=$row["productid"]+1; //———————————————————————————-photo if(!empty($_FILES["photo"])) { $uploaddir = “../photo/”; // set this to wherever if (copy($_FILES["photo"]["tmp_name"], $uploaddir . $_FILES["photo"]["name"])) { $a=$_FILES["photo"]["name"]; $end=strstr($a,’.'); $photo=$uploaddir.$productid.$end; rename($uploaddir.$a, $photo); // rename the file in the directory $uploaddir eg xyz.jpg to 01.jpg $photo=$productid.$end; //prepares the file name to be stored in the database } else { echo (”Image Not Uploaded!<br>”); $photo=”"; } } else { $photo=”"; } //———————————————————————————-file if(!empty($_FILES["file"])) { $uploaddir = “../file/”; // set this to wherever if (copy($_FILES["file"]["tmp_name"], $uploaddir . $_FILES["file"]["name"])) { $a=$_FILES["file"]["name"]; $end=strstr($a,’.'); $file=$uploaddir.$productid.$end; rename($uploaddir.$a, $file); // rename the file in the directory $uploaddir eg xyz.jpg to 01.jpg $file=$productid.$end; //prepares the file name to be stored in the database } else { echo (”Image Not Uploaded!<br>”); $file=”"; } } else { $file=”"; } mysql_query(”insert into product values(’$productid’,'$product’,'$photo’,'$file’, ‘$bdesc’,'$ddesc’)”) or die(”product not insert”); mysql_query(”insert into productcategory values(’$productcat’,'$productid’)”) or die(mysql_error()); ?>

Modify File

Open file admin/modifyproduct.php and type the following below the “Photo” field.

Make sure the form declaration has <form method=post name=myform action=”updateproduct.php” enctype=”multipart/form-data”>

<?php $my_file = “../file/”.$row1["file"]; $file_size = filesize($my_file); if ($file_size >= 1073741824) { $show_filesize = number_format(($file_size / 1073741824),2) . ” GB”; } elseif ($file_size >= 1048576) { $show_filesize = number_format(($file_size / 1048576),2) . ” MB”; } elseif ($file_size >= 1024) { $show_filesize = number_format(($file_size / 1024),2) . ” KB”; } elseif ($file_size >= 0) { $show_filesize = $file_size . ” bytes”; } else { $show_filesize = “0 bytes”; } ?> <tr> <td width=”200″ height=”21″ valign=”middle” align=”left”><font>File</font></td> <td width=”8″> : </td> <td width=”350″ align=”left”><font class=tablack><? if($row1["file"]!=”") { $file=$row1["file"]; ?><a href=”<? echo $my_file ?>”><font class=”tablackb”><? echo $file ?></font></a> (<? echo $show_filesize?>) <? } else { ?> File not available<? } ?></font></td> </tr> <input type=”hidden” name=”oldfile” value=”<? echo $row1["file"] ?>”> <tr> <td width=”200″ height=”21″ valign=”middle” align=”left”><font>Change file</font></td> <td width=”8″> : </td> <td width=”350″ align=”left”><font class=tablack><input type=file name=”newfile” size=50 class=ainput disabled=1><br> <input type=radio name=”pic” value=”usecurrent” checked onclick=radval3();> Use Current <input type=radio name=”pic” value=”newpic” onclick=radval4();>New File</b> </font></td> </tr> <SCRIPT language=JavaScript> <!– function radval3() { document.myform.newfile.disabled=1; } function radval4() { document.myform.newfile.disabled=0; } –> </SCRIPT>

Update File

Open admin/updateproduct.php; find <!– listing –> delete the existing text and type the following:

<? $productid=$_POST["productid"]; $product=$_POST["product"]; $productcat=$_POST["productcat"]; $bdesc=$_POST["bdesc"]; $ddesc=$_POST["ddesc"]; //——————————————————————————-sphoto $pic=$_REQUEST["pic"]; if($pic==”usecurrent”) { $newphoto=$_REQUEST["oldphoto"]; } else { $oldphoto=$_REQUEST["oldphoto"]; if($oldphoto!=”") unlink(”../photo/”.$oldphoto); if(!empty($_FILES["newphoto"])) { $uploaddir = “../photo/”; // set this to wherever if (copy($_FILES["newphoto"]["tmp_name"], $uploaddir . $_FILES["newphoto"]["name"])) { $a=$_FILES["newphoto"]["name"]; $end=strstr($a,’.'); $newphoto=$uploaddir.$productid.$end; rename($uploaddir.$a, $newphoto); // rename the file in the directory $uploaddir eg xyz.jpg to 01.jpg $newphoto=$productid.$end; //prepares the file name to be stored in the database } else { echo (”Image Not Uploaded!<br>”); $newphoto=”"; } } else { $newphoto=”"; } } //——————————————————————————-sfile $pic1=$_REQUEST["pic1"]; if($pic1==”usecurrent”) { $newfile=$_REQUEST["oldfile"]; } else { $oldfile=$_REQUEST["oldfile"]; if($oldfile!=”") unlink(”../file/”.$oldfile); if(!empty($_FILES["newfile"])) { $uploaddir = “../file/”; // set this to wherever if (copy($_FILES["newfile"]["tmp_name"], $uploaddir . $_FILES["newfile"]["name"])) { $a=$_FILES["newfile"]["name"]; $end=strstr($a,’.'); $newfile=$uploaddir.$productid.$end; rename($uploaddir.$a, $newfile); // rename the file in the directory $uploaddir eg xyz.jpg to 01.jpg $newfile=$productid.$end; //prepares the file name to be stored in the database } else { echo (”Image Not Uploaded!<br>”); $newfile=”"; } } else { $newfile=”"; } } mysql_query(”update product set product=’$product’,photo=’$newphoto’, file=’$newfile’, bdesc=’$bdesc’,ddesc=’$ddesc’ where productid=’$productid’”) or die(mysql_error()); mysql_query(”update productcategory set productcat=’$productcat’ where productid=’$productid’”) or die(mysql_error()); ?>

Delete File

Open admin/deleteproduct.php find <!– listing –> delete the existing text and type the following:

<? for($i=1;$i<=50;$i++) { if(ISSET($_REQUEST["enquiry".$i])) { $productid=$_REQUEST["enquiry".$i]; $respic=mysql_query(”select * from product where productid=’$productid’”); $rowpic=mysql_fetch_array($respic); if($rowpic["photo"]!=”") { $photo=$rowpic["photo"]; unlink(”../photo/”.$photo); } $resfile=mysql_query(”select * from product where productid=’$productid’”); $rowfile=mysql_fetch_array($resfile); if($rowfile["file"]!=”") { $file=$rowfile["file"]; unlink(”../file/”.$file); } $strquery=”Delete from product where productid=’$productid’ “; mysql_query($strquery) or die(”Cannot Delete Record From product”); $strj=”Delete from productcategory where productcat like ‘$productid’ “; mysql_query($strj) or die(mysql_error()); } } ?>

Download File or Games on the Website

Open product.php find <!– listing –> delete the existing text and type the following:

<? $productid=$_REQUEST["productid"]; $res=mysql_query(”select * from product where productid=’$productid’”)or die(mysql_error()); $row=mysql_fetch_array($res); $photo=”photo/”.$row["photo"]; $my_file = “file/”.$row["file"]; $file_size = filesize($my_file); if ($file_size >= 1073741824) { $show_filesize = number_format(($file_size / 1073741824),2) . ” GB”; } elseif ($file_size >= 1048576) { $show_filesize = number_format(($file_size / 1048576),2) . ” MB”; } elseif ($file_size >= 1024) { $show_filesize = number_format(($file_size / 1024),2) . ” KB”; } elseif ($file_size >= 0) { $show_filesize = $file_size . ” bytes”; } else { $show_filesize = “0 bytes”; } echo “<h4>”.$row["product"].”</h4><img src=’$photo’><br>”.$row["bdesc"].”<br>”.$row["ddesc"].”<hr><br><a href=’$my_file’><h4>Download $show_filesize</h4></a>”; ?>

Code	Explanation
saveproduct.php
`if(!empty($_FILES["file"]))`	Extracting the file from the previous page and checking if it exists
`$uploaddir = "../file/";`	assigning the folder for uploading images
`if (copy($_FILES["file"]["tmp_name"], $uploaddir . $_FILES["file"]["name"]))`	copying image from existing folder to the assigned folder if copying is true then follow further steps else $file=empty to be stored in DB
`$a=$_FILES["file"]["name"];`	$a = name of the file
`$end=strstr($a,'.');`	extracting the extension of the file
`$file=$uploaddir.$productid.$end;`	$file = folder name productid and extension
`rename($uploaddir.$a, $file);`	rename the file name with desired name which in this case is the productid
`$file=$productid.$end;`	$file = productid + extension to be stored in the mysql table “product”
`mysql_query("insert into product values('$productid','$product','$photo', '$file','$bdesc','$ddesc')")`	Inserting the file in table “product”
modifyproduct.php
`<? if($row1["file"]!="") { ?><img src="../file/<? echo $row1["file"] ?>" width="100"> <? } else { ?> Picture not available<? } ?>`	displaying the file if exit else display image
`<?php $my_file = "../file/".$row1["file"]; $file_size = filesize($my_file);` if ($file_size >= 1073741824) { $show_filesize = number_format(($file_size / 1073741824),2) . ” GB”; } elseif ($file_size >= 1048576) { $show_filesize = number_format(($file_size / 1048576),2) . ” MB”; } elseif ($file_size >= 1024) { $show_filesize = number_format(($file_size / 1024),2) . ” KB”; } elseif ($file_size >= 0) { $show_filesize = $file_size . ” bytes”; } else { $show_filesize = “0 bytes”; } ?>	PHP function filesize() to find the exact size of the file Make the file size readable by using PHP number_format function
`<input type="hidden" name="oldfile" value="<? echo $row1["file"] ?>">`	passing the file name if not changed
`<input type=file name="newfile" size=50 disabled=1><br> <input type=radio name="pic" value="usecurrent" checked onclick=radval1();> Use Current <input type=radio name="pic" value="newpic" onclick=radval2();>New Image</b>`	using radio buttons to give choice of either to use the current image or new image
`function radval3(){document.myform.newfile.disabled=1;} function radval4(){document.myform.newfile.disabled=0;}`	Javascript function for the above step
updateproduct.php
`$pic=$_REQUEST["pic"];`	request radio button “pic” to check if the user have the changed the image
`if($pic=="usecurrent"){ $newfile=$_REQUEST["oldfile"];}`	$pic = current then $newfile=the oldfile ie no change
`$oldfile=$_REQUEST["oldfile"];if($oldfile!="") unlink("../file/".$oldfile);`	else get the oldfile and delete it from website folder
`if(!empty($_FILES["newfile"])) ...`	copying the file to the website folder like done in saveproduct.php
`mysql_query("update product set product='$product',file='$newfile', bdesc='$bdesc',ddesc='$ddesc' where productid='$productid'")`	update the file in the table “product”
deleteproduct.php
`$respic=mysql_query("select * from product where productid='$productid'"); $rowpic=mysql_fetch_array($respic);`	Extracting row from table “product” where productid matches
`if($rowpic["file"]!="")`	Checks if the file exist
`$file=$rowpic["file"]; unlink("../file/".$file);`	Delete file

Dan dana dan DONE! Coding is very similar to our previous tutorial so you see how the same coding can do different things!!!!

posted under Development Guide

Drupal Views Exposed Computed Field Dropdown Select
8:07 am, January 24, 2012

Drupal Addresses Computed Field
7:35 am, January 23, 2012

Jquery easing effect not smooth
7:49 am, December 29, 2011

Page Navigation Effect using Jquery Easing
5:20 am, December 25, 2011

Drupal forms theme table
6:38 am, December 19, 2011

NAV Dynamics Webservices PHP
6:39 am, December 8, 2011

Drupal Views Total CCK field (Two content types related)
8:17 am, August 15, 2011

Drupal Theme Form CCK User Register
7:44 am, August 4, 2011

Drupal Form Theme CCK
7:38 am, August 1, 2011

Drupal Form Alter Fields
8:01 am, July 19, 2011