mysql - PHP MySQLI::bind_result issue -
i'm having issue trying bind result. php keeps outputting error 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 starts referencing other links, have looked , down stackoverflow , done little searching on google well. examples i've found, including php.net, correct... evidently it's not.
here have:
function __verify($digit4, $woid) { $query = $this->mysql->prepare("select * pc_wo wo left join pc_owner owner on owner.pcid=wo.pcid wo.woid=? , 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 suppose can't use bind_result wildcard select (*)... use in accordance mysqli_stmt fetch entire array?
thank you!
the answer in documentation
Comments
Post a Comment