Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

PastzpModel.php

<?php

class PastzpModel {

private $db;
	private $table_name = "pastzp";

public function __construct(){
		$this->db = new Database;
	}

// Get All Pastzp
	public function readAll(){
		$this->db->query("SELECT Id, MemberId, Year, Rearks 
			FROM
			" . $this->table_name . " ");

$results = $this->db->resultset();

return $results;
	}

// read Pastzp with pagination
	public function ReadAllWithPaging($from_record_num, $records_per_page){

// select query
		$this->db->query("SELECT Id, MemberId, Year, Rearks 
			FROM
			" . $this->table_name . "  LIMIT :from_record_num, :records_per_page");

// bind variable values
		$this->db->bind("from_record_num", $from_record_num);
		$this->db->bind("records_per_page", $records_per_page);

// prepare query statement
		$results =$this->db->resultset();

return $results;
	}

// read Pastzp with pagination with search
	public function ReadAllWithPagingSearch($from_record_num, $records_per_page, $Searchtext){

$rcount = $this->count($Searchtext);

// select query
		$this->db->query("SELECT pastzp.Id, pastzp.MemberId, Member.Name, pastzp.Year, 
					LOMId,  lom.name AS 'LOM', TagName, Mobile, IsZT, isNT, isST, isPT, 
					isAT, Member.isActive, Rearks
					FROM
					 " . $this->table_name . " 
					Inner Join Member on " . $this->table_name . ".MemberId = member.Id
					 Inner Join LOM on Lom.id= LOMid
						WHERE Member.isdeleted=0   
						AND (Member.name like :searchText OR  'LOM' like :searchText 
							OR Member.mobile like :searchText OR TagName like :searchText
							OR pastzp.Year like :searchText )
					Order By pastzp.Year DESC
						LIMIT :from_record_num, :records_per_page");

// bind variable values
		$this->db->bind("from_record_num", $from_record_num);
		$this->db->bind("records_per_page", $records_per_page);
		$this->db->bind("searchText", '%' . $Searchtext . '%');

// prepare query statement
		$results =$this->db->resultset();

$data = [
			'Pastzp' => $results,
			'TotalPastzp' => $rcount
		];        
		return $data;
	}

// Get Pastzp By ID
	public function readById($id){
		$this->db->query("SELECT pastzp.Id, MemberId, Year, 
				Rearks, member.Name, member.TagName, member.Mobile, member.Mobile2, member.Email,
				member.LOMId, lom.Name as LomName, member.Address, member.Address2, member.City, member.State,
				member.isPT, member.isST, member.isNT, member.IsZT, member.isAT, 
				member.Photo AS MemberPhoto, Member.isActive
			FROM
			" . $this->table_name . " 
						INNER JOIN Member ON pastzp.MemberID = Member.Id 
						INNER JOIN Lom ON member.LomId = Lom.Id			
			WHERE
				pastzp.id = :id
			LIMIT
				0,1");

$this->db->bind(':id', $id);

$row = $this->db->single();

return $row;
	}

// Add Pastzp
	public function create($data){
		// Prepare Query
		$this->db->query("INSERT INTO " . $this->table_name . " SET 
			MemberId = :MemberId, Year = :Year, Rearks = :Rearks");

// Bind Values
		//$this->db->bind(':Id', $data['Id']);
		$this->db->bind(':MemberId', $data['MemberId']);
		$this->db->bind(':Year', $data['Year']);
		$this->db->bind(':Rearks', $data['Rearks']);

//Execute
		if($this->db->execute()){
			return true;
		} else {
			return false;
		}
	}

// Update Pastzp
	public function update($data){
		// Prepare Query
		$imgfields='';
		$this->db->query("UPDATE " . $this->table_name . " SET
			MemberId = :MemberId, Year = :Year, Rearks = :Rearks $imgfields 
			WHERE
			Id = :Id");

// Bind Values
		$this->db->bind(":Id", $data['Id']);
		$this->db->bind(":MemberId", $data['MemberId']);
		$this->db->bind(":Year", $data['Year']);
		$this->db->bind(":Rearks", $data['Rearks']);

//Execute
		if($this->db->execute()){
			return true;
		} else {
			return false;
		}
	}

// Delete Pastzp
	public function delete($Id){
		// Prepare Query
		$this->db->query("DELETE FROM " . $this->table_name . " WHERE Id = :Id");

// Bind Values
		$this->db->bind(':Id', $Id);

//Execute
		if($this->db->execute()){
			return true;
		} else {
			return false;
		}
	}

// used for paging Pastzp
	public function count($Searchtext){
		// select query
		$this->db->query("SELECT count(*) as Totals FROM " . $this->table_name . "  
		");

//AND (field1 like :searchText OR field2 like :searchText 
			//OR field3 like :searchText OR field4 like :searchText )

// bind variable values
		//$this->db->bind("searchText", '%' . $Searchtext . '%');

$row = $this->db->single();    
		$row =  $row->Totals;
		return $row; 
	}

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2025-02-19 01:20:06
..	dir	-	0/0	0777	2025-02-19 01:20:06
AccountModel.php	text/x-php	502 B	0/0	0666	2022-01-26 09:50:25
ContactusModel.php	text/x-php	4.23 KB	0/0	0666	2022-01-26 09:00:20
HundredpointsModel.php	text/x-php	6.55 KB	0/0	0666	2021-03-17 11:18:30
IdcoursesModel.php	text/x-php	6.25 KB	0/0	0666	2021-08-15 10:19:52
JceventsModel.php	text/x-php	7.61 KB	0/0	0666	2022-01-24 03:59:29
LomModel.php	text/x-php	13.14 KB	0/0	0666	2022-04-30 06:31:21
LombearersModel.php	text/x-php	7.68 KB	0/0	0666	2022-01-27 12:31:01
LomhundredpointsModel.php	text/x-php	15.22 KB	0/0	0666	2021-08-19 08:59:55
LomyearModel.php	text/x-php	7.87 KB	0/0	0666	2021-08-19 08:59:57
MemberModel.php	text/x-php	19.23 KB	0/0	0666	2022-05-02 12:18:40
Pagination.php	text/x-php	2.75 KB	0/0	0666	2021-07-06 08:46:50
PastnpModel.php	text/x-php	6.64 KB	0/0	0666	2021-08-15 10:58:18
PastzpModel.php	text/x-php	4.54 KB	0/0	0666	2022-01-23 10:49:50
Post.php	text/x-php	1.95 KB	0/0	0666	2020-08-24 12:25:36
WorkyearModel.php	text/x-php	5.56 KB	0/0	0666	2021-03-17 11:21:39
ZgbModel.php	text/x-php	9.43 KB	0/0	0666	2022-01-26 09:09:50

Team Anon Force

https://t.me/Professor6T9x