function deleteData($db, $Id, &$i = 0) { // to check that whether child exists $sql = sprintf('SELECT Id, slave, position, ownerEl FROM ' . TREE_TABLE_PREFIX . '_elements WHERE ownerEl = %d ', $Id); $row = NULL; $i++; echo $i; if ($result = $db->query($sql)) { while ($row = $db->fetchObject($result)) { // if element type is not slave, // there can be childs belonging to that master if ($row->slave == "0") { // recursive operation, to reach the deepest element deleteData($db, $row->Id, $i); } } } $i--; // only update the elements' position on the same level of our first element if ($i == 0) { $sql = sprintf('SELECT position, ownerEl FROM ' . TREE_TABLE_PREFIX . '_elements WHERE Id = %d', $Id); if ($result = $db->query($sql)) { if ($row = $db->fetchObject($result)) { $sql = sprintf('UPDATE ' . TREE_TABLE_PREFIX . '_elements SET position = position - 1 WHERE ownerEl = %d AND position > %d', $row->ownerEl, $row->position); $db->query($sql); } } } // start to delete it from bottom to top $sql = sprintf('DELETE FROM ' . TREE_TABLE_PREFIX . '_elements WHERE ownerEl = %d OR Id = %d ', $Id, $Id); if (!$db->query($sql)) { return false; } return true; }
switch ($_POST[action]) { case 'save': // <<< SIMPAN DATA >>> if ($_POST[id] == 0) { // <<< SIMPAN DATA BARU >>> $elemen = array('kode', 'nama', 'id_golongan', 'id_satuan', 'barcode', 'harga_beli', 'persen_markup', 'stok'); $pesan = addNew('barang', $elemen); } else { // <<< UDATE DATA LAMA >>> $elemen = array('kode', 'nama', 'id_golongan', 'id_satuan', 'barcode', 'harga_beli', 'persen_markup', 'stok'); $pesan = updateOld('barang', $elemen, $_POST[id]); } break; case 'delete': // <<< HAPUS DATA >>> $pesan = deleteData('barang', $_POST[id]); break; case 'new': // <<< KOSONGKAN FORM >>> header("location: " . $_SERVER['PHP_SELF']); break; } // <<< ATUR ALERT >>> if (strlen($pesan) > 0) { $pesan = '<div class="box">' . $pesan . '</div>'; } $tampil_baru = true; } else { if (empty($_GET[id])) { $tampil_baru = true; }
<?php include_once '../utiliti/koneksi.php'; include_once '../utiliti/crud_function.php'; // Ambil parameter $id = isset($_GET['id']) ? $_GET['id'] : null; $query = $conn->query("SELECT img FROM calon WHERE id_calon='{$id}'"); $fetch_data = $query->fetch_array(); $dir = "../img/{$fetch_data['img']}"; //hapus file foto unlink($dir); // eksekusiquery $query_del = deleteData('calon', 'id_calon', $id, $conn); $query_del; if ($query_del) { ?> <script> alert("Data Berhasil di Hapus !!"); location.href = "?page=master&ref=data_calon"; </script> <?php }
<?php include "connect.php"; if (isset($_GET["id"])) { $id = $_GET["id"]; } $musteri = getData(); foreach ($musteri as $row) { $sil1 = $row["image_80_80"]; $sil2 = $row["image_200_200"]; $sil3 = $row["image_300_300"]; } $musteri = deleteData($id); if ($musteri) { unlink($sil1); unlink($sil2); unlink($sil3); header("location:index.php"); } else { echo "Silinemedi"; header("location:index.php"); }
} $chP = $recId == $recPrnt ? 'checked' : ''; $chC = $recId != $recPrnt ? 'checked' : ''; if (isset($_POST['act']) && base64_decode(trim($_POST['act'])) == '1') { $val = 'CSC_DC_ID="' . $psId . '", CSC_DC_NAME="' . $psNm . '", CSC_DC_PARENT="' . $psPrnt . '"'; $bOk = changeData($DBLink, $tbl, $val, $crt = 'CSC_DC_ID="' . $reqId . '"'); if ($bOk) { echo '<script>' . 'alert("Berhasil mengubah data ' . $reqId . '.");' . 'location.href="index.php";' . '</script>'; } else { echo '<script>' . 'alert("GAGAL mengubah data ' . $reqId . '.");' . 'location.href="index.php";' . '</script>'; } } break; case 'dl': $reqId = isset($_REQUEST['id']) ? base64_decode(trim($_REQUEST['id'])) : ""; $bOk = deleteData($DBLink, $tbl, $crt = 'CSC_DC_ID="' . $reqId . '"'); if ($bOk) { echo '<script>' . 'alert("Berhasil menghapus data ' . $reqId . '.");' . 'location.href="index.php";' . '</script>'; } else { echo '<script>' . 'alert("GAGAL menghapus data ' . $reqId . '.");' . 'location.href="index.php";' . '</script>'; } break; default: } } /* ----------------------------------------------------------- * query untuk menampilkan seluruh record * ----------------------------------------------------------- */ $crtCari = ''; $reqTxtCari = '';
} echo "</ul>"; ?> <?php require_once "functions.php"; if (!isset($_SESSION["logged_in_user_id"])) { header("Location: login.php"); } // kas kustutame // ?delete=vastav id mida kustutada on aadressireal if (isset($_GET["delete"])) { echo "Kustutame id " . $_GET["delete"]; //kaivitan funktsiooni, saadan kaasa id! deleteData($_GET["delete"]); } //salvestan andmebaasi uuendused if (isset($_POST["save"])) { var_dump($_POST); updateData($_POST["register_id"], $_POST["name"], $_POST["address"], $_POST["phone_number"], $_POST["register_code"]); } $keywod = ""; //aadressireal on keyword if (isset($_GET["keyword"])) { //otsin $keyword = $_GET["keyword"]; $array_of_data = getData($keyword); } else { //kusin koik andmed //kaivitan funktsiooni
switch ($_POST[action]) { case 'save': // <<< SIMPAN DATA >>> if ($_POST[id] == 0) { // <<< SIMPAN DATA BARU >>> $elemen = array('kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak'); $pesan = addNew('pelanggan', $elemen); } else { // <<< UDATE DATA LAMA >>> $elemen = array('kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak'); $pesan = updateOld('pelanggan', $elemen, $_POST[id]); } break; case 'delete': // <<< HAPUS DATA >>> $pesan = deleteData('pelanggan', $_POST[id]); break; case 'new': // <<< KOSONGKAN FORM >>> header("location: " . $_SERVER['PHP_SELF']); break; } // <<< ATUR ALERT >>> if (strlen($pesan) > 0) { $pesan = '<div class="box">' . $pesan . '</div>'; } $tampil_baru = true; } else { if (empty($_GET[id])) { $tampil_baru = true; }
<!-- <script type="text/javascript"> function delete(){ <?php deleteData($key->id); ?> } function add(){ <?php sentData(); ?> } $save=$_POST['btn']; $delete=$_POST['btn2']; echo $save.$delete;
<?php include_once '../utiliti/koneksi.php'; include_once '../utiliti/crud_function.php'; // Ambil parameter $id = isset($_GET['id']) ? $_GET['id'] : null; // eksekusiquery $query_del = deleteData('voter', 'id_pemilih', $id, $conn); $query_del; if ($query_del) { ?> <script> alert("Data Berhasil di Hapus !!"); location.href = "?page=master&ref=data_pemilih"; </script> <?php }
<button type="submit" name="silinecekVeri" value="<?php echo $key->id; ?> " style="background-color:#212121;" class="commentYazilarim"> Sil </button> <!--<a href="#" adminSent.php?$id=<?php $key->id; ?> class="commentYazilarim">Sil</a>--> </div> </form> </div><br> <?php } ?> </div> <div id="bottom"> <p class="info">Bu Web Sitesi Halil Barım Tarafından Yapılmıştır...</p> </div> </div> </body> </html> <?php if ($_POST) { deleteData($_POST['silinecekVeri']); header("Refresh:0"); }
switch ($_POST[action]) { case 'save': // <<< SIMPAN DATA >>> if ($_POST[id] == 0) { // <<< SIMPAN DATA BARU >>> $elemen = array('kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak'); $pesan = addNew('pemasok', $elemen); } else { // <<< UDATE DATA LAMA >>> $elemen = array('kode', 'nama', 'alamat', 'telepon', 'fax', 'kontak'); $pesan = updateOld('pemasok', $elemen, $_POST[id]); } break; case 'delete': // <<< HAPUS DATA >>> $pesan = deleteData('pemasok', $_POST[id]); break; case 'new': // <<< KOSONGKAN FORM >>> header("location: " . $_SERVER['PHP_SELF']); break; } // <<< ATUR ALERT >>> if (strlen($pesan) > 0) { $pesan = '<div class="box">' . $pesan . '</div>'; } $tampil_baru = true; } else { if (empty($_GET[id])) { $tampil_baru = true; }
} else { // <<< UDATE DATA LAMA >>> if (empty($_POST[password])) { // <<< UDATE TANPA PASSWORD >>> $elemen = array('username', 'nama_lengkap', 'id_status'); $pesan = updateOld('pengguna', $elemen, $_POST[id]); } else { // <<< UDATE DENGAN PASSWORD >>> $elemen = array('username', 'password', 'nama_lengkap', 'id_status'); $pesan = updateOld('pengguna', $elemen, $_POST[id]); } } break; case 'delete': // <<< HAPUS DATA >>> $pesan = deleteData('pengguna', $_POST[id]); break; case 'new': // <<< KOSONGKAN FORM >>> header("location: " . $_SERVER['PHP_SELF']); break; } // <<< ATUR ALERT >>> if (strlen($pesan) > 0) { $pesan = '<div class="box">' . $pesan . '</div>'; } $tampil_baru = true; } else { if (empty($_GET[id])) { $tampil_baru = true; }
<?php $id = filter_input(INPUT_GET, 'id'); $deleteResult = deleteData($id); if ($deleteResult !== true) { echo "<h3> Data did not delete!</h3>"; } header("Location: index.php");
function deleteGridDataQOFiles($fMemberId) { $key = $_POST['key']; $arr = $_POST['deleteKeys']; $count = 0; $selectedRows = json_decode(stripslashes($arr)); //decode the data from json format //should validate and clean data prior to posting to the database foreach ($selectedRows as $row_id) { $id = (int) $row_id; $fileName = getPluginFileById($id); if (deleteData('`qo_files`', '`' . $key . '` = ' . $id)) { $count++; $auditState = 'SUCCESS'; } else { $auditState = 'FAILURE'; } writeAudit($fMemberId, $auditState, 'Delete plugin file (' . $fileName . ')'); } if ($count) { //only checks if the last record was deleted, others may have failed /* If using ScriptTagProxy: In order for the browser to process the returned data, the server must wrap te data object with a call to a callback function, the name of which is passed as a parameter by the ScriptTagProxy. (default = "stcCallback1001") If using HttpProxy no callback reference is to be specified*/ $cb = isset($_GET['callback']) ? $_GET['callback'] : ''; $response = array('success' => $count, 'del_count' => $count); $json_response = json_encode($response); return $cb . $json_response; } else { return '{failure: true}'; } }
switch ($_POST[action]) { case 'save': // <<< SIMPAN DATA >>> if ($_POST[id] == 0) { // <<< SIMPAN DATA BARU >>> $elemen = array('kode', 'nama', 'keterangan'); $pesan = addNew('golongan', $elemen); } else { // <<< UDATE DATA LAMA >>> $elemen = array('kode', 'nama', 'keterangan'); $pesan = updateOld('golongan', $elemen, $_POST[id]); } break; case 'delete': // <<< HAPUS DATA >>> $pesan = deleteData('golongan', $_POST[id]); break; case 'new': // <<< KOSONGKAN FORM >>> header("location: " . $_SERVER['PHP_SELF']); break; } // <<< ATUR ALERT >>> if (strlen($pesan) > 0) { $pesan = '<div class="box">' . $pesan . '</div>'; } $tampil_baru = true; } else { if (empty($_GET[id])) { $tampil_baru = true; }
$company_profile_data['logo_url'] = $company_profile->logoUrl; $company_profile_data['company_id'] = $company_profile->id; $company_profile_data['name'] = remove_spacial_1(remove_spacial(clean_insert($company_profile->name))); $company_profile_data['website'] = $company_profile->websiteUrl; $address = doImplode($company_profile->locations->values); $location = implode(",", $address); $company_profile_data['address'] = remove_spacial_1(remove_spacial(clean_insert($location))); $company_profile_data['followers'] = $company_profile->numFollowers; # GET SINGLE COMPANY DATA [END] $company_profile_datas[] = $company_profile_data; # COLLECT ALL COMPANY DATA } $where = array('project_id' => $project_id, 'user_auto_id' => $user_auto_id); if (getRowCount('tbl_linkedin_search_company_data', $where) > 0) { # DELETE COMPANY DATA FOR SAME USER deleteData('tbl_linkedin_search_company_data', $where); } $el = array(); foreach ($company_profile_datas as &$el) { $el['project_id'] = $project_id; $el['search_opt'] = ''; //$search_opt $el['user_auto_id'] = $user_auto_id; $el['updated_date'] = date('Y-m-d H:i:s'); } if (is_multidimention_array($company_profile_datas)) { foreach ($company_profile_datas as $row) { # ADD NEW KEYWORD SEARCH DATA [COMPANY PROFILE] addData('tbl_linkedin_search_company_data', $row); } }
<meta charset="utf-8"> <?php include "dataBase.php"; $id = $_GET['id']; deleteData($id); header("refresh:2;url=index.php"); die('İşleminiz Gerçekleştiriliyor lütfen İşleminiz bekleyiniz.');
viewData(""); } else { if ($action == "addData") { manageData("add"); } else { if ($action == "addData_submit") { manageData_submit("add"); } else { if ($action == "editData") { manageData("edit"); } else { if ($action == "editData_submit") { manageData_submit("edit"); } else { if ($action == "deleteData") { deleteData(); } else { if ($action == "utils") { utils(); } } } } } } } } } } } }
$sources = getSources(); $rows = count($sources); $draw = 1; $json = array("draw" => $draw, "recordsTotal" => $rows, "recordsFiltered" => $rows, "data" => $sources); echo json_encode($json); break; //+++++++++++++++++++++++++++++++++++Sourcen für Datatable laden+++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++Sourcen updaten++++++++++++++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++Sourcen für Datatable laden+++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++Sourcen updaten++++++++++++++++++++++++++++++++++++++++++++++++++ case 'updateSource': global $mysqli; $sourceId = $_GET['sourceId']; $source_array = array("sources_name" => $_POST['source_name'], "sources_url" => $_POST['source_url'], "sources_status" => $_POST['source_status']); $where = "sources_id = " . $sourceId; updateData("sources", $source_array, $where); header('Location: /nurrap/admin/sources.php'); break; //+++++++++++++++++++++++++++++++++++Sourcen updaten++++++++++++++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++Sourcen löschen++++++++++++++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++Sourcen updaten++++++++++++++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++Sourcen löschen++++++++++++++++++++++++++++++++++++++++++++++++++ case 'deleteSource': global $mysqli; $sourceId = $_GET['sourceId']; $where = "sources_id = " . $sourceId; deleteData("sources", $where); header('Location: /nurrap/admin/sources.php'); break; //+++++++++++++++++++++++++++++++++++Sourcen löschen++++++++++++++++++++++++++++++++++++++++++++++++++ }