Advertisement
darryljf

wantlist class method addToWantlistFromCrate()

May 12th, 2020
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.81 KB | None | 0 0
  1. public function addToWantlistFromCrate($data) {
  2.         $query = "SELECT * FROM wantlist WHERE user_id = :user_id AND record_title = :record_title";
  3.         $stmt = $this->Conn->prepare($query);
  4.         $stmt->execute(array(
  5.             'user_id'=>$_SESSION['user_data']['user_id'],
  6.             'record_title'=>$data['title']
  7.         ));
  8.         $list_check = $stmt->fetch();
  9.  
  10.         if($list_check) {
  11.             // record already added
  12.             return true;
  13.         }else{
  14.             // needs to be added
  15.             $query = "INSERT INTO wantlist
  16.            (record_id, user_id, cover_image_url, record_title, record_year, record_genre, record_format, master_url,record_label,record_country)
  17.            VALUES
  18.            (:record_id, :user_id, :cover_image_url, :record_title, :record_year, :record_genre, :record_format, :master_url,:record_label,:record_country)";
  19.  
  20.             $stmt = $this->Conn->prepare($query);
  21.             $record_id = $data['record-id'];
  22.             $cover_image = $data['cover-image'];
  23.             $title = $data['title'];
  24.             $year = $data['year'];
  25.             $genre = $data['genre'];
  26.             $format = $data['format'];
  27.             $master_url = $data['master-url'];
  28.             $label = $data['label'];
  29.             $country = $data['country'];
  30.             return $stmt->execute(array(
  31.                 'record_id'=>$record_id,
  32.                 'user_id'=>$_SESSION['user_data']['user_id'],
  33.                 'cover_image_url'=>$cover_image,
  34.                 'record_title'=>$title,
  35.                 'record_year'=>$year,
  36.                 'record_genre'=>$genre,
  37.                 'record_format'=>$format,
  38.                 'master_url'=>$master_url,
  39.                 'record_label'=>$label,
  40.                 'record_country'=>$country
  41.             ));
  42.         }
  43.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement