Guest User

Untitled

a guest
Sep 1st, 2018
483
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. <?php
  2.  
  3. require_once('_.php');
  4.  
  5. // count_chars() is a method of phunction_Unicode, so:
  6. $chars = ph()->Unicode->count_chars('Lorem impsum....');
  7.  
  8. ph()->Dump($chars); // or print_r($chars);
  9.  
  10. // MySQL:
  11.  
  12. ph()->DB('mysql://HOST/DATABASE_NAME/', 'USERNAME', 'PASSWORD');
  13.  
  14. // Example Query
  15. ph()->Dump(ph()->DB('SHOW TABLES;')); // returns array
  16.  
  17. // Insert User
  18. ph()->Dump(ph()->DB('INSERT INTO users (email, password) VALUES (?, ?);', 'user@email.com', 'secretPassword')); // returns LAST_INSERT_ID
  19.  
  20. // Search User
  21. ph()->Dump(ph()->DB('SELECT * FROM users WHERE email LIKE ?;', 'search@email.com')); // returns array
  22.  
  23. // Update Specific User
  24. ph()->Dump(ph()->DB('UPDATE users SET password = ? WHERE email LIKE ? LIMIT 1;', 'newPassword', 'search@email.com')); // returns number of changed rows
  25.  
  26. // Delete Specific User
  27. ph()->Dump(ph()->DB('DELETE FROM users WHERE email LIKE ? LIMIT 1;', 'search@email.com')); // returns number of affected rows
  28.  
  29. // Truncate Table
  30. ph()->Dump(ph()->DB('TRUNCATE TABLE users;')); // returns true or false
  31.  
  32. ?>
Add Comment
Please, Sign In to add comment