Re: BLOB Support in DB

This looks good, but, you appear to be using the mysql API, not PEAR DB. I take it you just need to prepare the file path: $contents =addslashes(fread (fopen($filename, "rb"), $filesize));//rb is used in WIN NT and do a standard insert statement. Is there any differnece on Linux with (fread (fopen($filename, "rb") ? david On Wed, 2002-07-10 at 10:20, Michelle Manning wrote: > David, > Hopefully the following code will help. > I found that working on windows always makes something difficult. "rb" is important > because it then knows to read it as a binary file. > I included quite a bit of code to help you get a feeling for what I did... > Good Luck.... > Michelle > > //get the contents of the file, adding slashes to escape characters that will cause > a problem. > $contents =addslashes(fread (fopen($filename, "rb"), $filesize));//rb is > used in WIN NT > //get the file creation time > $fileCreateTime = filectime( $filename); > //configure file creation time to conform to database field specs > $date = date("Y-m-d H:i:s", $fileCreateTime); > //build insert string for database. > $insertString = "INSERT INTO tblwavfile (ID, WavFile, WavName, CreationDate, > WavSize, Type) VALUES ( '$ID', '$contents', '$realname', > '$date', '$filesize', '$filetype' )"; > > MYSQL_CONNECT(DB, USER, PASSWORD); > mysql_select_db("tranDB"); > $result=MYSQL_QUERY($insertString); > $id= mysql_insert_id(); > if ($id > 0) { > printf ("Database id for your file: %s<br>\n", $id); > } > else { > printf ("Your file was not successfully inserted!\n"); > } > //here , must delete file created with upload... > $unlinksuccess = unlink($filename); > if ($unlinksuccess) { > //echo "The file($filename) was deleted! <hr>"; > }else { > echo "The file ($filename) was not deleted!<hr>"; > } > MYSQL_CLOSE(); > } > } > ----- Original Message ----- > From: David Dahl > To: PEAR > Sent: Wednesday, July 10, 2002 11:07 AM > Subject: Re: [PEAR] BLOB Support in DB > > > My common.php: ($Id: common.php,v 1.3 2002/05/09 12:29:53 ssb Exp $) > has the same prepare() method as your version... > > I am not to confident in changing any PEAR files, as it might get me in > trouble later if I upgrade or something. > > how should I form my SQL to insert a BLOB? > something like this? > > insert into people (name, photo) values ('John', '/tmp/userfile') > > regards, > > David Dahl > > > > On Wed, 2002-07-10 at 09:51, Michelle Manning wrote: > > Hi David, > > We had a lot of problems using pear DB for Blobs and found a couple of things. > > 1. in common.php in DB the split is used, but this actually can cause some problems. > > so we used preg_split and had to change the & to another character as I was testing > > using bit comparison. With that change...it seems to work... > > ($Id: common.php,v 1.59.2.3 2001/11/13 01:26:42 ssb Exp $) This is the version that I am > > talking about. > > > > Let me know if there is anything else that would help with BLOBs - we have major work > > with wavs and images... > > > > In DB\common.php > > function prepare($query) > > { > > $tokens = preg_split("/[\^\?\!]/", $query); //changed this line... > > $token = 0; > > $types = array(); > > > > for ($i = 0; $i < strlen($query); $i++) { > > switch ($query[$i]) { > > case '?': > > $types[$token++] = DB_PARAM_SCALAR; > > break; > > case '^': > > $types[$token++] = DB_PARAM_OPAQUE; > > break; > > case '!': > > $types[$token++] = DB_PARAM_MISC; > > break; > > } > > } > > > > Michelle > > ----- Original Message ----- > > From: David Dahl > > To: PEAR > > Sent: Wednesday, July 10, 2002 10:32 AM > > Subject: [PEAR] BLOB Support in DB > > > > > > Hi: > > > > I was just wondering how things are going with BLOB support in DB? > > > > Thanks > > > > David Dahl > > > > > > -- > > PEAR General Mailing List (http://pear.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >