douyu1990 2012-10-30 08:09
浏览 68
已采纳

mysqli - mysqli_stmt :: bind_param()应该是一个参考

This is my class code:

class DAL
{

public function paramtypez($val)
{
        $types = '';                        //initial sting with types
        foreach($val as $para) 
        {     
            if(is_int($para)) {
                $types .= 'i';              //integer
            } elseif (is_float($para)) {
                $types .= 'd';              //double
            } elseif (is_string($para)) {
                $types .= 's';              //string
            } else {
                $types .= 'b';              //blob and unknown
            }
        }
        return $types;
}

 public function execsql($query,$param)
{
    $conn=new mysqli("127.0.0.1","root","","sample");

    if($row=$conn->prepare($query))
    {
        array_unshift($param,array(DAL::paramtypez($param)));
        call_user_func_array(array($row, 'bind_param'), $param);

        $row->execute();
        return true;
    }
    else
    return false;

}
}

and is use this class like this:

$vars = new DAL();
$vars->execsql('insert into tesst (name,family,age) values(?,?,?)',array('mori','gre','25'));

but that's return me this error:

 Warning: Parameter 2 to mysqli_stmt::bind_param() expected to be a reference, value given in ..\htdocs\inc.php on line 30

how can fix this error? thanks for any help

  • 写回答

2条回答 默认 最新

  • doujia6433 2012-10-30 08:24
    关注

    $param looks like this right before you pass it to call_user_func_array:

    [['ssi'],'mori','gre','25']
    

    This is incorrect. You should change this:

    array_unshift($param,array(DAL::paramtypez($param)));
    

    To this:

    array_unshift($param,DAL::paramtypez($param));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 求解决扩散模型代码问题
  • ¥15 工创大赛太阳能电动车项目零基础要学什么
  • ¥20 limma多组间分析最终p值只有一个
  • ¥15 nopCommerce开发问题
  • ¥15 torch.multiprocessing.spawn.ProcessExitedException: process 1 terminated with signal SIGKILL
  • ¥15 QuartusⅡ15.0编译项目后,output_files中的.jdi、.sld、.sof不更新怎么解决
  • ¥15 pycharm输出和导师的一样,但是标红
  • ¥15 想问问富文本拿到的html怎么转成docx的
  • ¥15 我看了您的文章,遇到了个问题。
  • ¥15 GitHubssh虚拟机连接不上