> I would like to know if one can save pictures, or movies in a mysql or
> oracle database. If yes, is there any size limit for the file to be
> saved? What's the command used?
You will have to utilize MySQL's BLOB type to store binary data such as
pictures and movies. Beware of the performance hit storing such binary data
in a database -- it's usually better to store the location of the file in
the database (from a performance standpoint).
Field: image
Type: BLOB
<?
$link = mysql_connect( "localhost", "username", "password" );
mysql_select_db( "images", $link );
$fp = fopen( "myImage.jpg", "r" );
$bvar = fread( $fp, filesize( "myImage.jpg" );
fclose( $fp )
$bvar = addslashes( $bvar );
mysql_query( "INSERT INTO gfx (image) values ('$bvar')", $link );
mysql_close( $link );
?>
As for file size limitations:
BLOB = 64 KB max.
MEDIUMBLOB = 16 MB max.
LONGBLOB = 4 GB max.
Regards,
Avinesh
================================
Avinesh Bangar, MS, BCIS, SCSA, CCA, A+
Lead Programmer & Network Administrator
Stratabase Inc.
E-mail: [EMAIL PROTECTED]
Web: http://www.stratabase.com
================================
_______________________________________________
ilugd mailing list
[EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
