<?php // page-update_base.php // include connection file require_once "db.php"; //récupération "propre" des variable) $id = !empty($_POST['id']) ? $_POST['id'] : NULL; $url = isset($_POST['url']) ? $_POST['url'] : ""; $text = isset($_POST['text']) ? $_POST['text'] : ""; function update_newsletter($url,$titre,$id){ $sql = "UPDATE tbl_newsletter SET url_$id = :url, titre_url_$id = :text WHERE newsletter_id = :id"; $datas = array(":url"=>$url, ":text"=>$text, ":id"=>$id); return queryExec($sql,$datas); } function queryExec($sql,$a_datas){ global $db; try { $req = $db->prepare($sql); $res = $req->execute($datas); $result = array( 'status'=> $res, 'msg'=>'Saisie enregistrée avec success !', 'debug'=>array("requete"=>$sql, "datas"=>$datas) ); } catch (Exception $e) { //erreur dans la requete $result = array( 'status'=>false, 'msg'=>'Erreur ! '.$e->getMessage(), 'debug'=>array("requete"=>$sql, "datas"=>$datas) ); } return $result; } if($id == 1 || $id==2 || $id==3){ $msg = update_newsletter($url,$titre,$id) } else { //pas d'ID $msg = array( 'status'=>false, 'msg'=>"Erreur ! ID de ligne vide !", 'debug'=>$_POST ); } // send data as json format echo json_encode($msg);
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
if($id == 1 || $id==2 || $id==3){
$msg = update_newsletter($url,$titre,$id)
} else {
//pas d'ID
$msg = array( 'status'=>false,
'msg'=>"Erreur ! ID de ligne vide !",
'debug'=>$_POST
);
}
<?php // page-update_base.php // include connection file require_once "db.php"; function update_newsletter($url,$text,$id){ $sql = "UPDATE tbl_newsletter SET url_lien = :url, titre_url_lien = :text WHERE newsletter_id = :id"; $datas = array(":url"=>$url, ":text"=>$text, ":id"=>$id); return queryExec($sql,$datas); } function queryExec($sql,$a_datas){ global $db; try { $req = $db->prepare($sql); $res = $req->execute($datas); $result = array( 'status'=> $res, 'msg'=>'Saisie enregistrée avec success !', 'debug'=>array("requete"=>$sql, "datas"=>$datas) ); } catch (Exception $e) { //erreur dans la requete $result = array( 'status'=>false, 'msg'=>'Erreur ! '.$e->getMessage(), 'debug'=>array("requete"=>$sql, "datas"=>$datas) ); } return $result; } //récupération "propre" des variable) $id = !empty($_POST['id']) ? $_POST['id'] : NULL; $url = isset($_POST['url']) ? $_POST['url'] : ""; $text = isset($_POST['text']) ? $_POST['text'] : ""; if($id){ $msg = update_newsletter($url,$titre,$id) } else { //pas d'ID $msg = array( 'status'=>false, 'msg'=>"Erreur ! ID de ligne vide !", 'debug'=>$_POST ); } // send data as json format echo json_encode($msg);
// include connection file
require_once "db.php";
$sql = 'SELECT * FROM tbl_newsletter WHERE newsletter_id = 1 OR newsletter = 2 OR newsletter_id = 3';
$req = $db->prepare($sql);
$req->execute();
$row = $req->fetch();
<div>
<h4>Item 1</h4>
<p>Incenderat autem audaces usque ad insaniam homines ad haec, quae nefariis egere conatibus, Luscus quidam curator urbis subito visus: eosque ut heiulans baiolorum praecentor ad expediendum quod orsi sunt incitans vocibus crebris. qui haut longe postea ideo vivus exustus est.</p>
<div ><a href="<?php echo $row['url_lien']; ?>" class="row-edit" data-type="link" data-id="<?php echo $row['newsletter_id']; ?>"><?php echo $row['titre_url_lien']; ?></a></div>
</div>
<div>
<h4>Item 2</h4>
<p>Incenderat autem audaces usque ad insaniam homines ad haec, quae nefariis egere conatibus, Luscus quidam curator urbis subito visus: eosque ut heiulans baiolorum praecentor ad expediendum quod orsi sunt incitans vocibus crebris. qui haut longe postea ideo vivus exustus est.</p>
<div ><a href="<?php echo $row['url_lien']; ?>" class="row-edit" data-type="link" data-id="<?php echo $row['newsletter_id']; ?>"><?php echo $row['titre_url_lien']; ?></a></div>
</div>
<div>
<h4>Item 3</h4>
<p>Splendida porro oculi fugitant vitantque tueri. sol etiam caecat, contra si tendere pergas,propterea quia vis magnast.</p>
<div ><a href="<?php echo $row['url_lien']; ?>" class="row-edit" data-type="link" data-id="<?php echo $row['newsletter_id']; ?>"><?php echo $row['titre_url_lien']; ?></a></div>
</div>