File Manager

X7ROOT File Manager

Current Path: /home/jurarevi/beta.jurareview.ro/application/models

home / jurarevi / beta.jurareview.ro / application / models /

📁 ..
📄 announcements_model.php(1.01 KB)
📄 chapters_model.php(5.22 KB)
📄 headerfooter_model.php(1.05 KB)
📄 index.html(114 B)
📄 menu_model.php(2.28 KB)
📄 miscconfig_model.php(1.98 KB)
📄 pagini_model.php(1.22 KB)
📄 sidebars_model.php(873 B)
📄 volumes_model.php(3.9 KB)

Editing: announcements_model.php

<?php

class Announcements_Model extends MY_Model {
	
	public function insert($title, $body){
		$sql = "INSERT INTO Announcements (Title, Body) values ('".$title."', '".mysql_real_escape_string($body)."')";
		$query = $this->db->query($sql);
		return true;
	}
	
	public function update($id, $title, $body){
		$sql = "UPDATE Announcements SET Title = '".$title."', Body = '".mysql_real_escape_string($body)."' WHERE Id = ".$id;
		$query = $this->db->query($sql);
		return true;
	}
	
	public function get_announcements_list(){
		$sql = "SELECT * FROM Announcements WHERE Deleted = 0";
		$query = $this->db->query($sql);
		return $query->result_array();
	}
	
	public function get_announcement($id){
		$sql = "SELECT * FROM Announcements WHERE Deleted = 0 AND Id = ".$id;
		$query = $this->db->query($sql);
		return $query->row_array();
	}
	
	public function delete_announcement($id){
		$sql = "UPDATE Announcements SET Deleted = 1 WHERE Id = ".$id;
		
		$query = $this->db->query($sql);
		return true;
	}
}

X7ROOT File Manager

Editing: announcements_model.php

Upload File

Create Folder