CODEWITHSUNDEEP
phpmysql
Iskono Morto
Iskono Morto

Reputation: 79

how to get php connect to mysql?

i've tried everything to make my site connect to the database but i always get his error: Could not connect to Master Database i have 2 files 

define('DBHOST','localhost');
define('DBUSER','root');
define('DBPASS','root');
define('DBNAME','test');
define('dbslave','test');  
define('dbsiteid','1');
define('dbprefix','_blog');

and connect.php

error_reporting(0);
$connect = mysql_connect("$DBHOST", "$DBUSER", "$DBPASS");
if ( ! $connect) {
    die('Could not connect to Database server');
}
$siteid  = "$dbsiteid";
$prefix  = "$dbprefix";
$dbmast  = "$DBNAME";
$dbslave = "$dbslave"; 
$cmast   = mysql_select_db("$DBNAME");
if ( ! $cmast) {
    die('Could not connect to Master Database');
}
$cslave = mysql_select_db("$dbslave");
if ( ! $cslave) {
    die('Could not connect to Slave Database');
}

how do i solve this error with connection or what i did wrong ?

Upvotes: 2

Views: 115

Answers (1)

John Conde
John Conde

Reputation: 219804

You do not put constants in quotes, they do not start with $, and by convention are all uppercase.

 define('DBHOST','localhost');
define('DBUSER','root');
define('DBPASS','root');
define('DBNAME','test');
define('DBSLAVE','test');  
define('DBSITEID','1');
define('DBPREFIX','_blog');

$connect = mysql_connect(DBHOST, DBUSER, DBPASS);
if (!$connect) {die('Could not connect to Database server');}
$cmast = mysql_select_db(DBNAME);
if (!$cmast) {die('Could not connect to Master Database');}
$cslave = mysql_select_db(DBSLAVE);
if (!$cslave) {die('Could not connect to Slave Database');}

Also, defining constants only to assign them to variables is silly and a waste of resources. And don't turn off error reporting when developing as it hides your errors. You want to do the opposite and them them on.

Upvotes: 7

Related Questions