Portal Home > Knowledgebase > Databases > How do I connect to my MySQL database?


How do I connect to my MySQL database?




A simple php script to open a connection to a database

<?php
$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 <something>.php and then whenever you want to access the database, just add

include '<something>.php'

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



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Powered by WHMCompleteSolution