PHP FORM_CONSTRUCT_SQL_FROM_POST示例

示例#1

文件： sarg.aliases.php 项目： BillTheBest/1.6.x

function Save()
{
    $tpl = new templates();
    $sql = FORM_CONSTRUCT_SQL_FROM_POST("sarg_aliases", "ID");
    $q = new mysql_squid_builder();
    $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error;
    }
}

示例#2

文件： squid.stats.reports.php 项目： BillTheBest/1.6.x

function report_main_save()
{
    $page = CurrentPageName();
    $tpl = new templates();
    $q = new mysql_squid_builder();
    $_POST["report_name"] = url_decode_special_tool($_POST["report_name"]);
    $_POST["description"] = url_decode_special_tool($_POST["description"]);
    $_POST["report_build_time_start"] = strtotime($_POST["report_build_time_start"] . " 00:00:00");
    $_POST["report_build_time_end"] = strtotime($_POST["report_build_time_end"] . " 00:00:00");
    $array = FORM_CONSTRUCT_SQL_FROM_POST("squid_reports", "ID");
    $sql = $array[1];
    $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error;
        return;
    }
    $report_days[2] = "2 {days}";
    $report_days[7] = "1 {week}";
    $report_days[15] = "2 {weeks}";
    $report_days[-1] = "{current_month}";
    $report_days[30] = "1 {month}";
    $report_days[60] = "2 {months}";
    $report_days[90] = "3 {months}";
    $report_days[180] = "6 {months}";
    $report_days[365] = "1 {year}";
}

示例#3

文件： nginx.site.ssl.php 项目： BillTheBest/1.6.x

function Save()
{
    $q = new mysql_squid_builder();
    if (isset($_POST["cache_peer_id"])) {
        $cache_peer_id = $_POST["cache_peer_id"];
        unset($_POST["cache_peer_id"]);
    }
    $sqlz = FORM_CONSTRUCT_SQL_FROM_POST("reverse_www", "servername");
    $q->QUERY_SQL($sqlz[1]);
    if (!$q->ok) {
        echo $sq->mysql_error;
        return;
    }
    $sock = new sockets();
    $sock->getFrameWork("nginx.php?compile-single=yes&servername=" . urlencode($_POST["servername"]));
}

示例#4

文件： nginx.caches.php 项目： BillTheBest/1.6.x

function cache_save()
{
    unset($_POST["save-cache"]);
    $sqlZ = FORM_CONSTRUCT_SQL_FROM_POST("nginx_caches", "ID");
    if ($_POST["ID"] == 0) {
        $sql = $sqlZ[0];
    } else {
        $sql = $sqlZ[1];
    }
    $q = new mysql_squid_builder();
    $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error . "\n{$sql}\n";
        return;
    }
    $sock = new sockets();
    $sock->getFrameWork("nginx.php?build-main=yes");
}

示例#5

文件： nginx.caches.php 项目： brucewu16899/1.6.x

function cache_save()
{
    unset($_POST["save-cache"]);
    $sqlZ = FORM_CONSTRUCT_SQL_FROM_POST("nginx_caches", "ID");
    if ($_POST["ID"] == 0) {
        $sql = $sqlZ[0];
    } else {
        $sql = $sqlZ[1];
    }
    $q = new mysql_squid_builder();
    $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error . "\n{$sql}\n";
    }
}

示例#6

文件： nginx.mail.php 项目： BillTheBest/1.6.x

function rule_save()
{
    $md5 = $_POST["zmd5"];
    if ($_POST["protocol"] != "smtp") {
        $_POST["destination"] = null;
    }
    $_POST["username"] = trim(mysql_escape_string2(url_decode_special_tool($_POST["username"])));
    $_POST["destination"] = trim(mysql_escape_string2(url_decode_special_tool($_POST["destination"])));
    $_POST["ipsrc"] = trim(mysql_escape_string2(url_decode_special_tool($_POST["ipsrc"])));
    if ($_POST["ipsrc"] == "*") {
        $_POST["ipsrc"] = null;
    }
    $squid = new squid_reverse();
    if ($md5 == null) {
        $md5 = md5("{$_POST["username"]}{$_POST["ipsrc"]}{$_POST["protocol"]}");
        $sql = "INSERT IGNORE INTO reverse_mailauth (zmd5,username,ipsrc,protocol,backend,backend_port,enabled,destination)\n\t\t\tVALUES('{$md5}','{$_POST["username"]}','{$_POST["ipsrc"]}','{$_POST["protocol"]}',\n\t\t\t'{$_POST["backend"]}','{$_POST["backend_port"]}','{$_POST["enabled"]}','{$_POST["destination"]}')";
    } else {
        $array = FORM_CONSTRUCT_SQL_FROM_POST("reverse_mailauth", "md5");
        $sql = $array[1];
    }
    $q = new mysql_squid_builder();
    $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error;
        return;
    }
}