PHP eksekusi_sql Examples

Example #1

File: disposisi_hapus.php Project: FaddliLWibowo/SkripsiSIAS

<?php

include "../koneksi.php";
$id = $_POST["id"];
//validasi
if (empty($id)) {
    echo "Anda harus memilih dahulu data yang ingin dihapus";
} else {
    $sql = "DELETE FROM t_disposisi_surat_masuk WHERE id_disposisi='{$id}'";
    if (eksekusi_sql($sql)) {
        echo "berhasil menghapus data {$id}";
    } else {
        echo "gagal menghapus data";
    }
}

Example #2

File: surat_keluar_upload.php Project: FaddliLWibowo/SkripsiSIAS

$urut = $_POST["txtUrut"];
$prefix = $_POST["txtPrefix"];
$lampiran_store_db = "";
if (empty($urut)) {
    echo "<script>\n          alert('Nomor Urut Surat belum terset');\n          window.location.href = '../SURAT_KELUAR/surat_keluar.php';\n          </script>";
    exit;
}
$no = trim($urut);
$jumlah_file = count($_FILES["upload"]["name"]);
$path = "../LAMPIRAN/{$no}/";
if (!file_exists($path)) {
    umask(0);
    mkdir($path, 0777, TRUE);
}
for ($i = 0; $i < $jumlah_file; $i++) {
    $tmp_file = $_FILES['upload']['tmp_name'][$i];
    $filetype = $_FILES['upload']['type'][$i];
    $filesize = $_FILES['upload']['size'][$i];
    $filename = $_FILES['upload']['name'][$i];
    if (move_uploaded_file($tmp_file, $path . $filename)) {
        $lampiran_store_db = $lampiran_store_db . "," . $filename;
        echo "<script>\n          alert('Berhasil Mengupload File');\n          window.location.href = '../SURAT_KELUAR/surat_keluar.php';\n          </script>";
    } else {
        echo "<script>\n          alert('Gagal Mengupload File');\n          window.location.href = '../SURAT_KELUAR/surat_keluar.php';\n          </script>";
    }
}
$no_surat = trim($urut . "/" . $prefix);
$lampiran_store_db = trim($lampiran_store_db, ",");
$sql = "UPDATE t_surat_keluar SET lampiran_file='{$lampiran_store_db}' WHERE no_surat_keluar='{$no_surat}'";
eksekusi_sql($sql);

Example #3

File: SuratMasukDetail.php Project: FaddliLWibowo/SkripsiSIAS

        $data = $data . "<dd>" . $a["pengirim"] . "</dd>";
        $data = $data . "<dt>KEPADA</dt>";
        $data = $data . "<dd>" . nama_penerima($a["penerima_surat"]) . "</dd>";
        $data = $data . "<dt>JENIS SURAT</dt>";
        $data = $data . "<dd>" . $a["jenis"] . "</dd>";
        $data = $data . "<dt>ISI SURAT</dt>";
        $data = $data . "<dd>" . $a["isi_surat"] . "</dd>";
        $data = $data . "<dt>PENANGGUNGJAWAB</dt>";
        $data = $data . "<dd>" . nama_penerima($a["penandatangan"]) . "</dd>";
        $data = $data . "<dt>PRIORITAS</dt>";
        $data = $data . "<dd>" . $a["prioritas_surat"] . "</dd>";
        $data = $data . "<dt>TEMBUSAN</dt>";
        $data = $data . "<dd>" . nama_penerima($a["tembusan"]) . "</dd>";
        $data = $data . "<dt>LAMPIRAN</dt>";
        $file_array = explode(",", $a["lampiran_file"]);
        $urut = ambil_no_urut($a["no_surat_keluar"]);
        $l = "";
        foreach ($file_array as $index => $file) {
            $l = $l . "<a href='" . "../LAMPIRAN/{$urut}/{$file}" . "' class='btn btn-link' type='button'>" . $file . "</a></br>";
        }
        $data = $data . "<dd>" . $l . "</dd>";
        $data = $data . "</dl>";
        if (eksekusi_sql("UPDATE t_surat_masuk SET status='Terbaca' WHERE no_surat_keluar_fk='{$id}'")) {
            echo $data;
        }
    } else {
        echo "tidak ditemukan data";
    }
} else {
    echo "No Data";
}

Example #4

File: arsip_hapus.php Project: FaddliLWibowo/SkripsiSIAS

<?php

include "../koneksi.php";
include "../fungsi.php";
$id = $_POST["id"];
$kategori = $_POST["kategori"];
//validasi
if (empty($id)) {
    echo "Anda harus memilih dahulu data yang ingin dihapus";
} else {
    $sql = "DELETE FROM t_arsip_surat WHERE kategori_arsip='{$kategori}' AND id_arsip='{$id}'";
    $ada = eksekusi_sql($sql);
    if ($ada == 1) {
        $space = "../LAMPIRAN/" . remove_Special_char($id);
        hapus_dir($space);
        echo "berhasil menghapus data {$id}";
    } else {
        echo "gagal menghapus data";
    }
}