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

[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]