20 Aug 10 Testing MySQL database connectivity through a script
You can test connectivity to a MySQL database using the below script -
Sample Script
<?php
$dbname = ‘mysql_dbname’;
if (!mysql_connect(‘mysql_host’, ‘mysql_user’, ‘mysql_password’)) { echo ‘Could not connect to mysql’; exit; }
$sql = “SHOW TABLES FROM $dbname”;
$result = mysql_query($sql);
if (!$result) { echo “DB Error, could not list tablesn”; echo ‘MySQL Error: ‘ . mysql_error(); exit; }
while ($row = mysql_fetch_row($result)) {
echo “Table: {$row[0]}n”;
}
mysql_free_result($result);
?>
The variables used in the script are –
- mysql_dbname – the MySQL database name
- mysql_host – this needs to be specified as localhost
- mysql_user – the username associated with the above MySQL database
- mysql_password – the password corresponding to the above user
This script, on a successful connection, will fetch and display the names of all the tables in the specified database.
Tags: Database Connectivity, Database Name, Lt, Php, Php Mysql, Query Sql, Script Php, Successful Connection, Variables
Leave a Comment
Gossimer Promotions and Announcements
- TechSupport Notifications February 28, 2010Technical support information and notifications […]
- PHP4 Discontinuation - 18th September September 7, 2009As announced earlier, PHP4 will not be supported on our Linux Hosting Servers from the 18th of September, 2009. Please pass on this information to your Customers and Resellers to ensure that they can update their websites to work with PHP5. […]
- .CN Launch - Coming Soon August 16, 2009We are glad to announce the launch of .CN - the most popular and fastest growing ccTLD worldwide. The .CN domain extension has seen an exemplary growth since its launch throughout the world. Earlier this year, .CN crossed over 13 million registrations to become the second most registered domain extension after .COM. Moreover, with China now representing the […]
- Live Chat Product Discontinuation - Moved to 18th August August 16, 2009Based on feedback that we received from several Resellers, we have decided to postpone the Live Chat discontinuation to the August of 18th, 2009 at 12:30 UTC. From the 18th of August, it will not be possible to purchase new Live Chat packages but exisiting packages will continue to function normally. […]