Help with the record, here isn't visibility!!!
| From: | Michele Salerno | Date: | Thu, 28 Feb 2002 19:52:32 +0000 |
| Subject: | Help with the record, here isn't visibility!!! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86648@lists.php.net to get a copy of this message | ||
The page is http://www.coopmediante.net/page/utenti/master.php
In the database i have 3 records. the page no print a video the records, because??
Help me...help me!!!!!
Tanks you very much!...is correct much?
Bey bey....
Michele
<?php
// Copyright (c) Interakt Online 2001
// http://www.interakt.ro/
require("./../../adodb/adodb.inc.php");
require("./../../Connections/coopmediante.php");
?><?php
$Recordset1=$coopmediante->Execute("SELECT * FROM utente, installatore WHERE
installatore.IDinstallatore = utente.IDinstallatore") or DIE($coopmediante->ErrorMsg());
$Recordset1_numRows=0;
$Recordset1__totalRows=$Recordset1->RecordCount();
?><?php
$Repeat1__numRows = 10;
$Repeat1__index= 0;
$Recordset1_numRows = $Recordset1_numRows + $Repeat1__numRows;
?><?php
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
// set the record count
$Recordset1_total = $Recordset1->RecordCount();
// set the number of rows displayed on this page
if ($Recordset1_numRows < 0) { // if repeat region set to all records
$Recordset1_numRows = $Recordset1_total;
} else if ($Recordset1_numRows == 0) { // if no repeat regions
$Recordset1_numRows = 1;
}
// set the first and last displayed record
$Recordset1_first = 1;
$Recordset1_last = $Recordset1_first + $Recordset1_numRows - 1;
// if we have the correct record count, check the other stats
if ($Recordset1_total != -1) {
$Recordset1_numRows = min($Recordset1_numRows, $Recordset1_total);
$Recordset1_first = min($Recordset1_first, $Recordset1_total);
$Recordset1_last = min($Recordset1_last, $Recordset1_total);
}
?><?php
// *** Recordset Stats: if we don't know the record count, manually count them
// set the number of rows displayed on this page
if ($Recordset1_numRows < 0 || $Recordset1_numRows > $Recordset1_total) {
$Recordset1_numRows = $Recordset1_total;
}
// set the first and last displayed record
$Recordset1_last = min($Recordset1_first + $Recordset1_numRows - 1, $Recordset1_total);
$Recordset1_first = min($Recordset1_first, $Recordset1_total);
?><?php $MM_paramName = ""; ?><?php
// *** Move To Record and Go To Record: declare variables
$MM_rs = &$Recordset1;
$MM_rsCount = $Recordset1_total;
$MM_size = $Recordset1_numRows;
$MM_uniqueCol = "";
$MM_paramName = "";
$MM_offset = 0;
$MM_atTotal = false;
$MM_paramIsDefined = ($MM_paramName != "" && isset($$MM_paramName));
?><?php
// *** Move To Record: handle 'index' or 'offset' parameter
if (!$MM_paramIsDefined && $MM_rsCount != 0) {
// use index parameter if defined, otherwise use offset parameter
if(isset($index)){
$r = $index;
} else {
if(isset($offset)) {
$r = $offset;
} else {
$r = 0;
}
}
$MM_offset = $r;
// if we have a record count, check if we are past the end of the recordset
if ($MM_rsCount != -1) {
if ($MM_offset >= $MM_rsCount || $MM_offset == -1) { // past end or move last
if (($MM_rsCount % $MM_size) != 0) { // last page not a full repeat region
$MM_offset = $MM_rsCount - ($MM_rsCount % $MM_size);
}
else {
$MM_offset = $MM_rsCount - $MM_size;
}
}
}
// move the cursor to the selected record
for ($i=0;!$MM_rs->EOF && ($i < $MM_offset || $MM_offset == -1); $i++) {
$MM_rs->MoveNext();
}
if ($MM_rs->EOF) $MM_offset = $i; // set MM_offset to the last possible record
}
?><?php
// *** Move To Record: if we dont know the record count, check the display range
if ($MM_rsCount == -1) {
// walk to the end of the display range for this page
for ($i=$MM_offset; !$MM_rs->EOF && ($MM_size < 0 || $i < $MM_offset + $MM_size);
$i++) {
$MM_rs->MoveNext();
}
// if we walked off the end of the recordset, set MM_rsCount and MM_size
if ($MM_rs->EOF) {
$MM_rsCount = $i;
if ($MM_size < 0 || $MM_size > $MM_rsCount) $MM_size = $MM_rsCount;
}
// if we walked off the end, set the offset based on page size
if ($MM_rs->EOF && !$MM_paramIsDefined) {
if (($MM_rsCount % $MM_size) != 0) { // last page not a full repeat region
$MM_offset = $MM_rsCount - ($MM_rsCount % $MM_size);
} else {
$MM_offset = $MM_rsCount - $MM_size;
}
}
// reset the cursor to the beginning
$MM_rs->MoveFirst();
// move the cursor to the selected record
for ($i=0; !$MM_rs->EOF && $i < $MM_offset; $i++) {
$MM_rs->MoveNext();
}
}
?><?php
// *** Move To Record: update recordset stats
// set the first and last displayed record
$Recordset1_first = $MM_offset + 1;
$Recordset1_last = $MM_offset + $MM_size;
if ($MM_rsCount != -1) {
$Recordset1_first = $Recordset1_first<$MM_rsCount?$Recordset1_first:$MM_rsCount;
$Recordset1_last = $Recordset1_last<$MM_rsCount?$Recordset1_last:$MM_rsCount;
}
// set the boolean used by hide region to check if we are on the last record
$MM_atTotal = ($MM_rsCount != -1 && $MM_offset + $MM_size >= $MM_rsCount);
?><?php
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
$MM_removeList = "&index=";
if ($MM_paramName != "") $MM_removeList .=
"&".strtolower($MM_paramName)."=";
$MM_keepURL="";
$MM_keepForm="";
$MM_keepBoth="";
$MM_keepNone="";
// add the URL parameters to the MM_keepURL string
reset ($HTTP_GET_VARS);
while (list ($key, $val) = each ($HTTP_GET_VARS)) {
$nextItem = "&".strtolower($key)."=";
if (!stristr($MM_removeList, $nextItem)) {
$MM_keepURL .= "&".$key."=".urlencode($val);
}
}
// add the URL parameters to the MM_keepURL string
if(isset($HTTP_POST_VARS)){
reset ($HTTP_POST_VARS);
while (list ($key, $val) = each ($HTTP_POST_VARS)) {
$nextItem = "&".strtolower($key)."=";
if (!stristr($MM_removeList, $nextItem)) {
$MM_keepForm .= "&".$key."=".urlencode($val);
}
}
}
// create the Form + URL string and remove the intial '&' from each of the strings
$MM_keepBoth = $MM_keepURL."&".$MM_keepForm;
if (strlen($MM_keepBoth) > 0) $MM_keepBoth = substr($MM_keepBoth, 1);
if (strlen($MM_keepURL) > 0) $MM_keepURL = substr($MM_keepURL, 1);
if (strlen($MM_keepForm) > 0) $MM_keepForm = substr($MM_keepForm, 1);
?><?php
// *** Move To Record: set the strings for the first, last, next, and previous links
$MM_moveFirst="";
$MM_moveLast="";
$MM_moveNext="";
$MM_movePrev="";
$MM_keepMove = $MM_keepBoth; // keep both Form and URL parameters for moves
$MM_moveParam = "index";
// if the page has a repeated region, remove 'offset' from the maintained parameters
if ($MM_size > 1) {
$MM_moveParam = "offset";
if (strlen($MM_keepMove)> 0) {
$params = explode("&", $MM_keepMove);
$MM_keepMove = "";
for ($i=0; $i < sizeof($params); $i++) {
list($nextItem) = explode("=", $params[$i]);
if (strtolower($nextItem) != $MM_moveParam) {
$MM_keepMove.="&".$params[$i];
}
}
if (strlen($MM_keepMove) > 0) $MM_keepMove = substr($MM_keepMove, 1);
}
}
// set the strings for the move to links
if (strlen($MM_keepMove) > 0) $MM_keepMove.="&";
$urlStr = $PHP_SELF."?".$MM_keepMove.$MM_moveParam."=";
$MM_moveFirst = $urlStr."0";
$MM_moveLast = $urlStr."-1";
$MM_moveNext = $urlStr.($MM_offset + $MM_size);
$MM_movePrev = $urlStr.(max($MM_offset - $MM_size,0));
?>
<html>
<head>
<title>IN-OFFICE: Utenti</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table align="center" border="1" bordercolor="#0099CC"
width="750">
<tr bgcolor="#0099CC">
<td align="default" width="14%"> Nome </td>
<td align="default" width="14%"> Cognome </td>
<td align="default" width="14%"> Località</td>
<td align="default" width="14%"> Provincia </td>
<td align="default" colspan="3"> Data ricezione e-mail</td>
</tr>
<?php while (($Repeat1__numRows-- != 0) && (!$Recordset1->EOF))
{
?>
<tr>
<td align="default" width="14%">
<?php echo $Recordset1->Fields("nome")?>
</td>
<td align="default" width="14%">
<?php echo $Recordset1->Fields("cognome")?>
</td>
<td align="default" width="14%">
<a href="detail.php?<?php echo
$MM_keepBoth.(($MM_keepBoth!="")?"&":"")."IDutente=".$Recordset1->Fields("IDutente")
?>">
<?php echo $Recordset1->Fields("paese_citta")?>
</a> </td>
<td align="default" width="14%">
<?php echo $Recordset1->Fields("provincia")?>
</td>
<td align="default" colspan="3">
<?php echo $Recordset1->Fields("giorno_ric")?>
-
<?php echo $Recordset1->Fields("mese_ric")?>
-
<?php echo $Recordset1->Fields("anno_ric")?>
</td>
</tr>
<?php
$Repeat1__index++;
$Recordset1->MoveNext();
}
?>
</table>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center">
<?php if ($MM_offset != 0) { ?>
<a href="<?php echo $MM_moveFirst?>">Primo</a>
<?php } // end $MM_offset != 0 ?>
</td>
<td width="31%" align="center">
<?php if ($MM_offset != 0) { ?>
<a href="<?php echo $MM_movePrev?>">Precedente</a>
<?php } // end $MM_offset != 0 ?>
</td>
<td width="23%" align="center">
<?php if (!$MM_atTotal) { ?>
<a href="<?php echo $MM_moveNext?>">Successivo</a>
<?php } // end !$MM_atTotal ?>
</td>
<td width="23%" align="center">
<?php if (!$MM_atTotal) { ?>
<a href="<?php echo $MM_moveLast?>">Ultimo</a>
<?php } // end !$MM_atTotal ?>
</td>
</tr>
</table>
<p> </p>
<p align="center">Record da
<?php echo $Recordset1_first?>
a
<?php echo $Recordset1_last?>
su
<?php echo $Recordset1_total?>
</p>
</body>
</html>
<?php
$Recordset1->Close();
?>