{"id":1008,"date":"2004-01-16T09:11:26","date_gmt":"2004-01-16T09:11:26","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=1008"},"modified":"2004-01-16T09:11:26","modified_gmt":"2004-01-16T09:11:26","slug":"mysql-db-class","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=1008","title":{"rendered":"mysql DB Class"},"content":{"rendered":"

\n\/* vim: set expandtab tabstop=4 shiftwidth=4: *\/
\n\/\/ +——————————————————–+
\n\/\/ | PHP version 4.3.x |
\n\/\/ +——————————————————–+
\n\/\/ | Copyright (c) 2003 Song Hyo-Jin |
\n\/\/ +——————————————————–+
\n\/\/ | This source file is GPL. |
\n\/\/ +——————————————————–+
\n\/\/ | Author : Song Hyo-Jin |
\n\/\/ | (MSN Messengerable) |
\n\/\/ +——————————————————–+
\n\/\/
\n\/\/ $Id: mysql.inc, v 0.01 2004\/01\/15 11:40:00 crosser Exp $
\n\/\/
\n\/\/ MySQL database control<\/p>\n

\/*
\n$test = new MyDB(‘access_file.ini’, [transaction bool]);
\n$test->query(‘sql query’);
\n$test->close();
\n$data = mysql_fetch_object($test->result);<\/p>\n

Want query error report
\n$test->err_report = true;
\n$test->query(‘sql query’);<\/p>\n

With transaction
\n$test = new MyDB(‘access_file.ini’, true);
\n$test->query(‘sql query’);
\n$test->query(‘sql query’);
\n$test->query(‘sql query’);
\nif(not good)
\n $test->close_error(‘error message’);
\n\/\/ or exit(‘error message’); auto rollback;<\/p>\n

access_file.ini<\/p>\n

ip = localhost
\nuser = sql_user
\npass = sql_pass
\ndb = sql_db
\n*\/<\/p>\n

\/\/ MySQL Unsigned Limit
\ndefine(‘MyBIGINT’, ‘18446744073709551615’);
\ndefine(‘MyINT’, 4294967295);
\ndefine(‘MyMEDIUMINT’, 16777215);
\ndefine(‘MySMALLINT’, 65535);
\ndefine(‘MyTINYINT’, 255);<\/p>\n

$db_set_file = array();<\/p>\n

class MyDB
\n{
\n var $conn, $transaction, $result, $err_report, $query_count;<\/p>\n

function MyDB($db_setting, $transaction = false)
\n {
\n $this->err_report = false;
\n $this->transaction = $transaction;
\n $this->query_count = 0;
\n static $db_set_file = array();<\/p>\n

if(false === array_key_exists($db_setting, $db_set_file))
\n $db_set_file[$db_setting] = parse_ini_file($db_setting);
\n $myset = &$db_set_file[$db_setting];
\n $this->conn = mysql_connect($myset[‘ip’], $myset[‘user’], $myset[‘pass’]) or exit(‘mysql_connect error’);
\n mysql_select_db($myset[‘db’], $this->conn) or exit(‘mysql_select_db error’);
\n if($transaction) {
\n mysql_query(‘SET AUTOCOMMIT=0’, $this->conn) or exit(‘mysql_transaction_autocommit error’);
\n mysql_query(‘BEGIN’, $this->conn) or exit(‘mysql_transaction_begin error’);
\n register_shutdown_function(array(&$this, ‘close_error’));
\n }
\n return true;
\n }<\/p>\n

function close()
\n {
\n if($this->transaction)
\n mysql_query(‘COMMIT’, $this->conn) or exit(‘mysql_transaction_commit error’);
\n mysql_close($this->conn) or exit(‘mysql_close error’);
\n $this->conn = false;
\n return true;
\n }<\/p>\n

function close_error($message = ‘mysql_error exit’)
\n {
\n if($this->transaction)
\n mysql_query(‘ROLLBACK’, $this->conn) or exit(‘mysql_transaction_rollback error’);
\n mysql_close($this->conn) or exit(‘mysql_close_error error’);
\n exit($message);
\n return true;
\n }<\/p>\n

function query($query)
\n {
\n $this->query_count ++;
\n $this->result = mysql_query($query, $this->conn) or $this->close_error($this->err_report?’query < '.$query.' > error (count : ‘.$this->query_count.’ ) : ‘.mysql_error($this->conn):’query error (count : ‘.$this->query_count.’ )’);
\n return true;
\n }
\n}<\/p>\n

?> <\/p>\n

\n\uc0ac\uc6a9\ubc95<\/p>\n

\uc5f0\uacb0
\n$test = new MyDB(‘access_file.ini’);<\/p>\n

\ud2b8\ub79c\uc7ad\uc158\uc6a9 \uc5f0\uacb0
\n$test = new MyDB(‘access_file.ini’, true);<\/p>\n

\ucffc\ub9ac
\n$test->query(‘sql query’);<\/p>\n

\uc885\ub8cc (\ud2b8\ub79c\uc7ad\uc158\uc2dc \uc790\ub3d9 COMMIT)
\n$test->close();<\/p>\n

\ubc1b\uc544\uc628\uac12
\n$data = mysql_fetch_object($test->result);<\/p>\n

\uc624\ub958\ucd9c\ub825 \uc6d0\ud560\uc2dc
\n$test->err_report = true;
\n$test->query(‘error query’);<\/p>\n

\uc624\ub958\uc788\uc744\uc2dc\uc5d0 \uc885\ub8cc (\ud2b8\ub79c\uc7ad\uc158\uc2dc \uc790\ub3d9 ROLLBACK)
\n$test->close_error(‘error message’);<\/p>\n

exit() \ub9cc \ud574\ub3c4 \ubb34\uc870\uac74 ROLLBACK (\uc544\ub9c8 $test->close() \uc548\ud558\uace0 \uc885\ub8cc\ub418\ub3c4 ROLLBACK)<\/p>\n

mysql_insert_id \ub4f1\uc758 \ud568\uc218 \uc0ac\uc6a9\uc2dc\uc5d0 $test->conn \ub9c1\ud06c \uc0ac\uc6a9.
\n$idx = mysql_insert_id($test->conn);<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc0ac\uc6a9\ubc95 \uc5f0\uacb0 $test = new MyDB(‘access_file.ini’); \ud2b8\ub79c\uc7ad\uc158\uc6a9 \uc5f0\uacb0 $test = new MyDB(‘access_file.ini’, true); \ucffc\ub9ac $test->query(‘sql query’); \uc885\ub8cc (\ud2b8\ub79c\uc7ad\uc158\uc2dc \uc790\ub3d9 COMMIT) $test->close(); \ubc1b\uc544\uc628\uac12 $data = mysql_fetch_object($test->result); \uc624\ub958\ucd9c\ub825 \uc6d0\ud560\uc2dc $test->err_report = true; $test->query(‘error query’); \uc624\ub958\uc788\uc744\uc2dc\uc5d0 \uc885\ub8cc (\ud2b8\ub79c\uc7ad\uc158\uc2dc \uc790\ub3d9 ROLLBACK) $test->close_error(‘error message’); exit() \ub9cc \ud574\ub3c4 \ubb34\uc870\uac74 ROLLBACK (\uc544\ub9c8 $test->close() \uc548\ud558\uace0 \uc885\ub8cc\ub418\ub3c4 ROLLBACK) mysql_insert_id \ub4f1\uc758 \ud568\uc218 \uc0ac\uc6a9\uc2dc\uc5d0 $test->conn \ub9c1\ud06c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-1008","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1008"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1008\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}