Jump to content

PHP OOP problem


cardwell164

Recommended Posts

i just started learning pdo and read this tutorial. read everything that was on it and somehow im having this problem and im stuck. anyway here is the code that i wrote.

<?php

$id = 5;

try
{
	$conn = new PDO('mysql:host=localhost;dbname=pdotuts', 'root', '');
	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

	$stmt = $conn->prepare('SELECT * FROM table WHERE id = :id');
	$stmt->execute(array
					(
						'id' => $id
					));

	while($row = $stmt->fetch())
	{
		print_r($row);
	}
}
catch(PDOException $e)
{
	echo 'ERROR: '. $e->getMessage();
}
?>

i saved the file as index.php and ran it in my browser. for some reason its giving me this error "ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table WHERE id = '5'' at line 1". i have been trying to debug this thing but had no luck in correcting it. i am hoping that someone could help me with this. i would really appreciate it.

Link to comment
https://forums.phpfreaks.com/topic/286039-php-oop-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.