Ejemplos de update_series_catalog en PHP

Ejemplo n.º 1

Archivo: update_series_catalog.php Proyecto: CMIP5/HUC8Climate

function db_UpdateSeriesCatalog_All()
{
    $result_status = array("inserted" => 0, "updated" => 0);
    $query = 'SELECT MAX(SiteID), MAX(VariableID), MAX(MethodID), MAX(SourceID), MAX(QualityControlLevelID)
            FROM ' . get_table_name('DataValues') . ' GROUP BY SiteID, VariableID, SourceID, MethodID, QualityControlLevelID';
    $result = mysql_query($query);
    if (!$result) {
        die("<p>Error in executing the SQL query " . $query . ": " . mysql_error() . "</p>");
    }
    $result_array = mysql_fetch_rowsarr($result, MYSQL_NUM);
    foreach ($result_array as $r) {
        $status = update_series_catalog($r[0], $r[1], $r[2], $r[3], $r[4]);
    }
}

Ejemplo n.º 2

Archivo: inputSensorData.php Proyecto: frandiaznet/arduino_to_hsl

$VariableID2 = $parsedInfo[3];
$PastTimeStamps = file_get_contents("DateRepository.txt");
$parsedData = explode(";", $data);
$sql7 = "INSERT INTO `datavalues`(`DataValue`, `LocalDateTime`, `UTCOffset`, `DateTimeUTC`, `SiteID`, `VariableID`, `CensorCode`, `MethodID`, `SourceID`, `QualityControlLevelID`) VALUES ";
for ($i = 0, $size = count($parsedData); $i < $size; ++$i) {
    $parsedMoreData = explode(",", $parsedData[$i]);
    //parses the individual data records
    $mydate = "20" . $parsedMoreData[0] . "," . $parsedMoreData[1];
    //formats the date so that it is 2014 instead of 14 and adds time value
    $timestamp = strtotime($mydate);
    $mydate = date('Y-m-d H:i:s', $timestamp);
    array_push($dateTimeArray, $mydate);
    if (strpos($PastTimeStamps, $mydate) !== false) {
        continue;
    }
    $ms = $UTCOffset * 3600;
    $utctimestamp = $timestamp - $ms;
    $DateTimeUTC = date("Y-m-d H:i:s", $utctimestamp);
    $sql7 .= "('{$parsedMoreData['2']}', '{$mydate}', '{$UTCOffset}', '{$DateTimeUTC}', '{$SiteID}', '{$VariableID1}', '{$CensorCode}', '{$MethodID}', '{$SourceID}', '{$QualityControlLevelID}'), ";
    $sql7 .= "('{$parsedMoreData['3']}', '{$mydate}', '{$UTCOffset}', '{$DateTimeUTC}', '{$SiteID}', '{$VariableID2}', '{$CensorCode}', '{$MethodID}', '{$SourceID}', '{$QualityControlLevelID}'), ";
}
file_put_contents("DateRepository.txt", $dateTimeArray);
$sql7 = substr($sql7, 0, strlen($sql7) - 2);
echo $sql7;
$result7 = @mysql_query($sql7, $connection) or die(mysql_error());
echo $result7;
echo "tests";
require_once 'update_series_catalog_function.php';
update_series_catalog($SiteID, $VariableID1, $MethodID, $SourceID, $QualityControlLevelID);
update_series_catalog($SiteID, $VariableID2, $MethodID, $SourceID, $QualityControlLevelID);