Fetch_array alternative for PHP prepared statements

Question

UPDATE

        $stmt = $this->db->prepare("
SELECT u.id,    u.fname,    u.lname,    u.mname,  u.type, u.email, u.salt,
       u.pass,  u.salt,     u.approved, u.ban,      u2.status
FROM `users` AS u
    LEFT OUTER JOIN `log` AS u2
        ON u2.user_id = u.id
WHERE u.email = ? LIMIT 1") or die($this->db->error);

        $stmt->bind_param("s", $_POST['email']) or die($stmt->error);
        $stmt->execute();
        $stmt->store_result();
        if ($stmt->num_rows == 0) {
            die($this->ajax->respond(7));
        }
        $result = $stmt->get_result();
        $data = $result->fetch_array(MYSQLI_BOTH);

Trying to fetch array but getting following error for last line

Fatal error: Call to a member function fetch_array() on a non-object

Can't get it work. Please help

not sure about the answer but try to use $stmt instead of $result... — Desolator
– Desolator, Commented Jan 29, 2012 at 1:26
@epic_syntax ok if $result is a boolean 1, why would $result->anythingatall work? — Hamish
– Hamish, Commented Jan 29, 2012 at 2:28

itachi · Accepted Answer · 2012-01-29 05:48:48Z

0

 $data = $stmt->fetchAll();

PDO gives this beautiful function for that purpose.

Edit: i thought it was PDO interface. Why you aren't using pdo? I find it way comfortable than mysqli.

answered Jan 29, 2012 at 5:48

itachi

6,3933 gold badges33 silver badges41 bronze badges

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

Comments

deceze · Accepted Answer · 2012-01-29 01:30:44Z

0

mysqli_stmt::execute does not return the result, only true or false. You fetch the result from the mysqli_stmt object itself. Please carefully read the examples at http://php.net/manual/en/mysqli-stmt.execute.php and http://php.net/manual/en/mysqli-stmt.fetch.php.

answered Jan 29, 2012 at 1:30

deceze♦

525k89 gold badges807 silver badges954 bronze badges

2 Comments

heron Over a year ago

Please take a look at Robert Pitts answer stackoverflow.com/questions/5679600/…

deceze Over a year ago

Well, look at the manual. mysqli_stmt::execute does not return an object.

Wrikken · Accepted Answer · 2012-01-29 01:39:12Z

0

With get_result() you can get a resultset from the executed statement:

    $stmt->execute();
    $result = $stmt->get_result();
    while ($row = $result->fetch_array(MYSQLI_BOTH))
    {

answered Jan 29, 2012 at 1:39

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

2 Comments

heron Over a year ago

Please take a look on updated question: modified code by your suggestion. Nothing has changed

user67416 Over a year ago

What if I want to get the nth result? MySQLi is f'ed up.

Collectives™ on Stack Overflow

Fetch_array alternative for PHP prepared statements

UPDATE

3 Answers 3

Comments

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

UPDATE

3 Answers 3

Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related