Reply to thread

Message

<blockquote data-quote="iExit" data-source="post: 332212" data-attributes="member: 33201">Hey.I created&nbsp; a Database System which should be very save.Code: [code]class Database {&nbsp;&nbsp; &nbsp; &nbsp; private $connection;&nbsp; &nbsp; private $executedQuerys = [];&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; public function __construct(\mysqli $connection) {&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = $connection;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function query($query, $params = [], $callback = null) {&nbsp; &nbsp; &nbsp; &nbsp; $query = $this-&gt;getConvertedQueryString($query, $params);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($callback == null || $callback() == true) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $return = $this-&gt;connection-&gt;query($query) or die($this-&gt;connection-&gt;error);&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return null;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;executedQuerys[] = [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'query' =&gt; $query, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'data' =&gt; $return&nbsp; &nbsp; &nbsp; &nbsp; ];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $return;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function multiQuery($querys = []) {&nbsp; &nbsp; &nbsp; &nbsp; $result = [];&nbsp; &nbsp; &nbsp; &nbsp; foreach($querys as $query) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $qry = $query['query'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $params = isset($query['params']) ? $query['params'] : [];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $callback = isset($query['callback']) ? $query['callback'] : null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result[] = $this-&gt;query($qry, $params, $callback);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $result;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; private function getConvertedQueryString($query, $params = []) {&nbsp; &nbsp; &nbsp; &nbsp; $toFind = [];&nbsp; &nbsp; &nbsp; &nbsp; $toReplace = [];&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach($params as $key =&gt; $value) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $toFind[] = ':'.$key;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $toReplace[] = &quot;'&quot;.$this-&gt;connection-&gt;real_escape_string($value).&quot;'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; $query = str_replace($toFind, $toReplace, $query);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $query;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; public function getExecutedQuerys() {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;executedQuerys;&nbsp; &nbsp; }}[/code]Example: [code]$db = new Database(new MySQLi('localhost', 'root', '', 'test'));$user = $db-&gt;query('SELECT * FROM users WHERE username = :username AND id = :id', [&nbsp; &nbsp; 'username' =&gt; 'Test',&nbsp; &nbsp; 'id' =&gt; 1], function() use ($db) {&nbsp; &nbsp; return $db-&gt;query('SELECT * FROM users WHERE username = :username', ['username' =&gt; 'Test'])-&gt;num_rows == 0;});echo $multiQuery = $db-&gt;multiQuery([&nbsp; &nbsp; [&nbsp; &nbsp; &nbsp; &nbsp; 'query' =&gt; 'SELECT * FROM users WHERE username = :username AND id = :id', &nbsp; &nbsp; &nbsp; &nbsp; 'params' =&gt; [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'username' =&gt; 'iExit',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'id' =&gt; 1&nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; ],&nbsp; &nbsp; [&nbsp; &nbsp; &nbsp; &nbsp; 'query' =&gt; 'INSERT INTO users SET username = :username',&nbsp; &nbsp; &nbsp; &nbsp; 'params' =&gt; [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'username' =&gt; 'Test1231'&nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'callback' =&gt; function() use ($db) {&nbsp; &nbsp; &nbsp;&nbsp; //callback :D &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $db-&gt;query('SELECT * FROM users WHERE username = :username', ['username' =&gt; 'Test1231'])-&gt;num_rows == 0; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; ]&nbsp;&nbsp; ])[0]-&gt;fetch_object()-&gt;username; // returns &quot;iExit&quot; :D[/code]Why should you use it?- save querys- multi-querys- callbacks (query execute when callback returns boolean &quot;true&quot;)If u got a question just ask.Cya</blockquote>

[QUOTE="iExit, post: 332212, member: 33201"] Hey. I created a Database System which should be very save. Code: [code] class Database { private $connection; private $executedQuerys = []; public function __construct(\mysqli $connection) { $this->connection = $connection; } public function query($query, $params = [], $callback = null) { $query = $this->getConvertedQueryString($query, $params); if($callback == null || $callback() == true) { $return = $this->connection->query($query) or die($this->connection->error); } else { return null; } $this->executedQuerys[] = [ 'query' => $query, 'data' => $return ]; return $return; } public function multiQuery($querys = []) { $result = []; foreach($querys as $query) { $qry = $query['query']; $params = isset($query['params']) ? $query['params'] : []; $callback = isset($query['callback']) ? $query['callback'] : null; $result[] = $this->query($qry, $params, $callback); } return $result; } private function getConvertedQueryString($query, $params = []) { $toFind = []; $toReplace = []; foreach($params as $key => $value) { $toFind[] = ':'.$key; $toReplace[] = "'".$this->connection->real_escape_string($value)."'"; } $query = str_replace($toFind, $toReplace, $query); return $query; } public function getExecutedQuerys() { return $this->executedQuerys; } } [/code] Example: [code] $db = new Database(new MySQLi('localhost', 'root', '', 'test')); $user = $db->query('SELECT * FROM users WHERE username = :username AND id = :id', [ 'username' => 'Test', 'id' => 1 ], function() use ($db) { return $db->query('SELECT * FROM users WHERE username = :username', ['username' => 'Test'])->num_rows == 0; }); echo $multiQuery = $db->multiQuery([ [ 'query' => 'SELECT * FROM users WHERE username = :username AND id = :id', 'params' => [ 'username' => 'iExit', 'id' => 1 ] ], [ 'query' => 'INSERT INTO users SET username = :username', 'params' => [ 'username' => 'Test1231' ], 'callback' => function() use ($db) { //callback :D return $db->query('SELECT * FROM users WHERE username = :username', ['username' => 'Test1231'])->num_rows == 0; } ] ])[0]->fetch_object()->username; // returns "iExit" :D [/code] Why should you use it? - save querys - multi-querys - callbacks (query execute when callback returns boolean "true") If u got a question just ask. Cya [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members