PHP request_has_requirement::set_where示例

示例#1

文件： form_data_request.php 项目： seans888/Bgy-Project

    $data = $result->fetch_assoc();
    extract($data);
    $data = explode('-', $date_filed);
    if (count($data) == 3) {
        $date_filed_year = $data[0];
        $date_filed_month = $data[1];
        $date_filed_day = $data[2];
    }
    $data = explode('-', $date_served);
    if (count($data) == 3) {
        $date_served_year = $data[0];
        $date_served_month = $data[1];
        $date_served_day = $data[2];
    }
}
require_once 'subclasses/request_has_requirement.php';
$dbh_request = new request_has_requirement();
$dbh_request->set_fields('date_submitted, requirement_document, status');
$dbh_request->set_where("request_id='" . quote_smart($request_id) . "'");
if ($result = $dbh_request->make_query()->result) {
    $num_request_has_requirement = $dbh_request->num_rows;
    for ($a = 0; $a < $num_request_has_requirement; $a++) {
        $data = $result->fetch_row();
        $data_temp_cf_date = explode('-', $data[0]);
        $cf_request_has_requirement_date_submitted_year[$a] = $data_temp_cf_date[0];
        $cf_request_has_requirement_date_submitted_month[$a] = $data_temp_cf_date[1];
        $cf_request_has_requirement_date_submitted_day[$a] = $data_temp_cf_date[2];
        $cf_request_has_requirement_requirement_document[$a] = $data[1];
        $cf_request_has_requirement_status[$a] = $data[2];
    }
}

示例#2

文件： form_data_request_has_requirement.php 项目： seans888/Bgy-Project

<?php

require 'components/get_listview_referrer.php';
require 'subclasses/request_has_requirement.php';
$dbh_request_has_requirement = new request_has_requirement();
$dbh_request_has_requirement->set_where("");
if ($result = $dbh_request_has_requirement->make_query()->result) {
    $data = $result->fetch_assoc();
    extract($data);
    $data = explode('-', $date_submitted);
    if (count($data) == 3) {
        $date_submitted_year = $data[0];
        $date_submitted_month = $data[1];
        $date_submitted_day = $data[2];
    }
}

示例#3

文件： form_data_request_has_requirement.php 项目： seans888/Bgy-Project

<?php

require 'components/get_listview_referrer.php';
require 'subclasses/request_has_requirement.php';
$dbh_request_has_requirement = new request_has_requirement();
$dbh_request_has_requirement->set_where("request_has_requirement_id='" . quote_smart($request_has_requirement_id) . "'");
if ($result = $dbh_request_has_requirement->make_query()->result) {
    $data = $result->fetch_assoc();
    extract($data);
    $data = explode('-', $date_submitted);
    if (count($data) == 3) {
        $date_submitted_year = $data[0];
        $date_submitted_month = $data[1];
        $date_submitted_day = $data[2];
    }
}

示例#4

文件： form_data_request.php 项目： seans888/Bgy-Project

$dbh_request->set_where("request_id='" . quote_smart($request_id) . "'");
if ($result = $dbh_request->make_query()->result) {
    $data = $result->fetch_assoc();
    extract($data);
    $data = explode('-', $date_filed);
    if (count($data) == 3) {
        $date_filed_year = $data[0];
        $date_filed_month = $data[1];
        $date_filed_day = $data[2];
    }
    $data = explode('-', $date_served);
    if (count($data) == 3) {
        $date_served_year = $data[0];
        $date_served_month = $data[1];
        $date_served_day = $data[2];
    }
}
require_once 'subclasses/request_has_requirement.php';
$dbh_request = new request_has_requirement();
$dbh_request->set_fields('date_submitted');
$dbh_request->set_where("requirement_document='" . quote_smart($request_id) . "'");
if ($result = $dbh_request->make_query()->result) {
    $num_request_has_requirement = $dbh_request->num_rows;
    for ($a = 0; $a < $num_request_has_requirement; $a++) {
        $data = $result->fetch_row();
        $data_temp_cf_date = explode('-', $data[0]);
        $cf_request_has_requirement_date_submitted_year[$a] = $data_temp_cf_date[0];
        $cf_request_has_requirement_date_submitted_month[$a] = $data_temp_cf_date[1];
        $cf_request_has_requirement_date_submitted_day[$a] = $data_temp_cf_date[2];
    }
}