Uploading, Saving and Downloading Binary Data in a MySQL Database

This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. This article is split into three pages: Setting up the database, Creating the 'upload' scripts, and Creating the 'download' script.

Related Tutorials

Editing MySQL Data Using PHP
We have had a few tutorial that show how to display and add data to a MySQL database. Now I am going to show you how to edit a row in your database.

PHP Script Tips - Working with MySQL Database
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

Saving Movie Clip Positions with PHP and MySQL
Good understanding of Flash Actionscript is required to complete this tutorial. What this tutorial basically does is to show you how to set up a table in a mySQL database, then using PHP (or asp with a few minor changes) manipulate that table and interact with Flash.

Saving Session data on a database
Unless you store your sessions in a database your web application cannot be load balanced across multiple servers.

How to connect to MySQL database using PHP
Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

How to Access a MySQL Database Using PHP
Display data from a MySQL database on a web page using PHP.

Convert a MySQL date field using PHP Functions
Today I am going to show you how to convert data returned from a MySQL database that was store as a date data type into a user friendly format. To do this you can take two different approaches.

Web Database Tutorial (PHP & MySQL)
This is a tutorial on how to create a web database application using PHP and MySQL on a Unix platform (Linux or Mac OS X). The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... All are based on inserting, displaying and managing data in a database.

Data Integrity Using MySQL and PHP (Part 2)
A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.

Edit a Row In mySQL
This tutorial goes along with several others that use the same news database such as Add a Row to mySQL, Displaying a Database, and Deleting a Row In mySQL.There are many reasons you might want to edit one of the rows in your mySQL database. Say for instance, you made a spelling error in one of your news posts and you want to edit it.

Pagination with PHP
This tutorial is designed to guide you through the logic and code behind the process of paginating data in PHP. In this tutorial, the data is retrieved from mySQL database. I feel you will be able to grasp this tutorial better if you have a decent knowledge of PHP and mySQL.

Data Integrity using MySQL and PHP
This is an overview of relational database concepts, specifically MySQL. It illustrate each of the concepts through simple examples.

PHP and Javascript: Dynamic update with MySQL
In this tutorial we will create a web page that extracts data from a MySQL database without having to refresh the page.

Building a Database-Driven Web Site Using PHP and MySQL
This ten part series of articles will teach you everything you'll need to build a database-driven Web site from the ground up. Main topics include: Installation, Getting Started with MySQL, Getting Started with PHP, Using PHP to access a MySQL database, Relational Database Design, A Content Management System, Content Formatting and Submission, MySQL Administration, Advanced SQL, and Advanced PHP.

Display data from a MySQL table
The basics of fetching data in a database and a bit about how to use it.

MySQL Query Limiting
Combining the power of a mySQL database with the flexibility of PHP allows even the most amateurish developer to create websites loaded with thousands of pages of information. But what do you do if you don't want to display all your QUERY data in one large lump?

Add, View, Edit & Delete from to MySQL database, Live Example (News System)
This tutorial will teach you how to deal with MySQL database using php, you will add, view, edit & delete data.

Accessing a Database Using PHP/MySQL
How to make a mysql connection, select a database, query the database, count the rows and use the information within the rows.

PHP/MYSQL Snippets
This tutorial explains the following: Opening and closing PHP tags; Connecting to a MYSQL Database; Selecting a mysql database; usage of ucfirst, ucwords, strtolower and strtoupper function, Using the date function to print different aspects of the date and time, Printing Browser Info, IP Address and hostname of the ip.

Basic mySQL Queries And PHP
This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial, you should get an idea on what a database is, how to use it, and how to access it. You can then go ahead and start reading on the many more advanced topics regarding database systems.

mySQL Search Engine
This tutorial will teach you how to search a mySQL table. It goes along with several others that use the same news database such as Add a Row to mySQL, Deleting a Row, and Edit a Row In mySQL.

