|
Alternating row colors with PHP and mySQL
|
Other links at PHP > Tutorials > Database-Related |
| 1. |
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.
|
| 2. |
Simple Connection to PostgreSQL
|
|
|
Like MySQL, the PostgreSQL database is quite popular among PHP developers. Understandably, there are numerous well-documented PHP functions you can use in conjunction with PostgreSQL. Here you will find how to make a simple connection and select some data using just a few of these functions.
|
| 4. |
Displaying Data In A MySQL Database
|
|
|
This tutorial shows how to store data into a MySQL database and then retrieve it by using a PHP query. This wil teach you the basics behind the use of PHP with databases. A VERY good tutorial for beginners who are interested in learning the language quickly.
|
|
|