Advertisement
coder-ex

Untitled

Jan 23rd, 2020
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. public function createFolderDB(string $user, string $name = '') {
  2. $params = [
  3. 'id' => '',
  4. 'logins' => $user,
  5. 'folders' => $name == '' ? $this->hash() : $name,
  6. ];
  7. $res = $this->db->row('SELECT logins FROM add_tmp WHERE logins = :logins', $params);
  8. //var_dump($params);
  9. var_dump($res);
  10. exit;
  11.  
  12. if(!$this->db->row('SELECT logins FROM add_tmp WHERE logins = :logins', $params)) {
  13. $this->db->query('INSERT INTO add_tmp VALUES (:id, :logins, :folders)', $params);
  14. } else
  15. $this->db->query('UPDATE add_tmp SET folders = :folders WHERE folders = :folders', $params);
  16. }
  17.  
  18. public function row($sql, array $params = []) {
  19. $result = $this->query($sql, $params);
  20. return $result->fetchAll(PDO::FETCH_ASSOC);
  21. }
  22.  
  23. public function query($sql, array $params = []) {
  24. $res = $this->db->prepare($sql);
  25. if(!empty($params)) {
  26. foreach ($params as $key => $val) {
  27. if($key == 'id') {
  28. $val = intval($val);
  29. }
  30. if($key === 'user_id') {
  31. $val = intval($val);
  32. }
  33.  
  34. if(is_int($val)) {
  35. $type = PDO::PARAM_INT;
  36. } else {
  37. $type = PDO::PARAM_STR;
  38. }
  39. $res->bindValue(':'.$key, $val, $type);
  40. }
  41. }
  42. $res->execute();
  43. $arr = $res->errorInfo();
  44. if($arr[1] != null) { var_dump($arr); }
  45. return $res;
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement