Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $conn = new PDO('mysql:host=localhost;dbname=latuts','root','');
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Latihan UTS</title>
- <link rel="stylesheet" type="text/css" href="css\bootstrap.css">
- <link rel="stylesheet" type="text/css" href="css\dataTables.bootstrap.min.css">
- </head>
- <body>
- <?php
- if (isset($_POST['username']) && isset($_POST['password']) && isset($_POST['btnLogin'])) {
- $username = $_POST['username'];
- $password = $_POST['password'];
- $stmt = $conn->prepare("SELECT username, password, salt FROM account");
- $stmt->execute();
- $rows = $stmt->fetchAll();
- foreach ($rows as $key => $line) {
- $pass_salt = $password . $line['salt'];
- $hash = md5($pass_salt);
- if($username == $line['username'] && strcmp($line['password'], $hash) == 0){
- $_SESSION['loginFlag'] = true;
- break;
- }
- }
- }
- if(isset($_POST['dataEdit'])){
- $nim = $_POST['updateNim'];
- $fname = $_POST['updateFname'];
- $lname = $_POST['updateLname'];
- $desc = $_POST['updateDesc'];
- $conn->query("UPDATE description SET studentid = '$nim', fname = '$fname', lname='$lname', descr = '$desc' WHERE ID=".$_SESSION['kodeUpdate']);
- header('Location: index.php');
- }
- if(isset($_POST['btnDelete'])){
- $conn->query("DELETE FROM description WHERE ID=".$_SESSION['kodeDelete']);
- }
- if(isset($_POST['dataInsert'])){
- $nim = $_POST['nim'];
- $lname = $_POST['lastname'];
- $fname = $_POST['firstname'];
- $desc = $_POST['description'];
- $id = ($result['max(id)']+1);
- $conn->query("INSERT INTO description VALUES($id, '$nim', '$fname', '$lname', '$desc'");
- header("Location: index.php");
- }
- ?>
- <nav class="navbar navbar-default">
- <div class="">
- <div class="navbar-header">
- <a href="#" class="navbar-brand">Latihan UTS</a>
- </div>
- <div></div>
- </div>
- </nav>
- <!-- modal Login -->
- <div class="modal fade" id="login-modal" role="dialog">
- <div class="container">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <h1 class="modal-title">Login dulu bos</h1>
- </div>
- <div class="modal-body">
- <form class="form-horizontal" action="index.php" method="post">
- <div class="form-group">
- <label for="username">Username</label>
- <input type="text" name="username" placeholder="Username..." class="form-control">
- </div>
- <div class="form-group">
- <label>Password</label>
- <input type="password" name="password" placeholder="Password..." class="form-control">
- </div>
- <div class="form-group modal-footer">
- <button type="submit" name="btnLogin">Login</button>
- </div>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- modalEdit -->
- <div class="modal fade" id="modalEdit" role="dialog">
- <div class="container">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <h1 class="modal-title">Edit Data Mahasiswa</h1>
- </div>
- <div class="modal-body">
- <form class="form-horizontal" action="index.php" method="post" enctype="multipart/form-data">
- <div class="form-group">
- <div class="col-sm-3">
- <label>NIM</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="updateNim" id="updateNim" class="form-control" placeholder="Nim">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-3">
- <label>First Name</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="updateFname" id="updateFname" class="form-control" placeholder="First Name">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-3">
- <label>Last Name</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="updateLname" id="updateLname" class="form-control" placeholder="Last Name">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-3">
- <label>Description</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="updateDesc" id="updateDesc" class="form-control" placeholder="Description">
- </div>
- </div>
- <div class="modal-footer">
- <input type="submit" name="dataEdit" class="btn btn-primary" value="Update"/>
- </div>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- modal insert -->
- <div class="modal fade" id="modalInsert" role="dialog">
- <div class="container">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <h1 class="modal-title">Insert Data Mahasiswa</h1>
- </div>
- <div class="modal-body">
- <form class="form-horizontal" action="index.php" method="post" enctype="multipart/form-data">
- <div class="form-group">
- <div class="col-sm-3">
- <label>NIM</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="nim" id="nim" class="form-control" placeholder="Nim">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-3">
- <label>First Name</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="firstName" id="firstName" class="form-control" placeholder="First Name">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-3">
- <label>Last Name</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="lastName" id="lastName" class="form-control" placeholder="Last Name">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-3">
- <label>Description</label>
- </div>
- <div class="col-sm-9">
- <input type="text" name="description" id="description" class="form-control" placeholder="Description">
- </div>
- </div>
- <div class="modal-footer">
- <input type="submit" name="dataInsert" class="btn btn-primary" value="Insert"/>
- </div>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- modaldelete -->
- <div class="modal fade" id="modalDelete">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <h4>Delete Mahasiswa</h4>
- </div>
- <div class="modal-body">
- <form class="form-horizontal" role="form" action="index.php" method="post">
- <div class="form-group">
- <div class="col-sm-12">
- <label class="control-label">Are you sure></label>
- </div>
- </div>
- <div class="modal-footer">
- <a class="btn btn-default" data-dismiss="modal">Cancel</a>
- <input id="delete" type="submit" name="btnDelete" class="btn btn-primary" value="Delete"/>
- </div>
- </form>
- </div>
- </div>
- </div>
- </div>
- <?php
- if(isset($_SESSION['loginFlag'])){
- ?>
- <div class="container">
- <div class="text-right">
- <form method="post" action="index.php">
- <a class="btn btn-primary" data-toggle='modal' data-target='#modalInsert' style="margin-bottom: 5px;">
- <span class="glyphicon glyphicon-user"></span><button hidden name="btnInsert" ></button> Insert
- </a>
- </form>
- </div>
- <div class="text-right">
- <form method="post" action="index.php">
- <a href="index.php" class="btn btn-primary" style="margin-bottom: 5px;">
- <span class="glyphicon glyphicon-user"></span><button hidden type="submit" name="btnLogout"></button> Sign Out
- </a>
- </form>
- </div>
- </div>
- <?php
- if($_SESSION['loginFlag']==true){
- ?>
- <div class="container">
- <table class="table table-striped table-bordered" id="dataMahasiswa">
- <thead>
- <tr>
- <th>NIM</th>
- <th>First Name</th>
- <th>Last Name</th>
- <th>Description</th>
- <th>Option</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $mahasiswa = $conn->query('SELECT * FROM description;');
- foreach ($mahasiswa as $line) {
- echo "<tr>";
- echo "<td>".$line['studentid']."</td>";
- echo "<td>".$line['fname']."</td>";
- echo "<td>".$line['lname']."</td>";
- echo "<td>".$line['descr']."</td>";
- echo '<td>
- <form method="post" action="index.php">
- <input type="hidden" name="updateData" value="'.$line['ID'].'">
- <button class="btn btn-info btn-xs" name="editData">
- <i class="glyphicon glyphicon-pencil"> Edit</i>
- </button>
- <input type="hidden" name="deleteData" value="'.$line['ID'].'">
- <button class="btn btn-danger btn-xs" name="deleteMhs">
- <i class="glyphicon glyphicon-trash"> Delete</i>
- </button>
- </form>
- </td>';
- }
- ?>
- </tbody>
- </table>
- </div>
- <?php
- if (isset($_POST['btnLogout'])) {
- unset($_SESSION['loginFlag']);
- session_destroy();
- header("Location: index.php");
- }
- ?>
- <?php
- }
- }
- ?>
- <script type="text/javascript" src="js\jquery-1.11.3.min.js"></script>
- <script type="text/javascript" src="js\bootstrap.js"></script>
- <script type="text/javascript" src="js\jquery.dataTables.min.js"></script>
- <script type="text/javascript" src="js\dataTables.bootstrap.min.js"></script>
- <script type="text/javascript">
- <?php
- if(!isset($_SESSION['loginFlag'])){
- ?>
- $(document).ready(function(){
- $('#login-modal').modal('show')
- });
- $('#login-modal').modal({
- backdrop: 'static',
- keyboard: false
- })
- <?php
- } else if($_SESSION['loginFlag']==true){
- ?>
- $(document).ready(function(){
- $('#login-modal').modal('hide')
- $('#dataMahasiswa').DataTable();
- });
- <?php
- }
- // session_destroy();
- ?>
- </script>
- <?php
- if(isset($_POST['editData'])){
- $id = $_POST['updateData'];
- $dataEdit = $conn->query("SELECT * FROM description WHERE ID= $id LIMIT 1");
- $result = $dataEdit->fetch(PDO::FETCH_ASSOC);
- $_SESSION['kodeUpdate'] = $id;
- echo"<script>
- $(document).ready(function(){
- $('#modalEdit').modal({
- show: 'true',
- backdrop: 'static',
- keyboard: true
- });
- $('#updateNim').val('".$result['studentid']."');
- $('#updateFname').val('".$result['fname']."');
- $('#updateLname').val('".$result['lname']."');
- $('#updateDesc').val('".$result['descr']."');
- console.log(".$id.");
- })
- </script>";
- }
- if(isset($_POST['deleteMhs'])){
- $id = $_POST['deleteData'];
- $_SESSION['kodeDelete'] = $id;
- echo"<script>
- $(document).ready(function(){
- $('#modalDelete').modal({
- show: 'true',
- backdrop: 'static',
- keyboard: true});
- })
- </script>";
- }
- /*if (isset($_POST['btnInsert'])) {
- echo"<script>
- $(document).ready(function(){
- $('#modalInsert').modal({
- show: 'true',
- backdrop: 'static',
- keyboard: true});
- })
- </script>";
- }*/
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement