PHP IMDB::direct_query示例

function insert_credential($imuser, $id, $type, $host, $username, $password, $token_type, $project, $proxy, $public_key, $private_key, $certificate, $tenant)
{
    include 'config.php';
    $res = "";
    $db = new IMDB();
    $fields = array();
    $fields[] = "'" . $db->escapeString($id) . "'";
    $fields[] = "'" . $imuser . "'";
    $fields[] = "'" . $type . "'";
    $fields[] = "'" . $db->escapeString($host) . "'";
    $fields[] = "'" . $db->escapeString($username) . "'";
    $fields[] = "'" . $db->escapeString($password) . "'";
    $fields[] = 1;
    $res = $db->direct_query("select max(ord) as max_ord from credentials where imuser = '******'");
    $fields[] = $res[0]['max_ord'] + 1;
    $fields[] = "'" . $db->escapeString($proxy) . "'";
    $fields[] = "'" . $db->escapeString($token_type) . "'";
    $fields[] = "'" . $db->escapeString($project) . "'";
    $fields[] = "'" . $db->escapeString($public_key) . "'";
    $fields[] = "'" . $db->escapeString($private_key) . "'";
    $fields[] = "'" . $db->escapeString($certificate) . "'";
    $fields[] = "'" . $db->escapeString($tenant) . "'";
    $res = $db->insert_item_into_table("credentials", $fields);
    $db->close();
    return $res;
}

示例#2

显示文件

文件： radl.php 项目： grycap/im-web

function get_radls($user)
{
    include 'config.php';
    include_once 'user.php';
    $user_groups = get_user_groups($user);
    $sql = "select rowid,* from radls where imuser = '******'";
    $sql = $sql . " or other_r = '1'";
    if (count($user_groups) > 0) {
        $sql = $sql . " or (group_r = '1' and (";
        for ($i = 0; $i < count($user_groups); $i++) {
            $group = $user_groups[$i];
            if ($i > 0) {
                $sql = $sql . " or ";
            }
            $sql = $sql . "grpname = '" . $group['grpname'] . "'";
        }
        $sql = $sql . "))";
    }
    $db = new IMDB();
    $res = $db->direct_query($sql);
    $db->close();
    return $res;
}