selectAll.php

<?php
include("PDOConnection.php");

	
	function selectAllUser($cnn)
{
	$query="SELECT * FROM user where id=1";
	$stmt=$cnn->prepare($query);
	$stmt->execute();
	
	$result = $stmt->fetch();	
	return $result;
}
	function selectAllProduct($cnn)
{
	$query="SELECT * FROM product";
	$stmt=$cnn->prepare($query);
	$stmt->execute();
	
	$result = $stmt->fetchall();	
	return $result;
}
	function selectVerifyOrder($cnn)
{
	$query="SELECT product.name AS productname, tblorder.verify, product.productcount, tblorder.orderid, tblorder.Suggest, user.name, user.lastname, user.email
			FROM tblorder, product, user
			WHERE product.id = tblorder.productid
			AND user.id = tblorder.userid
			AND tblorder.verify =0";
	$stmt=$cnn->prepare($query);
	$stmt->execute();
	
	$result = $stmt->fetchall();	
	return $result;
}
$info=array(
	'user'=>array(),
	'allProduct'=>array(array()),
	'AllOrder'=>array(array())
);
$result=selectAllUser($cnn);
$arr=array( 
	"id"=>$result['id'],
	"name"=>$result['name'],
	"lastname"=>$result['lastname'],
	"email"=>$result['email'],
	"password"=>$result['password'],
	"email"=>$result['email'],
	"image"=>$result['image'],
	"birthday"=>$result['birthday'],
	"gender"=>$result['gender'],
	"favFilm"=>$result['favFilm'],
	"favColor"=>$result['favColor'],
	"aboutme"=>$result['aboutme'],
);
$info['user']=$arr;

$result=selectAllProduct($cnn);
for($row=0;$row<count($result);$row++){
	$productlist[$row][]= array("id"=>$result[$row]["id"]
	, "name"=>$result[$row]["name"]
	, "productdesc"=>$result[$row]["productdesc"]
	, "image"=>$result[$row]["image"]
	, "productdate"=>$result[$row]["productdate"]
	, "productPrice"=>$result[$row]["productPrice"]
	, "productcount"=>$result[$row]["productcount"]);
	}
	$info['allProduct']=$productlist;
	
//-------------------------------------------
$result=selectVerifyOrder($cnn);
for($row=0;$row<count($result);$row++){
	$Orderlist[$row][]= array("productname"=>$result[$row]["productname"]
	, "verify"=>$result[$row]["verify"]
	, "productcount"=>$result[$row]["productcount"]
	, "orderid"=>$result[$row]["orderid"]
	, "Suggest"=>$result[$row]["Suggest"]
	, "name"=>$result[$row]["name"]
	, "lastname"=>$result[$row]["lastname"]
	, "email"=>$result[$row]["email"]
	
	
	);
	}
	
$info['AllOrder']=$Orderlist;
echo json_encode($info);


?>