This is a simple PHP script to test MySQL database connectivity. 
The result of this script displays the names of the tables present within the specified database.

 

<?php
$connect=mysql_connect('dbserver','dbuser','dbpassword') or die('Could not connect: ' . mysql_error());
mysql_select_db('dbname') or die('Could not open the db');
$showtablequery='SELECT * FROM `records` LIMIT 0 , 30';
echo 'Connected!';
$query_result=mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($query_result))
{
echo $showtablerow[0].' ';
}





Explanation about the variables used in the script:

dbserver: Mention the value as localhost for Linux Hosting (cPanel). For Windows Hosting (Plesk), MySQL Server IP needs to be mentioned
dbname: Specify complete database name including the prefix. For example, reseloaq_mysql.
dbuser: Mention the database user associated with the database.
dbpassword: Mention the password for the above database user.

  • MySQL, php
  • 47 Users Found This Useful
Was this answer helpful?

Related Articles

 How To Insert a Carriage Return in a PHP String

If you need to insert a Carriage Return in a string in PHP: Carriage return is: "\r"  But...

 How to Create a phpinfo page

The phpinfo() function outputs a huge amount of information about the system you're using, such...

 How To Make a Redirect in PHP

If you want that a page redirects automatically the user to a certain page or site (let's say,...

 How To Configure Easy WP SMTP Plugin To Use Gmail SMTP Service

Easy WP SMTP is a popular and free plugin for WordPress to send email(s) by an authenticated SMTP...

 How to Backup Your MySQL Database Using PHP

This simple PHP script will provide a full dump of your MySQL database.You need to provide...