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.
Not sure how to make use of the free MySQL database space included with your web-hosting plan? This step-by-step tutorial explains a simple way to upload data from a Microsoft Access database to the MySQL database at your ISP. The tutorial also contains a free sample application that is available in ASP and PHP versions.
After having worked through this tutorial you will be able to:
* know how the additional phpMyAdmin features using special seperate tables work and how to set them up
* store pictures inside a MySQL table and view them from within phpMyAdmin
* put specific transformations on any of your columns
* create your own transformations, even with active PHP-code in it!
* create PDF pages of your table layout, with relations and individually positioned ER-models
At the end of this tutorial there's also some hints on getting the most out of your phpMyAdmin config file, showing you some configuration directives which seem to get less public attention.
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.
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.
This is a nice tutorial on how to use PostgreSQL and PHP together. Topics covered include: Installation of PostgreSQL, PHP, and Apache, A Brief Introduction and Basic Commands, Different Types of Data, Retrieving Data from a Database, Inserting Data into a Database, Updating Data in a Database, Deleting Data from a Database, Dealing with Errors, and Including Files. The tutorial is also available for download.
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.
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 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.
0.0