Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function createFolderDB(string $user, string $name = '') {
- $params = [
- 'id' => '',
- 'logins' => $user,
- 'folders' => $name == '' ? $this->hash() : $name,
- ];
- $res = $this->db->row('SELECT logins FROM add_tmp WHERE logins = :logins', $params);
- //var_dump($params);
- var_dump($res);
- exit;
- if(!$this->db->row('SELECT logins FROM add_tmp WHERE logins = :logins', $params)) {
- $this->db->query('INSERT INTO add_tmp VALUES (:id, :logins, :folders)', $params);
- } else
- $this->db->query('UPDATE add_tmp SET folders = :folders WHERE folders = :folders', $params);
- }
- public function row($sql, array $params = []) {
- $result = $this->query($sql, $params);
- return $result->fetchAll(PDO::FETCH_ASSOC);
- }
- public function query($sql, array $params = []) {
- $res = $this->db->prepare($sql);
- if(!empty($params)) {
- foreach ($params as $key => $val) {
- if($key == 'id') {
- $val = intval($val);
- }
- if($key === 'user_id') {
- $val = intval($val);
- }
- if(is_int($val)) {
- $type = PDO::PARAM_INT;
- } else {
- $type = PDO::PARAM_STR;
- }
- $res->bindValue(':'.$key, $val, $type);
- }
- }
- $res->execute();
- $arr = $res->errorInfo();
- if($arr[1] != null) { var_dump($arr); }
- return $res;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement