Posts

Showing posts from November, 2022

APLIKASI PERPUSTAKAAN DENGAN BOOTSTRAP 5, PHP DAN MYSQL

 koneksi.php <?php  $db = mysqli_connect("localhost","root","","perpus"); function query($query){     global $db;     $result = mysqli_query($db, $query);     $rows = [];     while ($row = mysqli_fetch_assoc($result)) {         $rows[] = $row;     }     return $rows; } function register($nis,$nama,$password){     global $db;     $result = mysqli_query($db, "select nis from user where nis = '$nis'");     if (mysqli_fetch_assoc($result)) {         echo "<script>         alert('NIS sudah terdaftar!')         </script>";         return false;     }     $sql = mysqli_query($db,"insert into user value('$nis','$nama','$password')");     return $sql; } function login($nis,$password){     global $db;     $sql = mysqli_query($db, "selec...

Aplikasi PKL dengan PHP

PHP koneksi.php <?php       $host = "localhost"; $username = "root"; $password = ""; $database = "pkl"; $koneksi = mysqli_connect($host,$username,$password,$database);       function register($username,$password,$nama) {         global $koneksi; $insert = mysqli_query($koneksi,"insert into user values ('$username','$password','$nama')"); return $insert; }   function login($username,$password,$remember) {         global $koneksi; $query = mysqli_query($koneksi,"select * from user where username='$username'"); $data_user = $query->fetch_array(); if(password_verify($password,$data_user['password'])) { if($remember) { setcookie('username', $username, time() + (60 * 60 * 24 * 5), '/'); setcookie('nama', $data_user['nama'], time() + (60 * 60 * 24 * 5), '/'); } $_SESSION['user...