[TUTORIAL] Cara membuat Website Dinamis Sederhana dengan HTML, CSS, PHP, dan MySQL

<?php
#script 9.2

// Set the database access information as constants :
DEFINE('DB_USER', 'webdev');
DEFINE('DB_PASSWORD', 'webdev');
DEFINE('DB_HOST', 'localhost');
DEFINE('DB_NAME', 'sitename');

//Make connection
$dbc = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die ('Could not connect to MySQL: ' . mysqli_connect_error);

//set encoding
mysqli_set_charset($dbc, 'utf8');
?>

<?php
#template
$filecss = "../css/style.css";
$page_title = "Login";
$linkcalculator = "calculator.php";
$linkregister = "register.php";
$view_user = "view_users.php";
$password = "password.php";

include('../layouts/header.php');

if (isset($errors) && !empty($errors)) {
    echo '<h1>Error!</h1>
    <p class="error">Berikut kesalahan yang ditemukan:<br/>';
    foreach ($errors as $msg) {
        echo "- $msg<br>\n";
    }
    echo '</p><p>Silakan diicoba lagi.</p>';
}
?>

<h1>Login</h1>
<form action="login.php" method="post">
    <p>Email address: <input type="email" name="email" size="30" maxlength="60"/></p>
    <p>Password: <input type="password" name="pass" size="20" maxlength="20"/></p>
    <p><input type="submit" name="submit" value="login"/></p>
</form>

<?php
include('../includes/footer.php');
?>

<?php
function redirect_user($page="index.php") {
    $url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);

    $url = rtrim($url, '/\\');

    $url = '/' . $page;

    header("Location: $url");
    exit();
}

function check_login($dbc, $email='', $pass='') {
    $errors = array();
    if (empty($email)) {
        $errors[] = 'Masukkan alamat Email';
    } else {
        $e = mysqli_real_escape_string($dbc, trim($email));
    }
    if (empty($pass)){
        $errors[] = 'Masukkan Password Anda';
    } else {
        $p = mysqli_real_escape_string($dbc, trim($pass));
    }
    if (empty($errors)) {
        $q = "SELECT user_id, first_name FROM users WHERE email='$e' AND pass=SHA1('$p')";
        $r = @mysqli_query($dbc, $q);
        if (@mysqli_num_rows($r) == 1) {
            $row = mysqli_fetch_array($r, MYSQLI_ASSOC);
            return array(true, $row);
        } else {
            $errors[] = "Email dan Password tidak nyambung.";
        }
    }
    return array(false, $errors);
}
?>

<?php
$fileclass = "../css/style.css";
$page_title = "Register";
$linkcalculator = "calculator.php";
$linkregister = "register.php";
$view_user = "view_user.php";
$password = "password.php";

include ('../layouts/header.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    include ('../../include/mysqli_connect.php');
    $fn = trim($_POST['first_name']);
    $ln = trim($_POST['last_name']);
    $e = trim($_POST['email']);
    $p = trim($_POST['pass']);

    $q = "INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUE ('$fn', '$ln', '$e', SHA1('$p'), NOW())";
    $r = @mysqli_connect ($dbc, $q);

    if ($r) {
        echo '<h1>Thank you!</h1>
        <p>You are now registered.</p> <p><br /></p>';
    } else {
        echo '<h1>System Error</h1>
        <p class="error">You could not be registered due to a system error. We apologize for any inconvience.</p>';
    }
    mysqli_close($dbc);
}

?>

<h1>Register</h1>
<form action="register.php" method="post">
    <p>First Name: <input type="text" name="first_name" size="15" maxlength="20"
    value="<?php if(isset($_POST['first_name'])) echo $_POST['first_name'];?>"></p>

    <p>Last Name: <input type="text" name="last_name" size="15" maxlength="40"
    value="<?php if(isset($_POST['last_name'])) echo $_POST['last_name'];?>"></p>

    <p>Email Address: <input type="text" name="email" size="20" maxlength="60"
    value="<?php if(isset($_POST['email'])) echo $_POST['email'];?>"></p>
    
    <p>Password: <input type="text" name="pass" size="10" maxlength="20"
    value="<?php if(isset($_POST['pass'])) echo $_POST['pass'];?>"></p>

    <p>Confirm Password: <input type="text" name="pass2" size="10" maxlength="20"
    value="<?php if(isset($_POST['pass2'])) echo $_POST['pass2'];?>"></p>

    <p><input type="submit" name="submit" value="Register"></p>
