Postingan

Praktik 4

 koneksi.php <?php  $con = mysqli_connect("localhost", "root", "", "pwdpb"); if (!$con) { echo "Koneksi Gagal"; } function hapus ($data) { global $con; $id = $_GET['id']; $sql = mysqli_query($con, "DELETE FROM praktek1 WHERE id = '$id'"); return mysqli_affected_rows($con); } function edit($data) { global $con; $id = $_GET['id']; $nama = $_POST['nama']; $sql = "UPDATE praktek1 SET nama = '$nama' WHERE id = '$id'"; $query = mysqli_query($con, $sql); return mysqli_affected_rows($con); }  ?> edit.php <?php  require 'koneksi.php'; $id = $_GET['id']; if (isset($_POST['submit'])) { if (edit($_POST) > 0) { echo " <script> alert('Data Berhasil Diubah'); document.location.href = 'index.php'; </script> "; } else { echo " <script> ...

MEMBUAT APLIKASI DARI DASAR HINGGA AKHIR (PRAKTIK EMPAT)

Gambar
 SOURCE CODE koneksi.php <?php   $koneksi = mysqli_connect("localhost", "root", "", "pwdpb"); function tambah($data){ global $koneksi; $nama = $_POST['nama']; $hobi = $_POST['hobi']; $value = implode(",", $hobi); $query = mysqli_query($koneksi, "INSERT INTO praktek4 (nama, hobi) VALUES ('$nama', '".$value."')"); return mysqli_affected_rows($koneksi); } ?> form.php <?php  require'koneksi.php'; if (isset($_POST['submit'])) { if (tambah($_POST) > 0) { echo " <script> alert('Data Berhasil Ditambahkan'); document.location.href = 'hasil.php'; </script> "; } else { echo " <script> alert('Data Gagal Ditambahkan'); document.location.href = 'form.php'; </script> "; } }  ?> <!DOCTYPE html> <html> <head> ...

MEMBUAT APLIKASI DARI DASAR HINGGA AKHIR (PRAKTIK TIGA)

Gambar
 PRAKTIK TIGA SOURCE CODE koneksi.php <?php   $koneksi = mysqli_connect("localhost", "root", "", "pwdpb"); function tambah($data){ global $koneksi; $nama = $_POST['nama']; $jk = $_POST['jk']; $query = mysqli_query($koneksi, "INSERT INTO praktek3 (nama, jenkel) VALUES ('$nama', '$jk')"); return mysqli_affected_rows($koneksi); } ?> form.php <?php  require'koneksi.php'; if (isset($_POST['submit'])) { if (tambah($_POST) > 0) { echo " <script> alert('Data Berhasil Ditambahkan'); document.location.href = 'hasil.php'; </script> "; } else { echo " <script> alert('Data Gagal Ditambahkan'); document.location.href = 'form.php'; </script> "; } }  ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta n...

MEMBUAT APLIKASI DARI DASAR HINGGA AKHIR (PRAKTIK DUA)

Gambar
 PRAKTIK DUA SOURCE CODE : koneksi.php <?php   $koneksi = mysqli_connect("localhost", "root", "", "praktikdua"); function tambah($data){ global $koneksi; $nama = $_POST['nama']; $kelas = $_POST['kelas']; $query = mysqli_query($koneksi, "INSERT INTO projekdua (nama, kelas) VALUES ('$nama', '$kelas')"); return mysqli_affected_rows($koneksi); } ?> form.php <?php  require'koneksi.php'; if (isset($_POST['submit'])) { if (tambah($_POST) > 0) { echo " <script> alert('Data Berhasil Ditambahkan'); document.location.href = 'hasil.php'; </script> "; } else { echo " <script> alert('Data Gagal Ditambahkan'); document.location.href = 'form.php'; </script> "; } }  ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"...

MEMBUAT APLIKASI DARI DASAR HINGGA AKHIR

Gambar
 PRAKTEK 1 SOURCE CODE koneksi.php <?php   $koneksi = mysqli_connect("localhost", "root", "", "pwdpb"); function tambah($data){ global $koneksi; $nama = $_POST['nama']; $query = mysqli_query($koneksi, "INSERT INTO praktek1 (nama) VALUES ('$nama')"); return mysqli_affected_rows($koneksi); } ?> form_nama.php <?php  require 'koneksi.php'; if (isset($_POST['submit'])) { if (tambah($_POST) > 0) { echo " <script> alert('Data Berhasil Ditambahkan'); document.location.href = 'hasil_nama.php'; </script> "; } else { echo " <script> alert('Data Gagal Ditambahkan'); document.location.href = 'form_nama.php'; </script> "; } }  ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=dev...

Koneksi dan tambah data dengan PHP pada database.

Gambar
Koneksi dan tambah data dengan PHP pada database. Source Code : index.php <?php  require 'koneksi.php'; $data = mysqli_query($koneksi, "SELECT * FROM tamu");  ?>  <!DOCTYPE html>  <html>  <head>   <meta charset="utf-8">   <meta name="viewport" content="width=device-width, initial-scale=1">   <title></title>   <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-Zenh87qX5JnK2Jl0vWa8Ck2rdkQ2Bzep5IDxbcnCeuOxjzrPF/et3URy9Bv1WTRi" crossorigin="anonymous">  </head>  <body>   <div class="container-fluid">   <div class="row justify-content-center align-item-center top-50">   <h1 class="text-center" style="margin-top: 50px;">Buku Tamu</h1>   <button type="button" class="btn bt...

Statement/Penyataan Require, Include, Require_Once, dan Include_Once

Gambar
  Source Code index.php  <?php require 'alert.php';   ?>  <!DOCTYPE html>  <html>  <head>   <meta charset="utf-8">   <meta name="viewport" content="width=device-width, initial-scale=1">   <title></title>  </head>  <body>   <form method="POST">   <label>Nama Lengkap :</label>   <input type="text" name="nama">   <br>   <label>Nomor Telepon :</label>   <input type="number" name="nomor">   <br>   <label>Masukkan Email :</label>   <input type="email" name="email">   <br>   <label> Nama Bapak</label>   <input type=" text " name="nama2">   <br>   <input type="submit" name="submit">   </form>   <br>   <?php   ...