The author notes, "Last week we introduced you to the basics of creating an efficient database table structure. After today's concluding article of this series you'll be able to create some of your own MySQL-powered applications, or use this syntax as the basis for learning to create normalized databases on your database server of choice."
Version: n/a Platform(s): n/a Updated: Wed Dec 6 2000
A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.
Version: n/a Platform(s): n/a Updated: Wed Dec 6 2000
This 6-page article explains how to create an extension to PHPLIB to work with multiple databases. You may find this article helps you extend PHPLIB in other ways. Read this article to the end and then think about situations where PHPLIB performs 98% of what you want.
Version: n/a Platform(s): n/a Updated: Wed Nov 8 2000
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.
Version: n/a Platform(s): n/a Updated: Tue Oct 17 2000
Many devs using MySQL have fallen in love with PHP. Jason Gilmore explains why they're the perfect couple. This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.
Version: n/a Platform(s): n/a Updated: Tue Oct 17 2000
One of the most compelling things PHP has going for it is it support for a wide variety of databases. This part 4 of the PHP 101 is going to take advantage of that database support to create dynamic data-driven Web sites. This primer covers different techniques to select, insert and delete records, together with some tips to track and squash bugs when building SQL-driven sites.
Version: n/a Platform(s): n/a Updated: Sat Sep 9 2000
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.
Version: n/a Platform(s): n/a Updated: Sat Jul 29 2000
This is the second part of creating Web-based admin user interface. This tutorial covers adding and deleting users via Web form using a MySQL database.
Version: n/a Platform(s): n/a Updated: Sat Jul 29 2000
When interacting with a database, functions are called that are common to every transaction; functions to establish a connection, execute the query and then close the connection. This article shows how to create functions that will eliminate this redundancy. The tutorial uses MySQL as the database, but the database layer is irrelevant. These functions can be adapted to use other databases.
PHP includes functions for Open Database Connectivity (ODBC), which is useful if, for example, you want to connect to a Microsoft Access data source on Windows NT. An increasing number of PHP developers are using the ODBC functions to connect to databases; to that end, the ODBC functions are numerous and well-documented in the PHP Manual. This tutorial presents how to make simple ODBC connections using just a few of these functions.
Version: n/a Platform(s): n/a Updated: Thu Jun 29 2000
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.
Version: n/a Platform(s): n/a Updated: Thu Jun 29 2000
PHP provides built in functions to access just about every database that exists, including Oracle. This 8-page tutorial illustrates how to use these built in functions to communicate with an Oracle database.
Version: n/a Platform(s): n/a Updated: Tue Mar 21 2000
Here, you will learn how to create an MS Access database and interface with it using PHP on Windows platform. Main topics include: Creating an Access database, Setting up an ODBC Connection, and Interfacing with database.
Version: n/a Platform(s): n/a Updated: Wed Mar 8 2000
MySQL has a small, highly optimized database engine that implements the entry-level SQL92 specification. Its rich set of support tools lets you create dynamic Web applications such as catalogs, shopping carts, and contact lists. This article introduces MySQL and shows how to develop a simple Web interface to a contact database using MySQL and PHP.
Version: 1.1 Platform(s): n/a Updated: Tue Feb 22 2000
