PHP MySQL Connectivity

Posted on February 7, 2017

Hi there, this is probably a very basic question but I cannot seem to find the answer on google…

I have installed MySQL and Apache on the cloud server and trying to run a PHP program to indicate whether the connection to a database I have created was successful. I have written the PHP (below) on my personal computer and uploaded the file to the web host I use which is godaddy. For some reason every time I reference this PHP file in the URL the page is blank in the web browser (all my other non database PHP files work ok).

Sorry if this is not clear but could someone please help? I am expecting to see the connection to the database in the cloud was successful!

<?php
$host = 'xxx'; //188.166.....
$user = 'root';
$pass = 'yyy';
$db = 'zzz';

$conn=mysqli_connect($host,$user,$pass,$db);

if($conn)
{
	echo "Connection Successful";
}
else
{
	echo "Could not connect";
}
?>

Thanks,

Alex.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Jonathan Tittle

February 7, 2017

@alex878

I tested the above code locally and on a Droplet and the code works without any issues, though the issue on your end may be with $host. In most cases, you’d need to specify localhost as the host unless the provider specifically requires you to use an IP address.

If you installed Apache, PHP, and MySQL on a Droplet, unless you configured MySQL to bind to an IP specifically, you would need to use localhost as the host.

alex878

February 7, 2017

Thank you for the reply. I tried installing PHP on the Droplet and changing the host to localhost but still no luck (just a blank page).

Maybe I didn’t explain myself properly but is what I am trying to do possible? Ie create a database through MySQL on the Droplet and then upload a PHP file (above) to my web host (godaddy) to pull back information from the MySQL database (which is on the Droplet) and display this information on the web page?

Alex.