コード例 #1
0
ファイル: sec_soap.php プロジェクト: helio-vo/helio
    while (!checkdate($mo_from, $d_from, $y_from) and $d_from > 0) {
        $d_from--;
    }
    if (!checkdate($mo_from, $d_from, $y_from)) {
        sec_error('Start time is invalid, please verify');
        exit;
    }
    while (!checkdate($mo_to, $d_to, $y_to) and $d_to > 0) {
        $d_to--;
    }
    if (!checkdate($mo_to, $d_to, $y_to)) {
        sec_error('End time is invalid, please verify');
        exit;
    }
    if (mktime($h_from, $mi_from, $s_from, $mo_from, $d_from, $y_from) > mktime($h_to, $mi_to, $s_to, $mo_to, $d_to, $y_to)) {
        sec_error('End date is greater than start date, please verify');
        exit;
    }
    $from = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $y_from, $mo_from, $d_from, $h_from, $mi_from, $s_from);
    $to = sprintf("%04d-%02d-%02d %02d:%02d:%02d", $y_to, $mo_to, $d_to, $h_to, $mi_to, $s_to);
    $query_time = "time_start>='{$from}' AND time_start<='{$to}'";
    if ($nar != "") {
        $query_nar = " OR nar={$nar}";
    }
    $w = $query_time . $query_nar;
    $s1 = "SELECT * FROM {$cat1} WHERE {$w} ORDER BY time_start;";
    $s2 = "SELECT * FROM {$cat2} WHERE {$w} ORDER BY time_start;";
}
$error = 0;
echo "The VOTable (XML) result file is <a href=\"xml/{$xml1}\"><B>hec1_{$xmldate}.xml</B></a>";
echo "<br>The TXT result file is <a href=\"xml/{$txt1}\"><B>hec1_{$xmldate}.txt</B></a><p>";
コード例 #2
0
ファイル: sec_test.php プロジェクト: helio-vo/helio
<?php

# =============================================
# EGSO 2003,2004 - by Max Jurcev
# INAF - Trieste Astronomical Observatory
# ---------------------------------------------
require "sec_global.php";
echo sec_header("EGSO SEC test");
# =============================================
# connect db and perform the query
# =============================================
$dbconn = pg_connect("dbname=hec");
if (!$dbconn) {
    sec_error('Unable to connect to the database');
    exit;
}
$result = pg_exec($dbconn, "SELECT * FROM sgas_event ORDER BY time_start");
if (!$result) {
    sec_error('Error while reading the database');
    exit;
}
sec_showresult($result);
pg_close($dbconn);
echo sec_footer();