note 26946 deleted from function.base64-encode by didou

From: Date: Thu, 29 May 2003 20:56:23 +0000
Subject: note 26946 deleted from function.base64-encode by didou
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-49306@lists.php.net to get a copy of this message
Note Submitter: webmaster@mainbotics.com ---- In response to guy at bhaktiandvedanta dot com: You can simply save the images in a blob field (Binary Large OBject) in the data base just by using mysql_escape_string(), which escapes NULL, CR, LF, \x1A, ... and other special-meaning characters, so you can directly insert the image into the sql query without any problem and without any kind of encoding (just the slashes). That way, you'll save space at the data base and when you get the image, you can directly dump it to the browser without making any kind of decoding. The script will so become faster and more efficient, and MySQL is already aware about the field contains binary data, not text data, to threat it in a convenient way.

« previous php.notes (#49306) next »