1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| <?php
$count=0;
if(count($cat_id)>0){
$sql = "INSERT IGNORE INTO article (id, id_article, titre_article, text_article, cat_id)
VALUES (NULL, id_article = :id_article, titre_article = :titre_article, text_article = :text_article, cat_id= :cat_id)";
$query = $db->prepare($sql);
foreach($cat_id as $c_id){
$parameters = array(':id_article' => $id_article,':titre_article' => $titre_article, ':text_article' => $text_article, , ':cat_id' => $c_id); $query->execute($parameters);
$count+=$query->rowCount();
}
}
else{
$sql = "INSERT IGNORE INTO article (id, id_article, titre_article, text_article, cat_id)
VALUES (NULL, id_article = :id_article, titre_article = :titre_article, text_article = :text_article, NULL)";
$query = $db->prepare($sql);
$parameters = array(':id_article' => $id_article,':titre_article' => $titre_article, ':text_article' => $text_article);
$query->execute($parameters);
$count+=$query->rowCount();
}
echo $count.' ligne(s) insérée(s)<br/>'; |
Partager