Re: [PHP-DB] Insert an image in a Mysql table
I have created a MySQL table with a blob field and I dont know how to insert an image to it. Help me please because I am going crazy. I store in the blob not an image but the string: img[]=path/file.jpgdescription=var[]= etc and so on for any number of images and corresponding details. Then retrive the string as $images with a query as usual and use: parse_str($images[0]); /* GIVES ARRAY $img AND $description etc */ Regards, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Insert an image in a Mysql table
On Mar 21, 2004, at 8:44 AM, Stuart Gilbert wrote: Filip de Waard wrote: On Mar 20, 2004, at 3:11 PM, charalambos nicolaou wrote: Hi, I have created a MySQL table with a blob field and I dont know how to insert an image to it. Help me please because I am going crazy. Use your filesystem instead, databases might be capable of storing binary data but they are not perfect. Use your filesystem and store the filename in your database. And what if he has a perfectly good reason to store the data in the db? No offense but you didn't really help him with his query at all. I can't think of a scenario where storing binary data in a database is the best solution, but I'm sure there are situations where this is an interesting option (since there has to be a reason databases include this option). I haven't found one yet and I'm pretty sure that Charalambos should use the filesystem instead, since that is the correct answer for 99.999% of all cases. And yeah, search google! Using Google I found the link that solved his problem in 2 seconds. I told him to use Google next time and gave him the link to his answer. He thanked me for it, for godsake! I don't have a clue about what reason you have to kick somebody in the groan who is just helping, while you didn't help Charalambos a bit. Regards, Filip de Waard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Insert an image in a Mysql table
On Mar 21, 2004, at 9:19 PM, Stuart Gilbert wrote: Filip de Waard wrote: On Mar 21, 2004, at 8:44 AM, Stuart Gilbert wrote: Filip de Waard wrote: On Mar 20, 2004, at 3:11 PM, charalambos nicolaou wrote: Hi, I have created a MySQL table with a blob field and I dont know how to insert an image to it. Help me please because I am going crazy. Use your filesystem instead, databases might be capable of storing binary data but they are not perfect. Use your filesystem and store the filename in your database. And what if he has a perfectly good reason to store the data in the db? No offense but you didn't really help him with his query at all. I can't think of a scenario where storing binary data in a database is the best solution, but I'm sure there are situations where this is an interesting option (since there has to be a reason databases include this option). I haven't found one yet and I'm pretty sure that Charalambos should use the filesystem instead, since that is the correct answer for 99.999% of all cases. And yeah, search google! Using Google I found the link that solved his problem in 2 seconds. I told him to use Google next time and gave him the link to his answer. He thanked me for it, for godsake! I don't have a clue about what reason you have to kick somebody in the groan who is just helping, while you didn't help Charalambos a bit. Regards, Filip de Waard I was telling him, and people in general, to search Google, not you :) I'm sure you know what to do very well. Thank you :-) Sorry if it felt like a personal attack of some sort, I was just saying that if he asks how to do something like storing an imagine a db then the chances are that he wants to do that, and not something else. Shouldn't matter if it's not the ebst way to do something. IMHO it's always the best thing to give somebody what he's asking for, even if it's not the best way to do something. However, nobody will learn anything when you just tell them how they can solve their problem the wrong way, even when they ask for it. Anyway, sorry. No problem. I misinterpreted what you were saying as a flame against me. Cheers, Filip de Waard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Insert an image in a Mysql table
Hi, I have created a MySQL table with a blob field and I dont know how to insert an image to it. Help me please because I am going crazy. Thank you, in advance _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Insert an image in a Mysql table
On Mar 20, 2004, at 3:11 PM, charalambos nicolaou wrote: Hi, I have created a MySQL table with a blob field and I dont know how to insert an image to it. Help me please because I am going crazy. Use your filesystem instead, databases might be capable of storing binary data but they are not perfect. Use your filesystem and store the filename in your database. If you would've used google, you would've found this: http://www.phpbuilder.com/columns/florian19991014.php3 Regards, Filip de Waard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
