need help in stroing and retreving images from database
Sir , Iam working on Mysql5.0 version. Can I store .jpeg or .png or .gif etc imagefiles in database. If so where can I get the tutorials or sample code to insert and retrive the images from mysql database. Any help is welcome. Thanking you , Sreedhar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help in stroing and retreving images from database
Hi, all binary docs can be inserted in blob columns. see this link for a php insert method :http://www.phpcs.com/code.aspx?ID=30945 this is mysql doc : http://dev.mysql.com/doc/mysql/en/blob.html Mathias Selon madderla sreedhar [EMAIL PROTECTED]: Sir , Iam working on Mysql5.0 version. Can I store .jpeg or .png or .gif etc imagefiles in database. If so where can I get the tutorials or sample code to insert and retrive the images from mysql database. Any help is welcome. Thanking you , Sreedhar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: images on database
The most common problem in such cases is that the webserver doesn't know what MIME Type the file is and so it doesn't know how to send it. If you are using PHP to upload and later show that image on the web, i could give you the code for the scripts and the structure of the table containg the binary data. Luiz Rafael Culik Guimaraes said: Dear Friends I has images saved on an mysql table as an blob field, but i could not recreate the image as file by selecting an specific record of this field any ideia Regards Luiz -- If you don't like the news, go out and make some on your own. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: images on database
Hi The most common problem in such cases is that the webserver doesn't know what MIME Type the file is and so it doesn't know how to send it. If you are using PHP to upload and later show that image on the web, i could give you the code for the scripts and the structure of the table containg the binary data. yes, i´m using php 4.1 Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: images on database
Checkout: http://php.dreamwerx.net/forums/viewtopic.php?t=6 It's got streaming code.. What I do is if the type is unknown I always send application/octet-stream and the browser usually identifies it.. Or check the file extension for the file in the database, and apply content type based on that.. On Sun, 17 Aug 2003, [iso-8859-1] ÃåùñãéÜäçò Ãéþñãïò wrote: The most common problem in such cases is that the webserver doesn't know what MIME Type the file is and so it doesn't know how to send it. If you are using PHP to upload and later show that image on the web, i could give you the code for the scripts and the structure of the table containg the binary data. Luiz Rafael Culik Guimaraes said: Dear Friends I has images saved on an mysql table as an blob field, but i could not recreate the image as file by selecting an specific record of this field any ideia Regards Luiz -- If you don't like the news, go out and make some on your own. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
images on database
Dear Friends I has images saved on an mysql table as an blob field, but i could not recreate the image as file by selecting an specific record of this field any ideia Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: Storeing images in Database
Dobrý den, sexta-feira, 24 de janeiro de 2003, 22:41:47, napsal jste: WRM Since you obviously aren't going to search the images themselves there is WRM no reason to put them into a database. File systems are designed for WRM this. I might suggest using an Id field and then split them into WRM subdirectories based on the 1st or last digit of the ID (0..9). This WRM would reduce the number of files in a given directory which can be a WRM problem with VERY large numbers of files. You can also put them on a WRM totally differnet drive from the database data to increase performance. WRM The cost is bit of setup (have to create the directories) and WRM programming. This should allow the database rows to be uniform in size WRM which should help performance. OK , but my database is only for images... and i want integrate my client application with the Internet page around the world ... What is more easy, one select and get image or a connection to download the image ? The point is this. in my case... the images in sql database is more comfortable , but is it secure ? you loose data using BLOB fields ? please send me a reply to help me in my decision :) The suggestion bout ID in database and store an a file system, it is very interesting , but if i loose the id´s ? atomically i loose the images correct ? Tanks in advance ! sql,query,tnks - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storeing images in Database
Hello community !!! The software house on i'm work want to store images ( TIF FILES +/- 100kb compressed with gzip ) on database... using InnoDB database... ( files or raw devices ) The discussion is : - The innodb ( or myisam ) is sufficient robust to allow store 10.000.000 images ( with 100kb ) without problems ( corrupt or fail ) ? - If is sufficient robust , the speed to join and get images from database is not slow ( slow for me is 2 seconds )? - The best solution is store images in files ( ex : c:\images\img00.tif) or database ? The responses and experience of all community is very welcome ! special for Heikki and Monty , what do you think ? store in files or in database ? Please it is very important for my software house !!! my preference is into database... but i'm afraid the volume is big... MySQL version: 4.0.9 Table Type : InnoDB Operation System : Windows ( 98/ME/NT ) and Linux ( 2.4 ) Disk Types : IDE and SCSI ( depend of volume ) sql,query,urgent,hehe - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storeing images in Database
Hello community !!! The software house on i'm work want to store images ( TIF FILES +/- 100kb compressed with gzip ) on database... using InnoDB database... ( files or raw devices ) The discussion is : - The innodb ( or myisam ) is sufficient robust to allow store 10.000.000 images ( with 100kb ) without problems ( corrupt or fail ) ? - If is sufficient robust , the speed to join and get images from database is not slow ( slow for me is 2 seconds )? - The best solution is store images in files ( ex : c:\images\img00.tif) or database ? The responses and experience of all community is very welcome ! special for Heikki and Monty , what do you think ? store in files or in database ? Please it is very important for my software house !!! my preference is into database... but i'm afraid the volume is big... MySQL version: 4.0.9 Table Type : InnoDB Operation System : Windows ( 98/ME/NT ) and Linux ( 2.4 ) Disk Types : IDE and SCSI ( depend of volume ) sql,query,urgent,hehe Since you obviously aren't going to search the images themselves there is no reason to put them into a database. File systems are designed for this. I might suggest using an Id field and then split them into subdirectories based on the 1st or last digit of the ID (0..9). This would reduce the number of files in a given directory which can be a problem with VERY large numbers of files. You can also put them on a totally differnet drive from the database data to increase performance. The cost is bit of setup (have to create the directories) and programming. This should allow the database rows to be uniform in size which should help performance. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php