</form>

<?php
require ('../layouts/header.php');

#template
if($_SERVER['REQUEST_METHOD'] == 'POST') {
    require('../includes/login_function.inc.php');
    require('../includes/mysqli_connect.php');

    list($check, $data) = check_login($dbc, $_POST['email'], $_POST['pass']);

    if($check) {
        setcookie('user_id', $data['user_id'], time()+3600, '/', '', 0, 0);
        setcookie('first_name', $data['first_name'], time()+3600, '/', '', 0, 0);
    
        redirect_users('loggedin.php');
    } else {
        $errors = $data;
    }

    mysqli_close($dbc);
}

include('../layouts/footer.php');
?>

<?php
$filecss = "../css/style.css";
$linkcalculator = "calculator.php";
$linkregister = "register.php";
$view_user = "view_users.php";
$password = "password.php";

session_start();
if(!isset($_SESSION['user_id']) OR ($_SESSION['agent'] != md5($_SERVER['HTTP_USER_AGENT']))) {
    require('../includes/login_function.inc.php');
    redirect_user();
}

$page_title = "Logged In";

include('../layouts/header.php');
echo "<h1>Logged In!</h1>
<p>You are logged in as {$_SESSION['first_name']}.</p>
<p><a href=\"logout.php\">Logout</a></p>";

include('../layouts/footer.php');
?>

<?php
require ('../layouts/header.php');

#template
session_start();
if(!isset($_SESSION['user_id'])) {
    require('../includes/login_function.inc.php');
    redirect_user();
} else {
    //setcookie('user_id', $data['user_id'], time()+3600, '/', '', 0, 0);
    //setcookie('first_name', $data['first_name'], time()+3600, '/', '', 0, 0);
    $_SESSION = array();
    session_destroy();

    setcookie('PHPSESSIONID', '', time()-3600, '/', '', 0, 0);
}

$page_title = 'Logout';
$filecss = "../css/style.css";
$linkcalculator = "calculator.php";
$linkregister = "register.php";
$view_user = "view_users.php";
$password = "password.php";

include('../layouts/header.php');
?>

<h1>Logged Out</h1>
<p>Anda sekarang telah logged out.<?php echo $_COOKIE['first_name'];?></p>

<?php
include('../layouts/footer.php');
?>

<?php
$filecss = "../css/style.css";
$page_title = "Change Password";
$linkcalculator="calculator.php";
$linkregister="register.php";
$view_user ="view_user.php";
$password ="password.php";
include ('../layouts/header.php');

