Posted 14 June 2006 - 04:08 PM
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.
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.
Posted 14 June 2006 - 04:16 PM
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.
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
Posted 14 June 2006 - 05:39 PM
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.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users