At first we connect to a MySQL database and use the SHOW TABLES command to return all the tables in the database. Next, we iterate over each table and return the fields for each table using the SHOW FIELDS command. Finally, we put all of the returned information into XML.
SQLite is a C library that implements an embeddable SQL database engine. Scripts which link with the SQLite library can have SQL access without running an additional database server.
You have a web site with pages accessing a database. You want to use PHPLIB, but do not want to change your existing database to suit. Here is the answer to your dreams. PHPLIB and multiple databases.
Sometimes if you want to install a new PHP CMS, blog, wiki, ... you first need to create the necessary database. The installation packages contains the sql file you need to execute, however if you don't have any web based management tool then it can take a bit more time. In this article we will create a simple PHP solution which can execute any sql script on your MySQL database.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.