Active Articles: 2038
Total Categories: 16
Sub Categories:616
Export Database Schema as XML | ||||||||
Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema. ... learn more
| ||||||||
| ||||||||
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 ... learn more
| ||||||||
| ||||||||
SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution | ||||||||
A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result fields. ... learn more
| ||||||||
| ||||||||
Add a Row to mySQL | ||||||||
Learn how to add a row to a mySQL database using a PHP form. Here is a useful script that Spoono uses to update the news. ... learn more
| ||||||||
| ||||||||
A script to generate a report from a valid mysql connection | ||||||||
A script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable. ... learn more
| ||||||||
| ||||||||
Using PHP with MySQL | ||||||||
Quick and easy script on how to create a DB link and execute an sql statement ... learn more
| ||||||||
| ||||||||
ODBC with PHP: Tips and Hints on Windows | ||||||||
ODBC is one of Microsoft's earliest technologies for connecting to databases. This article describes how to setup and use ODBC from a PHP perspective. Also discusses ODBC extension bugs, database wrapper libraries, Microsoft's ADO (which is Microsoft's recommended API for 4GL programmers) and DSN-less connections. ... learn more
| ||||||||
| ||||||||
Alternating row colours | ||||||||
shows you how to generate a table with alternating row colours from a MySQL databse. ... learn more
| ||||||||
| ||||||||
Basics of MySQL | ||||||||
MySQL is a very powerful language. Coupled with PHP you can do just about anything you want. This tutorial here will cover "INSERT", "SELECT", "DELETE", "UPDATE" and "RAND". ... learn more
| ||||||||
| ||||||||
Count and display the number of rows in a MySQL database table | ||||||||
This code will count the number of entries / records in a MySQL database table and then display it using echo. ... learn more
| ||||||||
| ||||||||
Doing Simple DB Abstraction in PHP | ||||||||
This tutorial explains the need for database abstraction in PHP, and shows how to create your own database API that can be to used with different types of databases. The tutorial uses a PHP PostgreSQL API as an example. ... learn more
| ||||||||
| ||||||||
Formatting Date/Time value in SQL query | ||||||||
Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal. ... learn more
| ||||||||
| ||||||||
Select random records from a MySQL database | ||||||||
Sometimes it could be very helpful to select a record from a table randomly. You can find such solution when you see random partners or randomly selected tutorials. This tutorial shows you how to select records randomly from a MySQL database. ... learn more
| ||||||||
| ||||||||
Useful String Manipulation | ||||||||
The correct usage of PHP strings is essential when dealing with database queries submitted from User Forms, such as User Registration. Find out how to format strings before saving them in a database in this helpful tutorial. ... learn more
| ||||||||
| ||||||||
Install ADOdb Database Abstraction Layer | ||||||||
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 ... learn more
| ||||||||
| ||||||||
Connecting to a mySQL database | ||||||||
This tutorial explains how to use several basic MySQL database functions in PHP. Main topics include: Connecting to a mySQL database using PHP, SHOW available tables, Using telnet to CREATE tables, How to INSERT, QUERY, UPDATE, and DELETE rows in a table, How to ALTER a table, Commenting Your mySQL Tables, and Creating mySQL tables. ... learn more
| ||||||||
| ||||||||
Newest MySQL manual in HTML Help (.chm) | ||||||||
Everyone who likes MS HTML Help (.chm extension) can now obtain complete conversion of MySQL manual into this format. This conversion tries to bring additional functionality and make using of MySQL manual more comfortable. ... learn more
| ||||||||
| ||||||||
Add a Row to mySQL | ||||||||
Learn how to add a row to a mySQL database using a PHP form. ... learn more
| ||||||||
| ||||||||