Page 1 of 1

PDO and SQLite3 problem

Posted: Tue Aug 07, 2007 8:42 pm
by jpratt
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


This is my connection string:

Code: Select all

<?php
//database connection
try {
    $db = new PDO('sqlite:drive.sqlite3'); //sqlite 3
}
catch (PDOException $error) {
   print "error: " . $error->getMessage() . "<br/>";
   die();
}
?>
And this is my SELECT on my page:

Code: Select all

require_once('db/config.php');

$sql = "SELECT * FROM user";
$prepstatement = $db->prepare($sql);
$prepstatement->execute();

while($row = $prepstatement->fetch()) {
    $id = $row["userID"];
}
if (!(isset($id))) {
header('newuser.php');
}
I am new to the whole PDO thing and dont understand why it is thowing this error:

Fatal error: Call to a member function execute() on a non-object in L:\PortableWebAp3.5.1\Program\www\localhost\index.php on line 6

any ideas?? Thanks.


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Tue Aug 07, 2007 9:16 pm
by Benjamin
It means that..

Code: Select all

$db->prepare($sql);
is not returning an object.

Re: PDO and SQLite3 problem

Posted: Wed Aug 08, 2007 4:27 am
by volka
please try

Code: Select all

<?php
//database connection
try {
    $db = new PDO('sqlite:drive.sqlite3'); //sqlite 3
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $error) {
   print "error: " . $error->getMessage() . "<br/>";
   die();
}
?>