?>
<?php # Script 9.7 - password.php
// Check for form submission:
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

    require ('../../includes/mysqli_connect.php');
    $errors = array(); // Initialize an error array.

    // Check for an email address:
    if (empty($_POST['email'])) {
        $errors[] = 'You forgot to enter your email address.';
    } else {
        $e = mysqli_real_escape_string($dbc, trim($_POST['email']));
    }

    // Check for the current password:
    if (empty($_POST['pass'])) {
        $errors[] = 'You forgot to enter your current password.';
    } else {
        $p = mysqli_real_escape_string($dbc, trim($_POST['pass']));
    }

    // Check for a new password and match
    // against the confirmed password:
    if (!empty($_POST['pass1'])) {
        if ($_POST['pass1'] != $_POST['pass2']) {
            $errors[] = 'Your new password did not match the confirmed password.';
        } else {
            $np = mysqli_real_escape_string($dbc, trim($_POST['pass1']));
        }
    } else {
        $errors[] = 'You forgot to enter your new password.';
    }

    if (empty($errors)) { // If everything's OK.

        // Check that they've entered the right email address/password combination:
        $q = "SELECT user_id FROM users WHERE (email='$e' AND pass=SHA1('$p') )";
        $r = @mysqli_query($dbc, $q);
        $num = @mysqli_num_rows($r);
        if ($num == 1) { // Match was made.

            // Get the user_id:
            $row = mysqli_fetch_array($r, MYSQLI_NUM);

            // Make the UPDATE query:
            $q = "UPDATE users SET pass=SHA1('$np') WHERE user_id=$row[0]";
            $r = @mysqli_query($dbc, $q);

            if (mysqli_affected_rows($dbc) == 1) { // If it ran OK.

                // Print a message.
                echo '<h1>Thank you!</h1>
                <p>Your password has been updated. In Chapter 12 you will actually be able to log in!</p><p><br></p>';

            } else { // If it did not run OK.

                // Public message:
                echo '<h1>System Error</h1>
                <p class="error">Your password could not be changed due to a system error. We apologize for any inconvenience.</p>';

                // Debugging message:
                echo '<p>' . mysqli_error($dbc) . '<br><br>Query: ' . $q . '</p>';

            }

            mysqli_close($dbc); // Close the database connection.

            // Include the footer and quit the script (to not show the form).
            include ('includes/footer.html');
            exit();

        } else { // Invalid email address/password combination.
            echo '<h1>Error!</h1>
            <p class="error">The email address and password do not match those on file.</p>';
        }

    } else { // Report the errors.

        echo '<h1>Error!</h1>
        <p class="error">The following error(s) occurred:<br>';
        foreach ($errors as $msg) { // Print each error.
            echo " - $msg<br>\n";
        }
        echo '</p><p>Please try again.</p><p><br></p>';

    } // End of if (empty($errors)) IF.

    mysqli_close($dbc); // Close the database connection.

} // End of the main Submit conditional.
?>
<h1>Change Your Password</h1>
<form action="password.php" method="post">
    <p>Email Address: <input type="text" name="email" size="20" maxlength="60" value="<?php if (isset($_POST['email'])) echo $_POST['email']; ?>" > </p>
    <p>Current Password: <input type="password" name="pass" size="10" maxlength="20" value="<?php if (isset($_POST['pass'])) echo $_POST['pass']; ?>" ></p>
    <p>New Password: <input type="password" name="pass1" size="10" maxlength="20" value="<?php if (isset($_POST['pass1'])) echo $_POST['pass1']; ?>" ></p>
    <p>Confirm New Password: <input type="password" name="pass2" size="10" maxlength="20" value="<?php if (isset($_POST['pass2'])) echo $_POST['pass2']; ?>" ></p>
    <p><input type="submit" name="submit" value="Change Password"></p>
</form>
<?php
include ('../layouts/footer.php');
?>

<?php
require ('../layouts/header.php');

$page_title="User Terdaftar";
$display = 10;
require('../includes/mysqli_connect.php');
if(isset($_GET['p']) && is_numeric($_GET['p'])){
    $pages = $_GET['p'];
}else{
    //total record
    $q = "SELECT COUNT(user_id) FROM users";
    $r = @mysqli_query($dbc, $q);
    $row = @mysqli_fetch_array($r, MYSQLI_NUM);
    $records = $row[0];
    if($records>$display){
        $pages = ceil($records/$display);
    }else{
        $pages = 1;
    }
}
if(isset($_GET['s']) && is_numeric($_GET['s'])){
        $start = $_GET['s'];
    }else{
        $start=0;
}
//Menentukan sort 
$sort = (isset($_GET['sort'])) ? $_GET['sort'] : 'rd';
switch ($sort){
    case 'ln':
        $order_by = 'last_name ASC';
        break;
    case 'fn': 
        $order_by = 'first_name ASC';
        break;
    case 'e': 
        $order_by = 'email ASC';
        break;
    case 'rd':
        $order_by = 'registration_date ASC';
        break;
    default:
        $order_by = 'registration_date ASC';
        break;
}
?>

<h1>Halaman Users</h1>

<?php

