PHP db_sql::close Examples

Example #1

File: zicserver.php Project: nonempty/woon.php

function OnCheckRegId()
{
    ShowMsg("OnCheckRegId.");
    $userid = $_GET['memberid'];
    global $db;
    global $dbaddr, $dbuser, $dbpwd, $dbname;
    if (!$db) {
        $db = new db_sql();
        $db->connect($dbaddr, $dbuser, $dbpwd, $dbname);
        ShowMsg("receate db .");
    }
    if (!$db) {
        return;
    }
    $sql = "select userid from tb_members where userid='" . $userid . "'";
    ShowMsg("query db width ." . $sql);
    $query = $db->query($sql);
    if (!$query) {
        echo GetErrorResult("CHECK_MEM_ID", 0);
        $db->close();
        return;
    }
    $count = $db->num_rows($query);
    $db->close();
    if ($count > 0) {
        echo GetErrorResult("CHECK_MEM_ID", 2);
    } else {
        echo GetErrorResult("CHECK_MEM_ID", 0);
    }
    return TRUE;
}