- PHP
- MySQL Server
Uploading profile pic to user details PHP +MySQL
I am building a content managed business directory.
So far I have this working in that a user can login and update their details. What I want to add is the ability to upload a profile pic.
To do this I have found a script that uploads an image resizes it and send the filename to a database and the image to the server. This is fine but...the profile pic table is different to the main user info table and the two are not linked in any way.
So currently I have a table with user info and a separate table with profile image paths.
The code for the image upload form is...
</form></td>
<td width="48%" align="center" valign="top"> <form action="<?php echo $editFormAction; ?>" method="POST" name="image_upload" id="image_upload" enctype="multipart/form-da
<!-- begin image label and input -->
<label>SelECT Profile Photo Image (gif, jpg, png)</label><br />
<input type="file" size="30" name="uploadfile" id="uploadfile" class="file margin_5_0" onchange="ajaxUpload(this.
<br />
<!-- begin display uploaded image -->
<div id="upload_area" class="corners align_center">
please select image
</div><!-- begin display uploaded image -->
</form>
This resizes the image and calls ajax.js the in turn calls the upload.php script (both attached).
At the bottom of the upload.php script is the code that add the info to the database...
// database connection
include('inc/db.inc.php');
// insert into mysql database and show success message
mysql_query("INSERT INTO `image_upload` (`id`, `image`, `thumbnail`, `thumbnail2`, `thumbnail3` ) VALUES (NULL, '". $image ."', 'thumb-". $image ."', 'thumb2-". $image ."', 'thumb3-". $image ."')");
}
// error all fileds must be filled
} else {
echo '<div class="wrong">You must to fill all fields!</div>'; }
What I think I need to do here is either update a 'thumbnail' row of main user profile table (rather than image_upload table). I'm just not show how to carry over the unique user id to the upload.php file inorder to achieve this or...
insert to the image_upload table but send the unique id too.
I realise this may be confusing so please fire away if you need me to clear up anything!
Screen-shot-2011-11-02-at-15.28..png
Screen-shot-2011-11-02-at-15.29..png
Screen-shot-2011-11-02-at-15.41..png
So far I have this working in that a user can login and update their details. What I want to add is the ability to upload a profile pic.
To do this I have found a script that uploads an image resizes it and send the filename to a database and the image to the server. This is fine but...the profile pic table is different to the main user info table and the two are not linked in any way.
So currently I have a table with user info and a separate table with profile image paths.
The code for the image upload form is...
</form></td>
<td width="48%" align="center" valign="top"> <form action="<?php echo $editFormAction; ?>" method="POST" name="image_upload" id="image_upload" enctype="multipart/form-da
<!-- begin image label and input -->
<label>SelECT Profile Photo Image (gif, jpg, png)</label><br />
<input type="file" size="30" name="uploadfile" id="uploadfile" class="file margin_5_0" onchange="ajaxUpload(this.
<br />
<!-- begin display uploaded image -->
<div id="upload_area" class="corners align_center">
please select image
</div><!-- begin display uploaded image -->
</form>
This resizes the image and calls ajax.js the in turn calls the upload.php script (both attached).
At the bottom of the upload.php script is the code that add the info to the database...
// database connection
include('inc/db.inc.php');
// insert into mysql database and show success message
mysql_query("INSERT INTO `image_upload` (`id`, `image`, `thumbnail`, `thumbnail2`, `thumbnail3` ) VALUES (NULL, '". $image ."', 'thumb-". $image ."', 'thumb2-". $image ."', 'thumb3-". $image ."')");
}
// error all fileds must be filled
} else {
echo '<div class="wrong">You must to fill all fields!</div>'; }
What I think I need to do here is either update a 'thumbnail' row of main user profile table (rather than image_upload table). I'm just not show how to carry over the unique user id to the upload.php file inorder to achieve this or...
insert to the image_upload table but send the unique id too.
I realise this may be confusing so please fire away if you need me to clear up anything!
<?php
//----------------------------------------- start edit here ---------------------------------------------//
$script_location = "http://www.anjoman.co.uk/upload/"; // location of the script
$maxlimit = 1048576; // maxim image limit
$folder = "upload"; // folder where to save images
// requirements
$minwidth = 200; // minim width
$minheight = 200; // minim height
$maxwidth = 2400; // maxim width
$maxheight = 2400; // maxim height
//thumbnails - 1 or 0 to allow or disallow
$thumb = 1; // allow to create thumb n.1
// allowed extensions
$extensions = array('.png', '.gif', '.jpg', '.jpeg','.PNG', '.GIF', '.JPG', '.JPEG');
//----------------------------------------- end edit here ---------------------------------------------//
// check that we have a file
if((!empty($_FILES["uploadfile"])) && ($_FILES['uploadfile']['error'] == 0)) {
// check extension
$extension = strrchr($_FILES['uploadfile']['name'], '.');
if (!in_array($extension, $extensions)) {
echo 'wrong file format, alowed only .png , .gif, .jpg, .jpeg
<script language="javascript" type="text/javascript">window.top.window.formEnable();</script>';
} else {
// get file size
$filesize = $_FILES['uploadfile']['size'];
// check filesize
if($filesize > $maxlimit){
echo "File size is too big.";
} else if($filesize < 1){
echo "File size is empty.";
} else {
// temporary file
$uploadedfile = $_FILES['uploadfile']['tmp_name'];
// capture the original size of the uploaded image
list($width,$height) = getimagesize($uploadedfile);
// check if image size is lower
if($width < $minwidth || $height < $minheight){
echo 'Image is to small. Required minimum '.$minwidth.'x'.$minheight.'
<script language="javascript" type="text/javascript">window.top.window.formEnable();</script>';
} else if($width > $maxwidth || $height > $maxheight){
echo 'Image is to big. Required maximum '.$maxwidth.'x'.$maxheight.'
<script language="javascript" type="text/javascript">window.top.window.formEnable();</script>';
} else {
// all characters lowercase
$filename = strtolower($_FILES['uploadfile']['name']);
// replace all spaces with _
$filename = preg_replace('/\s/', '_', $filename);
// extract filename and extension
$pos = strrpos($filename, '.');
$basename = substr($filename, 0, $pos);
$ext = substr($filename, $pos+1);
// get random number
$rand = time();
// image name
$image = $basename .'-'. $rand . "." . $ext;
// check if file exists
$check = $folder . '/' . $image;
if (file_exists($check)) {
echo 'Image already exists';
} else {
// check if it's animate gif
$frames = exec("identify -format '%n' ". $uploadedfile ."");
if ($frames > 1) {
// yes it's animate image
// copy original image
copy($_FILES['uploadfile']['tmp_name'], $folder . '/' . $image);
// orignal image location
$write_image = $folder . '/' . $image;
//ennable form
echo '<img src="' . $write_image . '" alt="'. $image .'" alt="'. $image .'" width="300" /><br />
<input type="text" name="location" value="[IMG]'.$script_location.''.$write_image.'[/IMG]" class="location corners" />
<script language="javascript" type="text/javascript">window.top.window.formEnable();</script>';
} else {
// create an image from it so we can do the resize
switch($ext){
case "gif":
$src = imagecreatefromgif($uploadedfile);
break;
case "jpg":
$src = imagecreatefromjpeg($uploadedfile);
break;
case "jpeg":
$src = imagecreatefromjpeg($uploadedfile);
break;
case "png":
$src = imagecreatefrompng($uploadedfile);
break;
}
// copy original image
copy($_FILES['uploadfile']['tmp_name'], $folder . '/' . $image);
// orignal image location
$write_image = $folder . '/' . $image;
if ($thumb == 1){
// create first thumbnail image - resize original to 80 width x 80 height pixels
$newheight = ($height/$width)*200;
$newwidth = 200;
$tmp=imagecreatetruecolor($newwidth,$newheight);
imagealphablending($tmp, false);
imagesavealpha($tmp,true);
$transparent = imagecolorallocatealpha($tmp, 255, 255, 255, 127);
imagefilledrectangle($tmp, 0, 0, $newwidth, $newheight, $transparent);
imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);
// write thumbnail to disk
$write_thumbimage = $folder .'/thumb-'. $image;
switch($ext){
case "gif":
imagegif($tmp,$write_thumbimage);
break;
case "jpg":
imagejpeg($tmp,$write_thumbimage,100);
break;
case "jpeg":
imagejpeg($tmp,$write_thumbimage,100);
break;
case "png":
imagepng($tmp,$write_thumbimage);
break;
}
}
// all is done. clean temporary files
imagedestroy($src);
imagedestroy($tmp);
// image preview
if ($thumb == 1){
echo "<img src='" . $write_thumbimage . "' alt='". $image ."' /><br />
<input type='text' name='location' value='[IMG]".$script_location."". $write_thumbimage ."[/IMG]' class='location corners' /><br />
<br />";
}
}
}
}
}
// database connection
include('inc/db.inc.php');
// insert into mysql database and show success message
mysql_query("INSERT INTO `image_upload` (`id`, `image`, `thumbnail`, `thumbnail2`, `thumbnail3` ) VALUES (NULL, '". $image ."', 'thumb-". $image ."', 'thumb2-". $image ."', 'thumb3-". $image ."')");
}
// error all fileds must be filled
} else {
echo '<div class="wrong">You must to fill all fields!</div>'; }
?>
Screen-shot-2011-11-02-at-15.28..png
Screen-shot-2011-11-02-at-15.29..png
Screen-shot-2011-11-02-at-15.41..png
I would modify your user database to include the variables needed for the image.
Update the scripts to update those fields in your existing database.
Otherwise you will need to add a field to the images table that references the user ID.
Update the scripts to update those fields in your existing database.
Otherwise you will need to add a field to the images table that references the user ID.
Have you considered using mysql_insert_id? (http://us2.php.net/manual/en/function.mysql-insert-id.php)
After you do your INSERT into image_upload, that function will return the value of the autoinc id column of the row it just added, and then you can put that into your other table to tie back to the first.
After you do your INSERT into image_upload, that function will return the value of the autoinc id column of the row it just added, and then you can put that into your other table to tie back to the first.
That sounds good xterm.
The main problem i'm having though it that the insert to database code is on a separate page (upload.php) which is called by ajax.js.
Because of this I can't figure out how to get for example the user-id on the main admin page to carry over to ajax.js and then upload.php.
The my_insert_id sounds perfect but because the insert code is not on the same page as the main admin page I can't see how to get that return value.
Hope this makes sense?
The main problem i'm having though it that the insert to database code is on a separate page (upload.php) which is called by ajax.js.
Because of this I can't figure out how to get for example the user-id on the main admin page to carry over to ajax.js and then upload.php.
The my_insert_id sounds perfect but because the insert code is not on the same page as the main admin page I can't see how to get that return value.
Hope this makes sense?
I guess I'm a bit confused - can't you just post the user-id as a hidden field, and then right after the INSERT into the image_upload table, just do an insert into the main_user_info table directly afterwards?
why do you have 3 thumbs fields for one image?
all you need is one field for image name then reuse that image name for main image and thumb
e.g.
123.jpg 123_tumb.jpg
if you only require one picture for profile then you don not need a image table just use the user_id for image name
e.g
md5("$user_id somesalt").'jpg'
all you need is one field for image name then reuse that image name for main image and thumb
e.g.
123.jpg 123_tumb.jpg
if you only require one picture for profile then you don not need a image table just use the user_id for image name
e.g
md5("$user_id somesalt").'jpg'
Premium Content
You need an Expert Office subscription to comment.Start Free Trial