ubah.php

<?php
include "config/koneksi.php";
$id = $_GET['id'];

$sql = $koneksi->query("select * from datavirtu where kdvt='$id'");

$row = $sql->fetch_array(MYSQLI_ASSOC);


?>
<div class="panel panel-default">
    <div class="panel-heading">
                            Tambah Data
                </div>
                        <div class="panel-body">
                            <div class="row">
                                <div class="col-md-10">
                                    <form method="POST" action="" enctype="multipart/form-data">

                                        <div class="form-group">
                                            <label>KD Spot</label>
                                            <input class="form-control" name="kdvt" value="<?php echo $row['kdvt'];?>" required readonly/>
                                        </div>

                                        <div class="form-group">
                                            <label>Nama Spot</label>
                                            <input class="form-control" name="nama_vt" value="<?php echo $row['nama_vt'];?>"/>
                                        </div>

                                        <div class="form-group">
                                            <label>Informasi</label>
                                            </br>
                                            <textarea name="info_vt" rows="5" cols="112" class="form-control" placeholder="Masukan informasi spot"><?php echo $row['info_vt'];?></textarea>

                                        </div>

                                        <div class="form-group">
                                            <label>Foto</label>
                                            <input type="file" name="fotoUpload" id="fotoUpload"  ><p> Hanya file JPG, PNG, JPEG yang diperbolehkan. Ukuran Foto Kurang Dari 2 MB </p>
                                            <img src="upload/<?php echo $row['foto']; ?>" width="500px" height="250px">
                                        </div>

                                         <div class="form-group">
                                            <label>Link Foto360</label>
                                            <input class="form-control" name="foto360" placeholder="Link Foto360" value="<?php echo $row['foto360'];?>"/>
                                        </div>

                                        <div>

                                            <input type="submit" name="submit" value="simpan" class="btn btn-primary">

                                        </div>

                                    </div>
                                </form>

                            </div>
                    </div>
            </div>
</div>

<?php
    error_reporting(0);

    $kdvt = $_POST['kdvt'];
    $nama_vt =  $_POST['nama_vt'];
    $info_vt =  $_POST['info_vt'];
    $foto360 =  $_POST['foto360'];
    $simpan =  $_POST['submit'];


    $target_dir = "upload/";
    $target_file = $target_dir . basename($_FILES["fotoUpload"]["name"]);
    $uploadOk = 1;
    $imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
    $foto   = $kdvt.".".$imageFileType;
    $f=$kdvt.".";
    if($foto==$f){

        $fotos=$row['foto'];
    }else{
        $fotos=$foto;
    }
        if ($simpan) {
        $sql = $koneksi->query("update datavirtu set nama_vt='$nama_vt', info_vt='$info_vt', foto='$fotos', foto360='$foto360' where kdvt='$id'");


//cek foto
if (isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fotoUpload"]["tmp_name"]);
    if ($check !== false) {
        echo "File adalah foto. ";
        $uploadOk = 1;
    } else {
        echo "File bukan foto. ";
        $uploadOk = 0;
    }


//cek file foto sudah ada
if (file_exists($target_file)) {
    echo "Foto sudah ada. ";
    $uploadOk = 0;
}

// Check file size
if ($_FILES["fotoUpload"]["size"] > 10000000) {
    echo "Sorry, your file is too large.";
    $uploadOk = 0;
}

//cek format file
if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType !='JPG') {
    echo "Hanya file JPG, JPEG, PNG yang diperbolehkan. ";
    $uploadOk = 0;
}

//jika upload error
if ($uploadOk == 0) {
    echo "File belum terupload";
//jika upload berhasil
} else {
    if (move_uploaded_file($_FILES["fotoUpload"]["tmp_name"], $target_dir.$kdvt.".".$imageFileType)) {
        echo "File". basename($_FILES["fotoUpload"]["name"]). "telah di upload. ";
    } else {
        echo "Terjadi kesalahan mengupload";
        }
    }
}


        if ($sql) {
            ?>
                <script>

                    alert ("Data Berhasil Disimpan");

                    window.location.href="?page=vt";


                </script>


            <?php
        }
    }
        var_dump($sql->errorInfo());
        die;

?>