Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_POST["tombolSimpan"])){
- $namaserver = "localhost";
- $namapengguna = "root";
- $password = "";
- $namadatabase = "latihan";
- // Membuat koneksi
- $koneksi = new mysqli($namaserver,$namapengguna,$password,$namadatabase);
- // Periksa Koneksi
- if ($koneksi->connect_error) {
- die("Koneksi Gagal: " . $koneksi->connect_error);
- }
- $sql = "INSERT INTO komputer(kodebarang,hostname,ipaddress,macaddress) VALUES ('".$_POST["kodebarang"]."','".$_POST["hostname"]."','".$_POST["ipaddress"]."','".$_POST["macaddress"]."')";
- if ($koneksi->query($sql) === TRUE){
- echo "<script type='text/javascript'>alert('Data Berhasil Ditambahkan');</script>";
- } else {
- echo "<script type='text/javascript'>alert('Error: ". $sql ."<br>".$koneksi->error." ')</script>";
- }
- $koneksi->close();
- }
- if(isset($_POST["tombolUpdate"])) {
- $namaserver = "localhost";
- $namapengguna = "root";
- $password = "";
- $namadatabase = "latihan";
- // Membuat koneksi
- $koneksi = new mysqli($namaserver,$namapengguna,$password,$namadatabase);
- // Periksa Koneksi
- if($koneksi->connect_error) {
- die("Koneksi Gagal : " . $koneksi->connect_error);
- }
- $sql = "UPDATE komputer SET hostname='".$_POST["kodebarang"]."',ipaddress='".$_POST["ipaddress"]."',macaddress='".$_POST["macaddress"]."' WHERE kodebarang='".$_POST["kodebarang"]."'";
- if ($koneksi->query($sql) === TRUE) {
- echo "<script type='text/javascript'>alert('Data Berhasil Di Update');</script>";
- } else {
- echo "<script type='text/javascript'>alert('Error : ".$sql."<br>".$koneksi->error."')</script>";
- }
- $koneksi->close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement