Reply to thread

Message

<blockquote data-quote="Reecers" data-source="post: 452581" data-attributes="member: 78364">I used this and got [ATTACH=full]9488[/ATTACH]Also following is the class.engine[CODE=php]&lt;?phpnamespace Revolution;if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }class engine{&nbsp; &nbsp; private $initiated;&nbsp; &nbsp; private $connected;&nbsp; &nbsp; &nbsp; &nbsp; private $connection;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; final public function Initiate()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $_CONFIG;&nbsp; &nbsp; &nbsp; &nbsp; if(!$this-&gt;initiated)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('connect', mysql_connect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('pconnect', mysql_pconnect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMysql('select_db', mysql_select_db);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('query', mysql_query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('num_rows', mysql_num_rows);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('fetch_assoc', mysql_fetch_assoc);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('fetch_array',mysql_fetch_array);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('result', mysql_result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('free_result', mysql_free_result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('escape_string', mysql_real_escape_string);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;initiated = true;&nbsp; &nbsp; &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; 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; if(!$this-&gt;connected)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = mysqli_connect($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['database']);&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; &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; if($mydatabase)&nbsp; &nbsp; &nbsp; &nbsp; &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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MariaDB Engine', mysql_error());&nbsp; &nbsp; &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; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MariaDB Engine', mysql_error());&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; if($this-&gt;connected)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;mysql['close'])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = false;&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; &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; /*-------------------------------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; /*-------------------------------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; 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; 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; 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; 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; $data = array();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = $this-&gt;mysql['fetch_array']($query))&nbsp; &nbsp; &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; 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; }}?&gt;[/CODE]</blockquote>

[QUOTE="Reecers, post: 452581, member: 78364"] I used this and got [ATTACH=full]9488[/ATTACH] Also following is the class.engine [CODE=php]<?php namespace Revolution; if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); } class engine { private $initiated; private $connected; 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 = mysqli_connect($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['database']); if($this->connection) { $mydatabase = $this->mysql['select_db']($_CONFIG['mysql']['database'], $this->connection); if($mydatabase) { $this->connected = true; } else { $core->systemError('MariaDB Engine', mysql_error()); } } else { $core->systemError('MariaDB Engine', mysql_error()); } } } 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))); } /*-------------------------------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