PHP db_sql::connect Examples

Example #1

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

function GetDb()
{
    global $db;
    global $dbaddr, $dbuser, $dbpwd, $dbname;
    if (null == $db) {
        $db = new db_sql();
        ShowMsg("create new db");
        $db->connect($dbaddr, $dbuser, $dbpwd, $dbname);
        ShowMsg("create new db ok");
    }
    return $db;
}

Example #2

File: common.inc.php Project: yunsite/cyaskuc

} else {
    $tmp = $_SERVER['PHP_SELF'];
}
if (empty($_SERVER['HTTP_HOST'])) {
    $baseurl = "http://{$_SERVER['HTTP_HOST']}" . substr($tmp, 0, strrpos($tmp, '/'));
} else {
    $baseurl = "http://{$_SERVER['HTTP_HOST']}" . substr($tmp, 0, strrpos($tmp, '/'));
}
if ($gzipcompress && function_exists('ob_gzhandler') && CURSCRIPT != 'wap') {
    ob_start('ob_gzhandler');
} else {
    $gzipcompress = 0;
    ob_start();
}
$dblink = new db_sql();
$dblink->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$_DCOOKIE = $_DCACHE = array();
list($cyask_uid, $username, $email) = explode("\t", uc_authcode($_COOKIE['auth'], 'DECODE'));
define('FORMHASH', form_hash());
$styleid = $_DCOOKIE['styleid'] ? $_DCOOKIE['styleid'] : 1;
$cyask_adminid = 0;
if ($cyask_uid) {
    $query = $dblink->query("SELECT username,password,adminid,groupid FROM {$dbprefix}members WHERE uid={$cyask_uid}");
    $members = $dblink->fetch_array($query);
    if (empty($members)) {
        $members = array();
        list($uid, $uname, $email) = uc_get_user($cyask_uid, 1);
        $dblink->query("INSERT INTO {$dbprefix}members(uid,username,email,adminid,groupid,regdate) VALUES('{$cyask_uid}','{$username}','{$email}','5','0','" . time() . "')");
        $cyask_user = $username;
        unset($uid, $uname);

Example #3

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;
}