Tools, FAQ, Tutorials:
Selecting an Existing Database in PHP
How To Select an Exiting Database in PHP?
✍: FYIcenter.com
The first thing after you have created a connection object to the MySQL server is to select the database where your tables are locate, by using the mysql_select_db() function. If your MySQL server is offered by your Web hosting company, they will assign a database to you and provide you the database name. You should use this name to select your 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 = ""; $password = ""; $database = "fyi"; $con = mysql_connect($server, $username, $password); mysql_select_db($database); ?>
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.
⇒ Running a SQL Statement in PHP
2016-10-20, ∼3844🔥, 0💬
Popular Posts:
Where to find tutorials on JSON (JavaScript Object Notation) text string format? I want to know how ...
How to use "xml-to-json" Azure API Policy Statement? The "xml-to-json" Policy Statement allows you t...
Where to get the detailed description of the json_encode() Function in PHP? Here is the detailed des...
How to register and get an application ID from Azure AD? The first step to use Azure AD is to regist...
How To Use an Array as a Queue in PHP? A queue is a simple data structure that manages data elements...