במסgרות ה gh//شی הוא חיבור של הרב יהושע בועז שתוכנו מראי מקומות למקורותהתנדaghhhhו12ין יעל, המעציfghfghfע

ב הוא חיבור של הרב יהושע בועז שתוכנו מראי מקומות למקורותشسdggרות הל555ה התafhgfh במסgרות ה gh//شی הוא חיבור של הרב יהושע בועז שתוכנו מראי מקומות למקורותהתנדaghhhhו12ין יעל, המעציfghfghfע

<?php

include("conn.php");

class wine
{

function logo($conn,$table,$field)
	{
		$querylogo = "SELECT $field FROM `$table` WHERE status = 1 ORDER BY id DESC";
		if($sql_selectlogo = $conn->query($querylogo))
		{
			if($sql_selectlogo->num_rows>0)
			{
				$resultlogo = $sql_selectlogo->fetch_array(MYSQLI_ASSOC);
				return trim($resultlogo[$field]);
			}
		}
	}
		function getstatus($conn,$table)
	{
		$querystatus = "SELECT * FROM `$table` WHERE status = 1";
		if($sql_selectstatus = $conn->query($querystatus))
		{
		$num=$sql_selectstatus->num_rows;
		return $num;
		}
	}
		function getall($conn,$table)
	{
		$queryall = "SELECT * FROM `$table`";
		if($sql_selectall = $conn->query($queryall))
		{
		$numall=$sql_selectall->num_rows;
		return $numall;
		}
	}

function getstatus1($conn,$table)
	{
		$querystatus1 = "SELECT * FROM `$table` WHERE status = 0";
		if($sql_selectstatus1 = $conn->query($querystatus1))
		{
		$num1=$sql_selectstatus1->num_rows;
		return $num1;
		}
	}
	
	
	function getInfo($conn,$table,$field,$id)
	{
		$queryinfo = "SELECT $field FROM `$table` WHERE id = '".$id."'";
		if($sql_select = $conn->query($queryinfo))
		{
			if($sql_select->num_rows>0)
			{
				$resultinfo = $sql_select->fetch_array(MYSQLI_ASSOC);
				return trim($resultinfo[$field]);
			}
		}		
	}
	
	
		function getInfo2($conn,$table,$alias)
	{
	 	$queryinfo2 = "SELECT * FROM `$table` WHERE alias = '".$alias."'";
		if($sql_select2 = $conn->query($queryinfo2))
		{
			if($sql_select2->num_rows>0)
			{
				$resultinfo2 = $sql_select2->fetch_array(MYSQLI_ASSOC);
				return $resultinfo2;
			}
		}		
	}

function getdata($conn,$table,$field,$cond,$value)
	{
		$querydata = "SELECT $field FROM $table WHERE $cond = '".$value."' and status = '1'";
		if($sql_selectdata = $conn->query($querydata))
		{
			if($sql_selectdata->num_rows>0)
			{
				$resultdata = $sql_selectdata->fetch_array(MYSQLI_ASSOC);
				return trim($resultdata[$field]);
			}
		}
	}
	
	
	function getnewdata($conn,$table,$field,$cond,$value)
	{
		$query_data = "SELECT $field FROM $table WHERE $cond = '".$value."' ";
		if($sql_select_data = $conn->query($query_data))
		{
			if($sql_select_data->num_rows>0)
			{
				$result_data = $sql_select_data->fetch_array(MYSQLI_ASSOC);
				return trim($result_data[$field]);
			}
		}
	}
	
	function getallrecord($conn,$table)
	{
		$queryrecord = "SELECT * FROM `$table` WHERE status=1 ORDER BY id DESC";
		if($sql_selectrecord=$conn->query($queryrecord))
		{
			if($sql_selectrecord->num_rows>0)
			{
				$resultrecord=$sql_selectrecord->fetch_array(MYSQLI_ASSOC);
				return $resultrecord;
			}
		}
	}
	
	function getnumrows($conn,$table)
	{
		$querynumrows = "SELECT * FROM `$table` WHERE status=1";
		if($sql_selectnumrows = $conn->query($querynumrows))
		{
			$num = $sql_selectnumrows->num_rows;
			return $num;
		}
	}
	
	function getallrecords($conn,$table)
	{
		$queryrecords = "SELECT * FROM `$table` WHERE status=1 ORDER BY id DESC";
		if($sql_selectrecords=$conn->query($queryrecords))
		{
			return $sql_selectrecords;
		}
	}
	
	function getlimit($conn,$table,$limit)
	{
		$querylimit = "SELECT * FROM $table WHERE status=1 ORDER BY id DESC $limit";
		if($sql_selectlimit = $conn->query($querylimit))
		{
			return $sql_selectlimit;
		}
	}
	
	function getconlimit($conn,$table,$cond,$limit)
	{
		$queryconlimit = "SELECT * FROM $table WHERE $cond AND status=1 ORDER BY id DESC $limit";
		if($sql_selectconlimit = $conn->query($queryconlimit))
		{
			return $sql_selectconlimit;
		}
	}
	
	function getconrecords($conn,$table,$cond)
	{
		$queryconrecords = "SELECT * FROM $table WHERE $cond  ORDER BY id DESC";
		if($sql_selectconrecords=$conn->query($queryconrecords))
		{
			return $sql_selectconrecords;
		}
	}
	
	function getcolorrecords($conn,$table,$cond)
	{
		$querycolorrecords = "SELECT * FROM $table WHERE $cond GROUP BY id DESC";
		if($sql_selectcolorrecords=$conn->query($querycolorrecords))
		{
			return $sql_selectcolorrecords;
		}
	}
	
	function getconrecord($conn,$table,$cond)
	{
		$queryconrecord = "SELECT * FROM $table WHERE $cond AND status=1 ORDER BY id DESC";
		if($sql_selectconrecord=$conn->query($queryconrecord))
		{			
			if($sql_selectconrecord->num_rows>0)
			{
				$resultconrecord = $sql_selectconrecord->fetch_array(MYSQLI_ASSOC);
				return $resultconrecord;
			}
		}
	}
	
	function getconimage($conn,$table,$field,$cond)
	{
		$queryconrecord = "SELECT $field FROM $table WHERE $cond ORDER BY id DESC";
		if($sql_selectconrecord=$conn->query($queryconrecord))
		{			
			if($sql_selectconrecord->num_rows>0)
			{
				$resultconrecord = $sql_selectconrecord->fetch_array(MYSQLI_ASSOC);
				return trim($resultconrecord[$field]);
			}
		}
	}
	
	function gettotalitem($conn,$session_id)
	{
		$queryitem="SELECT * FROM cart WHERE session_id='$session_id' && status=1";
		if($sql_selectitem=$conn->query($queryitem))	
		{
			$num=$sql_selectitem->num_rows;
			return $num;
		}
	}
	
}

$newobject = new wine();

?>