How to upload pictures in Mysql?

[shahzad11]

hi all please help me,

i wanna make a php script where people will upload there pictures and search afterwards

please tell me how to compile three funcions


1. image upload to mysql
2. auto thumbnail to mysql
3. search query "or" logic based


thanks in advance to all who help me

 

[Peter]

have you actually tried making a start or are you hoping someone else will make the script for you.

If you truly wish to write such a script then look at the $_FILES array as well as GD functions in PHP (provided the server you are on is running GD) and lastly look at storing binary data in the database (although ideally you should have them on the file system instead of within a database, simply store the names in the database).

If it is a case of you wanting someone else to code it for you, you will be better posting in the 'Web Development Wanted' section.

 

[shahzad11]

thanks brother i am starting it myself

thanks again

 

[wikes82]

you can store binary using blob/longblob in Mysql, but very... very ... not recommended...

usually you just need to store the path to image, and save the image as file in the server...

hint: use $_FILES and move_uploaded_file ()