Advertisement
02190319693

proses.php

Mar 12th, 2019
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.83 KB | None | 0 0
  1. <?php
  2. require_once "../_config/db.php";
  3. require "../_assets/libs/vendor/autoload.php";
  4.  
  5. use Ramsey\Uuid\Uuid;
  6. use Ramsey\Uuid\Exception\UnsatisfiedDependencyException;
  7.  
  8. if( isset($_POST['add'])) {
  9.     //Generate a version 4 (random) UUID object
  10.     $nama            = trim(mysqli_real_escape_string($link, $_POST['nama']));
  11.     $bdstudi         = trim(mysqli_real_escape_string($link, $_POST['bdstudi']));
  12.     $kls             = trim(mysqli_real_escape_string($link, $_POST['kls']));
  13.     $lksbelajar      = trim(mysqli_real_escape_string($link, $_POST['lksbelajar']));
  14.     $absnbljr        = trim(mysqli_real_escape_string($link, $_POST['absnbljr']));
  15.     $nilaitf         = trim(mysqli_real_escape_string($link, $_POST['nilaitf']));
  16.     $pekn            = trim(mysqli_real_escape_string($link, $_POST['pekn']));
  17.     $pertemuan       = trim(mysqli_real_escape_string($link, $_POST['pertemuan']));
  18.     $sikap           = trim(mysqli_real_escape_string($link, $_POST['sikap']));
  19.     $id_user         = $_SESSION['akun_id'];
  20.     $query           = mysqli_query($link, "SELECT * FROM tb_user WHERE id_user = '$id_user'");
  21.  
  22.     mysqli_query($link, "INSERT INTO tb_nilai (nama_siswa, bidang_studi, kelas, lok_belajar, absensi, nilai_tf, pekan_belajar, pertemuan_tf, sikap, id_user)
  23.    VALUES('$nama', '$bdstudi', '$kls', '$lksbelajar','$absnbljr', '$nilaitf', '$pekn', '$pertemuan','$sikap', '$id_user')") or die (mysqli_error($link));
  24.  
  25.     header('Location: data.php');
  26. }else if( isset($_POST['edit'])) {
  27.     $id = $_POST['id'];
  28.     $nama = trim(mysqli_real_escape_string($link, $_POST['nama']));
  29.     $ket  = trim(mysqli_real_escape_string($link, $_POST['ket']));
  30.     mysqli_query($link, "UPDATE tb_obat SET nama_obat = '$nama', ket_obat = '$ket' WHERE id_obat = '$id'") or die (mysqli_error($link));
  31.     header('Location: data.php');
  32. }
  33.  
  34.  
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement