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.

  • 225 Users Found This Useful
Was this answer helpful?

Related Articles

How can I manage my MySQL database?

Once you have created a database using your Fast Name Control Panel you will be able to manage it...

How can I upload my MySQL database?

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

How do I access the raw web access or error logs?

Simply log into your Fast Name Control Panel and click on 'Log File Download' in the 'Web Site...

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...

How do I setup an email box (pop3)?

All your email settings can be controlled through your Fast Name Control Panel. Simply log into...