In your query:
$q = mysql_query(&q uot;UPDATE `Images` SET user_images = (".$filen ame.") WHERE username = ".$userna me."&quo t;);

try this:
$q = mysql_query(&q uot;UPDATE `Images` SET user_images = (".$filen ame.") WHERE username = ".strtolo wer($_SESSION[ 'username']). "");

Hi bs0d,

Thanks for reply. I tried your suggestion, still like before. images was uploaded to the folder but overwritten again and again. And table 'Images' still empty. I am just stuck. Hope to get more suggestions if possible. Thanks alot.

In an effort to debug your script, try to print out variables to the screen throughout the script. This will allow you to see if any variables are not being set and will help identify the area of the script that needs attention.

Fixed it and tested it, here it is. Works fine.

If you see a smilie, it is equals this )

Code:

FIND-

if(is_uploaded_ file($_FILES[' userfile']['t mp_name'])) {

ADD AFTER-

//find if user exists in image table
$get = mysql_query(&q uot;SELECT `user_id` FROM `images` WHERE `user_id` = '".$_SES SION['user_id ']."'&q uot;
if(!$get) die('An Error Occurred.');
$get2 = mysql_fetch_obj ect($get);
if(!$get2) {
$insert = mysql_query(&q uot;INSERT INTO `images` (user_id) VALUES ('".$_SE SSION['user_id ']."') ";
if(!$insert) die("Erro r while inserting.&quo t;
}


FIND-

$q = mysql_query(&q uot;UPDATE `Images` SET `user_images` = (".$filen ame." WHERE username = ".$userna me ";

REPLACE WITH-

$q = mysql_query(&q uot;UPDATE `images` SET `user_images` = (".$filen ame." WHERE user_id = '".$_SES SION['user_id ']."' ";

Good job, David! A note to everyone, if you click the checkbox in teh reply form that says, "Disable Smilies" then you won't get smilies in your code. But you have to do this in your initial reply. It doesn't work if you edit the reply.

Hey dude,

i have emailed you back with my script, which i have added thumbnail generation also, so feel free to take a look.

The only thing i can see where you have gone wrong is with your sql statement.


Code:

  barbs75 said...

< i> Hey dude,

i have emailed you back with my script, which i have added thumbnail generation also, so feel free to take a look.

The only thing i can see where you have gone wrong is with your sql statement.

<BR><f ont size=1><u >Code:</u ><BR>& lt;div name="div _box" class="di vCode"> ;$q = mysql_query(&q uot;UPDATE `Images` SET user_images = (".$filen ame." WHERE username = ".$userna me."&quo t;

Hi David and Barbs,

Thanks a lot for reply. I David's suggestion did help insert info into database but image_name is still 0 all the time. I guess I will keep testing. For Barbs, thank you for sending me the code. But, unfortunately, I checked through my mailbox for some reason, I did not receive your email. Would you please resent it or post the code here if possible. It shall be greatly appreciated. My email address, again, is wangwuj [at] mail [dot] ccsu [dot] edu
By the way, thanks bs0d for providing original code.

*Email edited by bs0d for spam bot protection.

I think I know what your saying with the 0 image. Your saying in your folder directory it keeps saving as 0.jpg right?

This was my code I used to test it, it counted up images just fine 0,1,2,3... in my directory and database.


Code:

Thanks David, one question, shall I define $user_id in login page as _session['user _id'] in order to insert it into database from the upload page? it seems it does not automatically carried in even I have session_start() ; on top of webpage.

Working on it.

Thanks for help. I understand what you posted and altered my code already. the problem is like before. I don't know what the hell my code happens. Here is how the code confuse me:

When I take session_start() off, the code will save image file in image folder as 1.jpg, 2 jpg and 3 jpg... by which i see the sequence and also in the table "user_ima ges" column i see number increasing. but I don't see username or user_id. being added to the uploaded image files. However, when I add session_start() on the very top of html, after uploaded image files, I can see username+1 or user_id+1 in the folder (depends how I set in upload page, I used username rather than user_id.) but no matter how many pic/images I upload, it keeps overwrite again and again. and the "user_ima ges" column is always "0" . I guess it sounds too complicated. I just post my code here see if anyone could figure it out if possible.

my login.php works great. it is like this



Code:

Ok, tested. Try this:


Code:

<?php
session_start() ;

// Include Database Connection Here

// Configuration - Your Options
$filetypes = array('.jpg', '.gif','.bmp ','.png');
$max_filesize = 999999;
$upload_path = 'images/';

// If submitted
if(isset($_POST ['submit'])) {

// Name of the original file
$filename = $_FILES['image ']['name'];

// Check the extension
$ext = substr($filenam e, strpos($filenam e,'.'), strlen($filenam e)-1);

// Check the filetype
if(!in_array($e xt,$filetypes))
die('The image type is not allowed.');

// Check the filesize
if(filesize($_F ILES['image'] ['tmp_name']) > $max_filesize)
die('The image is too large.');

// Check upload path
if(!is_writable ($upload_path))
die('Sorry, script cannot upload your image for some reason.<br />Please contact the admin.');

// SQL check
$get = mysql_query(&q uot;SELECT `username` FROM `images` WHERE `username` = '".$_SES SION['username ']."'& quot;
if(!$get) die(mysql_error ());
$get2 = mysql_fetch_obj ect($get);

if(!$get2) {
$insert = mysql_query(&q uot;INSERT INTO `images` (username) VALUES ('".$_SE SSION['usernam e']."') ";
if(!$insert) die(mysql_error ());
}

// Get max number of images the user has uoaded
$m = mysql_query(&q uot;SELECT max(user_images ) as `total_images` FROM `images` WHERE `username` = '".$_SES SION['username ']."'& quot;
if(!$m) die('An Error Occurred.');
$result = mysql_fetch_obj ect($m);
if($result-> total_images <= 0) {
$image_number = 1;
} else {
$image_number = $result->tot al_images + 1;
} //end if

// Rename file
$new_filename = strtolower($_SE SSION['usernam e']) . $image_number;

// Upload the file
if(move_uploade d_file($_FILES[ 'image']['tm p_name'],$uplo ad_path .$new_filename. $ext)) {

$sql = mysql_query(&q uot;UPDATE `images` SET `user_images` = '".$new_ filename.$ext. "' WHERE `username` = '".$_SES SION['username ']."' ";
echo 'Your image uploaded successfully!' ;
} else {
echo 'There was an error during the file upload. Please try again.';
}

} else {
?>
<form enctype=" multipart/form- data" action="& lt;? $_SERVER['PHP_ SELF']; ?>" method="p ost" name="upl oadImage" />
<input type="hid den" MAX_FILE_SIZE = "100000& quot; />
<input type="fil e" name="ima ge" size="35 " />
<input type="sub mit" name="sub mit" value="Up load Image"> ;

<?php } ?>