Budeng!!!: November 2025

Microsoft Windows [Version 10.0.19045.6332]

C:\Users\A-20>cd C://xampp2/mysql/bin

C:\xampp2\mysql\bin>mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 10.4.32-MariaDB mariadb.org binary distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

1. UNTUK MENAMPILKAN SELURUH DATA SISWA PADA TABEL tb_siswa

MariaDB [(none)]> use db_smk;

Database changed

MariaDB [db_smk]> select*from tb_siswa;

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

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

| 126 | Abyan Nadif | Laki-laki | Jakarta | 2012-11-19 | Ina |

| 127 | Jaka | Laki-laki | Pandeglang | 2008-12-08 | Inu |

| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |

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

4 rows in set (0.040 sec)

2. Tampilkan data siswa yang memiliki nama "bedul"

MariaDB [db_smk]> select*from tb_siswa WHERE nama='bedul';

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

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

| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |

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

1 row in set (0.000 sec)

2. Tampilkan data siswa yang memiliki nis lebih besar atau sama dengan dari 126

MariaDB [db_smk]> select*from tb_siswa WHERE nis>=126;

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

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

| 126 | Abyan Nadif | Laki-laki | Jakarta | 2012-11-19 | Ina |

| 127 | Jaka | Laki-laki | Pandeglang | 2008-12-08 | Inu |

| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |

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

4 rows in set (0.000 sec)

2. Tampilkan data siswa yang memiliki nama akhiran huruf "l"

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "%l";

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

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

| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |

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

1 row in set (0.000 sec)

2. Tampilkan data siswa yang memiliki nama awalan huruf "b"

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "b%";

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

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

| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |

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

1 row in set (0.000 sec)

3. Tampilkan data siswa yang memiliki nis dari 126 sampai 127

MariaDB [db_smk]> select*from tb_siswa WHERE nis BETWEEN 126 AND 127;

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

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

| 126 | Abyan Nadif | Laki-laki | Jakarta | 2012-11-19 | Ina |

| 127 | Jaka | Laki-laki | Pandeglang | 2008-12-08 | Inu |

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

2 rows in set (0.001 sec)

Langkah-Langkah Mengubah Data Siswa DI Web

1. Tampilkan data siswa. kemudian tambah tombol untuk aksi Ubah dengan nama data_siswa.php

Contoh Kodingan:

data_siswa.php

<h1>Data Siswa</h1>
<table width="600" border="1">
    <tr>
        <td>NIS</td> <td>Nama Siswa</td> <td>Jenis Kelamin</td>
        <td>Tempat Lahir</td> <td>Tanggal lahir</td>
        <td> Nama Ibu Kandung</td>
        <td>Aksi</td>

</tr>


<?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></td>
    </a>
    </td>
    </tr>";
}
?>
</table>

Hasil

2. Buat form untuk mengubah data siswa dengan nama form_ubahsiswa.php

script / koding :

form_ubahsiswa.php

<?php
$nis=$_GET['nis'];
include"conn/config.php";
$perintah = "SELECT * FROM tb_siswa WHERE nis='$nis'";
$query = mysqli_query($koneksi, $perintah);
$data = mysqli_fetch_array($query);
?>

<form action="update_siswa.php" method="post">
<table border="1" width="500" align="center">
    <tr>
        <td colspan="2"><center><b>Form Ubah Siswa</b></center></td>
    </tr>

    <tr>
        <td>NIS</td>
        <td><input type="text" name="nis" value="<?= $data['nis']; ?>" readonly></td>
    </tr>

    <tr>
        <td>Nama</td>
        <td><input type="text" name="nama" value="<?= $data['nama']; ?>"></td>
    </tr>

    <tr>
        <td>Jenis Kelamin</td>
        <td>
            <select name="jenis_kelamin">
                <option selected><?= $data['jenis_kelamin']; ?></option>
                <option>Laki-laki</option>
                <option>Perempuan</option>
            </select>
        </td>
    </tr>

    <tr>
        <td>Tanggal Lahir</td>
        <td><input type="date" name="tanggal_lahir" value="<?= $data['tanggal_lahir']; ?>"></td>
    </tr>

    <tr>
        <td>Nama Ibu Kandung</td>
        <td><input type="text" name="nama_ibukandung" value="<?= $data['nama_ibukandung']; ?>"></td>
    </tr>

    <tr>
        <td>Aksi</td>
        <td><input type="submit" name="update" value="Update"></td>
    </tr>
</table>
</form>

Hasil:

Script/koding Proses Update :

proses_ubahsiswa.php

<?php
$nis=$_POST['nis']; echo"$nis <br>";
$nama=$_POST['nama']; echo"$nama <br>";
$jenis_kelamin=$_POST['jenis_kelamin']; echo"$jenis_kelamin <br>";
$tempat_lahir=$_POST['tempat_lahir']; echo"$tempat_lahir <br>";
$tanggal_lahir=$_POST['tanggal_lahir']; echo"$tanggal_lahir <br>";
$nama_ibukandung=$_POST['nama_ibukandung']; echo"$nama_ibukandung <br>";

$koneksi=mysqli_connect("localhost","root","","db_smk");
$perintah="UPDATE tb_siswa SET nama='$nama', 
            jenis_kelamin='$jenis_kelamin',
            tempat_lahir='$tempat_lahir',
            tanggal_lahir='$tanggal_lahir',
            nama_ibukandung='$nama_ibukandung'
            WHERE nis='$nis'
           ";
$query=mysqli_query($koneksi,$perintah);

if($query==1)
{echo"
    <script>
        alert('Berhasil');
        parent.location='data_siswa.php';
    </script>"; 
}
else{
{echo"
    <script>
        alert('Gagal');
        parent.location='data_siswa.php';
    </script>"; 
}
}
?>

Budeng!!!

Rabu, 26 November 2025

Operasi Relasi DataBase

Senin, 24 November 2025

FROM UBAH DATA SISWA DIWEB

Laporkan Penyalahgunaan