<?php
require_once("");
require_once("");
session_start();
//The paging code begins
$pagesize = 10;//Set the number of pieces displayed per page
$rs= mysql_query("select count(*) from lo");// Get the total number of records and calculate the total number of pages
$myrow = mysql_fetch_array($rs);
$numrows = $myrow[0];//Calculate total records
$pages = intval($numrows/$pagesize);
if($numrows%$pagesize)$pages++;//Set the number of pages
if(isset($_GET['page']))
{
$page = intval($_GET['page']);
}
else
{
$page= 1;//Set as first page
}
$offset = $pagesize*($page-1);//Calculate the record offset
//The end of the pagination code
$sql = "select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time, '%Y year %m month %d date %T') from lo order by id desc limit $offset,$pagesize";//DATE-FORMAT formatted date format is used
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if($num>0){
while($row = mysql_fetch_array($result))
{
//echo print_r($row);
if($row[2]=="Male")//This changes the gender to the name you want^_^
{
$sex= "Ship pot";
}
else
{
$sex= "Beauty";
}
?>
<div >
<p class="num">Leave a message [<?= $row[0] ?>]
<p class="unline">Message:<span class="blue"><?= $row[1]?></span> Gender:<?= $sex?> Message time:<?= $row[7] ?> <? if($row[3]) {?> <a href="/msgrd?V=1&Uin=<?= $row[3] ?>&Site=&Menu=yes"><img src="img/" alt="<?= $row[3]?>" //a><? } ?><? if($row[4 ]){ ?> <a href="mailto:<?= $row[4] ?>"><img src="img/" alt="<?= $row[4]?>" /</a> <? }?><? if($_SESSION["key"]==1){ ?> IP:<?= $row[6] ?> <a href="?wuleying&id=<?= $row[0]?>">Change</a> <a href="?wuleying&id=<?= $row[0]?>">Delete</a><?}?></a></p>
<p class="blue">Message content:</p>
<div ><?= nl2br(htmlspecialchars($row[5])) ?></div>
</div>
<?php
}
}
else
{
echo "<div id=\"show\">No data...</div>";
}
?>
<div >
<p>
<?php
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if($page==1&&$pages>1)
{
echo "Homepage | ";
echo "Previous page | ";
echo "<a href=\"?page=".$next."\">Next Page</a> | ";
echo "<a href=\"?page=".$last."\">Last Page</a> | ";
}
elseif($page>=1&&$page!=$pages&&$num>0)
{
echo "<a href=\"?page=".$first."\">Home</a> | ";
echo "<a href=\"?page=".$prev."\">Previous page</a> | ";
echo "<a href=\"?page=".$next."\">Next Page</a> | ";
echo "<a href=\"?page=".$last."\">Last Page</a> | ";
}
elseif($page==$pages&&$page!=1)
{
echo "<a href=\"?page=".$first."\">Home</a> | ";
echo "<a href=\"?page=".$prev."\">Previous page</a> | ";
echo “Next page | ”;
echo “Last page | ";
}
elseif($page==$pages)
{
echo "Homepage | ";
echo "Previous page | ";
echo “Next page | ”;
echo “Last page | ";
}
else
{
echo "Homepage | ";
echo "Previous page | ";
echo “Next page | ”;
echo “Last page | ";
}
?>
A total of <span><?= $pages ?></span> Pages | Currently <span><?= $page ?></span> | Total <span><?=$numrows ?></span>
</div>
<?php
mysql_close();
?>
<?php
require_once("");
?>