Advertisement
darryljf

record.class.php

May 1st, 2020
467
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.93 KB | None | 0 0
  1. <?php
  2.  
  3. class Record {
  4.  
  5.     protected $Conn;
  6.  
  7.     public function __construct($Conn) {
  8.         $this->Conn = $Conn;
  9.     }
  10.  
  11.     public function addToCrate($data){
  12.  
  13.         $query = "INSERT INTO records (
  14.            user_id, cover_image_url, record_title, record_year, record_genre, record_format, master_url)
  15.            VALUES
  16.            (:user_id,:cover_image_url, :record_title, :record_year, :record_genre, :record_format, :master_url)";
  17.  
  18.         $stmt = $this->Conn->prepare($query);
  19.        
  20.         $result = $stmt->execute(array(
  21.             'user_id'=>$_SESSION['user_data']['user_id'],
  22.             'cover_image_url'=>$data['cover_image'],
  23.             'record_title'=>$data['title'],
  24.             'record_year'=>$data['year'],
  25.             'record_genre'=>$data['genre'],
  26.             'record_format'=>$data['format'],
  27.             'master_url'=>$data['master_url']
  28.         ));
  29.  
  30.         return $result;
  31.     }
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement