<?php
include "dbFunctions.php";
echo "note that a SQL zero time 0000-00-00 00:00:00 parses as\n";
var_export(strtotime('0000-00-00 00:00:00'));
$row = array("WasCanceled" => 1, "IsExpedited" => 0, "OrderedDate" => '2014-10-10 10:38:44', "PaidDate" => '0000-00-00 00:00:00');
echo "\nbefore:\n";
var_export($row);
echo "after:\n";
dbOrderNormalize2PHP($row);
var_export($row);
echo "and back again:\n";
dbOrderNormalize2SQL($row);
var_export($row);
echo "\nCheck Paypal date parsing:\n";
echo strtotime("08:12:31 Oct 13, 2014 PDT");
echo "\n";
echo date('Y-m-d H:i:s', strtotime("08:12:31 Oct 13, 2014 PDT"));
echo "\n";
function dbGetOrder($OID)
{
$hadError = false;
$con = dbConnect();
if ($con == null) {
return null;
}
$sql = "SELECT * FROM orders WHERE OID = {$OID}";
$result = mysqli_query($con, $sql);
if (!$result) {
dbErrorMsg("Error during sql query in dbGetOrder" . mysqli_error($con));
$hadError = true;
} else {
// only get one row
$row = mysqli_fetch_assoc($result);
dbOrderNormalize2PHP($row);
mysqli_free_result($result);
}
dbClose($con);
if ($hadError) {
return null;
} else {
return $row;
}
}
