doujiu3097 2014-01-21 18:35
浏览 78
已采纳

PDO只插入一条记录

I have been trying to overcome this problem for a while now and i need your help on this.

The code on the below only insert one record in mysql table and only one. Data from html forms are posted very well but it simple doesn't record more than once. I also use phpmyadmin and i don't know what is the problem. I'd be appriciated if you could help me.

Here is the code:

   try {

    $DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass); 
    $STH1 = $DBH->query("SELECT isim, adet, kategori 
                             FROM stock 
                             WHERE isim = '$isim' AND kategori = '$kategori'");
    $STH1->setFetchMode(PDO::FETCH_ASSOC);
    if($STH1->rowCount() == 0) {
        echo "There is no such record";
    }
    else {

        $STH2 = $DBH->prepare("INSERT INTO outgoing 
                                       (isim, adet, nereye, cikis_tarih, kategori) 
                                       values 
                                       (:isim, :adet, :nereye, :cikis_tarih, :kategori)");
        $STH2->bindParam(':isim', $isim, PDO::PARAM_STR);
        $STH2->bindParam(':adet', $adet, PDO::PARAM_STR);
        $STH2->bindParam(':nereye', $nereye, PDO::PARAM_STR);
        $STH2->bindParam(':cikis_tarih', $cikis_tarih, PDO::PARAM_STR);
        $STH2->bindParam(':kategori', $kategori, PDO::PARAM_STR);
        $STH2->execute();

    }    

}

catch(PDOException $e) {
    echo $e->getMessage();
}


?>
  • 写回答

1条回答 默认 最新

  • douchen3562 2014-01-21 18:50
    关注

    Instead of doing:

    $STH2->bindParam(':isim', $isim, PDO::PARAM_STR);
    $STH2->bindParam(':adet', $adet, PDO::PARAM_STR);
    $STH2->bindParam(':nereye', $nereye, PDO::PARAM_STR);
    $STH2->bindParam(':cikis_tarih', $cikis_tarih, PDO::PARAM_STR);
    $STH2->bindParam(':kategori', $kategori, PDO::PARAM_STR);
    $STH2->execute();
    

    Execute it through an array:

    $STH2->execute(array(':isim'=>$isim,
                                    ':adet'=>$adet,
                                    ':nereye'=>$nereye,
                                    ':cikis_tarih'=>$cikis_tarih,
                                    ':kategori'=>$kategori));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集
  • ¥15 在启动roslaunch时出现如下问题
  • ¥15 汇编语言实现加减法计算器的功能
  • ¥20 关于多单片机模块化的一些问题
  • ¥30 seata使用出现报错,其他服务找不到seata
  • ¥35 引用csv数据文件(4列1800行),通过高斯-赛德尔法拟合曲线,在选取(每五十点取1点)数据,求该数据点的曲率中心。
  • ¥20 程序只发送0X01,串口助手显示不正确,配置看了没有问题115200-8-1-no,如何解决?
  • ¥15 Google speech command 数据集获取
  • ¥15 vue3+element-plus页面崩溃