proses.php

<?php
session_start();
if($_SESSION['user_group'] <> 'Administrator'){
    header('location:../../id/error');
}
?>
<?php
include "../../connection.php";
if ($_POST['submit']) {
    try {
        // $sql = "INSERT INTO tw_blog (user_id, blog_username, blog_cat_id, blog_images, blog_date, blog_title, blog_body, blog_link) VALUES ('$_SESSION[user_id]', '$_POST[blog_username]', '$_POST[blog_cat_id]', '$_POST[blog_images]', '$_POST[blog_date]', '$_POST[blog_title]', '$_POST[blog_body]', '$_POST[blog_link]')";
        // $tw_blog = $db->prepare($sql);
        $tw_blog = $db->prepare("INSERT INTO tw_blog (user_id, blog_username, blog_cat_id, blog_images, blog_date, blog_title, blog_body, blog_link) VALUES  (:user_id, :blog_username, :blog_cat_id, :blog_images, :blog_date, :blog_title, :blog_body, :blog_link)");
        $tw_blog->BindParam(':user_id',$_SESSION['user_id']);
        $tw_blog->BindParam(':blog_username',$_POST['blog_username']);
        $tw_blog->BindParam(':blog_cat_id',$_POST['blog_cat_id']);
        $tw_blog->BindParam(':blog_images',$_POST['blog_images']);
        $tw_blog->BindParam(':blog_date',$_POST['blog_date']);
        $tw_blog->BindParam(':blog_title',$_POST['blog_title']);
        $tw_blog->BindParam(':blog_body',$_POST['blog_body']);
        $tw_blog->BindParam(':blog_link',$_POST['blog_link']);

    // inserting a record
        $tw_blog->execute();

    // jika TIDAK ada baris yg terpengaruh (data gagal masuk ke database) maka cetak “gagal”
        if($tw_blog->rowCount()==0){
            echo "Gagal";
        }
    //Jika ada baris yang terpengaruh (data berhasil masuk) cetak “berhasil”
        else{
            echo "Berhasil";
        }

        // print_r($tw_blog->errorInfo());
    } catch (PDOException $exception) {
        echo "Error: " . $exception->getMessage();
    }
}
?>