SCRIPT I RUN FROM LINK
 
<?php
require_once 'include/DB_Functions.php';
$db = new DB_Functions();
 
// Receiving The Post Params
$user_unique_id = $_POST['user_unique_id'];
$offset = $_POST['offset'];
 
$converted_offset = intval($offset);
//echo $user_unique_id . "<br />";
//echo $offset . "<br />";
//echo $converted_offset . "<br />";
// Getting Result Array
$resultArray = $db->getUserFavouriteRecipes($user_unique_id, $converted_offset);
echo json_encode($resultArray);
?>
 
FUNCTION IN CLASS DB_FUNCTIONS
	public function getUserFavouriteRecipes($user_unique_id, $offset) {
		//echo $user_unique_id . "<br />";
		//echo $offset;
		$stmt = $this->conn->prepare("SELECT recipe.`unique_id`, recipe.`title`, recipe.`img_tumbnail_link`, recipe.`add_date`, recipe.`kitchen_type`, recipe.`meal_type`, user.`name`, user.`surname`, 
		(SELECT count(*) from `like` WHERE recipe.`unique_id` = `like`.`recipe_unique_id_fk`) AS like_count 
		FROM `recipe` 
		JOIN `favourite` ON (recipe.`unique_id` = `favourite`.`recipe_unique_id_fk`) 
		JOIN `user` ON (recipe.`user_unique_id_fk` = user.`unique_id`) 
		WHERE favourite.`user_unique_id_fk` = ?
		ORDER BY recipe.`unique_id` DESC
		LIMIT ?, 10");					
 
		$stmt->bind_param("si", $user_unique_id, $converted_limit);	
		$result = $stmt->execute();
 
		$myArray = array();
 
		if($result) {
			$result_set = $stmt->get_result();
 
			while($row = $result_set->fetch_assoc()) {
				$myArray[] = $row;
			}
 
			return $myArray;
		} else {
			return NULL;
		}
	}

U0NSSVBUIEkgUlVOIEZST00gTElOSwoKPD9waHAKcmVxdWlyZV9vbmNlICdpbmNsdWRlL0RCX0Z1bmN0aW9ucy5waHAnOwokZGIgPSBuZXcgREJfRnVuY3Rpb25zKCk7CgovLyBSZWNlaXZpbmcgVGhlIFBvc3QgUGFyYW1zCiR1c2VyX3VuaXF1ZV9pZCA9ICRfUE9TVFsndXNlcl91bmlxdWVfaWQnXTsKJG9mZnNldCA9ICRfUE9TVFsnb2Zmc2V0J107CgokY29udmVydGVkX29mZnNldCA9IGludHZhbCgkb2Zmc2V0KTsKLy9lY2hvICR1c2VyX3VuaXF1ZV9pZCAuICI8YnIgLz4iOwovL2VjaG8gJG9mZnNldCAuICI8YnIgLz4iOwovL2VjaG8gJGNvbnZlcnRlZF9vZmZzZXQgLiAiPGJyIC8+IjsKLy8gR2V0dGluZyBSZXN1bHQgQXJyYXkKJHJlc3VsdEFycmF5ID0gJGRiLT5nZXRVc2VyRmF2b3VyaXRlUmVjaXBlcygkdXNlcl91bmlxdWVfaWQsICRjb252ZXJ0ZWRfb2Zmc2V0KTsKZWNobyBqc29uX2VuY29kZSgkcmVzdWx0QXJyYXkpOwo/PgoKRlVOQ1RJT04gSU4gQ0xBU1MgREJfRlVOQ1RJT05TCglwdWJsaWMgZnVuY3Rpb24gZ2V0VXNlckZhdm91cml0ZVJlY2lwZXMoJHVzZXJfdW5pcXVlX2lkLCAkb2Zmc2V0KSB7CgkJLy9lY2hvICR1c2VyX3VuaXF1ZV9pZCAuICI8YnIgLz4iOwoJCS8vZWNobyAkb2Zmc2V0OwoJCSRzdG10ID0gJHRoaXMtPmNvbm4tPnByZXBhcmUoIlNFTEVDVCByZWNpcGUuYHVuaXF1ZV9pZGAsIHJlY2lwZS5gdGl0bGVgLCByZWNpcGUuYGltZ190dW1ibmFpbF9saW5rYCwgcmVjaXBlLmBhZGRfZGF0ZWAsIHJlY2lwZS5ga2l0Y2hlbl90eXBlYCwgcmVjaXBlLmBtZWFsX3R5cGVgLCB1c2VyLmBuYW1lYCwgdXNlci5gc3VybmFtZWAsIAoJCShTRUxFQ1QgY291bnQoKikgZnJvbSBgbGlrZWAgV0hFUkUgcmVjaXBlLmB1bmlxdWVfaWRgID0gYGxpa2VgLmByZWNpcGVfdW5pcXVlX2lkX2ZrYCkgQVMgbGlrZV9jb3VudCAKCQlGUk9NIGByZWNpcGVgIAoJCUpPSU4gYGZhdm91cml0ZWAgT04gKHJlY2lwZS5gdW5pcXVlX2lkYCA9IGBmYXZvdXJpdGVgLmByZWNpcGVfdW5pcXVlX2lkX2ZrYCkgCgkJSk9JTiBgdXNlcmAgT04gKHJlY2lwZS5gdXNlcl91bmlxdWVfaWRfZmtgID0gdXNlci5gdW5pcXVlX2lkYCkgCgkJV0hFUkUgZmF2b3VyaXRlLmB1c2VyX3VuaXF1ZV9pZF9ma2AgPSA/CgkJT1JERVIgQlkgcmVjaXBlLmB1bmlxdWVfaWRgIERFU0MKCQlMSU1JVCA/LCAxMCIpOwkJCQkJCgkJCQkJCQkJCgkJJHN0bXQtPmJpbmRfcGFyYW0oInNpIiwgJHVzZXJfdW5pcXVlX2lkLCAkY29udmVydGVkX2xpbWl0KTsJCgkJJHJlc3VsdCA9ICRzdG10LT5leGVjdXRlKCk7CgkJCQkKCQkkbXlBcnJheSA9IGFycmF5KCk7CgkJCgkJaWYoJHJlc3VsdCkgewoJCQkkcmVzdWx0X3NldCA9ICRzdG10LT5nZXRfcmVzdWx0KCk7CgkJCQoJCQl3aGlsZSgkcm93ID0gJHJlc3VsdF9zZXQtPmZldGNoX2Fzc29jKCkpIHsKCQkJCSRteUFycmF5W10gPSAkcm93OwoJCQl9CgkJCQoJCQlyZXR1cm4gJG15QXJyYXk7CgkJfSBlbHNlIHsKCQkJcmV0dXJuIE5VTEw7CgkJfQoJfQ==