Error Connecting to Database via PHP

Question

I am trying to connect to my database via PHP but get blank page when I run through Safari(http://pushchat.local:11111/test/databasename.php)

I can see my datbasename.php file under http://pushchat.local:11111/test/ as shown below: enter image description here

Following is my PHP code:

try
{
    if (!defined('APPLICATION_ENV'))
        define('APPLICATION_ENV', getenv('APPLICATION_ENV') ? getenv('APPLICATION_ENV') : ‘development’);

    require_once '../api_config.php';
    $config = $config[APPLICATION_ENV];

    $pdo = new PDO(
        'mysql:host=' . $config['db']['host'] . ';dbname=' . $config['db']['dbname'], 
        $config['db']['username'], 
        $config['db']['password'],
        array());

    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->query('SET NAMES utf8');

    echo 'Database connection successful!';
}
catch (Exception $e)
{
    echo 'Could not connect to the database. Reason: ' . $e;
}

I even tried to put a stop sigh using codebug but I think it never stops.

Thanks for your help.

what is the error? is apache and mysql running? did you check phpinfo() ? — zod, May 07 '15 at 20:19
Use your catch to output actual error messages `$errorMsg = $e->getMessage(); echo $errorMsg;` — Jay Blanchard, May 07 '15 at 20:20
Yes both MySql and Apache Servers are running and I don't see any error. the link i used is : http://pushchat.local:11111/test/database.php and i get blank page with no output. — ddesai, May 07 '15 at 20:40

Jay Blanchard · Answer 1 · 2015-05-08T11:33:36.023

3

You're missing a closing quote -

'mysql:host=' . $config['db']['host'] . ';dbname=' . $config['db']['dbname'].'',
-----------------------------------------------------------------------------^

Note the additional single-quote which balances the line. Error checking would have caught this.

edited May 08 '15 at 11:33

answered May 07 '15 at 20:38

Jay Blanchard

34,243
16
77
119

score 0 · Accepted Answer · answered May 07 '15 at 20:46

I'm Sorry But I'm Seeing database.php Not databasename.php.
Have You Even Checked If The File Exists?
Also Connecting To The Database Should Be Typed In Config File & You should require It In You're Main PHP File.
For Example The Config File Should Look Like This:

<?php
$connection = mysql_connect('localhost', 'root', 'password');  //here is the host, username and password of mysql account.instead of localhost type in your websites domain name. 
if (!$connection){                                              //and instead of password,type in your own password.
    die("Database Connection Failed" . mysql_error());
}
$select_db = mysql_select_db('test');
if (!$select_db){
    die("Database Selection Failed" . mysql_error());
}
?>

& The Main PHP Should Look Like this:

<?php
require('config.php'); //requires the config.php page
//rest of the code goes here...
?>

Also On Line 10,You Have Missed A Closing Single-Quote.

Notice the OP is using PDO. Please, [stop using `mysql_*` functions](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php). They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). Learn about [prepared statements](http://en.wikipedia.org/wiki/Prepared_statement) instead, and consider using PDO, [it's not as hard as you think](http://jayblanchard.net/demystifying_php_pdo.html). — Jay Blanchard, May 11 '15 at 21:14

Error Connecting to Database via PHP

2 Answers2