Greetings,
In most cases you will find that the storage of pictures and mp3's for
instance are better left to the host fs rather than the dbs. Then you would
only store the link to such files. Some will argue that this slows down access
to the perticular file et cettera, blah blah blah...but generally most of us
are creating web based apps that end up creating url's to said data anyway.
Ok well that's my take on it.
cheers,
mikel
Barry Radloff wrote:
> A blob is a nice field to use I guess
>
> see these attachements from when I asked the same Q...
>
> Some of them may or maynot be helpful..
>
> regards
> Barry
>
> -----Original Message-----
> From: Danie Weideman [mailto:[EMAIL PROTECTED]]
> Sent: 23 February 2001 02:02
> To: [EMAIL PROTECTED]
> Subject: Saving pictures in MySql
>
> Hi everyone
>
> I am new to MySql and PHP
>
> I have downloaded and configured both
>
> I have just finished my first db and are on a high. I was quickly broad to
> ground when I tried to load a image via a form into the database. Could
> someone
> please help with:
>
> What field type must be defined for pictures.
> How to load and retreive pictures from a database using PHP
>
> Any thing more will be appreciated
>
> Kind Regards
> Danie Weideman
>
> ---------------------------------------------------------------------
> 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
>
> ------------------------------------------------------------------------
>
> Subject: RE: Binary data
> Date: Wed, 31 Jan 2001 10:30:34 +0200
> From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> > hi I am pretty new at this and would like to know how does one store a
> > binary blob to the mysql DB ie I would like to store a jpeg to the db
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.bitbybit.dk/mysqlfaq
>
> ------------------------------------------------------------------------
>
> Subject: RE: Binary data
> Date: Wed, 31 Jan 2001 19:28:24 +0200
> From: David Wilde <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
> <[EMAIL PROTECTED]>
>
> If your using PHP there is an article here on doing it with PHP3, it works
> on 4 as well. HTH
>
> http://www.phpbuilder.com/columns/florian19991014.php3
>
> Dave W.
>
> -----Original Message-----
> From: Barry Radloff [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 10:56 PM
> To: '[EMAIL PROTECTED]'
> Subject: Binary data
>
> hi I am pretty new at this and would like to know how does one store a
> binary blob to the mysql DB ie I would like to store a jpeg to the db
>
> Thanks
>
> Barry Radloff
> R&D
> Media24
>
> ---------------------------------------------------------------------
> 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
>
> ------------------------------------------------------------------------
>
> Subject: Re: Binary data
> Date: Thu, 1 Feb 2001 22:58:58 +0200
> From: Peter Szekszardi <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED]
>
> Hi Barry,
>
> I do not know what do you use for feeding your database, but in Perl you
> shoud use the DBI module, and insert the binary data through bindings.
>
> use DBI;
> use strict;
>
> ...
>
> my $dbh = DBI->connect("dbi:mysql:image_db", "user", "password") || die
> "$DBI::errstr\n"; # connect to the
> database
>
> ...
>
> my $sth = $dbh->prepare("INSERT jpeg_table SET size_x = $size_x, size_y =
> $size_y, image_data = ?;") || die "$DBI::errstr\n"; # prepare the insert
> statement, replacing the image data with a question mark
> $sth->bind_param(1, $image_data); # binding the binary
> data
> $sth->execute() || die "$DBI::errstr\n"; # executing the
> insert
>
> ...
>
> $dbh->disconnect(); # disconnect
>
> Regards,
>
> Peter Szekszardi
> PortoLogic Ltd.
> Portal building, design, net survey and more...
>
> On Wed, 31 Jan 2001, Barry Radloff wrote:
>
> >
> >
> > hi I am pretty new at this and would like to know how does one store a
> > binary blob to the mysql DB ie I would like to store a jpeg to the db
> >
> > Thanks
> >
> > Barry Radloff
> > R&D
> > Media24
> >
>
> ------------------------------------------------------------------------
>
> Subject: Re: binary data
> Date: Sun, 4 Feb 2001 08:26:57 +0200
> From: Teddy A Jasin <[EMAIL PROTECTED]>
> To: "Robert C. Paulsen Jr." <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> Hi okie heres a snippet of my php code:
> the code below takes a file uploaded from the web with $file as declared
> filename on
> the form.
>
> if ($file_size>0) { //check whether the file is not empty
> $data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the
> file and
> add neccessary quotes
> $SQL="Insert into Files (Filename,Filetype,Filesize,data) values
> ('$file_name','$file_type','$file_size','$data')"; //SQL commands to insert
> into table
> named 'FILES'
> $result = mysql_query ($SQL)
> or die ("ERROR Uploading File:".mysql_errno().":
> ".mysql_error()."<BR>$SQL");
> }
>
> okie hope that helps!
>
> Teddy
>
> "Robert C. Paulsen Jr." wrote:
>
> > On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote:
> > > I have the scripts in php to do this if u want.
> >
> > Yes, that would help! thanks.
> >
> > >
> > > "Robert C. Paulsen Jr." wrote:
> > >
> > > > How can I put binary data into a MySQL database?
> > > >
> > > > I assume the data type is blob, but I don't see how I can
> > > > use SQL syntax to insert anything but text data. I would
> > > > like to include various binary files (tar files, zip files,
> > > > image files, etc.).
> > > >
> >
> > --
> > ____________________________________________________________________
> > Robert Paulsen [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
>
> ---------------------------------------------------------------------
> 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
>
> ------------------------------------------------------------------------
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
