savanihd / php-angularjs-crud-with-search-and-pagination Goto Github PK

<?php
	require '../db_config.php';
	$num_rec_per_page = 5;
	if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
	$start_from = ($page-1) * $num_rec_per_page;

	if (!empty($_GET["search"])){
		$sqlTotal = "SELECT * FROM sms_addrs 
			WHERE (adrs LIKE '%".$_GET["search"]."%')"; 
		$sql = "SELECT TOP($start_from)id,adrs FROM sms_addrs 
			WHERE (adrs LIKE '%".$_GET["search"]."%')"; 
	}else{
		$sqlTotal = "SELECT * FROM sms_addrs"; 
		$sql = "SELECT TOP($start_from)id,adrs FROM sms_addrs"; 
	}

	$result = $mysqli->query($sql);

	while($row = $result->fetch_assoc()){
	     $json[] = $row;
	}
	$data['data'] = $json;

	$result =  mysqli_query($mysqli,$sqlTotal);
	$data['total'] = mysqli_num_rows($result);
	
	echo json_encode($data);
	
?>