$sql = "SELECT last_name, first_name, email, DATE_FORMAT(registration_date, '%M %d, %Y') AS dr, user_id 
FROM users ORDER BY $order_by LIMIT $start, $display";
$r = @mysqli_query($dbc, $sql);//run query
//total row
$num = mysqli_num_rows($r);
if($num) {
    echo "<p> Total user found $num </p>\n";
    
    echo '<table align="center" cellspacing="3" cellpadding="3" width="75%">
    <tr><td align="left"><strong>Edit</strong></td>
    <td align="left"><strong>Delete</strong></td>
    <td align="left"><strong><a href="view_users.php?sort=ln">Last Name</a></strong></td>
    <td align="left"><strong><a href="view_users.php?sort=fn">First Name</a></strong></td>
    <td align="left"><strong><a href="view_users.php?sort=e">Email</a></strong></td>
    <td align="left"><strong><a href="view_users.php?sort=rd">Registration Date</a></strong></td>
    </tr>';
    $bg = '#eeeeee';
    while($row = mysqli_fetch_array($r, MYSQLI_ASSOC)){
        $bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');
        echo '<tr bgcolor=' . $bg . '">
        <td align="left"><a href="edit_user.php?id=' . $row['user_id'] . '">Edit</a></td>
        <td align="left"><a href="delete_user.php?id=' . $row['user_id'] . '">Delete</a></td>
        <td align="left">' . $row['last_name'] . '</td>
        <td align="left">' . $row['first_name'] . '</td>
        <td align="left">' . $row['email'] . '</td>
        <td align="left">' . $row['dr'] . '</td></tr>';
    }
    echo '</table>';
    mysqli_free_result($r);
    mysqli_close($dbc);
} else {
    echo '<p class="error"> Users could not be rettrieved".</p>';
    echo '<p>' . mysqli_error($dbc) . '<br/>Query: ' . $sql . '</p>';
}
if($pages>1){
    echo '<br/><p>';
    $current_page = ($start/$display) + 1;
    if($current_page !=1){
        echo '<a href="view_users.php?s=' . ($start - $display) . '&p=' . $pages . '">Previous</a>';
    }
    //tampilkan jumlah halaman
    for($i=1;$i<=$pages; $i++){
        if($i !=$current_page){
            echo '<a href="view_users.php?s=' . (($display * ($i - 1))) . '&p=' . $pages . '">' . $i . '</a>';
        }else{
            echo $i . ' ';
        }
    }
    if($current_page !=$pages){
        echo '<a href="view_users.php?s=' . ($start + $display) . '&p=' . $pages . '">Next</a>';
    }
    echo '</p>';
}
?>

<?php
include('../layouts/footer.php');
?>

<?php
$fileclass = "../css/style.css";
$page_title = "Add Products";
$linkcalculator = "calculator.php";
$linkregister = "register.php";
$view_user = "view_user.php";
$password = "password.php";

include ('../layouts/header.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    include ('../../include/mysqli_connect.php');
    $pn = trim($_POST['produk_nama']);
    $c = trim($_POST['kategori']);
    $hs = trim($_POST['harga_satuan']);
    $st = trim($_POST['stok']);
    $ol = trim($_POST['order_level']);

    $q = "INSERT INTO users (produk_nama, kategori, stok, order_level) VALUE ('$pn', '$c', '$hs', '$st', $ol, NOW())";
    $r = @mysqli_connect ($dbc, $q);

    if ($r) {
        echo '<h1>Thank you!</h1>
        <p>You are now registered.</p> <p><br /></p>';
    } else {
        echo '<h1>System Error</h1>
        <p class="error">You could not be registered due to a system error. We apologize for any inconvience.</p>';
    }
    mysqli_close($dbc);
}
?>

<h1>Add Products</h1>
<form action="register.php" method="post">
    <p>Nama Produk: <input type="text" name="produk_nama" size="15" maxlength="20"
    value="<?php if(isset($_POST['produk_nama'])) echo $_POST['produk_nama'];?>"></p>

    <p>Kategori: <input type="text" name="kategori" size="15" maxlength="40"
    value="<?php if(isset($_POST['kategori'])) echo $_POST['kategori'];?
>"></p>

    <p>Harga Satuan: <input type="text" name="harga_satuan" size="5" maxlength="10"
    value="<?php if(isset($_POST['harga_satuan'])) echo $_POST['harga_satuan'];?>"></p>
    
    <p>Stok: <input type="text" name="stok" size="1" maxlength="5"
    value="<?php if(isset($_POST['stok'])) echo $_POST['stok'];?>"></p>

    <p>Order Level: <input type="text" name="order_level" size="1" maxlength="5"
    value="<?php if(isset($_POST['order_level'])) echo $_POST['order_level'];?>"></p>
    
    <p><input type="submit" name="submit" value="Add"></p>
