LIEFARHANRPL

 Awalnya     : Nah terus masuk ke form ubahnya Nih sytaknya     : <?php $nis = $_GET [ 'nis' ]; include "config.php" ; $perintah = "select * from tb_siswa where nis=' $nis '" ; $query = mysqli_query ( $koneksi , $perintah ); $data = mysqli_fetch_array ( $query ); ? > < center > < form method = "post" action = "proses_ubah_siswa.php" > < table border = "1" cellpadding = "8" cellspacing = "0" >     < tr >         < th colspan = "2" > FORM UBAH SISWA </ th >     </ tr >     < tr >         < td > NIS </ td >         < td >< input type = "text" name = "nis" value = " <?= $data [ 'nis' ]; ? > " ></ td >     </ tr >     < tr >         < td > Nama </ td >         < td >< input type = "te...

 MariaDB [db_smk]> use tb_siswa; ERROR 1049 (42000): Unknown database 'tb_siswa' MariaDB [db_smk]> select * from tb_siswa; +------------+----------------+---------------+--------------+---------------+-----------------+ | nis        | nama           | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung | +------------+----------------+---------------+--------------+---------------+-----------------+ |        220 | Andhika        | Laki - laki   | malaysia     | 2025-11-09    |                 | |       6883 | FarhanLie      | Laki - laki   | jakarta      | 2025-11-18    | kakak           | |       7553 | Hanlho         | Laki - laki   | jakarta...

DML (Data Manipulation lengague)     Delete            Perintah delete digunakan untuk menghapus data dari tabel  Sintaks     : DELETE FROM nama_tabel WHERE kondisi Contoh     :  Hapuslah data siswa pada tabel tb_siswa yang mempunyai nis '12345' Hapuslah data siswa pada tabel tb_siswa yang mempunyai nama 'Budi Santoso'.

 Syntaknya     : < h1 > Data Guru </ h1 > < table width = "800" border = "1" cellspacing = "0" cellpadding = "5" >     < tr style = " background-color: #f2f2f2;" >         < th > NIP </ th >         < th > Nama Guru </ th >         < th > Jenis Kelamin </ th >         < th > Tempat Lahir </ th >         < th > Tanggal Lahir </ th >         < th > Nama Ibu Kandung </ th >     </ tr > <?php include "config2.php" ; // pakai file config2 di folder yang sama $perintah = " SELECT * FROM tb_guru " ; $query = mysqli_query ( $koneksi , $perintah ); while ( $data = mysqli_fetch_row ( $query )) {     echo "         <tr>             <td> $data [ 0 ]</td...

 Syntak nya     : < h1 > Data Siswa </ h1 > < table width = "700" border = "1" >       < tr >         < th > NIS </ th >         < th > Nama Siswa </ th >         < th > Jenis Kelamin </ th >         < th > Tempat Lahir </ th >         < th > Tanggal Lahir </ th >         < th > Nama Ibu Kandung </ th >     </ tr > <?php include "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>       ...

Sytaknya    <?php $hostname = "localhost" ; $username = "root" ; $password = "" ; $db_name  = "db_smk" ; $koneksi = mysqli_connect ( $hostname , $username , $password , $db_name ); if ( $koneksi == true ) {     echo "Database db_smk berhasil terhubung!" ; } else {     echo "Database db_smk tidak terhubung!" ; } $perintah = "show tables" ; $querry = mysqli_query ( $koneksi , $perintah ); while ( $data = mysqli_fetch_row ( $querry )) echo "<hr> $data [ 0 ] <hr>" ; $perintah2 = " CREATE TABLE IF NOT EXISTS tb_siswa(     nis int ( 10 ) not null ,     nama varchar ( 100 ) not null ,     jenis_kelamin varchar ( 15 ) not null ,     tempat_lahir varchar ( 50 ) not null ,     tanggal_lahir date ,     nama_ibukandung varchar ( 100 ) not null ,     primary key (nis) ) " ; $querry2 = mysqli_query ( $koneksi , $perintah2 ); ? > Outputnya