—͟͞͞★ᴶ𝗈ʰ𝕒®ì—͟͞͞★: Januari 2026

Senin, 12 Januari 2026

Membuat Halaman Login Dan Proses Login

1. Buat Halaman Form Login dengan nama : login.php

<html lang="id">
<head>
    <meta charset="UTF-8">
    <title>Login SMK</title>
    <style>
        body {
            margin: 0;
            padding: 0;
            font-family: Arial, Helvetica, sans-serif;
            height: 100vh;
            background: url('bg-smk.jpg') no-repeat center center fixed;
            background-size: cover;
        }

        .overlay {
            background: rgba(0, 0, 0, 0.65);
            height: 100vh;
            display: flex;
            justify-content: center;
            align-items: center;
        }

        .login-box {
            background: #ffffff;
            padding: 30px;
            width: 360px;
            border-radius: 12px;
            box-shadow: 0 10px 25px rgba(0,0,0,0.5);
            text-align: center;
        }

        .login-box img {
            width: 90px;
            margin-bottom: 10px;
        }

        .login-box h2 {
            margin: 10px 0 5px;
            color: #333;
        }

        .login-box p {
            margin-bottom: 20px;
            color: #666;
            font-size: 14px;
        }

        .login-box input {
            width: 100%;
            padding: 12px;
            margin: 8px 0;
            border: 1px solid #ccc;
            border-radius: 6px;
            font-size: 14px;
        }

        .login-box button {
            width: 100%;
            padding: 12px;
            background: #0d6efd;
            border: none;
            color: white;
            font-size: 16px;
            border-radius: 6px;
            cursor: pointer;
            margin-top: 10px;
        }

        .login-box button:hover {
            background: #084298;
        }

        .footer {
            margin-top: 15px;
            font-size: 12px;
            color: #888;
        }
    </style>
</head>
<body>

<div class="overlay">
    <div class="login-box">

        <!-- LOGO SEKOLAH -->
        <img src="logo-smk.png" alt="logo-smk">

        <h2>Login SMK Bahtra</h2>
        <p>Sistem Informasi Sekolah</p>

         <form action="proses_login.php" method="post">
             <input 
                    type="text" 
                    name="username" 
                    placeholder="Masukkan username" 
                    required>
            <input 
                    type="password" 
                    name="password" 
                    placeholder="Masukkan password" 
                    required>
            <button type="submit">Login</button>
        </form>

        <div class="footer">
            © 2026 SMK Bahtra
        </div>
    </div>
</div>

</body>
</html>

Struktur Folder yang Disarankan


/login.html
/login.php
/img/
 ├─ bg-smk.jpg     (foto sekolah / siswa / gedung SMK)
 └─ logo-smk.png   (logo sekolah)

/proses_login.php /logout.php /koneksi.php /dashboard.php

Buat tabel user di CMD

[db_smk]> CREATE TABLE users (

-> id INT AUTO_INCREMENT PRIMARY KEY,

-> username VARCHAR(50) NOT NULL,

-> password VARCHAR(255) NOT NULL,

-> role ENUM('admin','guru','siswa') NOT NULL

-> );

ini skript untuk membuat enskripsi password : hash.php

<?php
echo password_hash("123", PASSWORD_DEFAULT);
?>

tambahkan data admin ke tabel users : ( ketik di CMD )

INSERT INTO users (username, password, role)

-> VALUES (

-> 'admin',

-> '$2y$10$daNDJq.oSJMABhWMA9cIjuoctvmgLP/9G8ivQhFTleWHhwFvrT4GK',

-> 'admin');

2. buat koneksi database dengan nama : koneksi.php

<?php
$host = "localhost";
$user = "root";
$pass = "";
$db   = "db_smk";

$koneksi = mysqli_connect($host, $user, $pass, $db);

if (!$koneksi) {
    die("Koneksi database gagal: " . mysqli_connect_error());
}

`3. Buat Halaman Proses Login dengan nama : proses_login.php`

<?php
session_start();
include 'koneksi.php';

$username = mysqli_real_escape_string($koneksi, $_POST['username']);
$password = $_POST['password'];

$query = mysqli_query($koneksi, 
    "SELECT * FROM users WHERE username='$username'"
);

$user = mysqli_fetch_assoc($query);

if ($user) {
    // Cek password
    if (password_verify($password, $user['password'])) {

        // Simpan session
        $_SESSION['login'] = true;
        $_SESSION['id']    = $user['id'];
        $_SESSION['nama']  = $user['username'];
        $_SESSION['role']  = $user['role'];

        // Redirect sesuai role
        header("Location: index.php");
        exit;
    } else {
        echo "<script>
                alert('Password salah!');
                window.location='login.php';
              </script>";
    }
} else {
    echo "<script>
            alert('Username tidak ditemukan!');
            window.location='login.php';
          </script>";
}

`4. Buat Hamalan Session Start dengan nama : session_start.php`

<?php
session_start();

if (!isset($_SESSION['login'])) {
    header("Location: login.php");
    exit;
}
?>

`5. Buat Halaman logout dengan nama : logout.php`

<?php
session_start();
session_destroy();
header("Location: login.html");
exit;

Minggu, 11 Januari 2026

From Pencarian

Ini from Pencariannya :

<style type="text/css">
tr:hover{
    background:blue;
    color:white;
}
</style>

<h1> Data siswa</h1>
<form method="get" action="#">
    <table class="table" align="right">
        <tr>
            <td data-label="NIS" align="right">
                <input type="hidden" name="page" value="data_siswa">
                <input type="text" name="kata_kunci">
                <input type="submit" name="cari">
            </td>
        </tr>
    </table>
