CRUD Dasar Laravel Dengan JQuery Tabledit + Datatables dan PostgreSQL

Lanjutkoding.com - Berbicara mengenai data, yaitu berbicara juga mengenai cara pengolahannya. Jika kebanyakan tutorial laravel hanyalah membahas crud biasa, pada kesempatan kalai ini crud laravel akan membahas crud yang luar biasa yaitu membuat live insert, update, delete langsung di table yang kita tampilkan pada halaman UI website kita.

pixabay.com

Harapan dari tutorial ini kamu bisa menggunakan laravel, kamu bisa menerapkan jquery editable pada laravel. Serta kamu bisa menggunakan database postgresql.

Gols dari pembahasan kali ini adalah :

1. Kamu bisa menulis kode dengan rapih

2. Kamu bisa melakukan konfigurasi laravel

3. Kamu mengenal PostgreSQL

<?php 
include_once 'config/dbcon.php';
session_start();

//tangkap proses dari tombol botton
//sql injection
function anti_injection($string) {
    $data = stripslashes(strip_tags(htmlentities(htmlspecialchars($string, ENT_QUOTES))));
    return $data;
}

if(isset($_POST['btnlogin'])){
    $nopeg = anti_injection($_POST['nopeg']);
    $password = anti_injection(md5($_POST['password']));

    //fitur tanpa remember me
    $sql = "SELECT * FROM trx_user WHERE nopeg='$nopeg' && password='$password' ";
    $result = $koneksi->query($sql); 
    $row = $result->num_rows;
    //===============================================================================
    $sql = $koneksi->query("SELECT * FROM trx_user WHERE nopeg='$nopeg' ");
    $data = $sql->fetch_array();
 
if($row > 0){ //jika data ada
    // cek jika user login sebagai superadmin
    if($data['role']=="superadmin"){
        $_SESSION["loggedin"] = true;
        $_SESSION['nopeg'] = $nopeg;
        $_SESSION['role'] = "superadmin";
        $_SESSION['user'] = $data['nama_user'];
        $_SESSION['email'] = $data['email'];
        $_SESSION['unit'] = $data['code_devisi'];
        $_SESSION['id_user'] = $data['id_user'];
        $sub_query = "
        INSERT INTO login_details 
        (user_id) 
        VALUES ('".$data['id_user']."')
        ";
        $sql = $koneksi->query($sub_query); 
        $_SESSION['login_details_id'] = $koneksi->insert_id;
        //rememberme check apa tidak
        // cek rememberme
        //===============================================================
        //jika rememberme di klik
        if(!empty($_POST["remember"])) {
            //buat cookie
            setcookie ("user_login",$_POST["nopeg"],time()+ (3600 * 365 * 24 * 60 * 60));
            setcookie ("userpassword",$_POST["password"],time()+ (3600 * 365 * 24 * 60 * 60));
        } else {
            if(isset($_COOKIE["user_login"])) {
             setcookie ("user_login","");
           }
           if(isset($_COOKIE["userpassword"])) {
             setcookie ("userpassword","");
           }
         }
        //direct halaman
    echo "<script type='text/javascript'>
    window.top.location='dashboard.php';
    </script>"; 
    exit;

    // cek jika user login sebagai lokasi
    }else if($data['role']=="lokasi"){
        $_SESSION["loggedin"] = true;
        $_SESSION['nopeg'] = $nopeg;
        $_SESSION['role'] = "lokasi";
        $_SESSION['user'] = $data['nama_user'];
        $_SESSION['email'] = $data['email'];
        $_SESSION['id_user'] = $data['id_user'];
        $_SESSION['unit'] = $data['code_devisi'];
        $sub_query = "
        INSERT INTO login_details 
        (user_id) 
        VALUES ('".$data['id_user']."')
        ";
        $sql = $koneksi->query($sub_query); 
        $_SESSION['login_details_id'] = $koneksi->insert_id;
        //rememberme check apa tidak
        // cek rememberme
        //===============================================================
        //jika rememberme di klik
        if(!empty($_POST["remember"])) {
            //buat cookie
            setcookie ("user_login",$_POST["nopeg"],time()+ (3600 * 365 * 24 * 60 * 60));
            setcookie ("userpassword",$_POST["password"],time()+ (3600 * 365 * 24 * 60 * 60));
        } else {
            if(isset($_COOKIE["user_login"])) {
             setcookie ("user_login","");
           }
           if(isset($_COOKIE["userpassword"])) {
             setcookie ("userpassword","");
           }
         }
        //direct halaman
    echo "<script type='text/javascript'>
    window.top.location='dashboard.php';
    </script>"; 
    exit;

    // cek jika user login sebagai pa
    }else if($data['role']=="pa"){
        $_SESSION["loggedin"] = true;
        $_SESSION['nopeg'] = $nopeg;
        $_SESSION['role'] = "pa";
        $_SESSION['user'] = $data['nama_user'];
        $_SESSION['email'] = $data['email'];
        $_SESSION['id_user'] = $data['id_user'];
        $_SESSION['unit'] = $data['code_devisi'];
        $sub_query = "
        INSERT INTO login_details 
        (user_id) 
        VALUES ('".$data['id_user']."')
        ";
        $sql = $koneksi->query($sub_query); 
        $_SESSION['login_details_id'] = $koneksi->insert_id;
        //rememberme check apa tidak
        // cek rememberme
        //===============================================================
        //jika rememberme di klik
        if(!empty($_POST["remember"])) {
            //buat cookie
            setcookie ("user_login",$_POST["nopeg"],time()+ (3600 * 365 * 24 * 60 * 60));
            setcookie ("userpassword",$_POST["password"],time()+ (3600 * 365 * 24 * 60 * 60));
        } else {
            if(isset($_COOKIE["user_login"])) {
             setcookie ("user_login","");
           }
           if(isset($_COOKIE["userpassword"])) {
             setcookie ("userpassword","");
           }
         }
        //direct halaman
    echo "<script type='text/javascript'>
    window.top.location='dashboard.php';
    </script>"; 
    exit;
        
    // cek jika user login sebagai non pa
    }else if($data['role']=="pengajar"){
        $_SESSION["loggedin"] = true;
        $_SESSION['nopeg'] = $nopeg;
        $_SESSION['role'] = "pengajar";
        $_SESSION['user'] = $data['nama_user'];
        $_SESSION['email'] = $data['email'];
        $_SESSION['unit'] = $data['code_devisi'];
        $_SESSION['id_user'] = $data['id_user'];
        $sub_query = "
        INSERT INTO login_details 
        (user_id) 
        VALUES ('".$data['id_user']."')
        ";
        $sql = $koneksi->query($sub_query); 
        $_SESSION['login_details_id'] = $koneksi->insert_id;
        //rememberme check apa tidak
        // cek rememberme
        //===============================================================
        //jika rememberme di klik
        if(!empty($_POST["remember"])) {
            //buat cookie
            setcookie ("user_login",$_POST["nopeg"],time()+ (3600 * 365 * 24 * 60 * 60));
            setcookie ("userpassword",$_POST["password"],time()+ (3600 * 365 * 24 * 60 * 60));
        } else {
            if(isset($_COOKIE["user_login"])) {
             setcookie ("user_login","");
           }
           if(isset($_COOKIE["userpassword"])) {
             setcookie ("userpassword","");
           }
         }
        //direct halaman
    echo "<script type='text/javascript'>
    window.top.location='dashboard.php';
    </script>"; 
    exit;

    // cek jika user login sebagai non pa
    }else if($data['role']=="penjadwalan"){
        $_SESSION["loggedin"] = true;
        $_SESSION['nopeg'] = $nopeg;
        $_SESSION['role'] = "penjadwalan";
        $_SESSION['user'] = $data['nama_user'];
        $_SESSION['email'] = $data['email'];
        $_SESSION['unit'] = $data['code_devisi'];
        $_SESSION['id_user'] = $data['id_user'];
        $sub_query = "
        INSERT INTO login_details 
        (user_id) 
        VALUES ('".$data['id_user']."')
        ";
        $sql = $koneksi->query($sub_query); 
        $_SESSION['login_details_id'] = $koneksi->insert_id;
        //rememberme check apa tidak
        // cek rememberme
        //===============================================================
        //jika rememberme di klik
        if(!empty($_POST["remember"])) {
            //buat cookie
            setcookie ("user_login",$_POST["nopeg"],time()+ (3600 * 365 * 24 * 60 * 60));
            setcookie ("userpassword",$_POST["password"],time()+ (3600 * 365 * 24 * 60 * 60));
        } else {
            if(isset($_COOKIE["user_login"])) {
             setcookie ("user_login","");
           }
           if(isset($_COOKIE["userpassword"])) {
             setcookie ("userpassword","");
           }
         }
        //direct halaman
    echo "<script type='text/javascript'>
    window.top.location='dashboard.php';
    </script>"; 
    exit;
    }else{
        //password tidak sesuai
        //direct halaman
    echo "<script type='text/javascript'>
    window.top.location='auth.php?pesan=fail';
    </script>"; 
    exit;
        //header("location:auth.php?pesan=fail");
    }
}else{
    // nopeg tidak ditemukan
        //direct halaman
        echo "<script type='text/javascript'>
        window.top.location='auth.php?pesan=gagal';
        </script>"; 
        exit;
    //header("location:auth.php?pesan=gagal");
}
}

?>

Selebihnya hanya tinggal kamu berlatih untuk mengasah skil yang kamu punya menjadi lebih amuh lagi. selamat mengerjakan happy coding.