[nurqeen]

hi..i'm doing a staff directory for my place..where i need to insert the staff informations like name, age, gender, phone no n others, i also would like to upload their image..the system also have a search function to search staff's information with just entering their name or their staff id.

at first i upload the image to the database, i'm using mysql n my code using php..it's work great..but then here's the problem..

when i'm doing my search function..i don't know how to call the image that i've already upload earlier..when i'm doing some finding on the net..i found out that i need to upload the image to the server (i'm using apache server) so that i can store the path to my upload image in my database MYSQL..

and just rite now, i've try to call the image by searching function, but the field for the image only display the path of the image not the image itself..the name,age,gender were display ok..

please,please some one give me the idea..do i have to include the downloading image when i'm doing the searching code or what..

hope some one out there understand my english n my problem..thanxxx yaa..

[han]

ho!
u need to read field that store image bc image in database as binary so u ought to read field binary.
first u need to read image as binary
good luck

[<?Wille?>]

store the path/pic name and show it with regular html
fetch the pic and show it like:

<img src="<? echo $thepic; ?>" />

[ashok]

Using the above said way u got the image

otherwise the path u have set to relative one (i e images/pic1.jpg this image is placed in http://yoursitename/images/pic1.jpg)

then the image display correctly

[FiRe]

PHP Code:

$UploadedPic = file_get_contents($upload);

mysql_query("SELECT picture FROM table WHERE picture LIKE '$UploadedPic'");