</form>

<?php

include"conn/config.php";
if(!isset($_GET['kata_kunci']))
    {$perintah="select * from tb_siswa";}
else
    {
        $kata_kunci=$_GET['kata_kunci'];
        $perintah="select * from tb_siswa WHERE 
                nis='$kata_kunci' OR
                nama='$kata_kunci' OR
                tempat_lahir='$kata_kunci' OR
                jenis_kelamin='$kata_kunci' OR
                tanggal_lahir='$kata_kunci' OR
                nama_ibukandung='$kata_kunci'";}
$query=mysqli_query($koneksi,$perintah);

Rabu, 07 Januari 2026

Basis Data Membuat from tb_nilai siswa

Basis Data

> SELECT SUM(nilai) From tb_nilai;

> SELECT COUNT(nilai) From tb_nilai;

>SELECT MAX(nilai) From tb_nilai;

>SELECT MIN(nilai) From tb_nilai;

>SELECT AVG(nilai) From tb_nilai;

-----------------------------------------------------------------------------------------------------------

MariaDB [(none)]> use db_smk;

Database changed

MariaDB [db_smk]> create table tb_nilai(

-> nis int(10)not null,

-> nama varchar(50)not null,

-> kelas varchar(10)not null,

-> nilai int(5)not null,

-> primary key(nis));

Query OK, 0 rows affected (0.005 sec)

MariaDB [db_smk]> insert into tb_nilai values('1001','Aan','XI RPL','85');

Query OK, 1 row affected (0.049 sec)

MariaDB [db_smk]> insert into tb_nilai values('1002','Iin','XI RPL','90');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> insert into tb_nilai values('1003','Uun','XI RPL','92');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> insert into tb_nilai values('1004','Een','XI RPL','89');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> insert into tb_nilai values('1005','Oon','XI RPL','93');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> select * from tb_nilai;

+------+------+--------+-------+

+------+------+--------+-------+

| 1001 | Aan | XI RPL | 85 |

| 1002 | Iin | XI RPL | 90 |

| 1003 | Uun | XI RPL | 92 |

| 1004 | Een | XI RPL | 89 |

| 1005 | Oon | XI RPL | 93 |

+------+------+--------+-------+

5 rows in set (0.000 sec)

MariaDB [db_smk]> SELECT SUM(nilai) FROM tb_nilai;

+------------+

| SUM(nilai) |

+------------+

| 449 |

+------------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT COUNT(*) FROM tb_nilai;

+----------+

| COUNT(*) |

+----------+

| 5 |

+----------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT COUNT(*) FROM tb_nilai WHERE nilai >90;

+----------+

| COUNT(*) |

+----------+

| 2 |

+----------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT MAX(nilai) FROM tb_nilai;;

+------------+

| MAX(nilai) |

+------------+

| 93 |

+------------+

1 row in set (0.000 sec)

ERROR: No query specified

MariaDB [db_smk]> SELECT MIN(nilai) FROM tb_nilai;

+------------+

| MIN(nilai) |

+------------+

| 85 |

+------------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT AVG(nilai) FROM tb_nilai;

+------------+

| AVG(nilai) |

+------------+

| 89.8000 |

+------------+

1 row in set (0.000 sec)

Senin, 05 Januari 2026

Tambahan Tombol Hapus Dan Warna Tulisan Saat di Klik

Tambah Tumbol Hapus dan warna Tulisan Saat di pilih

<style  type="text/css">
    tr:hover{
        background:red;
        color:white;
    }
</style >

<h1>Data Siswa</h1>
<table Width="800" border="1">
    <tr>
        <td>NIS</td> <td>NAMA SISWA</td> <td>jenis kelamin</td>
        <td>tempat lahir</td> <td>tanggal lahir</td> <td>ibu kandung</td> 
        <td>Aksi</td>
<?php
include "conn/config.php";
$perintah = "SELECT * FROM tb_siswa";
$query   = mysqli_query($koneksi, $perintah);
while ($data = mysqli_fetch_row($query)) 
    { echo "
        <tr>
         <td>$data[0]</td> <td>$data[1]</td> <td>$data[2] </td>
        <td>$data[3]</td> <td>$data[4] </td> <td>$data[5]</td> 
    <td>
        <a href=Form_ubahsiswa.php?nis=$data[0]>
            <button>Ubah</button></a>&nbsp; "; ?>


        <a href=hapus_siswa.php?nis=<?=$data[0];?>
            onclick="return confirm('Yakin mau dihapus?')">
            <button>Hapus</button>
            </a>
            <?php echo"
    </td>
    </tr>";
}
?>
</table>

—͟͞͞★ᴶ𝗈ʰ𝕒®ì—͟͞͞★

Senin, 12 Januari 2026

Membuat Halaman Login Dan Proses Login

1. Buat Halaman Form Login dengan nama : login.php

Struktur Folder yang Disarankan

Buat tabel user di CMD

2. buat koneksi database dengan nama : koneksi.php

`3. Buat Halaman Proses Login dengan nama : proses_login.php`

`4. Buat Hamalan Session Start dengan nama : session_start.php`

`5. Buat Halaman logout dengan nama : logout.php`

Minggu, 11 Januari 2026

From Pencarian

Ini from Pencariannya :

Rabu, 07 Januari 2026

Basis Data Membuat from tb_nilai siswa

Senin, 05 Januari 2026

Tambahan Tombol Hapus Dan Warna Tulisan Saat di Klik

tambahkan cmd

Laporkan Penyalahgunaan