citywebshop_cms/application/models/admin_news_model.php

<?php

class admin_news_model extends Model {
    
    
    public function getImages() {
        $result = $this->query("select * from azonics_news where slide_status<>'0';");
        return $result;
    }
    
    
    public function loadImage() {
        $slide_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from azonics_news where slide_id='".$slide_id."';");
        return $row[0];
    }
    
    
    public function saveImage() {
        $data = $this->escapeArray($_REQUEST);
        
        if ($data['slide_id']!='') {
            $this->execute("update azonics_news set "
                    . "slide_title='".$data['slide_title']."', "
                    . "slide_content='".$data['slide_content']."', "
                    . "slide_subtitle='".$data['slide_subtitle']."', "
                    . "slide_buttontitle='".$data['slide_buttontitle']."', "
                    . "slide_buttonURL='".$data['slide_buttonURL']."' "
                    . "where slide_id='".$data['slide_id']."';");
            
            return true;
        }
        else {
            $this->execute("insert into azonics_news set "
                . "slide_title='".$data['slide_title']."', "
                . "slide_content='".$data['slide_content']."', "
                . "slide_subtitle='".$data['slide_subtitle']."', "
                . "slide_buttontitle='".$data['slide_buttontitle']."', "
                . "slide_buttonURL='".$data['slide_buttonURL']."', "
                . "slide_status='1', slide_banner='".$path.$fname."', "
                . "slide_user='".$_SESSION['admin_user']->admin_id."';");

            return true;
        }
    }
    
    
    public function deleteImage() {
        $slide_id = $this->escapeString($_REQUEST['id']);
        $this->execute("update azonics_news set slide_status='0' where slide_id='".$slide_id."';");
        return true;
    }
    
    
}