Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function addToWantlistFromCrate($data) {
- $query = "SELECT * FROM wantlist WHERE user_id = :user_id AND record_title = :record_title";
- $stmt = $this->Conn->prepare($query);
- $stmt->execute(array(
- 'user_id'=>$_SESSION['user_data']['user_id'],
- 'record_title'=>$data['title']
- ));
- $list_check = $stmt->fetch();
- if($list_check) {
- // record already added
- return true;
- }else{
- // needs to be added
- $query = "INSERT INTO wantlist
- (record_id, user_id, cover_image_url, record_title, record_year, record_genre, record_format, master_url,record_label,record_country)
- VALUES
- (:record_id, :user_id, :cover_image_url, :record_title, :record_year, :record_genre, :record_format, :master_url,:record_label,:record_country)";
- $stmt = $this->Conn->prepare($query);
- $record_id = $data['record-id'];
- $cover_image = $data['cover-image'];
- $title = $data['title'];
- $year = $data['year'];
- $genre = $data['genre'];
- $format = $data['format'];
- $master_url = $data['master-url'];
- $label = $data['label'];
- $country = $data['country'];
- return $stmt->execute(array(
- 'record_id'=>$record_id,
- 'user_id'=>$_SESSION['user_data']['user_id'],
- 'cover_image_url'=>$cover_image,
- 'record_title'=>$title,
- 'record_year'=>$year,
- 'record_genre'=>$genre,
- 'record_format'=>$format,
- 'master_url'=>$master_url,
- 'record_label'=>$label,
- 'record_country'=>$country
- ));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement