Salve,
ho lo script riportato qui sotto e mi succede che se lo inserisco in una pagina nuova.php funziona correttamente facendomi vedere 12 records per pagina, invece se lo inserisco all'interno della mia pagina php dove ci sono anche altri script, che però non dovrebbero influire perchè questo viene richiamato da un link e si trova all'interno di una if, mi fa vedere solo 2 records per pagina. La mia pagina apre una sessione, penso che questa essere la causa, perchè se copio lo script prima dell'apertura della sessione, funziona anche nella mia pagina php.
Qualcuno mi può aiutare a trovare la soluzione?
Grazie mille e scusate per la lunghezza.
Codice PHP:<?
// This two varibles are the heart of paging,
$record_limit = 12;
$pg_limit = 10;
// include db connection parameter file
include_once("pag/lib/dbconnection.php");
// This the class file that we use the manage db interaction
if (!class_exists(myclass)) {
include_once("pag/lib/myclass.php");
if (!isset($obj))
$obj = new myclass($d_base, $u_sername, $p_ass, $H_ost);
}
if (!isset($num_totrec)) {
$dbsql = "select count(*) as tot from anagrafica ";
$db_recs = $obj->select($dbsql);
// $num_totrec, total number of records, is standard variable that you must pass before calling paging file
$num_totrec = $db_recs[0]["tot"];
}
// This is how you can pass extra variables in paging link like i pass n and num_totrec in following code, both this variable will be pass in query string every time while navigate paging
$var_extra = $var_extra . "&num_totrec=" . $num_totrec;
$var_extra = $var_extra . "&n=" . $n;
// you did all now just include the paging file
// CODE FOR PAGING
if (!isset($num_totrec)) $num_totrec = $db_recs[0]["tot"];
// $num_totrec SHOULD BE PASSED
// $pg_limit = 10;//$obj->ADM_PAGELIMIT; //page limit
if (!isset($n) or $n == "") {
$rec_limit = $record_limit; //$obj->ADM_RECLIMIT; //record limit
} else {
$rec_limit = $n;
}
$var_self = $obj->HOST; //url
$num_tmp = 0;
$var_flg = "0";
$var_limit = "";
$num_limit = 0;
$var_filter = "";
$var_file_url = $PHP_SELF . "?";
if (isset($keyword)) $var_filter = "&keyword=" . rawurlencode($keyword) . "&option=$option";
// ENDS HERE
// SET Extra querystring variables to pass from here
// $var_extra can be attached with the links for this purpose
if (isset($start)) {
$num_limit = ($start-1) * $rec_limit;
$var_limit = " LIMIT $num_limit,$rec_limit";
} else
$var_limit = " LIMIT 0,$rec_limit";
if (!isset($nstart)) {
if ($num_totrec) { // if recs exists!!
if ($rec_limit > $num_totrec) {
$num_pgs = 1;
$var_flg = "2";
} else {
$num_loopctr = 0;
$num_loopctr = ceil($num_totrec / $rec_limit);
if ($pg_limit > $num_loopctr) {
$num_pgs = $num_loopctr;
$var_flg = "2";
} else {
$num_pgs = $pg_limit;
if ($num_totrec <= ($rec_limit * $pg_limit)) $var_flg = "2";
else $var_flg = "1";
}
}
$var_link = "";
$var_prevlink = "";
// if sorting is set
$var_sort_link = "";
if (isset($sorton)) $var_sort_link = "&sorton=$sorton";
// $var_prevlink ="<font face=verdana size=1 color=black>Prev <|";
$var_prevlink = "";
if (!isset($start)) {
$start = 1;
}
for($i = 1;$i <= $num_pgs;$i++) {
if ($start == $i) {
$var_link .= "$i";
} ELSE {
$var_link .= "<a style=\"font-size:11px\" href=\"$var_self$var_file_url&data=ana&nstart=1&start=$i$var_filter$var_sort_link$var_extra\">$i</a>";
}
}
if ($var_flag != "0" and $var_flg != "2") {
$var_link .= "><a style=\"font-size:11px\" href=\"$var_self$var_file_url&data=ana&nstart=2&start=$i$var_filter$var_filter$var_sort_link$var_extra\"> Avanti</a></font>";
} else {
$var_link .= "";
// $var_link .= "> Next</font>";
}
$page_link = "";
$page_link = "$var_prevlink $var_link";
} else {
$var_link = "";
}
} else { // if nstart is set
if ($num_totrec) { // if recs exists!!
$num_loopctr = 0;
$num_rem_rec = 0;
$num_rem_rec = ($num_totrec - (($nstart-1) * $rec_limit * $pg_limit));
$num_loopctr = ceil($num_rem_rec / $rec_limit);
$num_tmp = $rec_limit * $nstart * $pg_limit;
$last_start = 0;
$last_start = ceil($num_totrec / $rec_limit);
$last_nstart = 0;
$last_nstart = ceil($num_totrec / ($rec_limit * $pg_limit));
if ($num_tmp > $num_totrec) {
$num_pgs = $num_loopctr;
$var_flg = "2";
} else {
$num_pgs = $pg_limit;
if ($num_totrec == ($nstart * $rec_limit * $pg_limit)) $var_flg = "2";
else $var_flg = "1";
}
$var_link = "";
$var_prevlink = "";
// if sorting is set
$var_sort_link = "";
if (isset($sorton)) $var_sort_link = "&sorton=$sorton";
$num_prevnstart = 0;
$num_prevstart = 0;
$num_prevnstart = $nstart-1;
$num_prevstart = ($nstart * $pg_limit) - $pg_limit;
$num_tmp = ($num_totrec / $rec_limit);
if ($nstart <= 1) {
$var_prevlink = "";
// $var_prevlink ="<font face=verdana size=1 color=black>Precedente <|";
} else
$var_prevlink = "[<a style=\"font-size:11px\" href=\"$var_self$var_file_url&data=ana&nstart=1&start=1$var_filter$var_sort_link$var_extra\">Prima Pagina</a>]<a style=\"font-size:11px\" href=\"$var_self$var_file_url&nstart=$num_prevnstart&data=ana&start=$num_prevstart$var_filter$var_sort_link$var_extra\">Precedente</a><font face=verdana size=2 color=black><</font>";
for($i = 1;$i <= $num_pgs;$i++) {
$num_start = $num_prevstart + $i;
$num_nstart = $nstart + 1;
if ($num_start == $start) $var_link .= "$num_start";
ELSE $var_link .= "<a style=\"font-size:11px\" href=\"$var_self$var_file_url&data=ana&nstart=$nstart&start=$num_start$var_filter$var_sort_link$var_extra\">$num_start</a>";
}
$num_start++;
if ($var_flag != "0" and $var_flg != "2") {
$var_link .= "><a style=\"font-size:11px\" href=\"$var_self$var_file_url&data=ana&nstart=$num_nstart&start=$num_start$var_filter$var_sort_link$var_extra\"> Avanti</a></font>[<a style=\"font-size:10px\" href=\"$var_self$var_file_url&nstart=$last_nstart&data=ana&start=$last_start$var_filter$var_sort_link$var_extra\">Ultima Pagina </a>]";
} else {
$var_link .= "";
// $var_link .= "<font face=verdana size=1 color=black>> Avanti</font>";
}
$page_link = "";
$page_link = "$var_prevlink $var_link";
} else {
// IF NO RECORDS EXISTS!!
$var_link = "";
}
}
// if set the paging variables
if (isset($nstart)) $var_pgs = "&nstart=$nstart&start=$start"; //attach this with the sorting links
// CODE FOR PAGING ENDS OVER HERE
if (isset($sorton)) {
switch ($sorton) {
case "1": $sort = "denominazione_esercizio";
break;
case "2": $sort = "ragione_sociale";
break;
case "3": $sort = "tipo_prodotto";
break;
case "4": $sort = "citta";
break;
case "5": $sort = "provincia";
break;
case "6": $sort = "referente";
break;
case "7": $sort = "telefono_fisso";
break;
}
} else {
// no sort is given then this is a default sort
$sort = "ragione_sociale";
}
// this is how we can provide search option in the records, it is simple code, which finds whether $keyword which is search criteria is define or not if it is defined then it makes query accordingly
if (!isset($keyword))
$db_query = "select * from anagrafica where black = '' order by $sort $var_limit";
else
$db_query = "select * from anagrafica where black = '' order by $sort $var_limit";
$db_res = $obj->select($db_query);
?>
<!--
<h1>The Paging file Demo</h1>
-->
<link href="stili.css" rel="stylesheet" type="text/css">
<?php if (count($db_res)) {
echo "<table border=\"0\" width=\"600\" align=\"center\"><tr class=\"linea_menu_n\" ><td class=\"testo_menu\" align=\"center\" id=nove>Anagrafica</td></tr></table></div>";
?>
<table width="760" border="1" cellpadding="1" cellspacing="1" align="center">
<tr><td colspan="9" class="testo_form" align="right" id=otto>[url="javascript:Stampa3()"][img]img/b_print.png[/img]Stampa[/url]</td></tr>
<tr class="testo_menu2">
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" >[url="home.php?file_add=userlist&data=ana&sorton=1&n=<?=$n"]>Denominazione[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" class="mainheading">[url="home.php?file_add=userlist&data=ana&sorton=2&n=<?=$n"]>Ragione Sociale[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" class="mainheading">[url="home.php?file_add=userlist&data=ana&sorton=3&n=<?=$n"]>Tipo Prodotto[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" >[url="home.php?file_add=userlist&data=ana&sorton=4&n=<?=$n"]>Città[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" >[url="home.php?file_add=userlist&data=ana&sorton=5&n=<?=$n"]>Provincia[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" >[url="home.php?file_add=userlist&data=ana&sorton=6&n=<?=$n"]>Referente[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" >[url="home.php?file_add=userlist&data=ana&sorton=7&n=<?=$n"]>Telefono[/url]</td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" ></td>
<td align="center" style="border-bottom: 1 solid Gray;" style="border-bottom: 1 solid Gray;" ></td>
<?php
// here......simple loop to database records
for($i = 0;$i < count($db_res);$i++) {
?>
<tr class="lin" onmouseover="this.style.backgroundColor='#ccffff'" onmouseout="this.style.backgroundColor='#FFFFFF'">
<td class="lin" ><? $id_anagrafica = $db_res[$i]["id_anagrafica"];
$denominazione_eserciz = $db_res[$i]["denominazione_esercizio"];
echo "<a href=\"\" onclick=\"return apri_schede('$PHP_SELF?scheda=anagrafica&id_an=$id_anagrafica&den=$denominazione_eserciz')\"> "; ?> <?php echo $db_res[$i]["denominazione_esercizio"];
?></a></td>
<td class="lin" ><? $id_anagrafica = $db_res[$i]["id_anagrafica"];
$denominazione_eserciz = $db_res[$i]["denominazione_esercizio"];
echo "<a href=\"\" onclick=\"return apri_schede('$PHP_SELF?scheda=anagrafica&id_an=$id_anagrafica&den=$denominazione_eserciz')\"> "; ?> <?php echo $db_res[$i]["ragione_sociale"];
?></a></td>
<td class="lin" ><?php echo $db_res[$i]["tipo_prodotto"];
?></td>
<td class="lin" ><?php echo $db_res[$i]["citta"];
?></td>
<td class="lin" ><?php echo $db_res[$i]["provincia"];
?></td>
<td class="lin" ><?php echo $db_res[$i]["referente"];
?></td>
<td class="lin" ><?php echo $db_res[$i]["telefono_fisso"];
?></td>
<?
$id_anagrafica = $db_res[$i]["id_anagrafica"];
echo "<td class=\"lin\"><a href=\"$PHP_SELF?data=ana&data=inbl&idana=$id_anagrafica\"><img src=\"img/b_newtbl.png\" alt=\"Metti in Black List\" border=\"0\"></a></td><td><a href=\"$PHP_SELF?data=ana&data=elim&idana=$id_anagrafica\"><img src=\"img/b_drop.png\" border=\"0\" alt=\"Elimina completamente anagrafica\"></a></td>";?>
</tr>
<?php }
?>
<table align="center">
<tr>
<Td >
<?php
GO.......= $page_link
echo $page_link;
?>
</td>
</tr>
</table>
</table>
<?php
} else {
?>
<?php
}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
Rispondi quotando