[PHP] MySQL and images
Assuming that I have to for some unknown reason, are there any articles on storing images in the database and retrieving them? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL and images
In order to speed-up queries, it is suggested that you DO NOT store images in the database. Rather, store the images in files and store file names in the database. - Original Message - From: John Meyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:32 PM Subject: [PHP] MySQL and images Assuming that I have to for some unknown reason, are there any articles on storing images in the database and retrieving them? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL and images
Know that, believe that, been preaching that, but I just want to know just in case. Actually found the article. -Original Message- From: Rick Emery [mailto:remery;emeryloftus.com] Sent: Tuesday, October 29, 2002 8:46 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL and images In order to speed-up queries, it is suggested that you DO NOT store images in the database. Rather, store the images in files and store file names in the database. - Original Message - From: John Meyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:32 PM Subject: [PHP] MySQL and images Assuming that I have to for some unknown reason, are there any articles on storing images in the database and retrieving them? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL and images
There are times, especially in highly dynamic situations, where backing up and restoring of images and metadata from a database or for security reasons, where storing the images within a database makes real sense. Separating the physical storage areas for the two types of data (metadata images) and keeping the image data from being buffered into the database server's memory space can make storage within the database almost as efficient as file storage. Mark C. Mark C. -Original Message- From: Rick Emery [mailto:remery;emeryloftus.com] In order to speed-up queries, it is suggested that you DO NOT store images in the database. Rather, store the images in files and store file names in the database. - Original Message - From: John Meyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:32 PM Subject: [PHP] MySQL and images Assuming that I have to for some unknown reason, are there any articles on storing images in the database and retrieving them? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Mysql and Images
His list, I have some images stores in a mysql database and now i need to recover them to put in a html. My question is there's a way to do this in the same page, I mean, withou the need to buil another php page that process th image? Something like a function that output the image to the img src= in the html. Thank's in advance Rodrigo Peres -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Mysql and Images
If I understand you right, then what you want is just impossible. You have to give a source as filepath. You can't put the binary picture data into the same output. What you could is to have a file which calls itself with params telling it to output now the image instead of the html e.g. example.php which produces without given parameters html like HTMLIMG SRC=example.php?showimage=true/HTML You can then check in the example.php file if $showimage is set. if it is set then you call a function to send correct header and binary data and die afterwards (better: exit ;-) But due hold it more simple I would hardly suggest you to have image-output functions in a separate file. You can still use that file for all images in your database If I misunderstood you and you just want a sample code for outputting picture-data then look at this: ?php #make sure that above this line nothing is printed to the browser require(your_mysql_access_routines.php); header(content-type: image/jpg); #replace jpg with gif or png or whatever you want $result = mysql_query(SELECT imageBinaryField FROM imagesTable WHERE id='$id'); #you can give $id as parameter to the file $row = mysql_fetch_array($result); echo $row['imageBinaryField']; #don't print anything below this to the browser ? I hope I could help you Stefan Rusterholz, [EMAIL PROTECTED] -- interaktion gmbh Stefan Rusterholz Zürichbergstrasse 17 8032 Zürich -- T. +41 1 253 19 55 F. +41 1 253 19 56 W3 www.interaktion.ch -- - Original Message - From: Rodrigo Peres [EMAIL PROTECTED] To: PHP [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 3:32 PM Subject: [PHP] Mysql and Images His list, I have some images stores in a mysql database and now i need to recover them to put in a html. My question is there's a way to do this in the same page, I mean, withou the need to buil another php page that process th image? Something like a function that output the image to the img src= in the html. Thank's in advance Rodrigo Peres -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] help with php mysql and images...
Don't know if this is the place to ask this, but I'll find out soon. I'm trying to create a database in mysql that will hold information About users, it will hold the path to a picture, and it will resize Images on a page... sorry that's a really blunt description. A user will goto this certain page... they bring up the page and the page it self, coded in php, will pull out of the database, the names of everyone that is registered to this certain page. It will list it all in alphabetical order. For anyone interested... the page I'm working on is here... http://www.hypoparathyroidism.com/gallery.asp I am having trouble figuring out how to do it, I'm new to mysql And php actually... I just started learning it about a month ago But I've done some pretty impressive stuff for php. I guess I just need some ideas on how to go about doing this project. Going to that page will help you figure out what I have to do. You see the guy that programmed that page before, did it all In asp. And I don't know anything about asp, and I was told Not to learn anything about asp because it is dumb (no offense To anyone intended) Any help appreciated... mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] help with php mysql and images...
A couple of things: 1. ASP is not dumb. It was just written by Microsoft. Seriously, though I'd learn both, it would make you much more marketable. 2. First off, create the database. Then ask yourself what are the steps that you have to go through. What your probably looking at right now is selecting the information off of the database and reporting it. I'd _definitely_ think about sitting down with the MySQL manual and the PHP manual, both of which are availible free. Also, look for a good MySQL/PHP book (my favorite is MySQL/PHP Database Applications, by Jay Greenspan and Brad Bulger). You have some work ahead of you, but not a lot. At 10:09 AM 8/22/01 -0700, you wrote: Don't know if this is the place to ask this, but I'll find out soon. I'm trying to create a database in mysql that will hold information About users, it will hold the path to a picture, and it will resize Images on a page... sorry that's a really blunt description. A user will goto this certain page... they bring up the page and the page it self, coded in php, will pull out of the database, the names of everyone that is registered to this certain page. It will list it all in alphabetical order. For anyone interested... the page I'm working on is here... http://www.hypoparathyroidism.com/gallery.asp I am having trouble figuring out how to do it, I'm new to mysql And php actually... I just started learning it about a month ago But I've done some pretty impressive stuff for php. I guess I just need some ideas on how to go about doing this project. Going to that page will help you figure out what I have to do. You see the guy that programmed that page before, did it all In asp. And I don't know anything about asp, and I was told Not to learn anything about asp because it is dumb (no offense To anyone intended) Any help appreciated... mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
