CODEWITHSUNDEEP
phpmysqlpdo
Sizzling Code
Sizzling Code

Reputation: 6090

PHP PDO, connection works buy query not executing

i am new to PDO.

Here is what i have done so far,

Created file "pdotest.php"

Code Inside that file

<?php

try {
    $conn = new PDO('mysql:host=localhost;dbname=houserentsystem;charset=utf8', 'root', 'admin');
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}
$stmt = $conn->query("SELECT roomName FROM roomName.roomnames");
$results = $stmt->fetchAll();
$stmt->closeCursor();
print_r($results);
var_dump($results);

it should display some results from database but instead it says 500 internal server error in firebug, but no error on screen, its a white blank screen.

Upvotes: 0

Views: 61

Answers (2)

user3791372
user3791372

Reputation: 4695

$stmt = $conn->query("SELECT roomName FROM roomName.roomnames");

try this instead:

$stmt = $conn->query("SELECT roomName FROM roomnames");

The select syntax is (basically):

SELECT column[, another_column, ...] FROM tablename[WHERE condition][ORDER BY some_column ASC/DESC];`

As you are setting the error mode to PDO::ERRMODE_EXCEPTION, you'll need to use try/catch to see any errors. This brings the burden of wrapping try/catch statements around your db queries.

Check your php log file for the exact php error - a white screen is shown as php is probably set up not to display errors on screen.

Upvotes: 2

Alex Szabo
Alex Szabo

Reputation: 3276

I'd check this part: 

SELECT roomName FROM roomName.roomnames

Are you really trying to select roomName column from a table named roomName.roomnames? Should it not be the other way around like

SELECT roomnames FROM roomName

?

Upvotes: 0

Related Questions