Having an hard time fetching data from sql query using PHP PDO

Question

I have a script and connects to a database, then inserts data into a database. However I am having an issue fetching the data.

Here is the error message I get: Fatal error: Call to a member function fetchAll() on boolean in C:\xampp\htdocs\projects\forms\db.php on line 24

What am I doing wrong?

Here is the script

<?php
    //This script provides connection to the database//
    //Connect
    $user="root";
    $pass="";
    try {
        $connection = new PDO('mysql:host=localhost;dbname=thetest', $user, $pass);
    } catch (Exception $e) {
        print "Error!: " . $e->getMessage() . "<br/>";
    die();
    }

    //Insert
    try {
        $stmt = $connection->prepare("INSERT INTO `users`(`name`, `lastname`, `age`) VALUES(?,?,?)");
        $stmt->execute(array("Dave", "Smithers", "22"));
    } catch (Exception $e) {
        echo "Error!: " . $e->getMessage() . "<br/>";
        die();
    }

    //Fetch
    try {
        $stmt = $connection->prepare("SELECT `name` FROM `users` WHERE `lastname` = 'Smithers'");
        $result = $stmt->execute();
        $user = $result->fetchAll();
        print_r($user);
    } catch (Exception $e) {
        echo "Error!: " . $e->getMessage() . "<br/>";
    }
?>

php.net/pdo.prepared-statements

Funk Forty Niner
– Funk Forty Niner

2015-06-17 17:54:19 +00:00
Commented Jun 17, 2015 at 17:54 — Funk Forty Niner
– Funk Forty Niner, Commented Jun 17, 2015 at 17:54

score 3 · Accepted Answer · 2015-06-17 17:52:19Z

3

$stmt->execute() returns a boolean indicating success/failure.

Instead, use this:

$stmt->execute();
$result = $stmt->fetchAll();

edited Jun 17, 2015 at 17:52

answered Jun 17, 2015 at 17:48

user4413591

Sign up to request clarification or add additional context in comments.

3 Comments

Pratik Joshi Over a year ago

Should have been a comment

user4920811 Over a year ago

Really I can't detect difference in your code with the code question .. What is that ?

user4413591 Over a year ago

@stack - The user believed $stmt->execute() returned a result set when it returns a boolean

Collectives™ on Stack Overflow

Having an hard time fetching data from sql query using PHP PDO

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related