Notice: Undefined index: id in C:\xampp\htdocs\phpdasar\pertemuan16\hapus.php on line 4

Notice: Undefined index: id in C:\xampp\htdocs\phpdasar\pertemuan16\ubah.php on line 6

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\phpdasar\pertemuan16\functions.php on line 10

Notice: Undefined offset: 0 in C:\xampp\htdocs\phpdasar\pertemuan16\ubah.php on line 9 ----------------------------------------------------------------------------------------

| ini hapus.php | 0 ) { echo "

"; } else { echo " "; } ?>

---------------------------------------------------------------------------------------- | ini ubah.php |

0 ) { echo "

"; }else { echo " "; }

} ?>

ubah data mahasiswa

ubah data mahasiswa

"> ">

• nrp :">

• nama :">

• email :">

• jurusan :">

• gambar :

Ubah Data!

---------------------------------------------------------------------------------------- | ini functions.php |

alert('pilihlah gambar terlebih dahulu'); "; return false; }

// cek apakah yang diupload adalah gambar $ekstensiGambarValid = ['jpg', 'jpeg', 'png']; $ekstensiGambar = explode('.', $namaFile); $ekstensiGambar = strtolower(end($ekstensiGambar)); if ( !in_array($ekstensiGambar, $ekstensiGambarValid)) { echo " "; return false; }

// cek jika ukuran terlalu besar if($ukuranFile > 1000000) { echo " "; return false; }

//lolos pengecekan, gambar siap diupload //generate nama gambar baru $namaFilebaru = uniqid(); $namaFilebaru .= '.'; $namaFilebaru .= $ekstensiGambar;

move_uploaded_file($tmpname,'img/' . $namaFilebaru);

return $namaFilebaru; }

function hapus($id) { global $conn; mysqli_query($conn, "DELETE FROM mahasiswa WHERE id = $id"); return mysqli_affected_rows($conn); }

function ubah($data) { global $conn; // koneksi ke DMBS // ambil data dari tiap elemen dalam form $id = $data["id"]; $nrp = htmlspecialchars($data["nrp"]); $nama = htmlspecialchars($data["nama"]); $email = htmlspecialchars($data['email']); $jurusan = htmlspecialchars($data['jurusan']); $gambarlama = htmlspecialchars($data['gambarlama']);

//check apakah user pilih gambar baru atau tidak if ( $_FILES['gambar']['error'] === 4 ) { $gambar = $gambarlama; } else { $gambar = upload(); }

$query = "UPDATE mahasiswa SET nrp = '$nrp', nama = '$nama', email = '$email', jurusan = '$jurusan', gambar = '$gambar' WHERE id = $id "; mysqli_query($conn, $query);

return mysqli_affected_rows($conn); }

function cari($keyword) { $query = "SELECT * FROM mahasiswa WHERE nama LIKE '%$keyword%' OR nrp LIKE '%$keyword%'OR email LIKE '%$keyword%'OR jurusan LIKE '%$keyword%' OR gambar LIKE '%$keyword%' "; return query($query); }

function registrasi($data) { global $conn;

$username = strtolower(stripslashes($data["username"])); $password = mysqli_real_escape_string($conn, $data["password"]); $password2 = mysqli_real_escape_string($conn, $data["password2"]);

//cek username udah ada atau belum $result = mysqli_query($conn, "SELECT username FROM user WHERE username = '$username'");

if ( mysqli_fetch_assoc($result)) { echo ""; return false; }

// check konfirmasi password if ($password !== $password2) { echo ""; return false; }

// enkripsi password $password = password_hash($password, PASSWORD_DEFAULT);

// tambahkan userbaru ke database mysqli_query($conn, "INSERT INTO user VALUES('', '$username', '$password')");

return mysqli_affected_rows($conn);

}

?>