Storing Binary Data in MySQL

Account Login

Latest Articles

The basic usage of PHPTAL, a XML/XHTML template library for PHP

by awuehr on 11-10-2008 in Tips & Tricks

Vulnerable methods and the areas they are commonly trusted in.

by Village Idiot on 11-04-2008 in Classes & Objects

Simple way to protect a form from bot

by codefreek on 10-23-2008 in Basic

The Basics On: How Session Stealing Works

by wiifanatic on 09-12-2008 in Security & Permissions

How to keep your forms from double posting data

by drewbee on 07-03-2008 in Tips & Tricks

IRC Channel

Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.

Associates

TalkPHP » Storing Binary Data in MySQL

LinkBack

Thread Tools

Search this Thread

Display Modes

08-27-2009, 09:17 AM	#1 (permalink)
TheOnly92 The Contributor Join Date: Mar 2009 Posts: 49 Thanks: 0	Storing Binary Data in MySQL I have been trying to storing binary datas like images into the MySQL database. The column type is set to LONGBLOB, but I'm unable to successfully store the file. It seems when I execute the query, it will somehow go corrupted. I have tried using mysql_real_escape_string, addslashes to escape and tried bin2hex to store but all failed. Any suggestion?

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Injection and mysql_real_escape_string	Durux	General	61	01-29-2013 12:20 PM
Storing Session data in $_COOKIE as well	shownomercy	General	8	08-21-2008 02:00 PM
want to fetch data in excel sheet from my mysql database	sharma.9.pooja	Absolute Beginners	2	06-24-2008 05:04 AM
what kind of data can go into a mysql database?	sarmenhb	General	27	03-04-2008 10:51 AM
Log User Data with PHP & MySQL	mortisimus	Absolute Beginners	6	09-30-2007 05:52 PM

All times are GMT. The time now is 01:21 PM.