[coatsey]

I need someassistance or a guidance in some php/mysql coding if there is any body out there.

I am currently designing a database driven website where users log in and out etc. Once logged in there is a form where users can fill out and upload a picture of their car and submit it into a mysql database. First of all how would i go about inserting an image and text into a table into a mysql database. Also once the user has done this i would like them to view what they have just done. How would i go about that?

I know i can pull off a query on text but how can i doit so it can display their picture as well as a description underneath?

And one last thing i am using a dropdown box for people to choose where they live so later i can insert a search query to search for cars in that county. So i am trying to search for a list of cars whichwill be pulled of the mysql database and listed for users to then choose.

I might be asking for too much i know, i have taken this job on as a favour to afriendwho is car mad and we/i thought to give it a go.

Help...

Thanks

[jpp]

My choice would be to store the images in a directory, and not in your db. Binary data in your db can slow down the performance. Don't know if u use phpMyAdmin or something like that, it gets real slow when it tries to display binarydata in ascii.
Before storing the image you could rename it to the primary key of your table ($id?), and then in your page all you have to do is:

PHP Code:

echo "<img src=\"imagedirectory/$id.jpg\">"; 

[SEATi]

Originally Posted by coatsey

I need someassistance or a guidance in some php/mysql coding if there is any body out there.

I am currently designing a database driven website where users log in and out etc. Once logged in there is a form where users can fill out and upload a picture of their car and submit it into a mysql database. First of all how would i go about inserting an image and text into a table into a mysql database. Also once the user has done this i would like them to view what they have just done. How would i go about that?



Thanks

Just use the BLOB field type, read the temp file generated by the upload, add slashes to it (otherwise it could contain "dangerous" characters) and insert it into the blob field.

To display the image create a php file that sends a Content type header with image/jpeg or gif or whatever you are going to use and "echo" the results.

The other solution (storing them in a directory) is fine, but you would need to make that directory writeable by the webserver, and that can be kinda risky. If you have a nice box to deploy a huge database then go on and use the blob field.

[coatsey]

Originally Posted by jpp

My choice would be to store the images in a directory, and not in your db. Binary data in your db can slow down the performance. Don't know if u use phpMyAdmin or something like that, it gets real slow when it tries to display binarydata in ascii.
Before storing the image you could rename it to the primary key of your table ($id?), and then in your page all you have to do is:

PHP Code:

echo "<img src=\"imagedirectory/$id.jpg\">"; 

I have created a registration form for users to insert details of themselves and include a picture of themselve to upload to the server. I have now decided to send my images to a destination file on the server to keep databse activity optimum.

I am stuck though. How can i get my users to register their details aswell as including an image to store in the database. Is this where the id value comes into use. How ould i go about that and also when it comes to retriving the data how would i retrieve the data from the databse as well as the picture and letting all users view this on a web page.

Help.....