How to store images in MYsql database ??

Anon

Could anybody tell me how to store images in mysql database.. Plese gimme the code if you can..

Anon

hi,
It is always better to store imagename and imagepath in database rather than storing images in database

[deleted]

... and you can read why here:

http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=22

Anon

but u can if u want. sometimes its a good thing to store the imgage in db.

this works for me:

$pic = fread(fopen($pic,"r"), filesize($pic));
$pictype = $picture_type;
$picname = $picture_name;

$query = "insert into PICTURE values (NULL,'$pictype','$pic','$picname')";

if ( ! mysql_db_query($DB,$query,$sql) ) {
echo "error";
db_error($sql);
}

[deleted]

It's never a good thing.

Anon

Thanx a lot .. Now I am not going to store it into database..filesyatem is GOOD enough..

Anon

hi,

could you please tell me "what is the best way to find out Current Online User on my site ???

Regards
Tabish

[deleted]

The 'easiest' way is with a database, someone described a 'nice' method on here a few days ago.

But in my opinion it is still useless data.

saltwater

so, in my situation, users can upload images, but the nobody user under linux where apache is running under doesn't allow me to create files on te server

what should I do?

Anon

First off, create a user account apache, and have that run the apache server. Then, you can create a group named apache, and make root and apache members of that group. Then you can make a directory in the WedRoot (/var/www/html/ or whatever) have write permission for that group. Of course, you cannot write to just any directory anywhere on the filesystem, but you can set it up such that the web server can write to files in specific directories by setting the permissions.

I do this on a PHP page that take MySQL data and creates an image (a graph). It writes the image to a temporary writable directory, then references that image in HTML to display the new graph image.

saltwater

that's all good and well when you have access to your server... but I don't
so images in mysql are the only option I can think off...

[deleted]

Another option is to talk to your host and tell them what you want to do.
Storing lots of images in a database will slow that database down to a crawl, and other users will suffer from that.

saltwater

my host won't do it because of security reasons...

[deleted]

An understandable is somewhat simple reason.

It's perfectly safe providing it is done properly, and that's probably too much work for your host :-)

In that case, make sure your database has a seperate table for the 'blob' data. That way the table that contains the searchable data stays small for quick access to get lists of image titles etc, and you can do simple straightforward 'get one record' queries to the 'blob' table, keeping the serverload to a minimum.