PROJEK 6

November 09, 2022

Koneksi.php

<?php

$host = mysqli_connect ("localhost","root");   
$db = mysqli_select_db ($host, "p6");

$id= $_POST['id'];
$nama= $_POST['nama'];
$gambar= $_FILES['foto']['name'];
$foto_tmp = $_FILES['foto']['tmp_name'];

// tentukan lokasi file akan dipindahkan
$dirUpload = "gambar/";

// pindahkan file


if ($_POST['upload'] == "upload") {
    
    move_uploaded_file($foto_tmp, $dirUpload.$gambar);
    $input = ("INSERT INTO `projek`(`nama`, `gambar`) VALUES ('$nama','$gambar')");
    $hasil=mysqli_query($host, $input);
        if($hasil){
            echo "Input gambar berhasil!.<br>";
        }else{
            echo "Input gambar gagal!.<br>";
        }

}else if($_POST['edit'] == "edit") {
    move_uploaded_file($foto_tmp, $fdirUpload.$gambar);
    $edit = ("UPDATE `projek` SET `nama`='$nama',`gambar`='$gambar' WHERE `id`='$id'");
    $hasil=mysqli_query($host, $edit);
        if($hasil){
            echo "Edit data berhasil!.<br>";
        }else{
            echo "Edit data gagal!.<br>";
        }
}else if($_POST['hapus'] == "hapus") {
    move_uploaded_file($foto_tmp, $dirUpload.$gambar);
    $edit = "DELETE FROM `projek` WHERE id=$id";
    $hasil=mysqli_query($host, $edit);
        if($hasil){
            echo "Hapus data berhasil!.<br>";
        }else{
            echo "Hapus data gagal!.<br>";
        }
    }
?>

Form.php

<!DOCTYPE html>
<html>
<head>
    <title>Upload Gambar</title> 
</head>

<body>
    <form action="koneksi.php" method="post" enctype="multipart/form-data">
    ID: <input type="text" name="id" /><br>
    Nama: <input type="text" name="nama"/><br>
    Pilih gambar: <input type='file' name='foto' accept='image/*' /><br><br>
        <input type="submit" name="upload" value="upload" />
        <input type="submit" name="edit" value="edit"/>
        <input type="submit" name="hapus" value="hapus"/>
    </form> 
</body> 
</html>