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? - PHP Script Tips - Working with MySQL Database
✍: 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.
2007-04-18, 4674👍, 0💬
Popular Posts:
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...
Can you explain why your project needed XML? Remember XML was meant to exchange data between two ent...
The object that contains all the properties and methods for every ASP.NET page, that is built is .. ...
What is the difference between strings and character arrays? A major difference is: string will have...