PHP pdo_execute_non_query示例

示例#1

文件： trucks.php 项目： MyJobReady/gps-truck-tracking

 /**
  * This function resets the GPS data weekly.
  **/
 public static function cURLReset()
 {
     $sql = "TRUNCATE TABLE GPSData";
     $params = array();
     $stm = pdo_execute_non_query($sql, $params);
     if ($stm) {
         return $stm;
     } else {
         return FALSE;
     }
 }

示例#2

文件： maps_ajax_add_truck_to_task.php 项目： MyJobReady/gps-truck-tracking

<?php

require "inc_header_ps.php";
require_once '../lib/pdo.php';
mysql_select_db($db_name, $oConn);
// 2014-09-22 Updated ^CS
$eventid = $_POST['eventId'];
$trucknum = $_POST['truckNum'];
$truckId;
$sql = "SELECT TruckID FROM GPSTruck WHERE ID = {$trucknum}";
$result = mysql_query($sql, $oConn);
if ($result == false) {
    echo $sql;
    die(mysql_error());
}
$row = mysql_fetch_array($result);
$truckId = $row['TruckID'];
$sql = "UPDATE Events SET AssignedTruckID = :trucknum, AssignedSubcontractorID = :truckId WHERE EventID = :eventid;";
$params = array(':eventid' => $eventid, ':trucknum' => $trucknum, ':truckId' => $truckId);
$ret = pdo_execute_non_query($sql, $params) == 1;
echo $ret;

示例#3

文件： curl_save_truck_route.php 项目： MyJobReady/gps-truck-tracking

        $DrivingRoute = "";
        $TimeStamps = "";
        $x = 1;
        while ($points = $stm2->fetch(PDO::FETCH_OBJ)) {
            if ($x == $RowCount) {
                $DrivingRoute .= '(' . $points->Latitude . ', ' . $points->Longitude . ')';
                $TimeStamps .= $points->TimeStamp;
            } else {
                $DrivingRoute .= '(' . $points->Latitude . ', ' . $points->Longitude . '),';
                $TimeStamps .= $points->TimeStamp . ", ";
            }
            $x++;
        }
        $sql = "INSERT INTO GPSTruckRoute (GPSID, CustomerID, Date, Route, TimeStamp) VALUES (:id, :customerid, :date, :route, :timestamps)";
        $params = array(':id' => $GPSID, ':customerid' => $CustomerID, ':date' => $date, ':route' => $DrivingRoute, ':timestamps' => $TimeStamps);
        $stm3 = pdo_execute_non_query($sql, $params);
        if ($stm3) {
            echo "Success<br />";
        } else {
            echo "Failure<br />";
        }
    }
}
$time_end = microtime(true);
$execution_time = ($time_end - $time_start) / 60;
function rutime($ru, $rus, $index)
{
    return $ru["ru_{$index}.tv_sec"] * 1000 + intval($ru["ru_{$index}.tv_usec"] / 1000) - ($rus["ru_{$index}.tv_sec"] * 1000 + intval($rus["ru_{$index}.tv_usec"] / 1000));
}
$ru = getrusage();
$MessageTime = "[SYSTEM-MSG] Save Truck Route - Total Execution Time:" . $execution_time . " minutes";