query("SELECT COUNT(*) FROM musteriler where bayidurum='1' and ID!='6285'"); $get_total_rows = $results->fetch_row(); $total_pages = ceil($get_total_rows[0]/$item_per_page); $page_position = (($page_number-1) * $item_per_page); $results = $mysqli_conn->query("SELECT ID, Ad_Soyad, firma, Tel, email, bayidurum FROM musteriler where bayidurum='1' and ID!='6285' ORDER BY ID DESC LIMIT $page_position, $item_per_page"); 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 '

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

'; echo '

'; echo paginate_function($item_per_page, $page_number, $get_total_rows[0], $total_pages); echo '

'; } 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; } ?>