PHP db_date_format示例

示例#1

文件： db-util.php 项目： ahelsing/geni-portal

function storeAbacAssertion($assertion, $issuer_fingerprint, $issuer_role, $subject_fingerprint, $expiration)
{
    $conn = portal_conn();
    $base64_assertion = base64_encode($assertion);
    $sql = "INSERT INTO abac_assertion (" . "issuer, issuer_role, subject, expiration, credential" . ") VALUES (" . $conn->quote($issuer_fingerprint, 'text') . ', ' . $conn->quote($issuer_role, 'text') . ', ' . $conn->quote($subject_fingerprint, 'text') . ', ' . $conn->quote(db_date_format($expiration), 'timestamp') . ', ' . $conn->quote($base64_assertion, 'text') . ')';
    /* print "command = $sql<br/>"; */
    $result = db_execute_statement($sql, "abac assertion insert");
    return $result[RESPONSE_ARGUMENT::VALUE];
}

示例#2

文件： test.php 项目： antho-firuze/_g.ene.sys_api_

 function extract_date()
 {
     // echo date("m", strtotime("2013-1-07"));
     // echo substr(date("Y", strtotime("2013-1-07")), -2);
     // echo date("Y", strtotime("2013-02-02"));
     // echo db_date_format("02/12/2015 15:30");
     echo db_date_format("02/12/2015") . " " . date('H:i:s');
     echo "<br>";
     echo date('Y-m-d H:i:s');
 }

示例#3

文件： rq_controller.php 项目： ahelsing/geni-portal

function resolve_pending_request($args)
{
    $request_id = null;
    if (array_key_exists(RQ_ARGUMENTS::REQUEST_ID, $args)) {
        $request_id = $args[RQ_ARGUMENTS::REQUEST_ID];
    }
    if (!isset($request_id) or is_null($request_id)) {
        return generate_response(RESPONSE_ERROR::ARGS, '', 'No request_id given');
    }
    $context_type = null;
    if (array_key_exists(RQ_ARGUMENTS::CONTEXT_TYPE, $args)) {
        $context_type = $args[RQ_ARGUMENTS::CONTEXT_TYPE];
    }
    $resolution_status = null;
    if (array_key_exists(RQ_ARGUMENTS::RESOLUTION_STATUS, $args)) {
        $resolution_status = $args[RQ_ARGUMENTS::RESOLUTION_STATUS];
    }
    $resolver = null;
    if (array_key_exists(RQ_ARGUMENTS::RESOLVER, $args)) {
        $resolver = $args[RQ_ARGUMENTS::RESOLVER];
    }
    $resolution_description = null;
    if (array_key_exists(RQ_ARGUMENTS::RESOLUTION_DESCRIPTION, $args)) {
        $resolution_description = $args[RQ_ARGUMENTS::RESOLUTION_DESCRIPTION];
    }
    $now = new DateTime(null, new DateTimeZone('UTC'));
    $conn = db_conn();
    $sql = "UPDATE " . get_request_tablename($context_type) . " SET " . RQ_REQUEST_TABLE_FIELDNAME::STATUS . " = " . $conn->quote($resolution_status, 'integer') . ", " . RQ_REQUEST_TABLE_FIELDNAME::RESOLUTION_DESCRIPTION . " = " . $conn->quote($resolution_description, 'text') . ", " . RQ_REQUEST_TABLE_FIELDNAME::RESOLUTION_TIMESTAMP . " = " . $conn->quote(db_date_format($now), 'timestamp') . ", " . RQ_REQUEST_TABLE_FIELDNAME::RESOLVER . " = " . $conn->quote($resolver, 'text') . " WHERE " . RQ_REQUEST_TABLE_FIELDNAME::ID . " = " . $conn->quote($request_id, 'integer');
    //  error_log("resolve_pending_request.sql = " . $sql);
    $result = db_execute_statement($sql);
    return $result;
}