Re: Very Large MySQL Query String

If I use the link to the file, i.e. file//C:\filedir\file.pdf or .txt or whatever how do I insert/update/delete the file since MySQL is holding only the link? BTW David, what are the properties of the field you are inserting to? Could that be the problem? -Kirk "Julio Nobrega Trabalhando" <inerte@hotmail.com> wrote in message news:20020506134353.56093.qmail@pb1.pair.com... > Instead of uploading to Mysql, why don't you store the file at a directory > and on Mysql only the path to it? > > Retrieving files from the hard drive is much faster than doing the same on > Mysql, and also access to manipulation (insert, update, delete, etc...) > > -- > > Julio Nobrega. > > Um dia eu chego lá: > http://sourceforge.net/projects/toca > > Ajudei? Salvei? Que tal um presentinho? > > http://www.submarino.com.br/wishlistclient.asp?wlid=664176742884 > > > "David Bouw" <maillist@mubo.nl> wrote in message > news:63458.213.73.175.215.1020687730.squirrel@login.mubo.nl... > > I can't seem to figure out the following. > > > > I use the http upload functions a lot, works great!!.. > > For some months now I have been using a small PHP program > > which I use to upload PDF files of scanned documents and > > insert them into a Mysql table.. > > > > Normally these files are small (<250 kb), but I now have a > > PDF of 1 MB... When uploading files I run the > > function: chunk_split(base64_encode($binaryfile)); > > to encode it, this to transform the binary file to text.. (Works great!!!) > > > > When the query was called to insert the data, nothing happens, > > also no error from mysql... Only think I can think of is that the mysql > > query string is to long.. ?? (The data when encoded is about 1.3 MB of > > text).. > > > > This is the source code.. > > > > if (!($userfile_size == 0)) > > {$fd = fopen ($userfile, "r"); > > $contents = fread ($fd, filesize ($userfile)); > > fclose ($fd); > > unlink ($userfile); > > echo "Eerste RAW: ".strlen($contents); > > $encodes_data = chunk_split(base64_encode($contents)); > > $userfile_name = str_replace(" ", "", "$userfile_name"); > > echo strlen($encodes_data)." - Displays text size <BR>"; //Works > right! > > mysql ($databasename_boekhoud, "insert mubo_boekhoud_images (data, > > originalname, groep, type) > > values '$encodes_data', '$userfile_name', '$groep', > > '$userfile_type')"); > // > > mysql_error(); //No error given..? > > } > > > > Any suggestions are very much appreciated... > > > > With kind regards, > > David Bouw > > > > > >