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.
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.
In PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(). When you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that the parameters you use for the different connect functions are different also.. That's why a database wrapper library such as ADODB comes in handy when you need to ensure portability.
<p>
This tutorial has been translated into multiple languages, including German, Spanish, Polish, Thai and Chinese.
The author writes "mySQL comes with a pretty powerful security system, the grant tables, which allows database administrators to precisely control access to databases, tables and even specific rows and columns." This article describes how the five grant tables combine to offer power users a tremedous amounts of flexibility and control over database access and operations.
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.