Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Membuat Koneksi Database
- <?php
- $host = "";
- $username = "";
- $password = "";
- $db = "";
- $conn = mysqli_connect($host, $username, $password, $db);
- ?>
- Menampilkan Data
- <?php
- include "connection.php";
- ?>
- <html>
- <head>
- <title>CRUD Databse Sekolah</title>
- </head>
- <body>
- <center><h1>Students Data of Eleven Vocational High School</h1></center><hr />
- <center><a href="add_student.php"><button>Add Student</button></a></center><br />
- <table border = "1" align = "center" width="90%">
- <tr>
- <td>No</td>
- <td>Nama</td>
- <td>Kelas</td>
- <td>Alamat</td>
- <td>Jurusan</td>
- <td>Created</td>
- <td>Modified</td>
- <td>Action</td>
- </tr>
- <?php
- $no = 101;
- $query = "SELECT * ";
- $exe = mysqli_query($conn, $query);
- while($row = mysqli_fetch_array($exe)){
- $id = $row['id'];
- ?>
- <tr>
- <td><?=$no++?></td>
- <td><?php echo $row['']; ?></td>
- <td><?=$row['']?></td>
- <td><?=$row['']?></td>
- <td><?=$row['jurusan']?></td>
- <td><?=$row['created']?></td>
- <td><?=$row['modified']?></td>
- <td>Edit | <a href = "process_delete.php?student_key=<?=$id?>">Hapus</a></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </body>
- </html>
- Tambah Data Siswa
- <?php
- include "config/";
- if(isset($_REQUEST[''])){
- $nama = $_REQUEST['nama'];
- $kelas = $_REQUEST['kelas'];
- $alamat = $_REQUEST['alamat'];
- $jurusan = $_REQUEST['jurusan'];
- $created = date("Y-m-d");
- $modified = date("Y-m-d");
- // echo $nama."<br />";
- // echo $kelas."<br />";
- // echo $alamat."<br />";
- // echo $jurusan."<br />";
- $query = "";
- //echo $query;
- $exe = mysqli_query($conn, $);
- if($exe){
- echo "<script>alert('Tambah data berhasil'); location.href='index.php'</script>" ;
- }else{
- echo "<script>alert('Tambah data gagal'); location.href='index.php'</script>" ;
- }
- }
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta http-equiv="X-UA-Compatible" content="ie=edge">
- <title>Document</title>
- </head>
- <body>
- <center><h1>ADD STUDENT FORM</h1></center><hr />
- <form>
- <table border = "0" align ="center">
- <tr>
- <td>Nama</td>
- <td>:</td>
- <td><input type = "text" name = "nama"></td>
- </tr>
- <tr>
- <td>Kelas</td>
- <td>:</td>
- <td><input type = "text" name = "kelas"></td>
- </tr>
- <tr>
- <td>Alamat</td>
- <td>:</td>
- <td><input type = "text" name = "alamat"></td>
- </tr>
- <tr>
- <td>Jurusan</td>
- <td>:</td>
- <td><input type = "text" name = "jurusan"></td>
- </tr>
- <tr>
- <td colspan = "3" align = "center"><input type = "submit" name = "save" value = "SAVE"></td>
- </tr>
- </table>
- </form>
- </body>
- </html>
- Hapus Data
- <?php
- include "config/connection.php";
- $id = $_GET[''];
- $query = "";
- $exe = mysqli_query($conn, $query);
- if($exe){
- echo "<script>alert('Hapus data berhasil'); location.href='index.php'</script>" ;
- }else{
- echo "<script>alert('Hapus data gagal'); location.href='index.php'</script>" ;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement