1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / andaman / application / models /
Filename : Blog_model.php
back
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Blog_model extends CI_Model
{

	public function save_blog($name,$meta_tag,$meta_title,$meta_description,$content,$source,$status)
	{

		$blog_data = array(
			'name' => $name,
			'content' => $content,
			'meta_tag' => $meta_tag,
			'meta_title' => $meta_title,
			'meta_description' => $meta_description,
			'image' => $source,
			'status' => $status
		);

		$this->db->insert('pa_blog', $blog_data);


	}
	
	public function get_list(){
		
		$query = $this->db->query("SELECT * FROM pa_blog WHERE status = 1 ORDER BY id DESC");
		return $query->result();
	}
	
	public function get_view_by_id($id)
	{
		$query = $this->db->query("SELECT * FROM pa_blog WHERE id = ? LIMIT 1", array($id));
		return $query->row();
	}
	
	public function get_boat_view($id){
		
		$query = $this->db->query("select * from pa_boat where id = '$id'");
		return $query->row();
	}
	
	public function edit_blog($id){
		
		$sql = "select * from pa_blog where id = '$id'";
		$result = $this->db->query($sql);
		return $result->row();
	}	
	
	public function edit_boat_charter($id){
		
		$sql = "select * from pa_boat where id = '$id'";
		$result = $this->db->query($sql);
		return $result->row();
	}
	
	public function update_blog($name, $meta_tag,$meta_title,$meta_description,$content, $source, $id) {
		
		if (!empty($source)) {
			$sql = "UPDATE pa_blog SET name = ?,meta_tag = ?,meta_title = ?,meta_description = ?, content = ?, image = ? WHERE id = ?";
			$result = $this->db->query($sql, array($name,$meta_tag,$meta_title,$meta_description, $content, $source, $id));
		} else {
			$sql = "UPDATE pa_blog SET name = ?,meta_tag = ?,meta_title = ?,meta_description = ?, content = ? WHERE id = ?";
			$result = $this->db->query($sql, array($name,$meta_tag,$meta_title,$meta_description, $content, $id));
		}
	
   }
   
    public function update_boat_charter($name,$content,$details,$source,$mrp,$price,$id) {
		
		if (!empty($source)) {
			$sql = "UPDATE pa_boat SET name = ?, details = ?, mrp = ?, price = ?, content = ? image = ? WHERE id = ?";
			$result = $this->db->query($sql, array($name, $details,$mrp, $price, $content, $source, $id));
		} else {
			$sql = "UPDATE pa_boat SET name = ?, details = ?, mrp = ?, price = ?, content = ? WHERE id = ?";
			$result = $this->db->query($sql, array($name, $details,$mrp, $price, $content, $id));
		}
	
   }
	
	public function delete_blog($id){
		
		$this->db->query("UPDATE  pa_blog SET status = 0 Where id='$id'");
	}
	
	public function save_boat_charter($name,$content,$details,$source,$mrp,$price,$status)
	{

		$boat_data = array(
			'name' => $name,
			'content' => $content,
			'details' => $details,
			'image' => $source,
			'mrp' => $mrp,
			'price' => $price,
			'status' => $status
		);

		$this->db->insert('pa_boat', $boat_data);


	}
	
	public function boat_charter_list(){
		
		$query = $this->db->query("SELECT * FROM pa_boat WHERE status = 1");
		return $query->result();
	}

	public function delete_boat_charter($id){
		
		$this->db->query("UPDATE  pa_boat SET status = 0 Where id='$id'");
	}
	
	
}