{"id":12259,"date":"2023-01-27T08:23:04","date_gmt":"2023-01-27T08:23:04","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=12259"},"modified":"2023-05-09T07:42:36","modified_gmt":"2023-05-09T07:42:36","slug":"php-mysql-crud-application","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/","title":{"rendered":"PHP MySQL : CRUD Application"},"content":{"rendered":"\n
Mengenal CRUD<\/h5>\n\n\n\n

CRUD adalah akronim untuk C<\/strong>reate, R<\/strong>ead, U<\/strong>date, dan D<\/strong>elete. Operasi CRUD adalah manipulasi data dasar untuk basis data. Kita telah belajar bagaimana melakukan create (mis. Insert), read (mis. Select), update dan delete operasi di bab-bab sebelumnya. Dalam tutorial ini kita akan membuat aplikasi PHP sederhana untuk melakukan semua operasi ini pada tabel database MySQL di satu tempat.<\/p>\n\n\n\n

Baiklah, mari kita mulai dengan membuat tabel yang akan kita gunakan dalam semua contoh kita.<\/p>\n\n\n\n

Membuat Tabel Database<\/h5>\n\n\n\n

Jalankan query SQL berikut untuk membuat tabel bernama employees<\/em> di dalam database MySQL kalian. Kita akan menggunakan tabel ini untuk semua operasi kita di masa depan.<\/p>\n\n\n

\nCREATE TABLE employees (\n    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,\n    name VARCHAR(100) NOT NULL,\n    address VARCHAR(255) NOT NULL,\n    salary INT(10) NOT NULL\n);\n<\/pre><\/div>\n\n\n
Membuat File Config<\/h5>\n\n\n\n
Setelah membuat tabel, kita perlu membuat skrip PHP untuk dapat terhubung ke server database MySQL. Mari kita membuat file bernama \u201cconfig.php<\/em><\/strong>\u201d dan memasukkan kode berikut di dalamnya.<\/p>\n\n\n\n
Nanti kita akan menyertakan file konfigurasi ini di halaman lain menggunakan fungsi PHP require_once().<\/em><\/strong><\/p>\n\n\n
\n<?php\n\/* Database credentials. Assuming you are running MySQL\nserver with default setting (user 'root' with no password) *\/\ndefine('DB_SERVER', 'localhost');\ndefine('DB_USERNAME', 'root');\ndefine('DB_PASSWORD', '');\ndefine('DB_NAME', 'demo');\n  \n\/* Attempt to connect to MySQL database *\/\n$link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);\n  \n\/\/ Check connection\nif($link === false){\n    die("ERROR: Could not connect. " . mysqli_connect_error());\n}\n?>\n<\/pre><\/div>\n\n\n
Jika kalian telah mengunduh contoh kode berorientasi objek atau PDO menggunakan tombol unduh, harap hapus teks \u201c-oo-format<\/em><\/strong>\u201d atau \u201c-pdo-format<\/em><\/strong>\u201d dari nama file sebelum menguji kode tersebut.<\/p>\n\n\n\n
Catatan<\/em><\/strong>: Ganti kredensial sesuai dengan pengaturan server MySQL kalian sebelum menguji kode ini, misalnya, ganti nama basis data \u2018demo<\/em>\u2018 dengan nama basis data kalian sendiri, ganti nama pengguna \u2018root<\/em>\u2018 dengan nama pengguna basis data kalian sendiri, tentukan kata sandi basis data jika ada.<\/p>\n\n\n\n
Membuat Landing Page<\/h5>\n\n\n\n
Pertama kita akan membuat landing page untuk aplikasi CRUD kita yang berisi grid data yang menunjukkan catatan dari tabel database karyawan. Itu juga memiliki ikon action untuk setiap catatan yang ditampilkan di grid, yang dimana kalian dapat memilih untuk melihat rinciannya, memperbaruinya, atau menghapusnya.<\/p>\n\n\n\n
Kita juga akan menambahkan tombol create di bagian atas grid data yang dapat digunakan untuk membuat catatan baru di tabel karyawan. Buat file bernama \u201cindex.php<\/em>\u201d dan masukkan kode berikut di dalamnya:<\/p>\n\n\n
\n<!DOCTYPE html>\n<html lang="en">\n<head>\n    <meta charset="UTF-8">\n    <title>Dashboard<\/title>\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n    <script src="https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.12.4\/jquery.min.js"><\/script>\n    <script src="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.js"><\/script>\n    <style type="text\/css">\n        .wrapper{\n            width: 650px;\n            margin: 0 auto;\n        }\n        .page-header h2{\n            margin-top: 0;\n        }\n        table tr td:last-child a{\n            margin-right: 15px;\n        }\n    <\/style>\n    <script type="text\/javascript">\n        $(document).ready(function(){\n            $('[data-toggle="tooltip"]').tooltip();   \n        });\n    <\/script>\n<\/head>\n<body>\n    <div class="wrapper">\n        <div class="container-fluid">\n            <div class="row">\n                <div class="col-md-12">\n                    <div class="page-header clearfix">\n                        <h2 class="pull-left">Employees Details<\/h2>\n                        <a href="create.php" class="btn btn-success pull-right">Add New Employee<\/a>\n                    <\/div>\n                    <?php\n                    \/\/ Include config file\n                    require_once "config.php";\n                     \n                    \/\/ Attempt select query execution\n                    $sql = "SELECT * FROM employees";\n                    if($result = mysqli_query($link, $sql)){\n                        if(mysqli_num_rows($result) > 0){\n                            echo "<table class='table table-bordered table-striped'>";\n                                echo "<thead>";\n                                    echo "<tr>";\n                                        echo "<th>#<\/th>";\n                                        echo "<th>Name<\/th>";\n                                        echo "<th>Address<\/th>";\n                                        echo "<th>Salary<\/th>";\n                                        echo "<th>Action<\/th>";\n                                    echo "<\/tr>";\n                                echo "<\/thead>";\n                                echo "<tbody>";\n                                while($row = mysqli_fetch_array($result)){\n                                    echo "<tr>";\n                                        echo "<td>" . $row['id'] . "<\/td>";\n                                        echo "<td>" . $row['name'] . "<\/td>";\n                                        echo "<td>" . $row['address'] . "<\/td>";\n                                        echo "<td>" . $row['salary'] . "<\/td>";\n                                        echo "<td>";\n                                            echo "<a href='read.php?id=". $row['id'] ."' title='View Record' data-toggle='tooltip'><span class='glyphicon glyphicon-eye-open'><\/span><\/a>";\n                                            echo "<a href='update.php?id=". $row['id'] ."' title='Update Record' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'><\/span><\/a>";\n                                            echo "<a href='delete.php?id=". $row['id'] ."' title='Delete Record' data-toggle='tooltip'><span class='glyphicon glyphicon-trash'><\/span><\/a>";\n                                        echo "<\/td>";\n                                    echo "<\/tr>";\n                                }\n                                echo "<\/tbody>";                            \n                            echo "<\/table>";\n                            \/\/ Free result set\n                            mysqli_free_result($result);\n                        } else{\n                            echo "<p class='lead'><em>No records were found.<\/em><\/p>";\n                        }\n                    } else{\n                        echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);\n                    }\n  \n                    \/\/ Close connection\n                    mysqli_close($link);\n                    ?>\n                <\/div>\n            <\/div>        \n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Setelah tabel employees <\/em>diisi dengan beberapa catatan landing page yaitu seperti contohnya grid data CRUD mungkin akan terlihat seperti yang ditunjukkan di bawah ini:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Tips<\/em><\/strong>: Kita telah menggunakan framework Bootstrap untuk membuat layout aplikasi CRUD ini dengan cepat dan indah. Bootstrap adalah framework front-end yang paling populer dan powerful untuk pengembangan web yang lebih cepat dan lebih responsif. Silakan, cek bagian tutorial Bootstrap untuk mempelajari lebih lanjut tentang framework ini.<\/p>\n\n\n\n
Membuat Create Page<\/h5>\n\n\n\n
Di bagian ini kita akan membangun fungsi C<\/strong>reate pada aplikasi CRUD kita.<\/p>\n\n\n\n
Mari kita buat file bernama \u201ccreate.php<\/em><\/strong>\u201d dan letakkan kode berikut di dalamnya. Ini akan menghasilkan form web yang dapat digunakan untuk menyisipkan catatan di tabel employees<\/em>.<\/p>\n\n\n
\n<?php\n\/\/ Include config file\nrequire_once "config.php";\n  \n\/\/ Define variables and initialize with empty values\n$name = $address = $salary = "";\n$name_err = $address_err = $salary_err = "";\n  \n\/\/ Processing form data when form is submitted\nif($_SERVER["REQUEST_METHOD"] == "POST"){\n    \/\/ Validate name\n    $input_name = trim($_POST["name"]);\n    if(empty($input_name)){\n        $name_err = "Please enter a name.";\n    } elseif(!filter_var($input_name, FILTER_VALIDATE_REGEXP, array("options"=>array("regexp"=>"\/^[a-zA-Z\\s]+$\/")))){\n        $name_err = "Please enter a valid name.";\n    } else{\n        $name = $input_name;\n    }\n     \n    \/\/ Validate address\n    $input_address = trim($_POST["address"]);\n    if(empty($input_address)){\n        $address_err = "Please enter an address.";     \n    } else{\n        $address = $input_address;\n    }\n     \n    \/\/ Validate salary\n    $input_salary = trim($_POST["salary"]);\n    if(empty($input_salary)){\n        $salary_err = "Please enter the salary amount.";     \n    } elseif(!ctype_digit($input_salary)){\n        $salary_err = "Please enter a positive integer value.";\n    } else{\n        $salary = $input_salary;\n    }\n     \n    \/\/ Check input errors before inserting in database\n    if(empty($name_err) && empty($address_err) && empty($salary_err)){\n        \/\/ Prepare an insert statement\n        $sql = "INSERT INTO employees (name, address, salary) VALUES (?, ?, ?)";\n          \n        if($stmt = mysqli_prepare($link, $sql)){\n            \/\/ Bind variables to the prepared statement as parameters\n            mysqli_stmt_bind_param($stmt, "sss", $param_name, $param_address, $param_salary);\n             \n            \/\/ Set parameters\n            $param_name = $name;\n            $param_address = $address;\n            $param_salary = $salary;\n             \n            \/\/ Attempt to execute the prepared statement\n            if(mysqli_stmt_execute($stmt)){\n                \/\/ Records created successfully. Redirect to landing page\n                header("location: index.php");\n                exit();\n            } else{\n                echo "Something went wrong. Please try again later.";\n            }\n        }\n          \n        \/\/ Close statement\n        mysqli_stmt_close($stmt);\n    }\n     \n    \/\/ Close connection\n    mysqli_close($link);\n}\n?>\n  \n<!DOCTYPE html>\n<html lang="en">\n<head>\n    <meta charset="UTF-8">\n    <title>Create Record<\/title>\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n    <style type="text\/css">\n        .wrapper{\n            width: 500px;\n            margin: 0 auto;\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class="wrapper">\n        <div class="container-fluid">\n            <div class="row">\n                <div class="col-md-12">\n                    <div class="page-header">\n                        <h2>Create Record<\/h2>\n                    <\/div>\n                    <p>Please fill this form and submit to add employee record to the database.<\/p>\n                    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">\n                        <div class="form-group <?php echo (!empty($name_err)) ? 'has-error' : ''; ?>">\n                            <label>Name<\/label>\n                            <input type="text" name="name" class="form-control" value="<?php echo $name; ?>">\n                            <span class="help-block"><?php echo $name_err;?><\/span>\n                        <\/div>\n                        <div class="form-group <?php echo (!empty($address_err)) ? 'has-error' : ''; ?>">\n                            <label>Address<\/label>\n                            <textarea name="address" class="form-control"><?php echo $address; ?><\/textarea>\n                            <span class="help-block"><?php echo $address_err;?><\/span>\n                        <\/div>\n                        <div class="form-group <?php echo (!empty($salary_err)) ? 'has-error' : ''; ?>">\n                            <label>Salary<\/label>\n                            <input type="text" name="salary" class="form-control" value="<?php echo $salary; ?>">\n                            <span class="help-block"><?php echo $salary_err;?><\/span>\n                        <\/div>\n                        <input type="submit" class="btn btn-primary" value="Submit">\n                        <a href="index.php" class="btn btn-default">Cancel<\/a>\n                    <\/form>\n                <\/div>\n            <\/div>        \n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
File \u201ccreate.php<\/em><\/strong>\u201d yang sama akan menampilkan form HTML dan memproses data form yang dikirimkan (submitted). Ini juga akan melakukan validasi dasar pada input pengguna (baris no-11 hingga 37) sebelum menyimpan data.<\/p>\n\n\n\n
Membuat Read Page<\/h5>\n\n\n\n
Sekarang saatnya untuk membangun fungsi R<\/strong>ead dari aplikasi CRUD kita.<\/p>\n\n\n\n
Mari kita buat file bernama \u201ccreate.php<\/em><\/strong>\u201d dan letakkan kode berikut di dalamnya. Hal tersebut hanya akan mengambil catatan dari tabel employees<\/em> berdasarkan atribut id<\/em><\/strong> karyawan.<\/p>\n\n\n
\n<?php\n\/\/ Check existence of id parameter before processing further\nif(isset($_GET["id"]) && !empty(trim($_GET["id"]))){\n    \/\/ Include config file\n    require_once "config.php";\n     \n    \/\/ Prepare a select statement\n    $sql = "SELECT * FROM employees WHERE id = ?";\n     \n    if($stmt = mysqli_prepare($link, $sql)){\n        \/\/ Bind variables to the prepared statement as parameters\n        mysqli_stmt_bind_param($stmt, "i", $param_id);\n         \n        \/\/ Set parameters\n        $param_id = trim($_GET["id"]);\n         \n        \/\/ Attempt to execute the prepared statement\n        if(mysqli_stmt_execute($stmt)){\n            $result = mysqli_stmt_get_result($stmt);\n     \n            if(mysqli_num_rows($result) == 1){\n                \/* Fetch result row as an associative array. Since the result set contains only one row, we don't need to use while loop *\/\n                $row = mysqli_fetch_array($result, MYSQLI_ASSOC);\n                 \n                \/\/ Retrieve individual field value\n                $name = $row["name"];\n                $address = $row["address"];\n                $salary = $row["salary"];\n            } else{\n                \/\/ URL doesn't contain valid id parameter. Redirect to error page\n                header("location: error.php");\n                exit();\n            }\n             \n        } else{\n            echo "Oops! Something went wrong. Please try again later.";\n        }\n    }\n      \n    \/\/ Close statement\n    mysqli_stmt_close($stmt);\n     \n    \/\/ Close connection\n    mysqli_close($link);\n} else{\n    \/\/ URL doesn't contain id parameter. Redirect to error page\n    header("location: error.php");\n    exit();\n}\n?>\n<!DOCTYPE html>\n<html lang="en">\n<head>\n    <meta charset="UTF-8">\n    <title>View Record<\/title>\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n    <style type="text\/css">\n        .wrapper{\n            width: 500px;\n            margin: 0 auto;\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class="wrapper">\n        <div class="container-fluid">\n            <div class="row">\n                <div class="col-md-12">\n                    <div class="page-header">\n                        <h1>View Record<\/h1>\n                    <\/div>\n                    <div class="form-group">\n                        <label>Name<\/label>\n                        <p class="form-control-static"><?php echo $row["name"]; ?><\/p>\n                    <\/div>\n                    <div class="form-group">\n                        <label>Address<\/label>\n                        <p class="form-control-static"><?php echo $row["address"]; ?><\/p>\n                    <\/div>\n                    <div class="form-group">\n                        <label>Salary<\/label>\n                        <p class="form-control-static"><?php echo $row["salary"]; ?><\/p>\n                    <\/div>\n                    <p><a href="index.php" class="btn btn-primary">Back<\/a><\/p>\n                <\/div>\n            <\/div>        \n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Membuat Update Page<\/h5>\n\n\n\n
Demikian pula, kita dapat membangun fungsionalitas U<\/strong>pdate aplikasi CRUD kita.<\/p>\n\n\n\n
Mari kita buat file bernama \u201cupdate.php<\/em><\/strong>\u201d dan masukkan kode berikut di dalamnya. Ini akan memperbarui catatan yang ada di tabel employees<\/em> berdasarkan atribut id<\/strong> karyawan.<\/p>\n\n\n
\n<?php\n\/\/ Include config file\nrequire_once "config.php";\n  \n\/\/ Define variables and initialize with empty values\n$name = $address = $salary = "";\n$name_err = $address_err = $salary_err = "";\n  \n\/\/ Processing form data when form is submitted\nif(isset($_POST["id"]) && !empty($_POST["id"])){\n    \/\/ Get hidden input value\n    $id = $_POST["id"];\n     \n    \/\/ Validate name\n    $input_name = trim($_POST["name"]);\n    if(empty($input_name)){\n        $name_err = "Please enter a name.";\n    } elseif(!filter_var($input_name, FILTER_VALIDATE_REGEXP, array("options"=>array("regexp"=>"\/^[a-zA-Z\\s]+$\/")))){\n        $name_err = "Please enter a valid name.";\n    } else{\n        $name = $input_name;\n    }\n     \n    \/\/ Validate address address\n    $input_address = trim($_POST["address"]);\n    if(empty($input_address)){\n        $address_err = "Please enter an address.";     \n    } else{\n        $address = $input_address;\n    }\n     \n    \/\/ Validate salary\n    $input_salary = trim($_POST["salary"]);\n    if(empty($input_salary)){\n        $salary_err = "Please enter the salary amount.";     \n    } elseif(!ctype_digit($input_salary)){\n        $salary_err = "Please enter a positive integer value.";\n    } else{\n        $salary = $input_salary;\n    }\n     \n    \/\/ Check input errors before inserting in database\n    if(empty($name_err) && empty($address_err) && empty($salary_err)){\n        \/\/ Prepare an update statement\n        $sql = "UPDATE employees SET name=?, address=?, salary=? WHERE id=?";\n          \n        if($stmt = mysqli_prepare($link, $sql)){\n            \/\/ Bind variables to the prepared statement as parameters\n            mysqli_stmt_bind_param($stmt, "sssi", $param_name, $param_address, $param_salary, $param_id);\n             \n            \/\/ Set parameters\n            $param_name = $name;\n            $param_address = $address;\n            $param_salary = $salary;\n            $param_id = $id;\n             \n            \/\/ Attempt to execute the prepared statement\n            if(mysqli_stmt_execute($stmt)){\n                \/\/ Records updated successfully. Redirect to landing page\n                header("location: index.php");\n                exit();\n            } else{\n                echo "Something went wrong. Please try again later.";\n            }\n        }\n          \n        \/\/ Close statement\n        mysqli_stmt_close($stmt);\n    }\n     \n    \/\/ Close connection\n    mysqli_close($link);\n} else{\n    \/\/ Check existence of id parameter before processing further\n    if(isset($_GET["id"]) && !empty(trim($_GET["id"]))){\n        \/\/ Get URL parameter\n        $id =  trim($_GET["id"]);\n         \n        \/\/ Prepare a select statement\n        $sql = "SELECT * FROM employees WHERE id = ?";\n        if($stmt = mysqli_prepare($link, $sql)){\n            \/\/ Bind variables to the prepared statement as parameters\n            mysqli_stmt_bind_param($stmt, "i", $param_id);\n             \n            \/\/ Set parameters\n            $param_id = $id;\n             \n            \/\/ Attempt to execute the prepared statement\n            if(mysqli_stmt_execute($stmt)){\n                $result = mysqli_stmt_get_result($stmt);\n     \n                if(mysqli_num_rows($result) == 1){\n                    \/* Fetch result row as an associative array. Since the result set contains only one row, we don't need to use while loop *\/\n                    $row = mysqli_fetch_array($result, MYSQLI_ASSOC);\n                     \n                    \/\/ Retrieve individual field value\n                    $name = $row["name"];\n                    $address = $row["address"];\n                    $salary = $row["salary"];\n                } else{\n                    \/\/ URL doesn't contain valid id. Redirect to error page\n                    header("location: error.php");\n                    exit();\n                }\n                 \n            } else{\n                echo "Oops! Something went wrong. Please try again later.";\n            }\n        }\n         \n        \/\/ Close statement\n        mysqli_stmt_close($stmt);\n         \n        \/\/ Close connection\n        mysqli_close($link);\n    }  else{\n        \/\/ URL doesn't contain id parameter. Redirect to error page\n        header("location: error.php");\n        exit();\n    }\n}\n?>\n  \n<!DOCTYPE html>\n<html lang="en">\n<head>\n    <meta charset="UTF-8">\n    <title>Update Record<\/title>\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n    <style type="text\/css">\n        .wrapper{\n            width: 500px;\n            margin: 0 auto;\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class="wrapper">\n        <div class="container-fluid">\n            <div class="row">\n                <div class="col-md-12">\n                    <div class="page-header">\n                        <h2>Update Record<\/h2>\n                    <\/div>\n                    <p>Please edit the input values and submit to update the record.<\/p>\n                    <form action="<?php echo htmlspecialchars(basename($_SERVER['REQUEST_URI'])); ?>" method="post">\n                        <div class="form-group <?php echo (!empty($name_err)) ? 'has-error' : ''; ?>">\n                            <label>Name<\/label>\n                            <input type="text" name="name" class="form-control" value="<?php echo $name; ?>">\n                            <span class="help-block"><?php echo $name_err;?><\/span>\n                        <\/div>\n                        <div class="form-group <?php echo (!empty($address_err)) ? 'has-error' : ''; ?>">\n                            <label>Address<\/label>\n                            <textarea name="address" class="form-control"><?php echo $address; ?><\/textarea>\n                            <span class="help-block"><?php echo $address_err;?><\/span>\n                        <\/div>\n                        <div class="form-group <?php echo (!empty($salary_err)) ? 'has-error' : ''; ?>">\n                            <label>Salary<\/label>\n                            <input type="text" name="salary" class="form-control" value="<?php echo $salary; ?>">\n                            <span class="help-block"><?php echo $salary_err;?><\/span>\n                        <\/div>\n                        <input type="hidden" name="id" value="<?php echo $id; ?>"\/>\n                        <input type="submit" class="btn btn-primary" value="Submit">\n                        <a href="index.php" class="btn btn-default">Cancel<\/a>\n                    <\/form>\n                <\/div>\n            <\/div>        \n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Membuat Delete Page<\/h5>\n\n\n\n
Akhirnya, kita akan membangun fungsionalitas D<\/strong>elete dari aplikasi CRUD kita.<\/p>\n\n\n\n
Mari kita buat file bernama \u201cdelete.php<\/em><\/strong>\u201d dan masukkan kode berikut di dalamnya. Ini akan menghapus catatan yang ada dari tabel employees<\/em> berdasarkan atribut id<\/em><\/strong> karyawan.<\/p>\n\n\n
\n<?php\n\/\/ Process delete operation after confirmation\nif(isset($_POST["id"]) && !empty($_POST["id"])){\n    \/\/ Include config file\n    require_once "config.php";\n     \n    \/\/ Prepare a delete statement\n    $sql = "DELETE FROM employees WHERE id = ?";\n     \n    if($stmt = mysqli_prepare($link, $sql)){\n        \/\/ Bind variables to the prepared statement as parameters\n        mysqli_stmt_bind_param($stmt, "i", $param_id);\n         \n        \/\/ Set parameters\n        $param_id = trim($_POST["id"]);\n         \n        \/\/ Attempt to execute the prepared statement\n        if(mysqli_stmt_execute($stmt)){\n            \/\/ Records deleted successfully. Redirect to landing page\n            header("location: index.php");\n            exit();\n        } else{\n            echo "Oops! Something went wrong. Please try again later.";\n        }\n    }\n      \n    \/\/ Close statement\n    mysqli_stmt_close($stmt);\n     \n    \/\/ Close connection\n    mysqli_close($link);\n} else{\n    \/\/ Check existence of id parameter\n    if(empty(trim($_GET["id"]))){\n        \/\/ URL doesn't contain id parameter. Redirect to error page\n        header("location: error.php");\n        exit();\n    }\n}\n?>\n<!DOCTYPE html>\n<html lang="en">\n<head>\n    <meta charset="UTF-8">\n    <title>View Record<\/title>\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n    <style type="text\/css">\n        .wrapper{\n            width: 500px;\n            margin: 0 auto;\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class="wrapper">\n        <div class="container-fluid">\n            <div class="row">\n                <div class="col-md-12">\n                    <div class="page-header">\n                        <h1>Delete Record<\/h1>\n                    <\/div>\n                    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">\n                        <div class="alert alert-danger fade in">\n                            <input type="hidden" name="id" value="<?php echo trim($_GET["id"]); ?>"\/>\n                            <p>Are you sure you want to delete this record?<\/p><br>\n                            <p>\n                                <input type="submit" value="Yes" class="btn btn-danger">\n                                <a href="index.php" class="btn btn-default">No<\/a>\n                            <\/p>\n                        <\/div>\n                    <\/form>\n                <\/div>\n            <\/div>        \n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Membuat Error Page<\/h5>\n\n\n\n
Pada akhirnya, mari kita buat satu file lagi \u201cerror.php<\/em><\/strong>\u201c. Halaman ini akan ditampilkan jika permintaan tidak valid yaitu jika parameter id<\/em><\/strong> tidak ada dari string kueri URL atau tidak valid.<\/p>\n\n\n
\n<!DOCTYPE html>\n<html lang="en">\n<head>\n    <meta charset="UTF-8">\n    <title>Error<\/title>\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n    <style type="text\/css">\n        .wrapper{\n            width: 750px;\n            margin: 0 auto;\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class="wrapper">\n        <div class="container-fluid">\n            <div class="row">\n                <div class="col-md-12">\n                    <div class="page-header">\n                        <h1>Invalid Request<\/h1>\n                    <\/div>\n                    <div class="alert alert-danger fade in">\n                        <p>Sorry, you've made an invalid request. Please <a href="index.php" class="alert-link">go back<\/a> and try again.<\/p>\n                    <\/div>\n                <\/div>\n            <\/div>        \n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Mengenal CRUD CRUD adalah akronim untuk Create, Read, Udate, dan Delete. Operasi CRUD adalah manipulasi data dasar untuk basis data. Kita telah belajar bagaimana melakukan create (mis. Insert), read<\/p>\n","protected":false},"author":1,"featured_media":9023,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[3892,3887,3889,3890,3891,3888],"class_list":["post-12259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-belajar-php-mysql-crud-application","tag-belajar-php-mysql-crud-application-pemula","tag-kursus-php-mysql-crud-application-bandung","tag-kursus-php-mysql-crud-application-jakarta","tag-tutorial-php-mysql-crud-application","tag-tutorial-php-mysql-crud-application-pemula"],"yoast_head":"\nPHP MySQL : CRUD Application - WebHozz Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP MySQL : CRUD Application - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Mengenal CRUD CRUD adalah akronim untuk Create, Read, Udate, dan Delete. Operasi CRUD adalah manipulasi data dasar untuk basis data. Kita telah belajar bagaimana melakukan create (mis. Insert), read\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-27T08:23:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-09T07:42:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\"},\"headline\":\"PHP MySQL : CRUD Application\",\"datePublished\":\"2023-01-27T08:23:04+00:00\",\"dateModified\":\"2023-05-09T07:42:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/\"},\"wordCount\":623,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"keywords\":[\"Belajar PHP MySQL CRUD Application\",\"Belajar PHP MySQL CRUD Application Pemula\",\"Kursus PHP MySQL CRUD Application Bandung\",\"Kursus PHP MySQL CRUD Application Jakarta\",\"Tutorial PHP MySQL CRUD Application\",\"Tutorial PHP MySQL CRUD Application Pemula\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/\",\"name\":\"PHP MySQL : CRUD Application - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"datePublished\":\"2023-01-27T08:23:04+00:00\",\"dateModified\":\"2023-05-09T07:42:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"width\":750,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-crud-application\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySQL : CRUD Application\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web & Android di Jakarta Bandung\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\",\"name\":\"WebHozz\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"width\":442,\"height\":442,\"caption\":\"WebHozz\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP MySQL : CRUD Application - WebHozz Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/","og_locale":"en_US","og_type":"article","og_title":"PHP MySQL : CRUD Application - WebHozz Blog","og_description":"Mengenal CRUD CRUD adalah akronim untuk Create, Read, Udate, dan Delete. Operasi CRUD adalah manipulasi data dasar untuk basis data. Kita telah belajar bagaimana melakukan create (mis. Insert), read","og_url":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/","og_site_name":"WebHozz Blog","article_published_time":"2023-01-27T08:23:04+00:00","article_modified_time":"2023-05-09T07:42:36+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef"},"headline":"PHP MySQL : CRUD Application","datePublished":"2023-01-27T08:23:04+00:00","dateModified":"2023-05-09T07:42:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/"},"wordCount":623,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","keywords":["Belajar PHP MySQL CRUD Application","Belajar PHP MySQL CRUD Application Pemula","Kursus PHP MySQL CRUD Application Bandung","Kursus PHP MySQL CRUD Application Jakarta","Tutorial PHP MySQL CRUD Application","Tutorial PHP MySQL CRUD Application Pemula"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/","url":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/","name":"PHP MySQL : CRUD Application - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","datePublished":"2023-01-27T08:23:04+00:00","dateModified":"2023-05-09T07:42:36+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#primaryimage","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","width":750,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-crud-application\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PHP MySQL : CRUD Application"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web & Android di Jakarta Bandung","publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhozz.com\/blog\/#organization","name":"WebHozz","url":"https:\/\/www.webhozz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","width":442,"height":442,"caption":"WebHozz"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=12259"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12259\/revisions"}],"predecessor-version":[{"id":12580,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12259\/revisions\/12580"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media\/9023"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=12259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=12259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=12259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}