항상 기뻐하라(Be joyful always;)

[code php;gutter:false] function webpage_static_id($pageid="");
function webpage_member_id($pageid=""); [/code]

[code php;gutter:false] function uglobal_lock();
function uglobal_unlock(); [/code]

[code php;gutter:false] function uglobal($pageid, $name, $value="");
function uglobal_unset($pageid, $name); [/code]

[code sql;gutter:false] CREATE TABLE 테이블명 (
pageid varchar(32) not null,
value blob not null,
PRIMARY KEY (pageid)
); [/code]

[code php;gutter:false] .
.
.
$obj = new clsUserglobal($host, $user, $pass, $base);

$obj->uglobal_lock();

$all_page_hits = $obj->uglobal("pageglobal","all_page_hits")+1;
$obj->uglobal("pageglobal", "all_page_hits", $all_page_hits);

if (0 == ($all_page_hits % 10))
$history = "";
else
$history = $obj->uglobal("pageglobal", "history");

$history .= "[".$obj->webpage_static_id()
. "/히트수][a]=$all_page_hits";
$obj->uglobal("pageglobal", "history", $history);

$obj->uglobal_unlock();
.
.
. [/code]

[code php;gutter:false] function baseMysql($host="", $user="", $pass="", $base="", $connect="") {
if (is_array($host))
extract($host);

if (!$this->LID=$GLOBALS["_hBASE"]["mysql"]->connect($host, $user, $pass, $base, $connect))
die("Not a valid Link resource in ".__FILE__." on line ".__LINE__); // <-- 새로 추가된 에러출력 부분
} [/code]

[code php;gutter:false] function prvNumRows($query) {
if (eregi("^[[:space:]]*SELECT[[:space:]]", $query)) {
$from_pos = strpos(strtoupper($query),"FROM");
$q = "SELECT count(*) ". substr($query, $from_pos);
$rid = @ifx_query($q, $this->LID);
$record = @ifx_fetch_row($rid);
@ifx_free_result($rid);
return $record['(count)'];
} else
return @ifx_affected_rows($this->RID);
} [/code]

[code php;gutter:false] require("./minidb/class.mysql.php"); // 미니디비(MySQL용) 0.2.2p1
require("./applicationer/class.applbase.php"); // 애플리케이셔너(디비용) 0.0.2
if ("3." == substr(phpversion(), 0, 2)) {
include("./sessioner/lib.sessioner.php"); // 세셔너 0.2.5p1
}
require("./sessioner/handler.sessbase.php"); // 세셔너핸들러(디비용) 0.0.2p3
require("./unittable/class.unittable.php"); // 유닛테이블 0.x.x [/code]

[code php;gutter:false] require("./minidb/class.mysql.php");
$db = new MiniDB("localhost", "userid", "password", "dbname");

if (list($rows,$fields)=$db->query("select * from Members")) {
while ($record=$db->next_record()) {
......
}
} [/code]

[code php;gutter:false] require("./minidb/class.oracle.php");
require("./minidb/class.mysql.php");

$mys = new baseMysql("localhost", "userid", "password", "dbname");
$ora = new baseOracle("localhost", "userid", "password", "ORCL");

if (list($rows,$fields)=$ora->query("select * from Members")) {
while ($record = $ora->next_record()) {
......
}
}

if (list($rows,$fields)=$mys->query("select * from Members")) {
while ($record = $mys->next_record()) {
......
}
} [/code]

[code php;gutter:false] require("./minidb/class.mysql.php");

$my1 = new MiniDB("localhost", "userid", "password", "dbname#1");
$my2 = new MiniDB("localhost", "userid", "password", "dbname#2"); [/code]

[code php;gutter:false] <?php /***메인 스크립트***/
require("./class.mysql.php"); // 미니디비(MySQL용) 0.2.2
require("./class.applbase.php"); // 애플리케이셔너(디비용) 0.2.0

$db = new MiniDB("디비 호스트명", "사용자명", "디비 패스워드", "디비명");

.
.
.
?>

<?php /***애플리케이셔너(디비용)***/
/*
filename : class.applbase.php (ver 0.0.2)
email : hwooky＠phpclass.com
homepage : www.phpclass.com
author : hwooky
environment : PHP3 & 4, 미니디비 ver 0.2.2
*/

class Applicationer {
var $prvWaitingTime = 5; // Waiting Time(초단위)
var $prvResource = "Applicationer";
var $prvList = array();
var $baseClass = "MiniDB";
var $baseObj;

function Applicationer($resource="") {
if (!is_object($this->baseObj)) {
$base = $this->baseClass;
$this->baseObj = new $base;
}
if ($resource) $this->prvResource = $resource;
}

function prvLocking($varname) {
$query = sprintf("UPDATE %s SET islock=1,lastused=%s WHERE id='%s'",
$this->prvResource,
time(),
$varname
);
$this->baseObj->query($query);
}

.
.
.
?> [/code]

[code php;gutter:false] if ($db->query("SELECT count(*) FROM $table")) {
list(,$count) = each($db->next_record());
}   [/code]

[code php;gutter:false] if ($db->query("SELECT count(*) FROM $table")) {
$rec = $db->next_record();
list(,$count) = each($rec);
} [/code]

[code php;gutter:false] $db = new MiniDB("디비 호스트명", "사용자명", "디비 패스워드", "디비명", "pconnect"); [/code]

[code php;gutter:false] $db = new MiniDB("디비 호스트명", "사용자명", "디비 패스워드", "디비명", "connect"); [/code]

[code php;gutter:false] if (list($rows,$fields)=$db->query("select * from Members")) {
// 정상적으로 쿼리되었을 때 처리할 내용
} else {
// 에러발생시 처리할 내용
} [/code]

[code php;gutter:false] $db->query("REPLACE INTO (userid, password, age) VALUES ('user9', 'pw9', 22)"); [/code]

[code php;gutter:false] while ($record=$db->next_record()) {
......
} [/code]

[code php;gutter:false] $db = new MiniDB(
"디비 호스트명",
"사용자명",
"디비 패스워드",
"디비명",
"접속방식"
); [/code]

[code php;gutter:false] $info = array(
"host"=>"디비 호스트명",
"user"=>"사용자명",
"pass"=>"디비 패스워드",
"base"=>"디비명",
"connect"=>"접속방식"
);

$db = new MiniDB($info); [/code]

[code php;gutter:false] $db = new MiniDB; [/code]

[code php;gutter:false] $db = new MiniDB("새롭게 연결할 디비명"); [/code]

[code sql;gutter:false] CREATE TABLE Members ( userid varchar(20) not null PRIMARY KEY, password varchar(16) not null ); [/code]

[code sql;gutter:false] INSERT INTO Members VALUES('user1', 'test'); INSERT INTO Members VALUES('user2', 'test'); INSERT INTO Members VALUES('user3', 'test'); [/code]

[code php;gutter:false] $permission_user = "user1"; $permission_type = "owner"; [/code]

[code php;gutter:false] $permission_type = "login"; [/code]