Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Selecting an Existing Database

By: FYIcenter.com

(Continued from previous topic...)

How To Select an Exiting Database?

The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by your Web hosting company, they will assign a empty database to you and provide you the database name. You should use this name to select this empty database as your current database. The following script shows you how to select a database called "fyi". It also shows you how to put all the database connection statements in a single include file, and re-use it in all of your PHP pages.

Create the include file, connect.php, with the following statements:

<?php
  $server = "localhost";
  $username = "dev";
  $password = "iyf";
  $database = "fyi";
  $con = mysql_connect($server, $username, $password);
  mysql_select_db($database, $con);
?>

To test this database connection and selection include file, try the following script:

<?php
  include "mysql_connection.php";
  $sql = 'SHOW TABLES';
  if ($rs = mysql_query($sql, $con)) {
    print(mysql_num_rows($rs) . " tables in the database.\n");
  } else {
    print("SHOW TABLES failed.\n");
  }
  mysql_close($con); 
?>

You will get something like this:

0 tables in the database.

(Continued on next topic...)

  1. How To Install PHP on Windows?
  2. How To Verify Your PHP Installation?
  3. What Do You Need to Connect PHP to MySQL?
  4. How To Turn on mysql Extension on the PHP Engine?
  5. How To Connect to a MySQL Server with Default Port Number?
  6. How To Connect to a MySQL Server with a Port Number?
  7. How To Connect to MySQL Server with User Accounts?
  8. How To Access MySQL Servers through Firewalls?
  9. How To Get Some Basic Information Back from MySQL Servers?
  10. How To Close MySQL Connection Objects?
  11. How To Get a List of Databases from MySQL Servers?
  12. How To Create a New Database?
  13. What Happens If You Do Not Have Privileges to Create Database?
  14. How To Get MySQL Statement Execution Errors?
  15. How To Drop an Existing Database?
  16. How To Select an Exiting Database?
  17. Can You Select Someone Else Database?
  18. How To Execute a SQL Statement?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...