</form>

<?php
require ('../layouts/header.php');

$page_title="Produk Terdaftar";
$display = 10;
require('../includes/mysqli_connect.php');


if(isset($_GET['p']) && is_numeric($_GET['p'])){
    $pages = $_GET['p'];
}else{
    //total record
    $q = "SELECT COUNT(produk_id) FROM produk";
    $r = @mysqli_query($dbc, $q);
    $row = @mysqli_fetch_array($r, MYSQLI_NUM);
    $records = $row[0];
    if($records>$display){
        $pages = ceil($records/$display);
    }else{
        $pages = 1;
    }
}

if(isset($_GET['s']) && is_numeric($_GET['s'])){
        $start = $_GET['s'];
    }else{
        $start=0;
}

//Menentukan sort 
$sort = (isset($_GET['sort'])) ? $_GET['sort'] : 'pn';
switch ($sort){
    case 'pn':
        $order_by = 'produk_nama ASC';
        break;
    case 'c': 
        $order_by = 'kategori ASC';
        break;
    case 'hs':
        $order_by = 'harga_satuan ASC';
        break;
    case 's':
        $order_by = 'stok ASC';
        break;
    case 'ol':
        $order_by = 'order_level ASC';
        break;
    default:
        $order_by = 'produk_nama ASC';
        break;
}
?>

<h1>Halaman Produk</h1>

<?php

$sql = "SELECT produk_nama, kategori, harga_satuan, stok, order_level, produk_id 
FROM produk ORDER BY $order_by LIMIT $start, $display";
$r = @mysqli_query($dbc, $sql);//run query
//total row
$num = mysqli_num_rows($r);
if($num) {
    echo "<p> Total produk found $num </p>\n";
    
    echo '<table align="center" cellspacing="3" cellpadding="3" width="75%">
    <tr><td align="left"><strong>Edit</strong></td>
    <td align="left"><strong>Delete</strong></td>
    <td align="left"><strong><a href="view_products.php?sort=pn">Produk Nama</a></strong></td>
    <td align="left"><strong><a href="view_products.php?sort=c">Kategori</a></strong></td>
    <td align="left"><strong><a href="view_products.php?sort=hs">Harga Satuan</a></strong></td>
    <td align="left"><strong><a href="view_products.php?sort=s">Stok</a></strong></td>
    <td align="left"><strong><a href="view_products.php?sort=ol">Order Level</a></strong></td>
    </tr>';
    $bg = '#eeeeee';
    while($row = mysqli_fetch_array($r, MYSQLI_ASSOC)){
        $bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');
        echo '<tr bgcolor=' . $bg . '">
        <td align="left"><a href="edit_product.php?id=' . $row['produk_id'] . '">Edit</a></td>
        <td align="left"><a href="delete_product.php?id=' . $row['produk_id'] . '">Delete</a></td>
        <td align="left">' . $row['produk_nama'] . '</td>
        <td align="left">' . $row['kategori'] . '</td>
        <td align="left">' . $row['harga_satuan'] . '</td>
        <td align="left">' . $row['stok'] . '</td>
        <td align="left">' . $row['order_level'] . '</td></tr>';
    }
    echo '</table>';
    mysqli_free_result($r);
    mysqli_close($dbc);
} else {
    echo '<p class="error"> Users could not be rettrieved".</p>';
    echo '<p>' . mysqli_error($dbc) . '<br/>Query: ' . $sql . '</p>';
}
if($pages>1){
    echo '<br/><p>';
    $current_page = ($start/$display) + 1;
    if($current_page !=1){
    echo '<a href="view_products.php?s=' . ($start - $display) . '&p=' . $pages . '&sort=' . $sort . '">Previous</a>';
    }
    //tampilkan jumlah halaman
    for($i=1;$i<=$pages; $i++){
    if($i !=$current_page){
    echo '<a href="view_products.php?s=' . (($display * ($i - 1))) . '&p=' . $pages . '&sort=' . $sort . '">' . $i . '</a>';
    }else{
    echo $i . ' ';
    }
    }
    if($current_page !=$pages){
    echo '<a href="view_products.php?s=' . ($start + $display) . '&p=' . $pages . '&sort=' . $sort . '">Next</a>';
    }
    echo '</p>';
    }
    
    include('../layouts/footer.php');
