donglei1616 2018-05-12 10:36
浏览 69
已采纳

PHP PDO查询执行不保存传递的数据

I've a problem with PDO prepared statements using mysql. When the query is executed it will save into the preposed table the placeholders that I've binded using the bindParam() method. Here is the code and here is a screen of the result of the execution of the query. How i can solve this embaracing problem? I'm a newbie on PDO!

PHP (This is the controller that is called using ajax).

if(isset($_POST['code'])){

$code = filter_var($_POST['code'],FILTER_SANITIZE_STRING);    
$qty = filter_var($_POST['quantity'],FILTER_SANITIZE_STRING);  
$brand = filter_var($_POST['brand'],FILTER_SANITIZE_STRING);
$article_name = filter_var($_POST['artName'],FILTER_SANITIZE_STRING);  
$price = filter_var($_POST['price'],FILTER_SANITIZE_STRING);
$article_type = filter_var($_POST['artType'],FILTER_SANITIZE_STRING); 
$note = filter_var($_POST['note'],FILTER_SANITIZE_STRING);    

$save = $core->insert_article($code,$qty,$brand,$article_name,$price,$article_type,$note);    

if($save){
echo 'ok';    
} else {
echo 'error';    
}

}

PHP 2 (this is the function of the class who manage all the database operations)

public function insert_article($code,$qty,$brand,$article_name,$price,$article_type,$note){

$db = $this->init_db();    

$sql = "INSERT INTO products (cod_articolo, pezzi_disponibili, marca, nome_articolo, prezzo, tipologia_articolo, note) VALUES (':cod_articolo',':pezzi_disponibili',':marca',':nome_prodotto',':prezzo',':tipologia_articolo',':note')";    
$stmt = $db->prepare($sql);    

$stmt->bindParam(':cod_articolo',$code,PDO::PARAM_STR);
$stmt->bindParam(':pezzi_disponibili',$qty,PDO::PARAM_STR);
$stmt->bindParam(':marca',$brand,PDO::PARAM_STR);
$stmt->bindParam(':nome_articolo',$article_name,PDO::PARAM_STR);
$stmt->bindParam(':prezzo',$price,PDO::PARAM_STR);
$stmt->bindParam(':tipologia_articolo',$article_type,PDO::PARAM_STR);
$stmt->bindParam(':note',$note,PDO::PARAM_STR);

if($stmt->execute()){
echo 'ok';    
} else {
echo 'error';    
}    

}

This is the screen of the results after that the query is executed table after query execution

  • 写回答

1条回答 默认 最新

  • douxuan4556 2018-05-12 10:41
    关注

    Try removing the single quotes surrounding the binding part

    $sql = "INSERT INTO products (cod_articolo, pezzi_disponibili, marca, nome_articolo, prezzo, tipologia_articolo, note) VALUES (:cod_articolo,:pezzi_disponibili,:marca,:nome_prodotto,:prezzo,:tipologia_articolo,:note)";    
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

    报告相同问题?

    悬赏问题

    • ¥15 c++图Djikstra算法求最短路径
    • ¥15 Linux操作系统中的,管道通信问题
    • ¥15 ansible tower 卡住
    • ¥15 等间距平面螺旋天线方程式
    • ¥15 通过链接访问,显示514或不是私密连接
    • ¥100 系统自动弹窗,键盘一接上就会
    • ¥50 股票交易系统设计(sql语言)
    • ¥15 调制识别中这几个数据集的文献分别是什么?
    • ¥15 使用c语言对日志文件处理
    • ¥15 请大家看看报错原因,为啥会这样