pdo bind_param错误

Question

我在插入表时出错了

杰森：

{"machine":"1","postage":"1","tracking":"1","lve":"1","notice":"4","content":"12","refresh":"1","location":"cityname"}

我怎么才能让这事继续下去？

thx

编辑修正了你们提到的错误

function addOptions ($postData, $dbh) {

//print_r($postData);
$result = json_decode($postData);
//$location = $result->location;
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO options (location, display_time ,content_time, refresh_time, machine_data, postage_data, tracking_data, lve_data) 
                    VALUES (:location, :display_time, :content_time, :refresh_time, :machine_data, :postage_data, :tracking_data, :lve_data) 
                    ON DUPLICATE KEY UPDATE 
                    display_time= :display_time, refresh_time= :refresh_time, machine_data= :machine_data, content_time= :content_time, postage_data= :postage_data, tracking_data= :tracking_data, lve_data= :lve_data";
$preparedStatement = $dbh->prepare($sql);
$preparedStatement->bindParam(':location', $result->location);
$preparedStatement->bindParam(':display_time', $result->display);
$preparedStatement->bindParam(':content_time', $result->content);
$preparedStatement->bindParam(':refresh_time', $result->refresh);
$preparedStatement->bindParam(':machine_data', $result->machine);
$preparedStatement->bindParam(':postage_data', $result->postage);
$preparedStatement->bindParam(':tracking_data', $result->tracking);
$preparedStatement->bindParam(':lve_data', $result->lve);
$preparedStatement->execute();

}

现在我得到了这个错误消息

警告: PDOStatement::execute()期望参数1是数组，在第186行的D:\xampp\htdocs\admin\include\function.php中给出字符串

Answer 1

很少有错误：

1. 添加pdo准备： $preparedStatement = $dbh->prepare($sql)；
2. 将所有bind_param更改为： $preparedStatement>bindParam(‘：display’，$result->display)；
3. 将execute添加到if条件中，以便查看它是否有效： 如果($preparedStatement>execute() === FALSE){引发新的\异常(‘糟糕的查询插入！’)；}