PHP isn't connecting to MySQL DB
I've been developing a PHP / MySQL database-driven website locally on XAMPP. Everything works perfectly fine and as expected, so, with some data in the database I decided it was time to finally upload the website files and DB to my web host MediaTemple on the Grid-Server service.
Unfortunately the PHP isn't connecting to the MySQL DB, for some reason.
Please see the following database-driven PHP pages which aren't connecting to the MySQL DB:
As you can see from the links - No error messages and also no data from the MySQL DB either. My DB connection is as follows (the details aren't the real details, but they are correct when they are the real details):
The (mt) support guy tested the connection with an mttest database user without error and found that the database server itself is working and accepting connections. He also mentioned that the DB connection script that I've pasted above was configured correctly so this is likely not an issue, which means it must be something to do with the other PHP files I've got.
$pdo = new PDO('mysql:host=internal-db.s00000.gridserver.com;dbname=db00000_huffier', 'db00000', 'password');
$pdo->exec('SET NAMES "utf8"');
catch (PDOException $e)
$output = 'Unable to connect to the database server.';
This index.php file is located in the "library" folder:
And this is the library.html.php file, also located in the "library" folder:
include $_SERVER['DOCUMENT_ROOT'] . '/includes/dbconnection.inc.php';
$sql = 'SELECT bookTitle, bookSlugName FROM books';
$result = $pdo->query($sql);
catch (PDOException $e)
$error = 'Error fetching books: ' . $e->getMessage();
foreach ($result as $row)
$books = array(
'name' => $row['bookTitle'],
'slug' => $row['bookSlugName']
And the "error.php" files, also located in the "library" folder just replaces the PHP containers in the "library.html.php" file with <?php echo error; ?>.
<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/huffier.com/includes/helpers.inc.php'; ?>
<meta name="description" content="Browse through all of the eBook titles available in the Huffier digital library on this page.">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Library – Huffier</title>
<!--[if lt IE 9]>
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'>
<link rel="stylesheet" media="screen" href="../css/stylesheet.css">
<?php include_once("../analyticstracking.php") ?>
<?php include_once("../includes/nav.php") ?>
<?php foreach ($books as $book): ?>
<a href="title/?slug=<?php htmlout($book['slug']); ?>">
<img src="../images/covers/<?php htmlout($book['slug']); ?>.png" alt="<?php htmlout($book['name']); ?>"/>
<?php endforeach; ?>
Any bright ideas as to what has gone woefully wrong with my scripting? :(
Any pointers in the right direction (or a solution) would be greatly appreciated!