Jump to content


Photo

Viewing Images


  • Please log in to reply
2 replies to this topic

#1 garlicka

garlicka
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 June 2006 - 04:08 PM

Hello, I am very very new to all this and am building a website.

I have managed to Create a mySql Database, I have managed to upload information into the database and upload a file to the image directory.

for example
Table name is employees
User inputs --
Name goes to Name Field
Email goes to Email Field
Phone goes to Phone Field
Photo filename goes to Photo Field and the Image goes to my Upload Dir.

When I do a search I can enter the name and it displays all info in the Database, but I cant seem to put a code in to view the picture too.

Can anyone help my stupidity.

Thanks

#2 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 14 June 2006 - 04:16 PM

well in your script after it retrieves the info you just make an img tag.

let's say your script looks something like this:
$name = $_POST['name'];

$sql = "select * from employees where Name='$name'";
$result = mysql_query($sql);
$info = mysql_fetch_array($result);

echo "Name: " . $info['Name'] . "<br>";
echo "Email: " . $info['Email'] . "<br>";
echo "<img src = '" . $info['Photo'] ."' />";
this assumes that your photo holds the full name of the photo, like blah.jpg not just blah. and it also assumes that your photo is in the same directory as your script. if these things are not so, then you will have to alter your script to add on the extension and/or path to the img.
Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#3 garlicka

garlicka
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 June 2006 - 05:39 PM

Thanks for that, I have it working now.

But I do have a quick question , Do you know how to downsize the images or just show it in a Certain Area, When I open it up it uses the entire screen.

Many Thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users