PHP DataClass::getKidsList示例

// + STEP 2: get data				   +
// +-----------------------------------+


$uid=$_REQUEST['user_id'];

if(!($uid)){
	$success="0";
	$msg="Incomplete Parameters";
	$data=array();
}
else{

	$path=BASE_PATH."uploads/";
	
	$kid=DataClass::getKidsList($uid);
	
		foreach($kid as $row){
		
		$num.=$row.',';
		}
		
		$kid_ids=rtrim($num,',');

	$sql="SELECT kids_wishlist.kid_id,reward.id as reward_id,reward.category_id,reward.title,reward.description,reward.price,reward.status,category.name as category_name, category.filepath as category_image,
	(SELECT group_concat(concat('$path',rewardimages.image) SEPARATOR ',') 	FROM rewardimages WHERE rewardimages.reward_id=reward.id ORDER BY defaultImage DESC) as reward_image, 
	(SELECT group_concat(tags.name SEPARATOR ',') 	FROM tags WHERE tags.reward_id=reward.id) as tag_name FROM kids_wishlist join `reward` on reward.id=kids_wishlist.reward_id
	join category on category.id=reward.category_id where kid_id IN ($kid_ids)";
	
	$sth=$conn->prepare($sql);
	//$sth->bindValue('kid_id',$kid);