Code: Select all
public function getEntry($uniqId,$pageNo){
$mysqli=kjrDB::dbStart();
$qry="SELECT entries.title,entries.body FROM entries JOIN details ON details.id=entries.id WHERE details.uniqID=? AND entries.page=?";
if($stmt=$mysqli->prepare($qry)){
$stmt->bind_param('si',$uniqId,$pageNo);
$stmt->execute();
$stmt->bind_result($title,$body);
$stmt->fetch();
$stmt->close();
return array('title'=>$title,'body'=>$body);
}else{
trigger_error('Could Not Prepare Query',E_USER_WARNING);
return false;
}
}