PHP MySQLI::bind_result issue

Question

I'm having an issue trying to bind my result. PHP keeps outputting an error with the following

Warning: mysqli_stmt::bind_result(): Number of bind variables doesn't match number of fields in prepared statement in /var/www/public_html/test.php on line 38

Now before anyone starts referencing other links, I have already looked up and down stackoverflow and done a little searching on Google as well. All the examples I've found, including PHP.net, say this is correct... But evidently it's not.

Here is what I have:

function __verify($digit4, $woid) {
    $query = $this->mysql->prepare("SELECT * FROM pc_wo wo LEFT JOIN pc_owner owner ON owner.pcid=wo.pcid WHERE wo.woid=? AND SUBSTRING(owner.pcphone, -4)=?");
    $query->bind_param("is",$woid,$digit4);
    if ( !$query->execute() ) return false;
    $query->bind_result($resp);
    $query->fetch();

    var_dump($resp);
    return true;
}

EDIT I suppose you can't use bind_result for a wildcard select (*)... So what do I use in accordance with mysqli_stmt to fetch an entire array?

Thank you!

@LiamSorsby Negative. Tried it out & it duplicated the error. — user0000001
– user0000001, Commented Aug 12, 2013 at 19:39

user0000001 · Accepted Answer · 2013-08-12 20:12:14Z

1

My solution was using the pseudo method:

private function __compile($handler)
{
    $meta = $handler->result_metadata();
    while ($field = $meta->fetch_field()) {
        $params[] = &$row[$field->name];
    }

    call_user_func_array(array($handler, 'bind_result'), $params);

    while ($handler->fetch()) {
        foreach($row as $key => $val) {
          $x[$key] = $val;
        }
        $results[] = $x;
    }

    return $results;
}

This might be a solution, but why does MySQLi not incorporate a prepared statement for wildcard statements?

answered Aug 12, 2013 at 20:12

user0000001

2,2733 gold badges29 silver badges58 bronze badges

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

3 Comments

Your Common Sense Over a year ago

it does. in the form of get_result.

huysentruitw Over a year ago

Use PDO then. See stackoverflow.com/questions/13569/…

user0000001 Over a year ago

@WouterHuysentruit Great suggestion. I jumped on board to MySQLi because I am just parting away from the old PHP MySQL extension and thought it would be familiar... But after looking at PDO, the OO aspect of things is very interesting :o... Thanks for this share.

Your Common Sense · Accepted Answer · 2013-08-12 20:08:41Z

0

if you get lucky enough, you can use get_result():

if ( !$query->execute() ) return false;
$res = $query->get_result();
$row = $res->fetch-assoc();

if not - you are bound to use these get_metadata() tricks from other answer.

answered Aug 12, 2013 at 20:08

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Collectives™ on Stack Overflow

PHP MySQLI::bind_result issue

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related