fetch_array with prepared statement? PHP MYSQL?

Question

For some reason I cannot get this to work for the life of me, I am new to prepared statements!


    $q = $dbc -> prepare ("SELECT * FROM accounts WHERE email = ? && logcount = ''");
    $q -> bind_param ('s', ($_SERVER['QUERY_STRING']));
    $row = $q -> fetch_array(MYSQLI_ASSOC);
    $q -> execute();
    $q -> store_result();
        if ($q -> num_rows == 1) {
            $q = $dbc -> prepare("UPDATE accounts SET logcount = '0' WHERE email = ?");
            $q -> bind_param('s', ($_SERVER['QUERY_STRING']));
            $q -> execute();
            echo 'Congratulations ' . $row['username'] . ' your account is now active!';
        }

Any ideas why $row['username'] will not print? It returns a : Call to undefined method mysqli_stmt::fetch_array()

Thanks.

us2.php.net/manual/en/mysqli-stmt.prepare.php browse down to Example 1. There is no fetch_array() method. you need to "bind result" — FoneyOp
– FoneyOp, Commented Apr 15, 2011 at 16:21

gen_Eric · Accepted Answer · 2011-04-15 16:21:22Z

4

You don't need fetch_array in this case.

If you want to use get the data from the query, you need to use bind_result and fetch after calling execute.

answered Apr 15, 2011 at 16:21

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

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

Comments

a1ex07 · Accepted Answer · 2011-04-15 16:18:17Z

1

You need to call $q -> execute(); prior to fetching result.

answered Apr 15, 2011 at 16:18

a1ex07

37.4k12 gold badges94 silver badges104 bronze badges

1 Comment

Basic Over a year ago

I did that, and edited my question, it throws the same error, thanks.

Community · Accepted Answer · 2018-02-07 10:22:30Z

0

You seem to be doing it wrong, when you call execute it returns a result object, which is what you call your fetch methods on:

$q = $dbc->prepare ("SELECT * FROM accounts WHERE email = ? && logcount = ''");
$q->bind_param ('s', ($_SERVER['QUERY_STRING']));

//Updated Here
$result = $q -> execute();

if ($result->num_rows == 1)
{
    $assocData = $result->fetch_array(MYSQLI_ASSOC);
    //Do other stuff
}

edited Feb 7, 2018 at 10:22

CommunityBot

11 silver badge

answered Apr 15, 2011 at 16:24

RobertPitt

57.3k21 gold badges117 silver badges161 bronze badges

Collectives™ on Stack Overflow

fetch_array with prepared statement? PHP MYSQL?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related