query("SELECT COUNT(*) FROM musteriler"); $get_total_rows = $results->fetch_row(); //hold total records in variable //break records into pages $total_pages = ceil($get_total_rows[0]/$item_per_page); //get starting position to fetch the records $page_position = (($page_number-1) * $item_per_page); //SQL query that will fetch group of records depending on starting position and item per page. See SQL LIMIT clause $results = $mysqli_conn->query("SELECT ID, Ad_Soyad, firma, Tel, email FROM musteriler Where Ad_Soyad LIKE '$adi' ORDER BY ID DESC LIMIT $page_position, $item_per_page"); //Display records fetched from database. echo ' '; while($row = $results->fetch_assoc()) { $carikim= $row["ID"]; $cariborc = mysql_query("SELECT SUM(borc) as borc FROM carihareket where cariid='$carikim' "); $row5 = mysql_fetch_array($cariborc); $borcu= $row5["borc"]; $carialacak = mysql_query("SELECT SUM(alacak) as alacak FROM carihareket where cariid='$carikim' "); $row2 = mysql_fetch_array($carialacak); $alacak= $row2["alacak"]; $toplayalim = number_format($borcu-$alacak,2, ',', '.'); echo ' '; } echo '

Ad Soyad	Firma	Telefon	E-posta	Bakiye
'.$row["ID"].'	'.$row["Ad_Soyad"].'	'.$row["firma"].'	'.$row["Tel"].'	'.$row["email"].'	'.$toplayalim.'

'; echo '

'; /* We call the pagination function here to generate Pagination link for us. As you can see I have passed several parameters to the function. */ echo paginate_function($item_per_page, $page_number, $get_total_rows[0], $total_pages); echo '

'; } ################ pagination function ######################################### function paginate_function($item_per_page, $current_page, $total_records, $total_pages) { $pagination = ''; if($total_pages > 0 && $total_pages != 1 && $current_page <= $total_pages){ //verify total pages and current page number $pagination .= '

«
<
'.$i.'
'.$current_page.'
'.$current_page.'
'.$current_page.'
'.$i.'
>
»

'; } return $pagination; //return pagination links } ?>