CustomerRewardsRESTAPI/Model/ImageModel.php

<?php
require_once PD . "/Model/Database.php";
require_once PD . "/Model/ModelTraits.php";

/**
 * Description of ImageModel
 *
 * @author Mike Howard
 * 
 * Table: loyalty_value_blob
 * Columns:
 * loyalty_value_id bigint PK 
 * loyalty_member_id bigint 
 * loyalty_attribute_id bigint 
 * loyalty_value_mime_type varchar(255) 
 * loyalty_value_blob blob
 */

class ImageModel extends Database {
    use ModelTraits;
    
    public $memberId;
    public $imageBlob;
    
    public $uploadTo;
    public $allowFileType;
    public $fileName;
    public $tempPath;
    public $basename;
    public $originalPath;
    public $fileType;
    
    function __construct() {
        $this->uploadTo = PD . "\\public\\images\\";
        //$this->uploadTo = PD . '/public/images/'; 
        $this->allowFileType = array('jpg','png','jpeg','gif');
    }
    
    /* Process the uploaded image and store in database */
    public function insertImage()
    {
        //$sql = "INSERT INTO ImageStore(ImageId,Image) VALUES('$this->image_id','" . mysql_escape_string(file_get_contents($tmp_image)) . "')";

        //$fp=addslashes(file_get_contents($_FILES['image']['tmp_name'])); //will store the image to fp
        //$query = "CALL insert_loyalty_member_image_proc('{$fileName}','{$fp}');";
        
        $query .= "CALL insert_loyalty_member_image_proc (" . $this->memberId . ", " . $this->imageBlob . ")";

        //return var_dump($query);
        
        $rowCount = $this->processImage($query);
        return $rowCount;
    }
}