atimmohd
10-30-2002, 06:24 AM
hai...
can i store an image inside mysql database?
if can, please show me..
tanks
can i store an image inside mysql database?
if can, please show me..
tanks
|
||||
save image in mysql databaseatimmohd 10-30-2002, 06:24 AM hai... can i store an image inside mysql database? if can, please show me.. tanks Hazhir 12-16-2007, 05:19 AM Take look : sub addNews { my $self = shift; my $file = param('new_pic'); #this is a Image File undef $file_cont; binmode $file; binmode $file_cont; while (<$file>){ $file_cont .= $_; } my $sql = "INSERT INTO sys_news SET Image= ". $self->{SQL}->quote($file_cont).", CreateDate=NOW()"; $self->{SQL}->do($sql); # this means $dbh->do($sql); :D } StupidRalph 12-16-2007, 05:35 AM You can save a picture inside a DB but as several threads here suggest its usually better to save the PATH to the image file instead. Try using the search function to find some of those old threads. nysmenu 07-28-2009, 02:42 PM how do you save the PATH? I've created a field for images in my form but, I can't cut and paste the file name to include. Any suggestions? Thanks Wizzard of Jazz 12-21-2010, 08:57 AM Use input field of type file. The file is sent to the server as $_FILES. var dump this and you'll be a long way. |
| |||
EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum