PNG  IHDR* pHYs+ IDATx]n#; cdLb Ǚ[at¤_:uP}>!Usă cag޿ ֵNu`ݼTâabO7uL&y^wFٝA"l[|ŲHLN밪4*sG3|Dv}?+y߉{OuOAt4Jj.u]Gz*҉sP'VQKbA1u\`& Af;HWj hsO;ogTu uj7S3/QzUr&wS`M$X_L7r2;aE+ώ%vikDA:dR+%KzƉo>eOth$z%: :{WwaQ:wz%4foɹE[9<]#ERINƻv溂E%P1i01 |Jvҗ&{b?9g=^wζXn/lK::90KwrюO\!ջ3uzuGv^;騢wq<Iatv09:tt~hEG`v;3@MNZD.1]L:{ծI3`L(÷ba")Y.iljCɄae#I"1 `3*Bdz>j<fU40⨬%O$3cGt]j%Fߠ_twJ;ABU8vP3uEԑwQ V:h%))LfraqX-ۿX]v-\9I gl8tzX ]ecm)-cgʒ#Uw=Wlێn(0hPP/ӨtQ“&J35 $=]r1{tLuǮ*i0_;NƝ8;-vݏr8+U-kruȕYr0RnC]*ެ(M:]gE;{]tg(#ZJ9y>utRDRMdr9㪩̞zֹb<ģ&wzJM"iI( .ꮅX)Qw:9,i좜\Ԛi7&N0:asϓc];=ΗOӣ APqz93 y $)A*kVHZwBƺnWNaby>XMN*45~ղM6Nvm;A=jֲ.~1}(9`KJ/V F9[=`~[;sRuk]rєT!)iQO)Y$V ی ۤmzWz5IM Zb )ˆC`6 rRa}qNmUfDsWuˤV{ Pݝ'=Kֳbg,UҘVz2ﴻnjNgBb{? ߮tcsͻQuxVCIY۠:(V뺕 ٥2;t`@Fo{Z9`;]wMzU~%UA蛚dI vGq\r82iu +St`cR.6U/M9IENDB` REDROOM
PHP 5.6.40
Preview: fetch_pagesarama.php Size: 6.06 KB
/home/ankaservis/servis.ankaservis.com/muhasebe/fetch_pagesarama.php

<meta charset="utf-8">
<?php
/* Title : Ajax Pagination with jQuery & PHP
Example URL : http://www.sanwebe.com/2013/03/ajax-pagination-with-jquery-php */

//continue only if $_POST is set and it is a Ajax request
if(isset($_POST) && isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'){
	
	include("config.inc.php");  //include config file
	//Get page number from Ajax POST
	if(isset($_POST["page"])){
		$page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); //filter number
		if(!is_numeric($page_number)){die('Invalid page number!');} //incase of invalid page number
	}else{
		$page_number = 1; //if there's no page number, set it to 1
	}
	
	//get total number of records from database for pagination
	$results = $mysqli_conn->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 '
	 <table id="id="exRowTable"" class="table table-striped table-bordered responsive">
                                <thead class="">
                                    <tr>
										
                                        <th>Ad Soyad</th>
										<th>Firma</th>
                                        <th>Telefon</th>
                                        <th>E-posta</th>
										  <th>Bakiye</th>
                                       
                                        
                                    </tr>
                                </thead>
                         
                                <tbody>
	
	';
	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 '
		<tr>
										<td style="max-width:50px"><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["ID"].' </a>	</td>
                                        <td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["Ad_Soyad"].' </a>	</td>
                                        <td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["firma"].'</a></td>
										<td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["Tel"].'</a></td>
                                        <td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["email"].'</a></td>
										<td>'.$toplayalim.'</td>
                                       
                                        
                                    </tr>
		
		';
		
	
	}  
	echo '
	</tbody>
                            </table>
	';
	
	
	echo '<div align="center">';
	/* 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 '</div>';
}
################ 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 .= '<ul class="pagination">';
        
        $right_links    = $current_page + 4; 
        $previous       = $current_page - 3; //previous link 
        $next           = $current_page + 1; //next link
        $first_link     = false; //boolean var to decide our first link
        
        if($current_page > 1){
			$previous_link = ($previous==0)?1:$previous;
            $pagination .= '<li class="first"><a href="#" data-page="1" title="ilk Sayfa">&laquo;</a></li>'; //first link
            $pagination .= '<li><a href="#" data-page="'.$previous_link.'" title="Geri">&lt;</a></li>'; //previous link
                for($i = ($current_page-2); $i < $current_page; $i++){ //Create left-hand side links
                    if($i > 0){
                        $pagination .= '<li ><a href="#" data-page="'.$i.'" title="Sayfa'.$i.'">'.$i.'</a></li>';
                    }
                }   
            $first_link = false; //set first link to false
        }
        
        if($first_link){ //if current active page is first link
            $pagination .= '<li class="active"><a>'.$current_page.'</a></li>';
        }elseif($current_page == $total_pages){ //if it's the last active link
            $pagination .= '<li class="last active"><a>'.$current_page.'</a></li>';
        }else{ //regular current link
            $pagination .= '<li class="active"><a>'.$current_page.'</a></li>';
        }
                
        for($i = $current_page+1; $i < $right_links ; $i++){ //create right-hand side links
            if($i<=$total_pages){
                $pagination .= '<li><a href="#" data-page="'.$i.'" title="Sayfa '.$i.'">'.$i.'</a></li>';
            }
        }
        if($current_page < $total_pages){ 
				$next_link = ($i > $total_pages)? $total_pages : $i;
                $pagination .= '<li><a href="#" data-page="'.$next_link.'" title="ileri">&gt;</a></li>'; //next link
                $pagination .= '<li class="last"><a href="#" data-page="'.$total_pages.'" title="Son Sayfa">&raquo;</a></li>'; //last link
        }
        
        $pagination .= '</ul>'; 
    }
    return $pagination; //return pagination links
}
?>

Directory Contents

Dirs: 23 × Files: 138

Name Size Perms Modified Actions
ajax DIR
- drwxr-xr-x 2025-11-13 03:55:32
Edit Download
barkod DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
blok DIR
- drwxr-xr-x 2025-11-13 17:05:02
Edit Download
config DIR
- drwxr-xr-x 2025-11-14 06:08:36
Edit Download
css DIR
- drwxr-xr-x 2025-11-13 09:56:00
Edit Download
db DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
docs DIR
- drwxr-xr-x 2025-11-14 08:05:06
Edit Download
Excel DIR
- drwxr-xr-x 2022-08-10 21:02:54
Edit Download
font DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
fonts DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
giris DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
holder.js DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
images DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
img DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
js DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
logs DIR
- drwxr-xr-x 2025-11-14 06:20:50
Edit Download
Pager DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
scopbin DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
sf DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
sistem DIR
- drwxr-xr-x 2025-11-14 03:27:46
Edit Download
Sorgula DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
- drwxr-xr-x 2025-11-14 06:31:08
Edit Download
yuklenen DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
1.50 KB lrw-r--r-- 2025-11-13 16:26:02
Edit Download
9.45 KB lrw-r--r-- 2025-11-13 12:19:02
Edit Download
3.41 KB lrw-r--r-- 2016-07-25 10:53:34
Edit Download
4.29 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
1.03 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
18.59 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
18.63 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
1.02 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
1.04 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
9.44 KB lrw-r--r-- 2025-11-13 12:19:02
Edit Download
17.47 KB lrw-r--r-- 2025-11-13 04:32:24
Edit Download
17.37 KB lrw-r--r-- 2025-08-30 03:25:02
Edit Download
6.53 KB lrw-r--r-- 2025-08-30 03:35:16
Edit Download
9.58 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
11.44 KB lrw-r--r-- 2025-11-13 07:58:26
Edit Download
88.86 KB lrw-r--r-- 2025-11-14 06:59:02
Edit Download
30.45 KB lrw-r--r-- 2025-11-14 06:59:02
Edit Download
539 B lrw-r--r-- 2025-11-14 06:08:44
Edit Download
4.85 KB lrw-r--r-- 2025-08-30 02:05:10
Edit Download
12.24 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
16.04 KB lrw-r--r-- 2025-08-30 03:21:46
Edit Download
3.66 KB lrw-r--r-- 2025-11-14 06:34:56
Edit Download
27.48 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
28.79 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
12.89 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
12.90 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
22.67 KB lrw-r--r-- 2025-11-13 14:41:24
Edit Download
23.73 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
22.58 KB lrw-r--r-- 2025-11-13 14:41:24
Edit Download
23.21 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
2.67 KB lrw-r--r-- 2025-11-16 13:10:55
Edit Download
22.77 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
5.08 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
6.06 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
4.96 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
6.02 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
3.52 KB lrw-r--r-- 2025-11-13 07:13:06
Edit Download
4.05 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
4.30 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
22.70 KB lrw-r--r-- 2025-11-14 05:39:58
Edit Download
25.04 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
1.02 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
12.08 KB lrw-r--r-- 2025-11-13 15:46:24
Edit Download
9.44 KB lrw-r--r-- 2025-11-13 12:19:02
Edit Download
16.80 KB lrw-r--r-- 2025-11-14 08:05:36
Edit Download
14.29 KB lrw-r--r-- 2025-11-14 08:05:30
Edit Download
2.79 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
2.88 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
35.92 KB lrw-r--r-- 2025-11-14 04:55:04
Edit Download
46.63 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
576 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
256 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
261.05 KB lrw-r--r-- 2016-07-25 10:53:52
Edit Download
422.49 KB lrw-r--r-- 2016-07-25 10:53:58
Edit Download
26.42 KB lrw-r--r-- 2016-07-25 10:53:54
Edit Download
8.21 KB lrw-r--r-- 2016-07-25 10:53:54
Edit Download
27.95 KB lrw-r--r-- 2016-07-25 10:53:56
Edit Download
27.06 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
7.09 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
28.29 KB lrw-r--r-- 2025-11-13 05:59:52
Edit Download
32.32 KB lrw-r--r-- 2025-11-13 13:57:56
Edit Download
31.08 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
466 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
15.21 KB lrw-r--r-- 2025-11-14 04:53:00
Edit Download
11.28 KB lrw-r--r-- 2025-11-13 06:16:28
Edit Download
6.78 KB lrw-r--r-- 2025-11-14 08:05:30
Edit Download
7.28 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
6.94 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
89.72 KB lrw-r--r-- 2025-11-14 06:46:04
Edit Download
23.22 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
17.24 KB lrw-r--r-- 2025-11-14 05:39:58
Edit Download
18.05 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
18.07 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
17.65 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
1.01 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
375 B lrw-r--r-- 2020-06-16 03:54:24
Edit Download
7.19 KB lrw-r--r-- 2025-11-14 05:26:10
Edit Download
19.50 KB lrw-r--r-- 2016-07-25 10:54:06
Edit Download
19.00 KB lrw-r--r-- 2016-07-25 10:54:06
Edit Download
55.54 KB lrw-r--r-- 2025-11-13 08:16:22
Edit Download
10.67 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
12.47 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
8.96 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
30.11 KB lrw-r--r-- 2025-11-14 07:21:30
Edit Download
17.58 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
34.28 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
17.23 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
39.90 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
33.82 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
11.28 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
18.78 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
8.43 KB lrw-r--r-- 2025-11-14 05:05:32
Edit Download
26.05 KB lrw-r--r-- 2025-11-13 14:24:40
Edit Download
26.07 KB lrw-r--r-- 2025-11-13 14:24:40
Edit Download
29.31 KB lrw-r--r-- 2025-11-13 14:08:28
Edit Download
29.63 KB lrw-r--r-- 2025-11-13 14:15:10
Edit Download
832 B lrw-r--r-- 2016-07-25 10:54:10
Edit Download
19.26 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
18.43 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
3.56 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
3.57 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
910 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
6.15 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
7.91 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
9.59 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
22.15 KB lrw-r--r-- 2025-11-14 05:39:58
Edit Download
14.32 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
12.47 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
8.26 KB lrw-r--r-- 2025-11-14 05:05:32
Edit Download
187.39 KB lrw-r--r-- 2016-07-25 10:54:16
Edit Download
20.10 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
23.85 KB lrw-r--r-- 2025-11-13 13:31:58
Edit Download
22.65 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
12.91 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
56.75 KB lrw-r--r-- 2025-11-13 05:05:10
Edit Download
28.72 KB lrw-r--r-- 2025-11-13 15:00:32
Edit Download
22.19 KB lrw-r--r-- 2025-11-13 14:52:04
Edit Download
21.66 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
21.39 KB lrw-r--r-- 2025-11-13 14:52:04
Edit Download
21.39 KB lrw-r--r-- 2025-11-13 14:41:24
Edit Download
21.09 KB lrw-r--r-- 2025-11-14 08:02:42
Edit Download
19.79 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
3.01 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
23.49 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
26.85 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
26.10 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
25.13 KB lrw-r--r-- 2025-11-13 14:52:04
Edit Download
26.53 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
24.88 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
19.79 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
31.08 KB lrw-r--r-- 2025-11-13 06:52:38
Edit Download
11.21 KB lrw-r--r-- 2025-11-13 06:19:58
Edit Download
242 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
11.29 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
17.99 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
16.99 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
6.41 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
1.77 KB lrw-r--r-- 2025-11-14 06:10:32
Edit Download

If ZipArchive is unavailable, a .tar will be created (no compression).
© 2026 REDROOM — Secure File Manager. All rights reserved. Built with ❤️ & Red Dark UI