示例#1
0
$grownup=$_REQUEST['grownup']?$_REQUEST['grownup']:0;// return all grownups linked else all buddies

if(!($uid && $kid2 && $code)){
	$success="0";
	$msg="Incomplete Parameters";
	$data=array();
}
else{
	$sql="SELECT * from users where id=:id and is_deleted=0";
	$sth=$conn->prepare($sql);
	$sth->bindValue('id',$uid);
	try{$sth->execute();}
	catch(Exception $e){}
	$res=$sth->fetchAll(PDO::FETCH_ASSOC);
	if(count($res)){
	$kid1=DataClass::getkidId($code,$uid);

	if($kid1){
	
	$sql="SELECT * from friends where kid_id1 IN (:kid1,:kid2) and kid_id2 IN (:kid1,:kid2)";
	$sth=$conn->prepare($sql);
	$sth->bindValue("kid1",$kid1);
	$sth->bindValue("kid2",$kid2);
	try{$sth->execute();}
	catch(Exception $e){}
	$result=$sth->fetchAll();
	
	if(count($result)){
	$success='1';
	$msg="Already Connected";
	}