1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
if(empty($update_page_errors)){
//Update
/*
$q="UPDATE pages, pages_tag SET pages.user_id=?,pages.cat_p_id=?,pages.status=?,pages.title=?,pages.summary=?,pages.ingredient=?,pages.recipe=?,pages.tips=?,pages.filename=?, pages_tag.tag_id=? WHERE pages.page_id=$page_id AND pages.page_id = pages_tag.page_id";
*/
$q ="UPDATE pages SET
pages.user_id=?
,pages.cat_p_id=?
,pages.status=?
,pages.title=?
,pages.summary=?
,pages.ingredient=?
,pages.recipe=?
,pages.tips=?
,pages.filename=?
WHERE pages.page_id=$page_id ";
$q .="UPDATE pages_tag
SET pages_tag.tag_id=?
WHERE pages_tag.page_id=$page_id ";
$stmt = mysqli_prepare($dbc,$q);
mysqli_stmt_bind_param($stmt, 'iisssssssi',$_POST['user_id'],$_POST['category'],$status, $title,$summary,$ingredient,$recipe,$tips,$filename,$tag);
$allowed='<div><p><span><br><a><img><h1><h2><h3><h4><ul><ol><li><blockquote>';
$status= strip_tags($_POST['status']);
$title= strip_tags($_POST['title']);
$summary= strip_tags($_POST['summary'], $allowed);
$ingredient= strip_tags($_POST['ingredient'], $allowed);
$recipe= strip_tags($_POST['recipe'], $allowed);
$tips= strip_tags($_POST['tips'], $allowed);
$filename = strip_tags($_POST['filename']);
$tag = implode(',', $_POST['tag']);
//mysqli_stmt_execute($stmt);
$result = mysqli_stmt_execute($stmt);
if ( $result === false ) {
printf("Error: %s.\n", mysqli_stmt_error($stmt));
}else {
if(mysqli_stmt_affected_rows($stmt) >= 1) {
mysqli_stmt_close($stmt);
$_POST = array();
echo'<div class="alert alert-success"><h3>Votre page à bien été modifié.</h3></div>';
}
}
}//END if array existe update
} |
Partager