Can't connect to my database.

SportinStyle

Hello guys, first time poster, long time reader.

I was attempting to connect to my database, using both of the following codes (in different scripts of course), and each time the page brings up the standard error that shows when their is no such script existant.

Code 1:

<?php # SQL CONNECT
ini_set('display_errors', 1);  // set to zero for production version
error_reporting(E_ALL); 
DEFINE ('DB_USER', 'testdatabase1');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'host');
DEFINE ('DB_NAME', 'testdatabase1');
$dbc = @sql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
@mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error());
?>

and Code2:

<?php
$host = "experienceascension.com";
$user = "testdatabase1";
$pass = "password";
$database = "testdatabase1";

//connect to database
$connection = @mysql_connect($host, $user, $pass);

//select a database to work with
$selected = @mysql_select_db($database, $connection);
or die( "<BR><BR><B>Error: Could not establish connection"); 
?>

Any idea's guys?

NogDog

For debugging purposes, I would recommend you get rid of all the "@" error-suppression operators for now. You may also want to add the following lines to make sure PHP tells you anything it sees that might be "interesting":

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

In the production version, you can change those error settings so that errors are logged instead of displayed, etc.; but for now you want all the information you can get.

SportinStyle

Fatal error: Call to undefined function sql_connect() in /hermes/bosweb/web267/b2675/ipw.experienceascension/public_html/test/mysqlconnect.php on line 8

I took off the suppression operators, and got the above error now.

Using this code:

<?php # SQL CONNECT
ini_set('display_errors', 1);
error_reporting(E_ALL); 
DEFINE ('DB_USER', 'testdatabase1');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'host');
DEFINE ('DB_NAME', 'testdatabase1');
$dbc = sql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error());
?>

Of course, I am specifying a specific password and hostname, that I know works. I just changed here, for the sake of obvious security.

Any ideas? Thanks.

laserlight

Right. Perhaps you wanted to use mysql_connect() instead of sql_connect()?

phpnewbiedublin

If your local testing then use localhost instead of host in DEFINE ('DB_HOST', 'host');

regards