PHP DbMySqli::queryの例

コード例 #1

ファイル: func_sql.php プロジェクト: kisstest/snu_stress_manage

function get_admin_uniqid()
{
    $db = new DbMySqli();
    $uniqid = uniqid();
    $sql = "select uniqid from tbl_admin";
    $sql .= " where uniqid = '{$uniqid}'";
    $result = $db->query($sql);
    $rows = mysqli_num_rows($result);
    if ($rows > 0) {
        $i = 1;
        do {
            $uniqid = uniqid();
            $sql = "select uniqid from tb_admin";
            $sql .= " where uniqid = '{$uniqid}'";
            $result2 = $db->query($sql);
            $rows2 = mysqli_num_rows($result2);
            if ($rows2 > 0) {
                $uniqid = uniqid();
            } else {
                $i = $i + 1;
            }
        } while ($i == 1);
    }
    return $uniqid;
}

コード例 #2

ファイル: 1session_proc.php プロジェクト: kisstest/snu_stress_manage

if ($qst_13 != "") {
    $_SESSION['session1_qst_13'] = $qst_13;
}
if ($qst_14 != "") {
    $_SESSION['session1_qst_14'] = $qst_14;
}
if ($qst_15 != "") {
    $_SESSION['session1_qst_15'] = $qst_15;
}
$name = "홍길동";
$userip = $_SERVER['REMOTE_ADDR'];
$table = "tbl_session1";
$session1_idx = $_SESSION['session1_idx'];
$sql = "select idx from tbl_session1";
$sql .= " where idx = '{$session1_idx}'";
$result = $db->query($sql);
$rows = mysqli_num_rows($result);
if ($rows <= 0) {
    $idx_field = "idx";
    $db['name'] = $name;
    $db['qst_1'] = $qst_1;
    $db['qst_2'] = $qst_2;
    $db['qst_3'] = $qst_3;
    $db['qst_4'] = $qst_4;
    $db['qst_5'] = $qst_5;
    $db['qst_6'] = $qst_6;
    $db['qst_7'] = $qst_7;
    $db['qst_8'] = $qst_8;
    $db['qst_9'] = $qst_9;
    $db['qst_10'] = $qst_10;
    $db['qst_11'] = $qst_11;