duanhuan8983 2015-11-09 12:16
浏览 285

mysqli bind_param类型中的元素数与绑定变量不匹配

I have this query:

qry=INSERT INTO assessments (Speaking_and_listening, Reading, Writing, Number, Measure, Geometry, Statistics, Science, ICT, Health_and_well_being, Relationships, Living_in_the_wider_world ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

I ceated two variables and a loop to do the binding:

foreach ($subjectListArray as $key=>$subject){
$sss .='s'; 
if (!isset($_POST[str_replace(" ","_",$subject)])){
    $fieldNameValues.='fred';   
}else{
    $fieldNameValues.=$_POST[str_replace(" ","_",$subject)];
}
if ($key!=(count($subjectListArray)-1)){
    $sss.=' ,';
    $fieldNameValues.=', ';
}
}

When I print out the two arrays $sss and $fieldNameValues I get this:

s ,s ,s ,s ,s ,s ,s ,s ,s ,s ,s ,s
p2iic, fred, fred, fred, fred, fred, fred, fred, fred, fred, fred, fred

Which looks right to me.

However when prepare and bind thus:

$record= $conn->prepare($qry);  
$record-> bind_param($sss, $fieldNameValues);

I get errors telling me

Warning: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables

which as far as I can see it does - there are 12 in the $ary, and twelve in $sss and 12 in $fieldNamesValues

What's wrong please?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
    • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
    • ¥16 mybatis的代理对象无法通过@Autowired装填
    • ¥15 可见光定位matlab仿真
    • ¥15 arduino 四自由度机械臂
    • ¥15 wordpress 产品图片 GIF 没法显示
    • ¥15 求三国群英传pl国战时间的修改方法
    • ¥15 matlab代码代写,需写出详细代码,代价私
    • ¥15 ROS系统搭建请教(跨境电商用途)
    • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。