Help Please :)

AlienOne

I know how to put a image/blob from a form into the database but how in hell do i do
when i want to put a image file from the server into a database 😕

Please post an example :rolleyes:

TobyRT

I can't give you an example, but I can give you a theory.

Don't.

Leave the image on the server and store a link to it in the database. Use a sensible naming system for your files, or if other users are uploading the files just make sure they put the correct name in. Then when you run your SQL query in the web page you can just echo the image name eg:

$query = "SELECT * FROM imagelist WHERE id = '$id'";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result)){
echo '<img src="www.myserver.com/uploads/'.$row['myimagename'].'">';

If you keep all your images in one folder, you can then let the db do the hard work of finding them.

mrhappiness

if you know what you want and what you're doing: read the file into $the_content, applay mysql_real_escape_string to $the_content and insert $the_content into the database

AlienOne

Yes i know what i am donig i just dont know how to do it 🙂

if you know what you want and what you're doing: read the file into $the_content, applay mysql_real_escape_string to $the_content and insert $the_content into the database

can anyone do more explaning exaple ? and i am new to more advanced php.

how do i get a file (image.jpg) from a folder on the server and and send it into mysql (binary)
how do i get the data "data/size/type" into variabels as i do when i post a file by form ???

Cheers, Peter

AlienOne

Ha i did know what i was doing 🙂
Got it to work 🙂

one thig i dont get is when i extrakt the filetype i only get thiss "file" how do i get "image/jpeg" or i have to do that my selfe by looking at the extetion ".jpg" ??

Cherrs, Peter

AlienOne

This going to be a funny post

well I found the solution mime_content_type(); 🙂 was the answer he he
He who seek shall find.

😃 😃