function postRecord($userID, $date) { global $DBConnArray; $sql = "insert into invoices values (" . $userID . ", '" . $date . "', " . "12.49);"; $returnArray = updateData($DBConnArray, $sql); if (!$returnArray['ErrorReturn']['Success']) { echo json_encode(array('table' => $DBConnArray['ErrorReturn']['ErrorMessage'])); return; } }
function signupOverride($coreUserInfo) { global $gasDatabaseName, $CoreUserTableName; $insert = array(); $uid = $coreUserInfo["Result"]["Uid"]; $insert["EmployeeName"] = post("EmployeeUserName"); $insert["StoreName"] = post("StoreName"); $_POST = null; connectDB($gasDatabaseName); // insertData("Employee", $insert); updateData("{$CoreUserTableName}", "Uid = '{$uid}'", $insert); printResultByMessage("", 0); }
/** * Author : Jan Germann * Datum : 02.05.2010 * Modul : menu * Beschreibung : Bearbeiten von einem Menüpunkt */ function edit() { global $msg, $mysql; //Keine Menüpunkte vorhande? Dann Abbrechen mit Fehler! if (!mysql_result($mysql->query("SELECT count(*) FROM " . _PREFIX_ . "menu"), 0)) { $msg->error("Es sind keine Menüpunkte vorhanden."); return; } if (!isset($_POST['choose']) && !isset($_POST['edit'])) { return chooseMenu(); } elseif (isset($_POST['choose'])) { return showFormEdit(); } elseif (isset($_POST['edit'])) { return updateData(); } }
function addData($parts, $data) { switch ($parts[0]) { case "season": //header('Content-Type: application/json'); $cmd = [0 => "all"]; $current = getData($cmd); $new = json_decode($data); $seasons = [0 => "none", 1 => "autumn", 2 => "winter", 3 => "spring", 4 => "summer"]; $oldseasonname = $current->season_name; $seasonid = $current->season; $name = explode(" ", $oldseasonname); $file = '../data/archive/' . $name[1] . '_' . $seasons[$seasonid] . '_archive.json'; $fh = fopen($file, 'w') or die("Error: Can't open file."); fwrite($fh, json_encode($current)); fclose($fh); updateData([0 => "all"], $new); break; } }
function signupOverride($coreUserInfo) { global $gasDatabaseName, $CoreUserTableName; $insert = array(); $uid = $coreUserInfo["Result"]["Uid"]; $insert["CustomerType"] = post("CustomerType"); $insertAddress = array(); $insertAddress["Uid"] = $uid; $insertAddress["Username"] = ""; $insertAddress["PhoneNumber"] = post("PhoneNumber"); $insertAddress["City"] = post("RegionFirstLevel"); $insertAddress["Area"] = post("RegionSecondLevel"); $insertAddress["DetailAddress"] = post("DetailAddress"); $insertAddress["Floor"] = 0; $insertAddress["Elevator"] = 0; $insertAddress["IsDefault"] = 1; $_POST = null; connectDB($gasDatabaseName); // insertData("Customer", $insert); updateData($CoreUserTableName, "Uid = {$uid}", $insert); insertData("CustomerAddress", $insertAddress); printResultByMessage("", 0, $coreUserInfo["Result"]); }
$_SESSION['returnArray'] = $DBConnArray['ErrorReturn']['ErrorMessage']; header("Location: " . $_SERVER['HTTP_REFERER']); return; } $sql = "SELECT * from users as u, payments as p\n\t\tWHERE p.owner_id = u.id \n\t\tAND u.email_address = '" . $postArray['email'] . "';"; $checkArray = getDataSet($DBConnArray, $sql); if (!$DBConnArray['ErrorReturn']['Success']) { $_SESSION['returnArray'] = $DBConnArray['ErrorReturn']['ErrorMessage']; header("Location: " . $_SERVER['HTTP_REFERER']); return; } if (empty($checkArray['DataSet'])) { $_SESSION['returnArray'] = "You can not critique your canner if you have never paid"; header("Location: " . $_SERVER['HTTP_REFERER']); return; } # # Select info from temp_users table # Update password from current form # Copy to users record # Insert record into users table... # #$postArray['email'] = '*****@*****.**'; $sql = "SELECT c.* FROM canners as c, owners as o, users as u \n\t\tWHERE c.user_id = o.canner_id \n\t\tAND o.user_id = u.id \n\t\tAND u.email_address = '" . $postArray['email'] . "';"; $cannerArray = getDataSet($DBConnArray, $sql); $sql = "INSERT INTO canner_ratings (user_id, rating, notes) \n\t\tVALUES (" . $cannerArray['DataSet'][0]['user_id'] . "," . $postArray['rating'] . ",\"" . preg_replace("/\"/", "'", $postArray['notes']) . "\");"; $cannerArray = updateData($DBConnArray, $sql); header('Location:' . $baseURL . 'index.html'); ?>
<meta charset="utf-8"> <?php include "connect.php"; $id = $_GET['id']; if (isset($_POST["GÜNCELLE"])) { updateData($id); header("location:index.php"); } $users = getData(); foreach ($users as $row) { ?> <form action="index.php" method="POST" enctype="multipart/form-data"> <h1 style="color:gray; ">Müşteri Ekle </h1> <table > <tr> <td><img src="<?php echo $row['image_200_200']; ?> " alt=""></td> </tr> <tr> <td><input type="text" style="padding:5px; " name="ad" id="ad" value="<?php echo $row['ad']; ?> " required></td> </tr> <tr> <td><input type="text" style="padding:5px;" name="soyad" id="soyad" value="<?php echo $row['soyad']; ?> " required></td>
<?php if (isset($_POST['submit'])) { saveData() ? add_media_slider() : media_slider_details(); } elseif (isset($_POST['edit'])) { updateData() ? add_media_slider() : media_slider_details(); } elseif ($_GET['action'] == 'edit') { add_media_slider(); } elseif ($_GET['action'] == 'add') { add_media_slider(); } elseif ($_GET['action'] == 'delete') { delete_slider($_GET['id']); media_slider_details(); } else { media_slider_details(); } function delete_slider($id) { global $wpdb; $table_name = $wpdb->prefix . "media_sliders"; $slider_image = $wpdb->get_row("select * from {$table_name} where id='" . $id . "';"); $wpdb->delete($table_name, array('ID' => $id)); $file_path = ABSPATH . "wp-content/uploads/"; $file_path1 = ABSPATH . "wp-content/uploads/resize/"; for ($i = 1; $i <= 8; $i++) { $image = "image" . $i; $file_name = $file_path . $slider_image->{$image}; $file_name1 = $file_path1 . $slider_image->{$image}; unlink($file_name); unlink($file_name1); }
<?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 $array_of_data = getData(); } ?> <h2>Tabel</h2>
/** * Connect (create a socket) to the WhatsApp network. */ public function connect() { //If we have already connected AND the socket has not been closed from the remote side - then //no need to connect again. //WARNING: Lots of bugs in PHP's detection of socket timeout/remote disconnect. Be careful changing this code. //http://ie2.php.net/manual/en/function.socket-read.php#115903 //https://bugs.php.net/bug.php?id=47918 //http://stackoverflow.com/questions/20334366/php-fsockopen-how-to-know-if-connection-is-alive if ($this->isConnected()) { return true; } $WAver = trim(file_get_contents($this->WHATSAPP_VER_CHECKER)); $WAverS = str_replace(".", "", $WAver); $ver = str_replace(".", "", $this->WHATSAPP_VER); if ($ver < $WAverS) { $classesMD5 = file_get_contents('https://coderus.openrepos.net/whitesoft/whatsapp_classes'); updateData('token.php', $WAver, $classesMD5); updateData('whatsprot.class.php', $WAver); } $Socket = fsockopen($this->WHATSAPP_HOST, $this->PORT); if ($Socket !== false) { stream_set_timeout($Socket, $this->TIMEOUT_SEC, $this->TIMEOUT_USEC); $this->socket = $Socket; $this->eventManager()->fire("onConnect", array($this->phoneNumber, $this->socket)); } else { if ($this->debug) { print_r("Firing onConnectError\n"); } $this->eventManager()->fire("onConnectError", array($this->phoneNumber, $this->socket)); } }
} if ($action == "update") { $NewFName = trim($_POST['FName']); $NewLName = trim($_POST['LName']); $NewMName = trim($_POST['MName']); $NewAddress1 = trim($_POST['Address1']); $NewAddress2 = trim($_POST['Address2']); $NewCity = trim($_POST['City']); $NewState = trim($_POST['State']); $NewZip = trim($_POST['Zip']); $NewPhone1 = trim($_POST['Phone1']); $NewPhone2 = trim($_POST['Phone2']); $NewEmail = trim($_POST['Email']); $NewUsername = trim($_POST['Username']); if (updateData($CustomerID, $FName, $NewFName, $LName, $NewLName, $MName, $NewMName, $Address1, $NewAddress1, $Address2, $NewAddress2, $City, $NewCity, $State, $NewState, $Zip, $NewZip, $Phone1, $NewPhone1, $Phone2, $NewPhone2, $Email, $NewEmail, $Username, $NewUsername, $dblogin, $dbpass, $database)) { generateGenericLayout($dblogin, $dbpass, $db, "<B>Account Settings</B>"); beginContentBox(); displayAccountInfo($CustomerID, $FName, $LName, $MName, $Address1, $Address2, $City, $State, $Zip, $Phone1, $Phone2, $Email, $Username, ""); endContentBox(); } exit; } ?>
public function setTxt($conn, $text) { $this->text = $text; updateData($conn, "solutions", "text", $text, "context_id", $this->getId()); }
<?php include_once '../utiliti/crud_function.php'; #input ke log $id = isset($_GET['id']) ? $_GET['id'] : null; $array_obj = array('id_log' => '', 'id_calon' => $id); insertData($array_obj, 'log', $conn); # Update data calon yang sudah memilih $id_voter = $_SESSION['no_aktv']; $array_obj2 = array('status' => 'sudah memilih'); updateData($array_obj2, 'voter', $id_voter, 'no_aktivasi', $conn); #unset nomor aktv unset($_SESSION['no_aktv']); ?> <h1 align="center"> TERIMA KASIH SUDAH MENGGUNAKAN HAK PILIH</h1> <h2 align="center">SILAHKAN TINGGALKAN BILIK SUARA DAN PASTIKAN TIDAK ADA YANG TERTINGGAL</h2>
<?php require_once "functions.php"; $array_of_names = getFirstData(); if (isset($_POST["save"])) { updateData($_POST["id"], $_POST["carved"], 0, 0); } ?> <h2>Tabel</h2> <table border=1> <tr> <th>id</th> <th>Nimi</th> <th>Treitud</th> <th>Edit</th> </tr> <?php //var_dump($array_of_names); for ($i = 0; $i < count($array_of_names); $i++) { //echo $array_of_names[$i]->id; if (isset($_GET["edit"]) && $array_of_names[$i]->id == $_GET["edit"]) { echo "<tr>"; echo "<form action= 'tabel1.php' method='post'>"; echo "<input type='hidden' name='id' value='" . $array_of_names[$i]->id . "'>"; echo "<td>" . $array_of_names[$i]->id . "</td>"; echo "<td>" . $array_of_names[$i]->name . "</td>"; echo "<td><input name='carved' value='" . $array_of_names[$i]->carved . "'></td>"; echo "<td><a href='tabel1.php'>cancel<a></td>";
$data = insertData('devices', $insert_data); $devices_ID = mysql_insert_id(); } else { $where = array('user_id' => $user_ID); $data = updateData('devices', $insert_data, $where); $devices_ID = $devices_row[0]; } if ($data) { $activity_data = array('user_id' => $user_ID, 'device_id' => $devices_ID, 'activity_type' => '', 'activity_notes' => $note, 'activity_date' => date("Y-m-d")); $activity_row = getRow("SELECT * FROM `activity_log` WHERE `user_id` ='{$user_ID}'"); if ($activity_row == null) { insertData('activity_log', $activity_data); echo "<h3 class='success-msg'>Device Added Successfully.</h3>"; } else { $where = array('user_id' => $user_ID); $data = updateData('activity_log', $activity_data, $where); echo "<h3 class='success-msg'>Device Updated Successfully.</h3>"; } } } if (!empty($_SESSION['user_id'])) { $user_data = get_user_data($_SESSION['user_id']); $name = $user_data->f_name . ' ' . $user_data->l_name; if ($device_data = get_device_data($_SESSION['user_id'])) { $purchase_date = $device_data->purchase_date ? $device_data->purchase_date : ''; $price = $device_data->price ? $device_data->price : ''; $imei = $device_data->imei_string ? $device_data->imei_string : ''; $serial = $device_data->serial_num ? $device_data->serial_num : ''; $phone = $device_data->phone_num ? $device_data->phone_num : ''; $purchaser = $device_data->purchaser ? $device_data->purchaser : ''; $model = $device_data->model ? $device_data->model : '';
function updateInvoices($params) { global $DBConnArray; $userID = $params['userID']; $userEmail = $params['email']; $userFName = $params['fname']; $userLName = $params['lname']; $paymentAmount = $params['amount']; $paymentDateArray = $params['dates']; $date = date("Y-m-d"); #echo "<br>" . $userEmail; #echo "<br>" . $userFName . " " . $userLName; #echo "<br>" . $paymentAmount; #echo "<br>" . print_r($paymentDateArray, true); foreach ($paymentDateArray as $invDate) { $sql = "SELECT * FROM invoices WHERE owner_id = " . $userID . " AND service_date = '" . $invDate . "';"; $invoiceData = getDataSet($DBConnArray, $sql); if ($paymentAmount >= $invoiceData['DataSet'][0]['amount']) { $paymentAmount -= $invoiceData['DataSet'][0]['amount']; $sql = "UPDATE invoices SET paid = 'Y', " . " invoice_date ='" . $date . "' WHERE owner_id = " . $userID . " AND service_date = '" . $invDate . "';"; $returnArray = updateData($DBConnArray, $sql); } else { $paymentAmount = 0; $sql = "UPDATE invoices SET paid = 'P', " . " invoice_date ='" . $date . "' WHERE owner_id = " . $userID . " AND service_date = '" . $invDate . "';"; $returnArray = updateData($DBConnArray, $sql); } } return array('success' => true); }
$array_obj = array('status' => 'sudah di aktivasi'); updateData($array_obj, 'voter', $id, 'id_pemilih', $conn); ?> <h1 align="center">NOMOR AKTIVASI <?php echo strtoupper($result_no_aktivasi['nama']); ?> </h1> <br> <br> <?php if ($result_no_aktivasi['no_aktivasi'] == "") { #input no aktivasi $acak = rand(111111111, 999999999); $array_obj2 = array('no_aktivasi' => $acak); updateData($array_obj2, 'voter', $id, 'id_pemilih', $conn); echo "<h2 align='center'><a href='?page=nomor_aktivasi&id={$id}' class='btn btn-lg btn-primary'>Klik Disini Untuk Melihat Nomor Aktivasi</a></h2>"; } else { ?> <p style="font-size:80px" align="center"><?php echo $result_no_aktivasi['no_aktivasi']; ?> </p> <?php } ?> <br> <br> <h3 align="center"> Catat Nomor Pada Kertas Yang Telah Di Sediakan Dan Berikan Ke Pemilih <br> Klik Tombol Di Bawah Ini Untuk Kembali Ke Halaman Utama.
#eksekusi query $array_obj = array('status' => $status, 'waktu_selesai' => $waktu_selesai); updateData($array_obj, 'waktu_pemilihan', $id, 'id_waktu', $conn); #input data statistik : $query_calon = $conn->query("SELECT * FROM calon"); while ($result_calon = $query_calon->fetch_array()) { $id_calon = $result_calon['id_calon']; $query_log = $conn->query("SELECT * FROM log WHERE id_calon = '{$id_calon}'"); $hitung_log = $query_log->num_rows; $array_obj1 = array('id_statistik' => '', 'id_calon' => $id_calon, 'jum_suara' => $hitung_log); insertData($array_obj1, 'statistik', $conn); } # mengitung prosentase data $query_jum = $conn->query("SELECT SUM(jum_suara) AS jumlah_suara FROM statistik"); $result_jum = $query_jum->fetch_array(); $jumlah = $result_jum['jumlah_suara']; $query_prosentase = $conn->query("SELECT * FROM statistik"); while ($result_prosentase = $query_prosentase->fetch_array()) { $id_calon = $result_prosentase['id_calon']; $jum_temp = $result_prosentase['jum_suara']; #hitung prosentase $prosentase = $jum_temp * 100 / $jumlah; $array_obj2 = array('prosentase' => $prosentase); updateData($array_obj2, 'statistik', $id_calon, 'id_calon', $conn); } ?> </div> <script> alert("Pemungutan Suara Selesai. Silahkan ke Menu Data Statistik untuk melihat perolehan Suara"); location.href = "home.php"; </script>
<?php include "../controller/function.php"; $no_seri = $_POST['no_seri']; $nama_produk = $_POST['nama_produk']; $harga = $_POST['harga']; $persentase = $_POST['persentase']; $stmt = "update produk set nama_produk='{$nama_produk}', harga='{$harga}', persentase='{$persentase}' where no_seri='{$no_seri}'"; if (updateData($stmt)) { echo '{"status":"Data Produk berhasil diupdate"}'; } else { echo '{"status":"Data Produk gagal diupdate"}'; }
register($link); break; case '2': logout(); break; case '3': addTag($link); break; case '4': modifyTag($link); break; case '5': deleteTag($link); break; case '6': updateData($link); break; case '7': listAllTags($link); break; case '8': // metaSearch(); // metaSearch(); default: break; } /***************************************************** Operation for the user *****************************************************/
$cannerArray = getArray('canners'); foreach ($cannerArray as $k => $value) { $cannerArray[$k] = $cannerWorkArray[$k]; } $cannerArray['user_id'] = $lastKey; $sql = "INSERT INTO canners " . stringKeys($cannerArray) . " VALUES " . stringValues($cannerArray) . ";"; #echo $sql;die; $returnArray = updateData($DBConnArray, $sql); if (!$returnArray['ErrorReturn']['Success']) { $_SESSION['returnArray'] = $returnArray['ErrorReturn']['ErrorMessage']; header("Location: " . $_SERVER['HTTP_REFERER']); return; } # # Clean up temp record $sql = "DELETE FROM temp_users WHERE id = " . $_SESSION['returnValues']['last_key'] . ";"; $returnArray = updateData($DBConnArray, $sql); if (!$returnArray['ErrorReturn']['Success']) { $_SESSION['returnArray'] = $returnArray['ErrorReturn']['ErrorMessage']; header("Location: " . $_SERVER['HTTP_REFERER']); return; } # # Set up variables and redirect to Canner Set up # $_SESSION['returnArray'] = ""; $_SESSION['postData'] = array('on' => true, 'email_address' => $userArray['email_address'], 'password' => $userArray['password']); header('Location:' . $baseURL . 'index.html'); ?>
public function setEngTxt($conn, $text) { $this->text_eng = $text; updateData($conn, "texts", "eng", $text, "text_id", $this->text_id_desc); }
/** * */ public function update() { $WAData = json_decode(file_get_contents(WHATSAPP_VER_CHECKER), true); if (WHATSAPP_VER != $WAData['e']) { updateData('bootstrap.php', null, $WAData['h']); updateData('bootstrap.php', $WAData['e']); } }
// create new instance of user class $user = new User(); $user->first_name = $firstName; $user->last_name = $lastName; $user->user_name = $userName; $user->email = $email; $user->zipcode = $zipCode; $user->save(); $_SESSION['logInMessage'] = "Your profile has been updated.!!!"; header("Location:index.php"); die; } } return $errors; } updateData($dbc); ?> <!doctype html> <html lang="en"> <head> <?php require_once '../views/partials/head.php'; ?> <title>Create User</title> </head> <body> <div class="container"> <?php require_once '../views/partials/navbar.php'; ?>
/** * 更新配置库的数据 * 读取excel数据 更新到数据库 */ //导入PHPExcel扩展 include_once '../app/vender/PHPExcel_180/PHPExcel.php'; include_once '../app/library/MDB.php'; $mdb = new MDB('ar'); $dir = __DIR__ . "/update_db_config/Config/"; $files = scandir($dir); $excels = []; foreach ($files as $key => $value) { if (file_exists($dir . $value) && substr($value, -4) == 'xlsx') { if ($value == '角色属性.xlsx') { $datas = updateData($dir . $value); //print_r($datas); if (!count($datas['list'])) { exit('NO DATAS'); } foreach ($datas['list'] as $key => $value) { $mdb->selectCol('user_level_conf_' . $datas['version'])->insert($value); } } } } function updateData($filename, $encode = 'utf-8') { $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filename)) { $PHPReader = new PHPExcel_Reader_Excel5();
<?php include '../blogPdo.php'; ?> <div id="container"> <div id="upper"> <div id="menu"> <a href="../index.php" class="but">ANA SAYFA</a> <a href="#" class="but">YAZILARIM</a> <a href="../hakkimda.php" class="but">HAKKIMDA</a> <a href="../iletisim.php" class="but">İLETİŞİM</a> </div> </div> <?php if ($_POST) { updateData($_GET['id']); } ?> <div id="middle"> <div id="toolBar"> <div class="profil"> <label>HOŞGELDİNİZ:</label>HALİL BARIM </div> <div id="profilTools"> <a class="commentYazilarim" href="adminTools.php">Geri Dön</a>
?> " style="text-decoration:none;">Düzenle</a> </div> <div class="event"> <a href="delete.php?<?php echo $id; ?> " style="text-decoration: none;">Sil</a> </div> </div> <?php } ?> </div> </form> </div> </body> </html> <div id="demo"></div> <?php if (isset($_POST['save'])) { updateData(); }
public function update() { $WAData = json_decode(file_get_contents(Constants::WHATSAPP_VER_CHECKER), true); $WAver = $WAData['e']; if (Constants::WHATSAPP_VER != $WAver) { updateData('token.php', null, $WAData['h']); updateData('Constants.php', $WAver); } }
<div style="margin:7%"> <?php include_once '../utiliti/crud_function.php'; #reset voter $query_view = $conn->query("SELECT * FROM voter WHERE status='sudah di aktivasi' OR status='sudah memilih'"); while ($result_view = $query_view->fetch_array()) { $id = $result_view['id_pemilih']; $array_obj1 = array('status' => 'belum di aktivasi'); updateData($array_obj1, 'voter', $id, 'id_pemilih', $conn); } #reset log $conn->query("TRUNCATE TABLE log"); #reset statistik $conn->query("TRUNCATE TABLE statistik"); #reset waktu pemilihan $id = 1; $waktu_mulai = "00:00:00"; $waktu_selesai = "00:00:00"; $status = 'belum dimulai'; $array_obj2 = array('status' => $status, 'waktu_mulai' => $waktu_mulai, 'waktu_selesai' => $waktu_selesai); updateData($array_obj2, 'waktu_pemilihan', $id, 'id_waktu', $conn); ?> <script> alert("Data Pemungutan Teah di Reset"); location.href = "home.php"; </script> </div>