PHP/MySql : Store file path or name in database, file in folder.

Create a file : form.html

<form action=addmembers.php method=post enctype="multipart/form-data">
<table border="0" cellspacing="0" align=center cellpadding="3" bordercolor="#cccccc">
<tr>
<td>File:</td>
<td><input type="file" name="filep" size=45></td>
</tr>
<tr>
<td colspan=2><p align=center>
<input type=submit name=action value="Load">
</td>
</tr>
</table>
</form>


Create another file : addmembers.php
<?

if ($_POST["action"] == "Load")
{
$folder = "images/";



move_uploaded_file($_FILES["filep"]["tmp_name"] , "$folder".$_FILES["filep"]["name"]);

echo "<p align=center>File ".$_FILES["filep"]["name"]."loaded...";

$result = mysql_connect("localhost", "****", "****") or die ("Could not save image name Error: " . mysql_error());
mysql_select_db("test") or die("Could not select database");
mysql_query("INSERT into picture (URL) VALUES('".$_FILES['filep']['name']."')");

if($result) { echo "Image name saved into database"; }
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}
}
?>


For Display the file use code :

<?
//Retrieves data from MySQL
mysql_connect("localhost", "****", "*****") or die ("Could not save image name Error: " . mysql_error());
mysql_select_db("test") or die("Could not select database");
$data = mysql_query("SELECT `URL` FROM picture ") or
die(mysql_error());
//Puts it into an array
$file_path = 'http://localhost/test/images/';

while($row = mysql_fetch_assoc( $data ))
{//Outputs the image and other data
$src=$file_path.$row['URL'];
echo "<img src=".$src.">  <br>";
}
?>