PDO只插入一条记录

Question

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();
}


?>

Answer 1

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));