Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Select an Exiting Database
How To Select an Exiting Database? - MySQL FAQs - PHP Connections and Query Execution
✍: 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 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.
2007-05-10, 4842👍, 0💬
Popular Posts:
Can Java object be locked down for exclusive use by a given thread? Yes. You can lock an object by p...
What will be printed as the result of the operation below: main() { char s1[]="Cisco"; char s2[]="sy...
How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...
From performance point of view how do they rate ? Repeater is fastest followed by Datalist and final...
What are unadjusted function points and how is it calculated? Unadjusted function points = ILF + EIF...