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.
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.
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.
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.
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.
Get started in Web databasing the open source way. This three-lesson tutorial covers everything you need to know to begin developing database hubs. Lesson 1 gives instructions for installation on both Unix and Windows, and then goes on to show some simple scripts that will insert information into a database and display that data on a Web page. Lesson 2 covers more PHP/MySQL goodies such as while loops, if-else statement, how PHP can be used with HTML forms, and how to add, edit, and remove information from your database. Lesson 3 covers some of the secrets that will turn your simple data-driven site into a useful application.