PHP provides built in functions to access just about every database that exists. MySQL is well designed, powerful and most importantly free in some situations. In this tutorial, you will learn how to access MySQL using PHP. Main topics include: Create A Database, Create A Table, Insert Entries Into The Table, and Retrieve All Entries Into The Table.
Version: n/a Platform(s): n/a Updated: Thu Feb 24 2000
As your website grows you may run into two problems: Your website has so much information that visitors can't quickly find what they want and visitors want to give you information. Both of these problems can be solved by building a database on a website. This introductory article shows you how to do this using basic PHP-MySQL interaction.
Version: n/a Platform(s): n/a Updated: Tue Jan 18 2000
mSQL is a lightweight SQL database engine for Unix systems. It is extremely easy to install and configure and it does a great job of handling simple SQL queries. This tutorial shows you how to communicate with the mSQL database engine using various mSQL-PHP functions.
Version: n/a Platform(s): n/a Updated: Sun Dec 26 1999
In this two-page online tutorial you will learn how to create a database-driven site that can display content on request. It covers topics on a simple SQL query interface and more complex example of parsing and querying.
Version: n/a Platform(s): n/a Updated: Tue Dec 14 1999
In this tutorial, you'll learn how to install and configure PHP for use with the Apache Web server on UNIX or the Microsoft Internet Information Server on Windows NT. Then you'll see by example how to use PHP to route HTML conditionally, to develop a simple database-driven Web application, and to track user sessions with cookies.
Version: n/a Platform(s): n/a Updated: Fri Dec 10 1999
This article will aid the reader in learning the basic operations of the MySQL server, including how to make a proper connection, set up the server for consequential manipulation and execute basic commands. The commands covered within this article are among the most important commands within the language, as they form the basis for the more advanced commands.
Version: n/a Platform(s): n/a Updated: Tue Nov 9 1999
One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, and reduced data redundancy. In MySQL (as well as many other SQL languages), this is accomplished via the join command. This tutorial takes a look at several types of the join command including The Cross Join, The Equi-join, The Left Join, and Self-joins.
Version: n/a Platform(s): n/a Updated: Tue Nov 9 1999
This tutorial is an introductory guide to get you started in the world of server-side-scripting and web databases. It covers installation and configuration of MySQL, Apache, and PHP. An example script is also included as a guide for making your own server-side-scripts. You will have accomplished after successfully completing this guide: setup the MySQL database server, setup the Apache web server, setup the PHP 3.0 Hypertext Preprocessor for server-side-scripting, and create a simple web enabled database.
Version: n/a Platform(s): n/a Updated: Tue Nov 9 1999
MySQL Administration correctly administering the MySQL server, including the manipulation the privilege system, and making intelligent decisions about the capabilities (permissions) given to users.
Version: n/a Platform(s): n/a Updated: Tue Nov 9 1999
One of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each user's intended behavior. This control can restrict user privileges over a general part of the server, such as limited access to an entire database, but can also be as specific as limiting privileges for a specific table or even column. This article will serve to explain the process in which the MySQL server grants/revokes these user privileges, highlighting in particular the newest additions to the MySQL privilege system, the tables_priv and columns_priv tables. Please keep in mind that the GRANT/REVOKE commands detailed later in this article are only relevant to MySQL version 3.22.11 and up.
Version: n/a Platform(s): n/a Updated: Tue Nov 9 1999
