Guest User

Untitled

a guest
Mar 28th, 2015
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.03 KB | None | 0 0
  1. $db = new Database(new MySQLi('localhost', 'root', '', 'test'));
  2.  
  3.  
  4. $user = $db->query('SELECT * FROM users WHERE username = :username AND id = :id', [
  5.     'username' => 'Test',
  6.     'id' => 1
  7. ], function() use ($db) {
  8.     return $db->query('SELECT * FROM users WHERE username = :username', ['username' => 'Test'])->num_rows == 0;
  9. });
  10.  
  11. echo $multiQuery = $db->multiQuery([
  12.     [
  13.         'query' => 'SELECT * FROM users WHERE username = :username AND id = :id',
  14.         'params' => [
  15.             'username' => 'iExit',
  16.             'id' => 1
  17.         ]
  18.     ],
  19.     [
  20.         'query' => 'INSERT INTO users SET username = :username',
  21.         'params' => [
  22.             'username' => 'Test1231'
  23.         ],
  24.        
  25.         'callback' => function() use ($db) {
  26.         //callback :D
  27.             return $db->query('SELECT * FROM users WHERE username = :username', ['username' => 'Test1231'])->num_rows == 0;
  28.         }
  29.     ]
  30.    
  31. ])[0]->fetch_object()->username; // gibt "iExit" aus, war nur ein Test und ich würde sowas niemals nutzen.
Advertisement
Add Comment
Please, Sign In to add comment