Professor6T9 Web SheLL

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

File Name : productphoto.php

<?php

include_once '../../library/jwt/jsontokens.php';

class Productphoto{

// database connection and table name
	private $conn;
	private $table_name = "ph_productphoto";

// object properties
	public $ID;
	public $ProductId;
	public $Photo;

// constructor with $db as database connection
	public function __construct($db, $serverValue = null){
		$this->conn = $db;
		$jstoken = new JsonTokens;
		if(is_array($serverValue))
		{
			$jstoken->validateToken($serverValue);
		}
	}

// read productphoto 
	function read(){

// select all query
		$query = "SELECT ID, ProductId, null AS Photo FROM " . $this->table_name . "  ";

// prepare query statement
		$stmt = $this->conn->prepare($query);

// execute query
		$stmt->execute();

return $stmt;
	}

// read productphoto with Image 
	function readwithimage(){

// select all query
		$query = "SELECT ID, ProductId, Photo FROM " . $this->table_name . "  ";

// prepare query statement
		$stmt = $this->conn->prepare($query);

// execute query
		$stmt->execute();

return $stmt;
	}

function readOne(){

// query to read single record
		$query = "SELECT
					ID, ProductId, Photo
				FROM
					" . $this->table_name . " 
				WHERE
					ID = ?
				LIMIT
					0,1";

// prepare query statement
		$stmt = $this->conn->prepare( $query );

// bind id of members to be updated
		$stmt->bindParam(1, $this->ID);
		// execute query
		$stmt->execute();

// get retrieved row
		$row = $stmt->fetch(PDO::FETCH_ASSOC);

// set values to object properties
		$this->ProductId =  $row['ProductId'];
		$this->Photo =  $row['Photo'];
		return $stmt;
	}
	// create productphoto 
	function create(){

// query to insert record
		$query = "INSERT INTO  " . $this->table_name . " SET ProductId = :ProductId, Photo = :Photo";

// prepare query
		$stmt = $this->conn->prepare($query);

// sanitize
		$this->ProductId=htmlspecialchars(strip_tags($this->ProductId));
		$this->Photo=htmlspecialchars(strip_tags($this->Photo));
		// bind values
		$stmt->bindParam(":ProductId", $this->ProductId);
		$stmt->bindParam(":Photo", $this->Photo);
		if (!$stmt->execute()){
			return false;
		}
		$count=$stmt->rowCount();
		// execute the query
		if($count>0){
			return true;
		}

return false;

}

// update the productphoto
	function update(){

// update query
		$query = "UPDATE " . $this->table_name . " SET ID = :ID, ProductId = :ProductId, Photo = :Photo
				WHERE
				ID = :ID";

// prepare query statement
		$stmt = $this->conn->prepare($query);

// sanitize
		$this->ID=htmlspecialchars(strip_tags($this->ID));
		$this->ProductId=htmlspecialchars(strip_tags($this->ProductId));
		$this->Photo=htmlspecialchars(strip_tags($this->Photo));

// bind new values
		$stmt->bindParam(":ID", $this->ID);
		$stmt->bindParam(":ProductId", $this->ProductId);
		$stmt->bindParam(":Photo", $this->Photo);

if (!$stmt->execute()){
			return false;
		}
		$count=$stmt->rowCount();
		// execute the query
		if($count>=0){            
			return true;
		}

return false;
	}

// delete the productphoto
	function delete(){

// delete query
		$query = "DELETE FROM " . $this->table_name . " WHERE ID = ?";

// prepare query
		$stmt = $this->conn->prepare($query);

// sanitize
		$this->ID=htmlspecialchars(strip_tags($this->ID));

// bind id of record to delete
		$stmt->bindParam(1, $this->ID);

if (!$stmt->execute()){
			return false;
		}
		$count=$stmt->rowCount();
		// execute the query
		if($count>0){
			return true;
		}

return false;

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2025-02-19 01:13:44
..	dir	-	0/0	0777	2025-02-19 01:13:44
account.php	text/x-php	1.05 KB	0/0	0666	2021-05-05 11:18:13
brand.php	text/x-php	3 KB	0/0	0666	2021-02-25 01:22:28
category.php	text/x-php	3.02 KB	0/0	0666	2021-02-25 01:22:28
combooffer.php	text/x-php	6.39 KB	0/0	0666	2021-05-09 05:09:36
customer.php	text/x-php	9.94 KB	0/0	0666	2021-05-09 05:11:14
customeraddress.php	text/x-php	5.34 KB	0/0	0666	2021-02-25 01:22:28
grade.php	text/x-php	3 KB	0/0	0666	2021-02-25 01:22:28
orders.php	text/x-php	8.42 KB	0/0	0666	2021-05-09 04:02:49
packingtype.php	text/x-php	3.04 KB	0/0	0666	2021-02-25 01:22:28
product.php	text/x-php	11.68 KB	0/0	0666	2021-05-09 04:57:52
productphoto.php	text/x-php	3.62 KB	0/0	0666	2021-02-25 01:22:28
quantity.php	text/x-php	3.15 KB	0/0	0666	2021-02-25 01:14:34
supplier.php	text/x-php	4.4 KB	0/0	0666	2021-02-25 01:22:28

Team Anon Force

https://t.me/Professor6T9x