Mysql Php Image Help Please!!!

Reply

Join Date: Mar 2006
Posts: 52
Reputation: puddin is an unknown quantity at this point 
Solved Threads: 0
puddin puddin is offline Offline
Junior Poster in Training

Mysql Php Image Help Please!!!

 
0
  #1
May 23rd, 2006
Hello and a BIG Thank-You!!! To you who have helped me...

This I think will be my last image question. Okay the user uploaded a picture , it went to the (Photos directory) (Name and Type Show) Great!... Next to the (Mysql Database under aphoto_filename) Again with (Name and Type Showing) Excellent!, It is in the users Mysql Database listing with all their other information. So Perfect! Last it shows up Beautiful!

Brick Wall I'm exhausted even missed school trying to solve it, I cannot do that again.
PROBLEM TO BE SOLVED:

When the user leaves the photo view page, I cannot get their photo to stay reappear. It remains in the photos directory and in the mysql database... When I try calling it... It only displays the image name and type I need it to open.

Please See My Code Below and Thank A Zillion!


<?
include'db.php';

$sql_check = mysql_query("SELECT aphoto_filename FROM gallery_photos WHERE email_address='".($email_address)."'AND password='".($password)."'" );

$aphoto_filename = mysql_fetch_array($sql_check,
MYSQL_ASSOC); //MYSQL_ASSOC;
$sql_check_num = mysql_num_rows($sql_check);
if($sql_check_num == 0){

if ($type == "image/pjpeg") {
imagejpeg($img);
} else if ($type == "image/x-png") {
imagepng($img);
} else if ($type == "image/gif") {
imagegif($img);
}
$handle = fopen($aphoto_filename['tmp_name'], $images_dir."/$filename". "wb");

echo ("");
} else {
echo $aphoto_filename['aphoto_filename'];
}

?>

P.S I actually have... aphoto, bphoto, cphoto and dphoto ... When anyone wants to see the users photo I need the photos to open. Thanks again soooooo much, puddin
Reply With Quote Quick reply to this message  
Join Date: May 2006
Posts: 7
Reputation: VioletSite is an unknown quantity at this point 
Solved Threads: 0
VioletSite's Avatar
VioletSite VioletSite is offline Offline
Newbie Poster

Re: Mysql Php Image Help Please!!!

 
0
  #2
May 27th, 2006
I'm not sure Pudd... but maybe your $sql_check_num is NOT equal to 0 anymore after the first page load; it would be 1, wouldn't it?

I hope this helps. Good luck to you!
"Those who know, don't need to be told. Those who don't; seldom listen." -- Ashida Kim

Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC