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: pagini_model.php

<?php

class Pagini_Model extends MY_Model {
	
	public function get_pages_list(){

$sql = "SELECT * FROM pagini WHERE Deleted = 0";
		
		$query = $this->db->query($sql);
		return $query->result_array();
		
	}
	
	public function get_page($page_id){
		$sql = "SELECT * FROM pagini WHERE Deleted = 0 AND Id = ".$page_id;
		
		$query = $this->db->query($sql);
		return $query->row_array();
	}
	
	public function insert_page($title, $subtitle, $content, $url){
		$sql = "
			INSERT INTO pagini
				(Titlu, Subtitlu, Continut, Deleted, Url)
			VALUES
				('".$title."', '".$subtitle."', '".mysql_real_escape_string ($content)."', 0, '" . $url . "')
		";
		$query = $this->db->query($sql);
		return true;
	}
	
	public function update_page($page_id, $title, $subtitle, $content, $url){
		$sql = "UPDATE pagini
			SET Titlu = '" .$title."',
				Subtitlu = '".$subtitle."',
				Continut = '".mysql_real_escape_string ($content)."',
				Url = '". $url."'
			WHERE Id = ".$page_id."
		";
		
		$query = $this->db->query($sql);
		return true;
	}
	
	public function delete_page($page_id){
		$sql = "UPDATE pagini SET Deleted = 1 WHERE Id = ".$page_id;
		
		$query = $this->db->query($sql);
		return true;
	}
	
}

X7ROOT File Manager

Editing: pagini_model.php

Upload File

Create Folder