how to upload pictures in mysql?

shahzad11 · 10-25-2007, 03:02 PM

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 · 10-25-2007, 03:33 PM

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 · 10-27-2007, 02:16 AM

thanks brother i am starting it myself

thanks again

wikes82 · 11-16-2007, 04:18 PM

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 ()

10-25-2007, 03:02 PM	THREAD STARTER #1 (permalink)
shahzad11 Account Closed Join Date: Nov 2006 Location: Lahore Posts: 297	how to upload pictures in mysql? 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

10-25-2007, 03:33 PM	#2 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	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. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-16-2007, 04:18 PM	#4 (permalink)
wikes82 NamePros Regular Join Date: Sep 2006 Location: K-R.NET Posts: 902	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 () __________________ LogicBoxes/Directi/Resell.biz Domain Catcher for Windows,Linux,Mac OSX

10-27-2007, 02:16 AM	THREAD STARTER #3 (permalink)
shahzad11 Account Closed Join Date: Nov 2006 Location: Lahore Posts: 297	thanks brother i am starting it myself thanks again

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)