I'm trying PDO for the first time. I'm sure I'm doing it wrong, but no matter what's wrong with my code, I can't get it to display or work.
<?
$dsn ='msql:dbname=mdbpinball;host=localhost';
$user = 'root';
$password = '';
try {
$dbh = new PDO($dsn, $user, $password);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION):;
} catch (PDOException $e){
echo 'Connection failed: ' . $e->getMessage();
}
$sql = "SELECT * FROM machine WHERE `m_ipdb`=:m_ipdb OR `m_name`=:m_name";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(":m_ipdb", $_GET['searchText']);
$stmt->bindParam(":m_name", $_GET['searchText']);
$stmt->execute();
if($result = $stmt->fetch(PDO::FETCH_OBJ)){
echo "IPDB: " . $result->m_ipdb;
echo "Name: " . $result->m_name;
}
?>
Whenever I run my code on the server (test server), it just spits out the code in the window like this:
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION):; } catch (PDOException $e){ echo 'Connection failed: ' . $e->getMessage(); } $sql = "SELECT * FROM machine WHERE m_ipdb=:m_ipdb OR m_name=:m_name"; $stmt = $pdo->prepare($sql); $stmt->bindParam(":m_ipdb", $_GET['searchText']); $stmt->bindParam(":m_name", $_GET['searchText']); $stmt->execute(); if($result = $stmt->fetch(PDO::FETCH_OBJ)){ echo "IPDB: " . $result->m_ipdb; echo "Name: " . $result->m_name; } ?>
What am I doing wrong (other than the errors in my code to begin with)? How do I get PDO to run properly?
I have checked and I believe it is enabled on my test server.
Thanks.