{"id":552,"date":"2019-09-20T14:17:17","date_gmt":"2019-09-20T14:17:17","guid":{"rendered":"https:\/\/www.webhozz.com\/code\/?p=552"},"modified":"2019-09-20T14:17:21","modified_gmt":"2019-09-20T14:17:21","slug":"php-mysql-login-system","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/","title":{"rendered":"PHP MySQL : Login System"},"content":{"rendered":"\n
Otentikasi pengguna sangat umum dalam aplikasi web modern.\nIni adalah mekanisme keamanan yang digunakan untuk membatasi akses tidak sah (restrict unauthorized) khusus\nuntuk member saja pada suatu situs tersebut.<\/p>\n\n\n\n
Pada tutorial ini kita akan membuat sistem registrasi dan login sederhana menggunakan PHP dan MySQL. Tutorial ini terdiri dari dua bagian: di bagian pertama kita akan membuat form pendaftaran pengguna, dan di bagian kedua kita akan membuat form login, serta halaman pembuka dan skrip logout.<\/p>\n\n\n\n
Membangun Sistem Registrasi<\/h5>\n\n\n\n
Di bagian ini kita akan membangun sistem pendaftaran yang memungkinkan pengguna untuk membuat akun baru dengan mengisi form web. Tapi, pertama kita perlu membuat tabel yang akan menampung semua data pengguna.<\/p>\n\n\n\n
Langkah 1 : Membuat Tabel Database<\/h5>\n\n\n
\nCREATE TABLE users (\n id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,\n username VARCHAR(50) NOT NULL UNIQUE,\n password VARCHAR(255) NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/pre><\/div>\n\n\n
Silakan periksa tutorial tentang pernyataan SQL CREATE TABLE<\/em><\/strong> untuk informasi terperinci tentang sintaks untuk membuat tabel dalam sistem database MySQL.<\/p>\n\n\n\n
Langkah 2 : Membuat Config File<\/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 “config.php<\/em><\/strong>” dan memasukkan kode berikut di dalamnya.<\/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 “-oo-format<\/em><\/strong>” atau “-pdo-format<\/em><\/strong>” 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 ‘demo<\/em>‘ dengan nama basis data kalian sendiri, ganti nama pengguna ‘root<\/em>‘ dengan nama pengguna basis data kalian sendiri, tentukan kata sandi basis data jika ada.<\/p>\n\n\n\n
Langkah 3 : Membuat Form Registrasi<\/h5>\n\n\n\n
Mari kita buat file PHP lain “register.php<\/em><\/strong>” dan\nmasukkan kode contoh berikut di dalamnya. Kode contoh ini akan membuat form web\nyang memungkinkan pengguna untuk mendaftar sendiri.<\/p>\n\n\n\n
Skrip ini juga akan menghasilkan error jika pengguna mencoba mengirimkan form tanpa memasukkan nilai apa pun, atau jika nama pengguna yang dimasukkan oleh pengguna sudah digunakan oleh pengguna lain.<\/p>\n\n\n
\n<?php\n\/\/ Include config file\nrequire_once "config.php";\n \n\/\/ Define variables and initialize with empty values\n$username = $password = $confirm_password = "";\n$username_err = $password_err = $confirm_password_err = "";\n \n\/\/ Processing form data when form is submitted\nif($_SERVER["REQUEST_METHOD"] == "POST"){\n \n \/\/ Validate username\n if(empty(trim($_POST["username"]))){\n $username_err = "Please enter a username.";\n } else{\n \/\/ Prepare a select statement\n $sql = "SELECT id FROM users WHERE username = ?";\n \n if($stmt = mysqli_prepare($link, $sql)){\n \/\/ Bind variables to the prepared statement as parameters\n mysqli_stmt_bind_param($stmt, "s", $param_username);\n \n \/\/ Set parameters\n $param_username = trim($_POST["username"]);\n \n \/\/ Attempt to execute the prepared statement\n if(mysqli_stmt_execute($stmt)){\n \/* store result *\/\n mysqli_stmt_store_result($stmt);\n \n if(mysqli_stmt_num_rows($stmt) == 1){\n $username_err = "This username is already taken.";\n } else{\n $username = trim($_POST["username"]);\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 \n \/\/ Validate password\n if(empty(trim($_POST["password"]))){\n $password_err = "Please enter a password."; \n } elseif(strlen(trim($_POST["password"])) < 6){\n $password_err = "Password must have atleast 6 characters.";\n } else{\n $password = trim($_POST["password"]);\n }\n \n \/\/ Validate confirm password\n if(empty(trim($_POST["confirm_password"]))){\n $confirm_password_err = "Please confirm password."; \n } else{\n $confirm_password = trim($_POST["confirm_password"]);\n if(empty($password_err) && ($password != $confirm_password)){\n $confirm_password_err = "Password did not match.";\n }\n }\n \n \/\/ Check input errors before inserting in database\n if(empty($username_err) && empty($password_err) && empty($confirm_password_err)){\n \n \/\/ Prepare an insert statement\n $sql = "INSERT INTO users (username, password) VALUES (?, ?)";\n \n if($stmt = mysqli_prepare($link, $sql)){\n \/\/ Bind variables to the prepared statement as parameters\n mysqli_stmt_bind_param($stmt, "ss", $param_username, $param_password);\n \n \/\/ Set parameters\n $param_username = $username;\n $param_password = password_hash($password, PASSWORD_DEFAULT); \/\/ Creates a password hash\n \n \/\/ Attempt to execute the prepared statement\n if(mysqli_stmt_execute($stmt)){\n \/\/ Redirect to login page\n header("location: login.php");\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>Sign Up<\/title>\n <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n <style type="text\/css">\n body{ font: 14px sans-serif; }\n .wrapper{ width: 350px; padding: 20px; }\n <\/style>\n<\/head>\n<body>\n <div class="wrapper">\n <h2>Sign Up<\/h2>\n <p>Please fill this form to create an account.<\/p>\n <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">\n <div class="form-group <?php echo (!empty($username_err)) ? 'has-error' : ''; ?>">\n <label>Username<\/label>\n <input type="text" name="username" class="form-control" value="<?php echo $username; ?>">\n <span class="help-block"><?php echo $username_err; ?><\/span>\n <\/div> \n <div class="form-group <?php echo (!empty($password_err)) ? 'has-error' : ''; ?>">\n <label>Password<\/label>\n <input type="password" name="password" class="form-control" value="<?php echo $password; ?>">\n <span class="help-block"><?php echo $password_err; ?><\/span>\n <\/div>\n <div class="form-group <?php echo (!empty($confirm_password_err)) ? 'has-error' : ''; ?>">\n <label>Confirm Password<\/label>\n <input type="password" name="confirm_password" class="form-control" value="<?php echo $confirm_password; ?>">\n <span class="help-block"><?php echo $confirm_password_err; ?><\/span>\n <\/div>\n <div class="form-group">\n <input type="submit" class="btn btn-primary" value="Submit">\n <input type="reset" class="btn btn-default" value="Reset">\n <\/div>\n <p>Already have an account? <a href="login.php">Login here<\/a>.<\/p>\n <\/form>\n <\/div> \n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Output dari contoh di atas (mis. Form pendaftaran) akan terlihat seperti ini:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Pada contoh di atas, kita telah menggunakan fungsi PHP password_hash()<\/em><\/strong> untuk membuat hash kata sandi dari string kata sandi yang dimasukkan oleh pengguna (baris no-75). Fungsi ini menciptakan hash kata sandi menggunakan algoritma hashing satu arah yang kuat. Hal itu juga menghasilkan dan menerapkan kode acak secara otomatis ketika hashing kata sandi; ini berarti bahwa meskipun dua pengguna memiliki kata sandi yang sama, hash kata sandi mereka akan berbeda.<\/p>\n\n\n\n
Pada saat login, kita akan memverifikasi kata sandi yang\ndiberikan dengan hash kata sandi yang disimpan dalam database menggunakan\nfungsi PHP password_verify()<\/em><\/strong>, seperti yang ditunjukkan pada contoh\nberikut.<\/p>\n\n\n\n
Kita telah menggunakan framework Bootstrap untuk membuat form layout dengan cepat dan indah. Silakan, cek bagian tutorial Bootstrap untuk mempelajari lebih lanjut tentang framework ini.<\/p>\n\n\n\n
Membangun System Login<\/h5>\n\n\n\n
Di bagian ini kita akan membuat form login di mana pengguna dapat memasukkan nama pengguna dan kata sandi mereka. Ketika pengguna mengirimkan form input maka hal tersebut akan diverifikasi dengan yang disimpan dalam database, jika nama pengguna dan kata sandi cocok, pengguna diotorisasi dan diberikan akses ke situs, jika tidak maka upaya login akan ditolak.<\/p>\n\n\n\n
Langkah 1 : Membuat Login Form<\/h5>\n\n\n\n
Mari kita buat file bernama “login.php<\/em><\/strong>” dan letakkan kode berikut di dalamnya.<\/p>\n\n\n
\n<?php\n\/\/ Initialize the session\nsession_start();\n \n\/\/ Check if the user is already logged in, if yes then redirect him to welcome page\nif(isset($_SESSION["loggedin"]) && $_SESSION["loggedin"] === true){\n header("location: welcome.php");\n exit;\n}\n \n\/\/ Include config file\nrequire_once "config.php";\n \n\/\/ Define variables and initialize with empty values\n$username = $password = "";\n$username_err = $password_err = "";\n \n\/\/ Processing form data when form is submitted\nif($_SERVER["REQUEST_METHOD"] == "POST"){\n \n \/\/ Check if username is empty\n if(empty(trim($_POST["username"]))){\n $username_err = "Please enter username.";\n } else{\n $username = trim($_POST["username"]);\n }\n \n \/\/ Check if password is empty\n if(empty(trim($_POST["password"]))){\n $password_err = "Please enter your password.";\n } else{\n $password = trim($_POST["password"]);\n }\n \n \/\/ Validate credentials\n if(empty($username_err) && empty($password_err)){\n \/\/ Prepare a select statement\n $sql = "SELECT id, username, password FROM users WHERE username = ?";\n \n if($stmt = mysqli_prepare($link, $sql)){\n \/\/ Bind variables to the prepared statement as parameters\n mysqli_stmt_bind_param($stmt, "s", $param_username);\n \n \/\/ Set parameters\n $param_username = $username;\n \n \/\/ Attempt to execute the prepared statement\n if(mysqli_stmt_execute($stmt)){\n \/\/ Store result\n mysqli_stmt_store_result($stmt);\n \n \/\/ Check if username exists, if yes then verify password\n if(mysqli_stmt_num_rows($stmt) == 1){ \n \/\/ Bind result variables\n mysqli_stmt_bind_result($stmt, $id, $username, $hashed_password);\n if(mysqli_stmt_fetch($stmt)){\n if(password_verify($password, $hashed_password)){\n \/\/ Password is correct, so start a new session\n session_start();\n \n \/\/ Store data in session variables\n $_SESSION["loggedin"] = true;\n $_SESSION["id"] = $id;\n $_SESSION["username"] = $username; \n \n \/\/ Redirect user to welcome page\n header("location: welcome.php");\n } else{\n \/\/ Display an error message if password is not valid\n $password_err = "The password you entered was not valid.";\n }\n }\n } else{\n \/\/ Display an error message if username doesn't exist\n $username_err = "No account found with that username.";\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 \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>Login<\/title>\n <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n <style type="text\/css">\n body{ font: 14px sans-serif; }\n .wrapper{ width: 350px; padding: 20px; }\n <\/style>\n<\/head>\n<body>\n <div class="wrapper">\n <h2>Login<\/h2>\n <p>Please fill in your credentials to login.<\/p>\n <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">\n <div class="form-group <?php echo (!empty($username_err)) ? 'has-error' : ''; ?>">\n <label>Username<\/label>\n <input type="text" name="username" class="form-control" value="<?php echo $username; ?>">\n <span class="help-block"><?php echo $username_err; ?><\/span>\n <\/div> \n <div class="form-group <?php echo (!empty($password_err)) ? 'has-error' : ''; ?>">\n <label>Password<\/label>\n <input type="password" name="password" class="form-control">\n <span class="help-block"><?php echo $password_err; ?><\/span>\n <\/div>\n <div class="form-group">\n <input type="submit" class="btn btn-primary" value="Login">\n <\/div>\n <p>Don't have an account? <a href="register.php">Sign up now<\/a>.<\/p>\n <\/form>\n <\/div> \n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Output dari contoh di atas (mis. Form login) akan terlihat seperti ini:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Langkah 2 : Membuat Welcome Page<\/h5>\n\n\n\n
Berikut kode file “welcome.php<\/em><\/strong>” kita, tempat pengguna diarahkan setelah login berhasil.<\/p>\n\n\n
\n<?php\n\/\/ Initialize the session\nsession_start();\n \n\/\/ Check if the user is logged in, if not then redirect him to login page\nif(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true){\n header("location: login.php");\n exit;\n}\n?>\n \n<!DOCTYPE html>\n<html lang="en">\n<head>\n <meta charset="UTF-8">\n <title>Welcome<\/title>\n <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n <style type="text\/css">\n body{ font: 14px sans-serif; text-align: center; }\n <\/style>\n<\/head>\n<body>\n <div class="page-header">\n <h1>Hi, <b><?php echo htmlspecialchars($_SESSION["username"]); ?><\/b>. Welcome to our site.<\/h1>\n <\/div>\n <p>\n <a href="reset-password.php" class="btn btn-warning">Reset Your Password<\/a>\n <a href="logout.php" class="btn btn-danger">Sign Out of Your Account<\/a>\n <\/p>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Jika data berasal dari sumber eksternal seperti form yang diisi oleh pengguna anonim, ada risiko bahwa itu mungkin berisi skrip berbahaya yang bermaksud untuk meluncurkan serangan skrip cross-site<\/em> (XSS). Oleh karena itu, kalian harus menghindari data ini menggunakan fungsi PHP htmlspecialchars()<\/em><\/strong> sebelum menampilkannya di browser, sehingga tag HTML apa pun yang ada di dalamnya menjadi tidak berbahaya.<\/p>\n\n\n\n
Misalnya, setelah mengeluarkan dari karakter khusus string <script>alert(“XSS”)<\/script><\/strong><\/em> menjadi <script>alert(“XSS”)<\/script><\/em><\/strong> yang dimana tidak akan dijalankan oleh browser.<\/p>\n\n\n\n
Langkah 3 : Membuat Logout Script<\/h5>\n\n\n\n
Sekarang, mari kita buat file “logout.php<\/em><\/strong>“. Ketika pengguna mengklik pada log out<\/em> atau sign out<\/em>, skrip di dalam file ini akan menghancurkan (mengeluarkan) sesi dan mengarahkan pengguna kembali ke halaman login.<\/p>\n\n\n
\n<?php\n\/\/ Initialize the session\nsession_start();\n \n\/\/ Unset all of the session variables\n$_SESSION = array();\n \n\/\/ Destroy the session.\nsession_destroy();\n \n\/\/ Redirect to login page\nheader("location: login.php");\nexit;\n?>\n<\/pre><\/div>\n\n\n
Menambahkan Fitur Reset Kata Sandi<\/h5>\n\n\n\n
Terakhir, di bagian ini kita akan menambahkan utilitas pengaturan ulang kata sandi ke sistem login kita. Dengan menggunakan fitur ini, pengguna yang masuk dapat langsung mengatur ulang kata sandi mereka sendiri untuk akun mereka.<\/p>\n\n\n
\n<?php\n\/\/ Initialize the session\nsession_start();\n \n\/\/ Check if the user is logged in, if not then redirect to login page\nif(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true){\n header("location: login.php");\n exit;\n}\n \n\/\/ Include config file\nrequire_once "config.php";\n \n\/\/ Define variables and initialize with empty values\n$new_password = $confirm_password = "";\n$new_password_err = $confirm_password_err = "";\n \n\/\/ Processing form data when form is submitted\nif($_SERVER["REQUEST_METHOD"] == "POST"){\n \n \/\/ Validate new password\n if(empty(trim($_POST["new_password"]))){\n $new_password_err = "Please enter the new password."; \n } elseif(strlen(trim($_POST["new_password"])) < 6){\n $new_password_err = "Password must have atleast 6 characters.";\n } else{\n $new_password = trim($_POST["new_password"]);\n }\n \n \/\/ Validate confirm password\n if(empty(trim($_POST["confirm_password"]))){\n $confirm_password_err = "Please confirm the password.";\n } else{\n $confirm_password = trim($_POST["confirm_password"]);\n if(empty($new_password_err) && ($new_password != $confirm_password)){\n $confirm_password_err = "Password did not match.";\n }\n }\n \n \/\/ Check input errors before updating the database\n if(empty($new_password_err) && empty($confirm_password_err)){\n \/\/ Prepare an update statement\n $sql = "UPDATE users SET password = ? 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, "si", $param_password, $param_id);\n \n \/\/ Set parameters\n $param_password = password_hash($new_password, PASSWORD_DEFAULT);\n $param_id = $_SESSION["id"];\n \n \/\/ Attempt to execute the prepared statement\n if(mysqli_stmt_execute($stmt)){\n \/\/ Password updated successfully. Destroy the session, and redirect to login page\n session_destroy();\n header("location: login.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 \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>Reset Password<\/title>\n <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css">\n <style type="text\/css">\n body{ font: 14px sans-serif; }\n .wrapper{ width: 350px; padding: 20px; }\n <\/style>\n<\/head>\n<body>\n <div class="wrapper">\n <h2>Reset Password<\/h2>\n <p>Please fill out this form to reset your password.<\/p>\n <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> \n <div class="form-group <?php echo (!empty($new_password_err)) ? 'has-error' : ''; ?>">\n <label>New Password<\/label>\n <input type="password" name="new_password" class="form-control" value="<?php echo $new_password; ?>">\n <span class="help-block"><?php echo $new_password_err; ?><\/span>\n <\/div>\n <div class="form-group <?php echo (!empty($confirm_password_err)) ? 'has-error' : ''; ?>">\n <label>Confirm Password<\/label>\n <input type="password" name="confirm_password" class="form-control">\n <span class="help-block"><?php echo $confirm_password_err; ?><\/span>\n <\/div>\n <div class="form-group">\n <input type="submit" class="btn btn-primary" value="Submit">\n <a class="btn btn-link" href="welcome.php">Cancel<\/a>\n <\/div>\n <\/form>\n <\/div> \n<\/body>\n<\/html>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Menerapkan Mekanisme Otentikasi Pengguna Otentikasi pengguna sangat umum dalam aplikasi web modern. Ini adalah mekanisme keamanan yang digunakan untuk membatasi akses tidak sah (restrict unauthorized)<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-552","post","type-post","status-publish","format-standard","hentry","category-php"],"yoast_head":"\n
Belajar PHP MySQL : Login System - WebHozz Code<\/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\/code\/php-mysql-login-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Belajar PHP MySQL : Login System - WebHozz Code\" \/>\n<meta property=\"og:description\" content=\"Menerapkan Mekanisme Otentikasi Pengguna Otentikasi pengguna sangat umum dalam aplikasi web modern. Ini adalah mekanisme keamanan yang digunakan untuk membatasi akses tidak sah (restrict unauthorized)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Code\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-20T14:17:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-20T14:17:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png\" \/>\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=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"headline\":\"PHP MySQL : Login System\",\"datePublished\":\"2019-09-20T14:17:17+00:00\",\"dateModified\":\"2019-09-20T14:17:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/\"},\"wordCount\":704,\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.tutorialrepublic.com\\\/lib\\\/images\\\/php-signup-form.png\",\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/\",\"name\":\"Belajar PHP MySQL : Login System - WebHozz Code\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.tutorialrepublic.com\\\/lib\\\/images\\\/php-signup-form.png\",\"datePublished\":\"2019-09-20T14:17:17+00:00\",\"dateModified\":\"2019-09-20T14:17:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.tutorialrepublic.com\\\/lib\\\/images\\\/php-signup-form.png\",\"contentUrl\":\"https:\\\/\\\/www.tutorialrepublic.com\\\/lib\\\/images\\\/php-signup-form.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-mysql-login-system\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySQL : Login System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\",\"name\":\"WebHozz Code\",\"description\":\"Tutorial Web & Pemrograman Indonesia\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/author\\\/dody\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Belajar PHP MySQL : Login System - WebHozz Code","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\/code\/php-mysql-login-system\/","og_locale":"en_US","og_type":"article","og_title":"Belajar PHP MySQL : Login System - WebHozz Code","og_description":"Menerapkan Mekanisme Otentikasi Pengguna Otentikasi pengguna sangat umum dalam aplikasi web modern. Ini adalah mekanisme keamanan yang digunakan untuk membatasi akses tidak sah (restrict unauthorized)","og_url":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/","og_site_name":"WebHozz Code","article_published_time":"2019-09-20T14:17:17+00:00","article_modified_time":"2019-09-20T14:17:21+00:00","og_image":[{"url":"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"headline":"PHP MySQL : Login System","datePublished":"2019-09-20T14:17:17+00:00","dateModified":"2019-09-20T14:17:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/"},"wordCount":704,"image":{"@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#primaryimage"},"thumbnailUrl":"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png","articleSection":["PHP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/","url":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/","name":"Belajar PHP MySQL : Login System - WebHozz Code","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#primaryimage"},"thumbnailUrl":"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png","datePublished":"2019-09-20T14:17:17+00:00","dateModified":"2019-09-20T14:17:21+00:00","author":{"@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"breadcrumb":{"@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#primaryimage","url":"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png","contentUrl":"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/code\/php-mysql-login-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/code\/"},{"@type":"ListItem","position":2,"name":"PHP MySQL : Login System"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/code\/#website","url":"https:\/\/www.webhozz.com\/code\/","name":"WebHozz Code","description":"Tutorial Web & Pemrograman Indonesia","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/code\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/code\/author\/dody\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/comments?post=552"}],"version-history":[{"count":4,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/552\/revisions"}],"predecessor-version":[{"id":557,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/552\/revisions\/557"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/media?parent=552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/categories?post=552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/tags?post=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"PHP](\"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-signup-form.png\")
<\/figure>\n\n\n\n![\"PHP](\"https:\/\/www.tutorialrepublic.com\/lib\/images\/php-login-form.png\")
<\/figure>\n\n\n\n