This article gives a introduction to PostgreSQL, prerequisites, connecting to PostgreSQL from PHP, using pg_query() to create a table, inserting data into your database, viewing the entries in the database and updating the entries. The author conclud
In this article, the author gives a code source file in a text form for making some alterations to search and get results in a MySQL database content. He gives some programmes to follow step by step and three major areas are covered in this script, t
This is a tutorial which tells the users about storing binary files in a mySQL database with php. This tutorial explains the users about setting up a database in which they should optimize the fields on their tables by not wasting any resources. This
In this article, the author gives some PHP scripted code functions for reducing your MySQL database queries and makes your website run fastly. The author describes in the following areas like how to minimize the impact of your server, building script
In this article, the author gives his views about MySQL and other RDBMS which are useful for large scale or multi-user applications. But the SQLite is the apt and light weight alternative as your database solution for smaller websites with low traffi
SQL Theory & How-To is an article that gives the answer to the two questions ie- how to Create complex, powerful, queries to take advantage of your table schemas and how to build complex queries on the fly. For this he gives some examples and...
In this article, the author gives some codes and programmes to display the time spent for SQL queries and overall percentage of time for MySQL only and time spent for running PHP code. The author gives some sample functions to show this for easy unde
This tutorial gives a solution to solve the problem of avoiding errors in SQL syntax normally one would get when switching web servers. The author helps coding PHP in an effective way which would make it work any any web server easily and does not co
Script Web databases quickly with PHP scripting language is a tutorial which teaches about how PHP is useful and flexible script that programmes web databases quickly and easily. This also discusses about how to install and configure PHP with the Apa
Random MySQL result-set is a PHP based tutorial for creating database related result tables. It requires MySQL database for storing and retrieving all the data or information. You can create random rows from a table by populating any of the columns t | 
