Photo Upload

n_baswa

Hi frends,

I've come with a new problem for my project. I've a table in mysql which is called the attorney_profiles....

I want to add photos to each profile. How do i add photos to the database and how do i retrieve them. Here are my codes....

<?php
include('dbconn.php');

//This is the directory where images will be saved
$target = "./photos/";
$target = $target . basename( $_FILES['photo']['name']);

//This gets all the other information from the form
/*$name=$_POST['name'];
$email=$_POST['email'];
$phone=$_POST['phone'];*/
$pic=($_FILES['photo']['name']); 

if( !empty($_POST) )
	{ 

	$sql = sprintf("INSERT INTO attorney_profiles(firstname,lastname,email,biography,username,password,areas_business,areas_litigation,areas_land_use,areas_real_estate,areas_senior_law,areas_estates,areas_PI,areas_employment,areas_family,areas_criminal,areas_LLT,photo) VALUES('$_POST[firstname]','$_POST[lastname]','$_POST[email]','$_POST[biography]','$_POST[username]','$_POST[password]','{$_POST[areas_business][0]}','{$_POST[areas_litigation][0]}','{$_POST[areas_land_use][0]}','{$_POST[areas_real_estate][0]}','{$_POST[areas_senior_law][0]}','{$_POST[areas_estates][0]}','{$_POST[areas_PI][0]}','{$_POST[areas_employment][0]}','{$_POST[areas_family][0]}','{$_POST[areas_criminal][0]}','{$_POST[areas_LLT][0]}','{$_POST[$_FILES['photo']['name']]}')");

	//exit(print($sql));

	//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

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

if (!mysql_query($sql,$con))
			{
				 die('Error: ' . mysql_error());
			}
	else
			{
				header("Location: index.php");
				echo "1 record added";
			}

if(!$sql)
{
	echo "No data.";
}
}

?>

<html>
<head>
</head>
<body>

<script language="Javascript">
function checkForm(form)
{

if(form.username.value=="")
{
alert("Please enter a User Name!!");
form.username.focus();
return(false);
}
if(form.password.value=="")
{
alert("Please enter a Password!!");
form.password.focus();
return(false);
}
if(form.firstname.value=="")
{
alert("Please enter a First Name!!");
form.firstname.focus();
return(false);
}
if(form.lastname.value=="")
{
alert("Please enter a Last Name!!");
form.lastname.focus();
return(false);
}

}
</script>

<form action="profile_add_neel.php" method="POST" enctype="multipart/form-data" onSubmit="return checkForm(this)" >

<input type="hidden" name="MAX_FILE_SIZE" value="150000" />

<table border='0'>

<tr>
<td>
<b>User Name*:</b> <br>
<input type="text" name="username" value="<?php print($username);?>" />
</td>
</tr>

<tr>
<td>
<b>Password*:</b> <br>
<input type="password" name="password" value="<?php print($password);?>" />
</td>
</tr>

<tr>
<td>
<b>First Name* :</b> <br>
<input type="text" name="firstname" value="<?php print($firstname);?>" />
</td>
</tr>

<tr>
<td>
<b>Last Name* :</b> <br>
<input type="text" name="lastname" value="<?php print($lastname);?>" />
</td>
</tr>

<tr>
<td>
<b>E-Mail Address:</b> <br>
<input type="text" name="email" value="<?php print($email);?>" />
<i>(e.g., abc@xyz.com)</i>
</td>
</tr>

<tr>
<td>
<b>Biography:</b> <br>
<TEXTAREA name="biography" class="biography"><?php print($biography);?></TEXTAREA></td>
</tr>

<tr>
<td>
<b>Practice Areas:</b> <br>
<input type="checkbox" name="areas_business[]" />Business<br>
<input type="checkbox" name="areas_litigation[]" />Litigation<br>
<input type="checkbox" name="areas_land_use[]" />Land Use<br>
<input type="checkbox" name="areas_real_estate[]" />Real Estate<br>
<input type="checkbox" name="areas_senior_law[]" />Senior Law<br>
<input type="checkbox" name="areas_estates[]" />Estates<br>
<input type="checkbox" name="areas_PI[]" />P.I.<br>
<input type="checkbox" name="areas_employment[]" />Employment<br>
<input type="checkbox" name="areas_family[]" />Family<br>
<input type="checkbox" name="areas_criminal[]" />Criminal<br>
<input type="checkbox" name="areas_LLT[]" />LL/T<br>
</tr>

<tr>
<td>
<b>Photo:</b> <br>
<input type="file" name="file" />
</td>
</tr>

</table>

<br>
<input type="submit" value="Add" id="submit" name="submit" />

</body>
</html>

The above code adds all the other data, but it does not add the photo into the database.

Pls help me in finding a solution for this.

Thank you.

quandrie

Where you insert into the attorney_profiles table, use $FILES['photo']['name'] instead of $POST[$_FILES['photo']['name']]

n_baswa

thanks

i tried doing the same but it gives the following error.....

Sorry, there was a problem uploading your file.Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name')' at line 1

i then tried changing the name to file which i gave the name of the input type file....and it gives the same error....

pls help...

n_baswa

guys...i had one more Q regarding this....

$target = "./photos/";

what path do i need to give for $target?

john1704

To insert your photo into a MySQL database, use this code:

$Picture = $_FILES['file']['tmp_name'];
$mysqlPicture = addslashes(fread(fopen($Picture, "r"), filesize($Picture)));

THEN, use the variable $mysqlPicture to use in your query while inserting values.

To retrieve a picture and display it, copy and paste this somewhere in your:

$result=mysql_query('SELECT * FROM TABLE_NAME WHERE id='.$idget) or
 die("Can't perform Query"); 
