how to get php connect to mysql?

Question

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 ?

Why on earth are you turning off errors?! We cannot help you if you do not know what the problem is. — Sverri M. Olsen
– Sverri M. Olsen, Commented Nov 28, 2014 at 0:56
Please, don't use mysql_* functions, They are no longer maintained and are officially deprecated. Learn about prepared statements instead, and use PDO or MySQLi. This article will help you decide. — sjagr
– sjagr, Commented Nov 28, 2014 at 0:59
Look at how you made an easy task seem hard? This code is too big just to connect to a MySQL DB! — DLastCodeBender
– DLastCodeBender, Commented Nov 28, 2014 at 0:59

John Conde · Accepted Answer · 2014-11-28 01:05:43Z

7

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.

edited Nov 28, 2014 at 1:05

answered Nov 28, 2014 at 0:54

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to get php connect to mysql?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related