?>

<?php
$page_title = "Delete User";

include('../layouts/header.php');

if((isset($_GET['id'])) && (is_numeric($_GET['id']))) {
    $id = $_GET['id'];
} elseif((isset($_POST['id'])) && (is_numeric($_POST['id']))) {
    $id = $_POST['id'];
} else {
    echo '<p class="error">Error Ditemukan</p>';
    include('../includes/footer.html');
    exit();
}
?>
<h1>Halaman Delete User</h1>
<?php 
require('../includes/mysqli_connect.php');
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

  if($_POST['sure'] == 'Yes') {
    $q = "DELETE FROM users WHERE user_id = $id LIMIT 1";
    $r = @mysqli_query($dbc, $q);
    
    if(mysqli_affected_rows($dbc) == 1) {
      echo '<p>User berhasil dihapus</p>';
    }
    
    else {
      echo '<p class="error">Error ditemukan, user tidak bisa dihapus</p>';
      echo '<p>'.mysqli_error($dbc).'<br/>'.$q.'</p>';
    }
  } else {
    echo '<p>User tidak jadi dihapus</p>';
  }
} else {
    //tampilkan form
    
    $q = "SELECT CONCAT(last_name, ', ', first_name) FROM users WHERE user_id = $id";
    $r = @mysqli_query($dbc, $q);
  
    if(mysqli_num_rows($r) == 1) {
    $row = mysqli_fetch_array($r, MYSQLI_NUM);
    echo "<br />";
    echo "<h3>Name: $row[0]</h3>
    <br />
    Are you sure to delete this user?";
    //create user
    echo '<form action="delete_user.php" method="post">
    <input type="radio" name="sure" value="Yes"> Yes 
    <input type="radio" name="sure" value="No"> No 
    <input type="submit" name="submit" value="Submit">
    <input type="hidden" name="id" value="'. $id .'">
    </form>';  
    } else {
      echo '<p class="error">Error ditemukan, ulangi lagi</p>';
    }
}

mysqli_close($dbc);
include('../layouts/footer.php');
?>

<?php
$page_title = "Delete Product";

include('../layouts/header.php');

if((isset($_GET['id'])) && (is_numeric($_GET['id']))) {
    $id = $_GET['id'];
} elseif((isset($_POST['id'])) && (is_numeric($_POST['id']))) {
    $id = $_POST['id'];
} else {
    echo '<p class="error">Error Ditemukan</p>';
    include('../includes/footer.html');
    exit();
}
  
?>
<h1>Halaman Delete User</h1>
<?php 
require('../includes/mysqli_connect.php');
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

  if($_POST['sure'] == 'Yes') {
    $q = "DELETE FROM users WHERE user_id = $id LIMIT 1";
    $r = @mysqli_query($dbc, $q);
    
    if(mysqli_affected_rows($dbc) == 1) {
      echo '<p>User berhasil dihapus</p>';
    }
    
    else {
      echo '<p class="error">Error ditemukan, user tidak bisa dihapus</p>';
      echo '<p>'.mysqli_error($dbc).'<br/>'.$q.'</p>';
    }
  } else {
    echo '<p>User tidak jadi dihapus</p>';
  }
} else {
    //tampilkan form
    
    $q = "SELECT CONCAT(produk_nama, '(', kategori, ')') FROM produk WHERE produk_id = $id";
    $r = @mysqli_query($dbc, $q);
  
    if(mysqli_num_rows($r) == 1) {
    $row = mysqli_fetch_array($r, MYSQLI_NUM);
    echo "<br />";
    echo "<h3>Name: $row[0]</h3>
    <br />
    Are you sure to delete this product?";
    //create user
    echo '<form action="delete_product.php" method="post">
    <input type="radio" name="sure" value="Yes"> Yes 
    <input type="radio" name="sure" value="No"> No 
    <input type="submit" name="submit" value="Submit">
    <input type="hidden" name="id" value="'. $id .'">
    </form>';  
    } else {
      echo '<p class="error">Error ditemukan, ulangi lagi</p>';
    }
}

mysqli_close($dbc);
include('../layouts/footer.php');
?>