Reply to thread

Message

<blockquote data-quote="Proximity" data-source="post: 358359" data-attributes="member: 43026">[code]&lt;?php&nbsp; &nbsp; namespace XFA;&nbsp; &nbsp; if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }&nbsp; &nbsp; class engine {&nbsp; &nbsp; &nbsp; &nbsp; private $initiated;&nbsp; &nbsp; &nbsp; &nbsp; private $connected;&nbsp; &nbsp; &nbsp; &nbsp; private $mysql;&nbsp; &nbsp; &nbsp; &nbsp; private $connection;&nbsp; &nbsp; &nbsp; &nbsp; final public function Initiate() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $_CONFIG;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$this-&gt;initiated) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('connect', mysql_connect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('pconnect', mysql_pconnect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMysql('select_db', mysql_select_db);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('query', mysql_query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('num_rows', mysql_num_rows);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('fetch_assoc', mysql_fetch_assoc);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('fetch_array',mysql_fetch_array);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('result', mysql_result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('free_result', mysql_free_result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('escape_string', mysql_real_escape_string);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;initiated = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connect($_CONFIG['mysql']['connection_type']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; final public function setMySQL($key, $value) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;mysql[$key] = $value;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /*-------------------------------Manage Connection-------------------------------------*/&nbsp; &nbsp; &nbsp; &nbsp; final public function connect($type) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $core, $_CONFIG;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$this-&gt;connected) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = $this-&gt;mysql[$type]($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;connection) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $mydatabase = $this-&gt;mysql['select_db']($_CONFIG['mysql']['database'], $this-&gt;connection);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($mydatabase)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = true;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL', 'Can not connect to Database');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL', 'Can not connect to Host');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; final public function disconnect() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $core;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;connected) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;mysql['close']) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL Engine', 'MySQL could not disconnect.');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /*-------------------------------Secure MySQL variables-------------------------------------*/&nbsp; &nbsp; &nbsp; &nbsp; final public function secure($var) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['escape_string'](stripslashes(htmlspecialchars($var)));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; final public function signature($var) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['escape_string']($var);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /*-------------------------------Manage MySQL queries-------------------------------------*/&nbsp; &nbsp; &nbsp; &nbsp; final public function query($sql) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['query']($sql, $this-&gt;connection) or die(mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; final public function num_rows($sql) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['num_rows']($this-&gt;mysql['query']($sql, $this-&gt;connection));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; final public function result($sql) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['result']($this-&gt;mysql['query']($sql, $this-&gt;connection), 0);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; final public function free_result($sql) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['free_result']($sql);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; final public function fetch_array($sql) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query = $this-&gt;mysql['query']($sql, $this-&gt;connection);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data = array();&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = $this-&gt;mysql['fetch_array']($query)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data[] = $row;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $data;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; final public function fetch_assoc($sql) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['fetch_assoc']($this-&gt;mysql['query']($sql, $this-&gt;connection));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }?&gt;[/code]</blockquote>

[QUOTE="Proximity, post: 358359, member: 43026"] [code] <?php namespace XFA; if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); } class engine { private $initiated; private $connected; private $mysql; private $connection; final public function Initiate() { global $_CONFIG; if(!$this->initiated) { $this->setMySQL('connect', mysql_connect); $this->setMySQL('pconnect', mysql_pconnect); $this->setMysql('select_db', mysql_select_db); $this->setMySQL('query', mysql_query); $this->setMySQL('num_rows', mysql_num_rows); $this->setMySQL('fetch_assoc', mysql_fetch_assoc); $this->setMySQL('fetch_array',mysql_fetch_array); $this->setMySQL('result', mysql_result); $this->setMySQL('free_result', mysql_free_result); $this->setMySQL('escape_string', mysql_real_escape_string); $this->initiated = true; $this->connect($_CONFIG['mysql']['connection_type']); } } final public function setMySQL($key, $value) { $this->mysql[$key] = $value; } /*-------------------------------Manage Connection-------------------------------------*/ final public function connect($type) { global $core, $_CONFIG; if(!$this->connected) { $this->connection = $this->mysql[$type]($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password']); if($this->connection) { $mydatabase = $this->mysql['select_db']($_CONFIG['mysql']['database'], $this->connection); if($mydatabase) { $this->connected = true; } else { $core->systemError('MySQL', 'Can not connect to Database'); } } else { $core->systemError('MySQL', 'Can not connect to Host'); } } } final public function disconnect() { global $core; if($this->connected) { if($this->mysql['close']) { $this->connected = false; } else { $core->systemError('MySQL Engine', 'MySQL could not disconnect.'); } } } /*-------------------------------Secure MySQL variables-------------------------------------*/ final public function secure($var) { return $this->mysql['escape_string'](stripslashes(htmlspecialchars($var))); } final public function signature($var) { return $this->mysql['escape_string']($var); } /*-------------------------------Manage MySQL queries-------------------------------------*/ final public function query($sql) { return $this->mysql['query']($sql, $this->connection) or die(mysql_error()); } final public function num_rows($sql) { return $this->mysql['num_rows']($this->mysql['query']($sql, $this->connection)); } final public function result($sql) { return $this->mysql['result']($this->mysql['query']($sql, $this->connection), 0); } final public function free_result($sql) { return $this->mysql['free_result']($sql); } final public function fetch_array($sql) { $query = $this->mysql['query']($sql, $this->connection); $data = array(); while($row = $this->mysql['fetch_array']($query)) { $data[] = $row; } return $data; } final public function fetch_assoc($sql) { return $this->mysql['fetch_assoc']($this->mysql['query']($sql, $this->connection)); } } ?> [/code] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members