PHP/MySQL Database/MySQL Connection
Connect to MySQL
<source lang="html4strict">
<? $connection = @mysql_connect("mysql153.secureserver.net", "wbex", "password") or die(mysql_error()); $dbs = @mysql_list_dbs($connection)or die(mysql_error());
$db_list ="- ";
$i =0;
while ($i < mysql_num_rows($dbs)){
$db_names[$i] = mysql_tablename($dbs,$i);
$db_list .= "
- $db_names[$i]"; $i++; } $db_list .="
?> <HTML> <HEAD> <TITLE>MySQL Databases</TITLE> </HEAD> <BODY>
Databases on localhost:
<? echo "$db_list"; ?> </BODY> </HTML>
</source>
Connect To MySQL Database
<source lang="html4strict">
<?php // $hostname="mysql153.secureserver.net"; $username="wbex"; $password="password"; $dbname="wbex"; $usertable="Employee"; $yourfield = "FirstName"; mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later."); mysql_select_db($dbname); $query = "SELECT * FROM $usertable"; $result = mysql_query($query); if($result) {
while($row = mysql_fetch_array($result)){
$name = $row["$yourfield"];
echo "Name: ".$name;
}
} ?>
</source>
Listing the Databases Available in a Connection
<source lang="html4strict">
<html>
<head>
<title>Listing the databases available in a connection</title>
</head>
<body>
<?php
$user = "wbex";
$pass = "password";
$link = mysql_connect( "mysql153.secureserver.net", $user, $pass );
if ( ! $link )
die( "Couldn"t connect to MySQL" );
$db_res = mysql_list_dbs( $link ); $num = mysql_num_rows( $db_res ); for( $x = 0; $x < $num; $x++ )
print mysql_tablename( $db_res, $x )."
";
mysql_close( $link );
?>
</body> </html>
</source>
