Binary Data + MySQL + PHP

Florian Dittmer

If you want to store binary data like images and html files directly in your MySQL database, this column is for you!

I will show how you can store the data via the HTML forms "File" feature in your database and how you can access and use this data in your webproject.

If you have read the article "PHP, MySQL and images" by William Samplonius here on phpbuilder.com, this might be interesting for you as William stores the binary data somewhere on your harddisk (using a shell command), instead of storing the image directly in the Sql-Database.

Overview:

• Create a new database on your SQL Server
• A sample php3 script you can use to store data in your database
• A sample php3 script with which you can access the stored data

Create a new database on your SQL Server

First of all, you have to create a new database on your SQL server in which your script will store the binary data.

For my example I use the following structure. To create this database, you have to do the following steps:

• login to the mysql monitor
• enter the command "create database binary_data;"
• enter the command "use binary_data;"
• copy and paste the following intructions (the table structure) to the monitor
• the database+table should be created

CREATE TABLE binary_data (
id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
description CHAR(50),
bin_data LONGBLOB,
filename CHAR(50),
filesize CHAR(50),
filetype CHAR(50)
);

Next Page

Comments:
IE 4.x on Windows not interpreting Data?	Zachery Bir	05/18/00 15:14
Invalid MySql resources	Chuck G	05/11/00 17:04
Displaying image with <img src	Miguel	05/11/00 00:29
Displaying image with <img src	Miguel	05/11/00 00:26
data types	Steven Holloway	05/10/00 21:12
data types	Steven Holloway	05/10/00 20:55
Won't upload file and store in table	Brian	05/05/00 09:15
RE: File upload problems - SOLVED	Marcel	05/04/00 02:28
RE: File upload problems	Marcel	05/03/00 03:17
File upload problems	Marcel	05/02/00 14:54
RE: Binary Data + MySQL + PHP	Rene Mischak	04/27/00 05:34
Binary Data + MySQL + PHP	Ravi Pandit	04/26/00 01:49
RE: Input file variable missing	Cass Surek	04/24/00 22:59
RE: performance considerations	Cass Surek	04/24/00 22:54
addslashes - the data isn´t being stored	Cass Surek	04/24/00 22:49
How can I generate a gif file using PHP?	emouse	04/23/00 18:11
performance considerations	Caspar von Seckendorff	04/22/00 11:00
RE: database connection	Richard	04/20/00 21:21
RE: ppgsql backup	Axel son of Jack	04/20/00 19:36
RE: ppgsql backup	Axel son of Jack	04/20/00 19:28
database connection	Shirley	04/19/00 08:30
RE: "getdata.php3?=2" doesn't work...	Baran Bingol	04/19/00 05:10
RE: POST not allow	Raymond	04/16/00 05:11
POST not allow	Raymond	04/16/00 05:04
i got it	Rudy Setiawan	04/16/00 04:44
Cant get it to work at all ... pls help me	Rudy Setiawan	04/16/00 04:36
Width and Height	Matt Whitted	04/15/00 19:41
getdata.php3 works but....	Sergio	04/14/00 19:03
NO OUTPUT !!!!	markus	04/14/00 04:24
Input file variable missing	Mark Wolfgramme	04/13/00 09:22
Input file variable missing	Mark Wolfgramme	04/13/00 09:22
Blank screen	Robbie	04/13/00 08:44
ppgsql backup	Ruben	04/12/00 12:12
How do I List Active sessions on my webserver	Fredrik	04/12/00 00:55
RE: how to use mysql_insert_id??	Dan Nedoborski	04/11/00 18:29
RE: "getdata.php3?=2" doesn't work...	Hennie Jansen	04/11/00 11:08
how to use mysql_insert_id??	thinker	04/10/00 20:01
File Progress Indicator	Dan Nedoborski	04/10/00 17:36
RE: How to display Flash File stored in Database?	Scott Helms	04/06/00 17:48
Got error: fopen("...") - Permission dienied	Rein Velt	04/06/00 04:56
"getdata.php3?=2" doesn't work...	Jakub Gaj	04/06/00 04:47
HELP ME!	Morten	04/03/00 13:34
RE: Can't find the image	Rainer Collet	03/31/00 10:05
RE: Can't find the image	Rainer Collet	03/31/00 10:05
RE: How to store image to Postgres	Bruno Rothgiesser	03/30/00 14:21
How to display Flash File stored in Database?	Ivan Christiansen	03/29/00 13:30
Can't find image	RAMac	03/26/00 23:22
Can't upload files bigger than 1 MB	Per Øyvind Moeng	03/23/00 09:51
I can't get mine to do anything	Michael	03/23/00 01:23
RE: How to send file name?	Rey Mangahas	03/22/00 19:03
How do I dump the database with an image	Jamie Becker	03/22/00 13:12
how deal the attached file in email with php3	Yang Qianggen	03/22/00 10:56
RE: How to send file name?	Ben Schumacher	03/22/00 01:05
How to store image to Postgres	Dusan Halamka	03/21/00 07:15
RE: Sending Filename	Dan Holtz	03/20/00 10:00
RE: Sending Filename	Dan Holtz	03/20/00 10:00
RE: got error from uploading some file	Ian....	03/19/00 00:31
RE: How to send file name?	Greg Speed	03/17/00 16:39
RE: How to send file name?	Jason Mitchell	03/17/00 02:36
How to send file name?	Andrea	03/16/00 16:52
undefines error	Markus	03/16/00 08:45
got error from uploading some file	Wilson	03/16/00 06:03
RE: Upload	Sander Boulogne	03/15/00 05:49
RE: Upload	Peter Martha	03/14/00 17:13
RE: Upload .. same problem here	Sander Boulogne	03/14/00 16:42
URL passing	Ruben	03/14/00 01:56
RE: Upload	pierre	03/13/00 18:59
RE: Upload	Bent Karlsen	03/13/00 16:50
Upload	Bent Karlsen	03/12/00 15:52
php&DB2	Riad Abd El Magid	03/10/00 07:39
RE: Can't find the image	Jake Goena	03/10/00 01:34
Can not upload file bigger than 2M	Mike, H	03/09/00 23:19
File uploading problem	Liam Gretton	03/09/00 11:40
RE: Why? and how to search	Frederik JOLY	03/08/00 03:13
$form_data variables	Aragon Gouveia	03/07/00 17:22
RE: Why?	Steve Grevemeyer	03/04/00 18:49
RE: Why?	Chester Bullock	03/04/00 12:24
RE: Why?	Rob Sletten	03/03/00 14:52
RE: Why?	Tim Perdue, PHPBuilder.com	03/03/00 12:21
RE: Why?	Chester	03/03/00 10:03
RE: Why?	Chester	03/02/00 14:37
Why?	Scott Genevish	03/02/00 13:48
RE: Can't find the image	Chester	03/02/00 10:23
RE: Can't find the image	Robert Bergs	03/02/00 03:42
Form Encoding	Robert Bergs	03/02/00 03:40
Can't find the image	Chester	02/29/00 14:40
the output part of the script	alexander	02/28/00 06:02
Add A Comment: Not [Logged In] Subject: Message: Due to abuse, you must now be [ logged in ] to post

Sample Code Library | Columns | Mail Archive | Support Forums | Get Started! | Links | Contribute!

Contact (non support questions)

internet.com Internet News, Internet Stocks/VC, Internet Technology, Windows Internet Tech., Linux/Open Source, Web Developer, E-Commerce/Marketing, ISP Resources, Downloads, Internet Resources, Internet Lists, International Search internet.com, Advertising Info, Corporate Info, Internet Trade Shows

internet.commerce Be a Commerce Partner, Software Store, Computer Help, Register Domains, Internet Jobs, Map Your Website, Rent E-mail Lists, Bookstore, Press Release dist., Internet Research, Venture Capital, Web Publishing, Build Your Intranet, Ask an Expert, Get e-Biz Intell., Content for Websites, Income for Small Biz, Address Verification, Build Sticky eStores, Advertise a Coupon, Promotional Products, Accept Credit Cards, Download Solutions, Create a Web Store, fax & vmail for free, Hardware Store, Track Time & Expenses, News to Your Desktop, Small Biz Purchasing, B2B Directory/Search, Freelancers

Copyright 2000 internet.com Corp. All Rights Reserved. Legal Notices, Reprints.   Privacy Policy