$row=mysql_fetch_object($result); 
#Header("Content-type: image/jpg"); 
echo $row->IMAGE_ROW_NAME_HERE;

You'll need to have an id associated with the picture so it can display properly, otherwise, it won't know which picture to display.

n_baswa

i tried the insert part u told me, but it doesn't insert the photo into the database. the photo field in the database is blank after inserting....

n_baswa

guys,

after a couple of hit and trials i'm now able to insert the photo filename into the photo field in the database....using this code...

<?php

//This is the directory where images will be saved
$target = "C://www//html//xxx//xxx/photos/";
$target = $target . basename( $_FILES['photo']['file']);

include('dbconn.php');
if( !empty($_POST) )
	{ 
			$sql = sprintf("INSERT INTO attorney_profiles(firstname,lastname,email,biography,username,password,areas_business,areas_litigation,areas_land_use,areas_real_estate,areas_senior_law,areas_estates,areas_PI,areas_employment,areas_family,areas_criminal,areas_LLT,photo) VALUES('$_POST[firstname]','$_POST[lastname]','$_POST[email]','$_POST[biography]','$_POST[username]','$_POST[password]','{$_POST[areas_business][0]}','{$_POST[areas_litigation][0]}','{$_POST[areas_land_use][0]}','{$_POST[areas_real_estate][0]}','{$_POST[areas_senior_law][0]}','{$_POST[areas_estates][0]}','{$_POST[areas_PI][0]}','{$_POST[areas_employment][0]}','{$_POST[areas_family][0]}','{$_POST[areas_criminal][0]}','{$_POST[areas_LLT][0]}','{$_FILES['photo']['name']}')"); 

if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

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

if (!mysql_query($sql,$con))
			{
				 die('Error: ' . mysql_error());
			}
	else
			{
				header("Location: index.php");
				echo "1 record added";
			}

if(!$sql)
{
	echo "No data.";
}
}

The above code inserts the filename to the database, but doesn't move the files to the photo folder i have and also it doesn't display the photo.....i use the following code for displaying the photos and other data...

<?php
include('dbconn.php');

$sql = "SELECT * FROM attorney_profiles";

if (!mysql_query($sql,$con))
{
 die('Error: ' . mysql_error());
}
// how many rows to show per page
$rowsPerPage = 5;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$result = mysql_query("SELECT * FROM attorney_profiles LIMIT $offset,$rowsPerPage");

$num=mysql_num_rows($result);

$i=0;
while ($i < $num) {
$attorney_id=mysql_result($result,$i,"attorney_id");
$firstname=mysql_result($result,$i,"firstname");
$lastname=mysql_result($result,$i,"lastname");
$email=mysql_result($result,$i,"email");
$biography=mysql_result($result,$i,"biography");
$username=mysql_result($result,$i,"username");
$password=mysql_result($result,$i,"password");
$areas_business=mysql_result($result,$i,"areas_business");
$areas_litigation=mysql_result($result,$i,"areas_litigation");
$areas_land_use=mysql_result($result,$i,"areas_land_use");
$areas_real_estate=mysql_result($result,$i,"areas_real_estate");
$areas_senior_law=mysql_result($result,$i,"areas_senior_law");
$areas_estates=mysql_result($result,$i,"areas_estates");
$areas_PI=mysql_result($result,$i,"areas_PI");
$areas_employment=mysql_result($result,$i,"areas_employment");
$areas_family=mysql_result($result,$i,"areas_family");
$areas_criminal=mysql_result($result,$i,"areas_criminal");
$areas_LLT=mysql_result($result,$i,"areas_LLT");
$photo=mysql_result($result,$i,"photo");

if($areas_business=="on") { 
	$areas_business="Business"; }

if($areas_litigation=="on") { 
	$areas_litigation="Litigation"; }

if($areas_land_use=="on") { 
	$areas_land_use="Land Use"; }

if($areas_real_estate=="on") { 
	$areas_real_estate="Real Estate"; }

if($areas_senior_law=="on") { 
	$areas_senior_law="Senior Law"; }

if($areas_estates=="on") { 
	$areas_estates="Estates"; }

if($areas_PI=="on") { 
	$areas_PI="P.I."; }

if($areas_employment=="on") { 
	$areas_employment="Employment"; }

if($areas_family=="on") { 
	$areas_family="Family"; }

if($areas_criminal=="on") { 
	$areas_criminal="Criminal"; }

if($areas_LLT=="on") { 
	$areas_LLT="LL/T"; }

echo "<b>Attorney Name:</b> <a href=\"profile_edit_neel.php?attorney_id=$attorney_id\">$firstname $lastname</a>"; echo "<br>";
echo "<b>E-Mail:</b> $email"; echo "<br>";
echo "<b>Biography:</b> $biography"; echo "<br>";
echo "<b>Practice Areas:</b> "; echo "$areas_business";  echo "&nbsp;"; 
							   echo "$areas_litigation";  echo "&nbsp;"; 
				   			   echo "$areas_land_use"; echo "&nbsp;";
				   			   echo "$areas_real_estate"; echo "&nbsp;";
							   echo "$areas_senior_law"; echo "&nbsp;";
							   echo "$areas_estates"; echo "&nbsp;";
							   echo "$areas_PI"; echo "&nbsp;";
							   echo "$areas_employment"; echo "&nbsp;";
							   echo "$areas_family"; echo "&nbsp;";
							   echo "$areas_criminal"; echo "&nbsp;";
							   echo "$areas_LLT";
echo "<br>";					   

echo "<img src=C://www//html//xxx//xxx//photos/" . $photo . ">"; 
echo "<br>"; echo "<br>";					   

$i++;
}