|
Formatting Date/Time value in SQL query
|
Other links at PHP > Tutorials > Database-Related |
| 1. |
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. Includes the complete source code for all the scripts involved.
|
| 3. |
LDAP to SQL
|
|
|
The author writes: Whilst working on the automatic production of web statistics - came across the following problem: "How do I get relational data from an Hierarchical structure?" It didnt take long to realize - Id have to use PHP to talk to LDAP, pull off records & upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow - so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query & produce daily snap shots.
|
| 4. |
Simple Connection to MySQL
|
|
|
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.
|
|
|
