PHP updateData函数代码示例

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;
    }
}

    $_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'] = 'nancybn18@gmail.com';
$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);
}