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. Includes the complete source code for all the scripts involved.
What is MySQL? How does it work? : And how do you work with it? This tutorial is a great place to get started using PHP & MySQL. Includes some code samples, explaination and resources.
This is a quick MySQL reference for your daily practice or for learning MySQL. This one page document includes most of the commands you will need to create databases and tables, run queries and process data. The download file format in MS Word.
This article will briefly describe how to compile PHP with ORACLE 8i support. The author writes "when i try to compile php with oracle support on Solaris 2.6 i got lots of problems. after tedious search in internet i have found solution. I have following configuration: ORACLE 8.1.6; PHP 4.0.6; Apache 1.3.19 (Already Installed)."
Do you get stressed out by mysql or other database queries? Do you use multiple databases and wish there was just one way to handle all of your queries? ADOdb is a system that executes queries to any type of database the same way, so you only have to know how to do it their way. This tutorial walks you through installing ADOdb on your web server, and configuring it to work with a mysql server.
Platform(s): Linux, Windows, FreeBSD, Mac OSX, Sun Solaris
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. This 6-page article describes the data relationships and the normalization of data using a simple example.
This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query.
The MySQL database is one of the most popular among PHP developers, and there are numerous well-documented PHP functions you can use in conjunction with your MySQL databases. In this tutorial, you will learn how to make a simple connection to MySQL using just a few of these functions.