How do I connect to my MySQL database?


A simple php script to open a connection to a database

$dbhost = 'localhost';
$dbuser = 'db username';
$dbpass = 'db password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'db name';
mysql_select_db($dbname);
?>

Save this as .php and then whenever you want to access the database, just add

include '.php'

to the top of a php script and the database can be queried using standard sql commands.


Was this answer helpful?

 Print this Article

Also Read

I've uploaded files to File manager but cannot see them, they were recently visible. What's happened?

File manager has a 5mb memory limit which restricts the number of files that can be displayed if...

How do I create a MySQL database?

If your account type includes MySQL databases, then log in to your Online Control Panel Control...

How can I upload my MySQL database?

There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2...

File Manager session expiry errors

In order to keep your files secure against various threats, File Manager requires that your...

How can I see email addresses on my email distribution list?

To view, add, amend or remove email addresses from your distribution lists simply log into your...