Writing to Web Databases
Writing data in web database applications requires different techniques than reading data. Issues of transactions and concurrency become important, and we introduce these issues and the principles of dealing with them in this tutorial.he introduction is practical: we focus on the basic management techniques of locking and unlocking tables, and how to safely implement simple database writes in MySQL when there is more than one user simultaneously accessing a database. Most importantly, we identify when special approaches are required, and when these can be safely omitted from a web database application.

Displaying Fields and Data of a MySql Table in PHP
This example shows how to display the data values from the columns of a search result from a MySql query in an HTML table.

How To Install Apache+PHP+MySQL PHP tutorial
This tutorial discusses the setup of Apache, PHP and MySQL for both Windows and Red Hat Linux.Because the install for Windows is straightforward, the discussion for Windows is an overview. The tutorial and how to for Red Had Linux is much more detailed and covers both downloading and installing packages as well as using Apache's DSO Module.

PHP Script Tips - Uploading Files to Web Servers
A collection of 12 tips on uploading files with PHP pages. Clear explanations and tutorial exercises are provided on creating file upload HTML tags, setting encoding type on HTML forms, getting uploaded file information, storing uploaded file in database.

Database Normalization And Design Techniques
One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. Whether you work with mySQL or Oracle, you should know the methods of normalizing the table schema in your relational database system. They can help make your PHP code easier to understand, easier to expand upon, and in some cases, actually speed up your application.

MySQL in PHP - Running Some Queries
Continuing the process of adding access to a MySQL Database to our HTML pages, we now need to interact with the database we previously selected from the server to which we also previously connected.

Querying Web Databases
We introduce the following techniques in this tutorial: * Using the five-step web database querying approach to develop database-driven queries * Coding a simple solution to produce HTML <pre> preformatted text * Using the MySQL library functions for querying databases * Handling MySQL DBMS errors * Producing formatted output with the HTML <table> environment * Using include files to modularize database code * Adding multiple queries to a script and consolidating the results into one HTML presentation environment * Performing simple calculations on database data * Developing basic database-driven scripts incrementally and producing modular code encapsulated in functions.

Random Links and images with PHP & MySQL
This script allows any number of images to be referenced and have an associated hyperlink attached, which makes it great for 88x31 buttons which are commonplace throughout the web. The script requires a web server with PHP and a MySQL database to store the data.

Using PHP to search a MySQL database and return paged results
PHP, MySQL and a Web Server capable of parsing PHP pages, like Apache or IIS. This search script does not spider all your pages by crawling the links, so the content you want to be searchable must be within the database. Knowledge of PHP and MySQL is also necessary because this script is just the bones of a working solution.

Blocking Bad Agents from downloading your website
If you found this page searching Google or search engine, you must be looking for a solution how to block those bad guys from downloading your whole site. I know exactly how it feels to be ripped off, and I have done some research in this area and found few solutions that really work. I thought I would share this with you so that you could save your bandwidth from illegal downloaders.

PHP and Mysql: Part 1
Alot of people have written in saying that the Using MySQL with PHP tutorials they've found in the internet are difficult to follow. This tutorial is our attempt at solving the confusion and providing a straight-forward explanation of how you use PHP to interact with a MySQL database.

Dumping mySQL Tables to HTML
In this tutorial we are going to expose basic mySQL queries, and how they can be used to print all data from a mySQL table into an HTML table.

Dynamic SQL Queries
One use of PHP is to create a connection to a MySQL database, use a query to select some data, display or loop through it. In the previous tutorial, we looped through some data which was provided to us using a static SQL query.

Read news from MySQL
Managing MySQL data with PHP and use them in a simple Flash MX application.

PHP/MySQL/LDap authentication
LDAP database for authentication and a MySQL database for time-keeping, account access control, etc.

MySQL Table Joins
One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, and reduced data redundancy. In MySQL (as well as many other SQL languages), this is accomplished via the join command.

Making Data Dynamic
One of the main strengths of PHP is its support for a vast number of databases. Very often, PHP and MySQL are viewed as an entity. However, other databases have their strengths, toofor instance, it took MySQL a very long time to support features that are considered standard in other systems; however, MySQL is known to be very fast.

Uploading, Saving and Downloading Binary Data in a MySQL Database

View Tutorial