Not much to say, directly on the code
Copy Code code as follows:
Linked database ' query
mysql_connect (' localhost ', ' username ', ' userpwd ') or Die ("Database link Failed". mysql_error ());
mysql_select_db (' Library name ');
mysql_query (' Set names UTF8 ');
$sql 1= "SELECT * from user";
$query 1=mysql_query ($sql 1);
$count =array ();
while ($row =mysql_fetch_assoc ($query 1)) {
$count []= $row;
}
$totalnews =count ($count);
Judge Page
if ($_get[' page ']) {
$page =$_get[' page '];
}else{
$page = 1;
}
$start = ($page-1) * $NEWNUM;
$sql = "SELECT * from User limit $start, $newnum";
$query =mysql_query ($sql);
$ret =array ();
while ($row =mysql_fetch_assoc ($query)) {
$ret []= $row;
}
?>
Table Styles
<div id= "wrap" style= "width:100%;height:100%; ">
<table border= "1px"; Style= "BORDER-COLLAPSE:COLLAPSE; border:1px solid #000; width:100%;height:100% ">
<?php foreach ($ret as $key => $value) {?>
<tr>
<td><?php echo $value [' ID ']?></td>
<td><?php echo $value [' username ']?></td>
<td><?php echo $value [' pwd ']?></td>
<td> Delete | Modify </td>
</tr>
<?php}?>
<tr >
Page Jump
<TD colspan= "4" align= "center" ><a href= "upload.php?page=1" > Home </a> <a href= "upload.php?page= <?php echo $lastpage?> "> Prev </a> <?php echo $page;? >/<?php echo $pagenum;?> <a href=" Uploa d.php?page=<?php echo $nextpage?> "> Next </a> <a href=" upload.php?page=<?php echo $pagenum?> " > Last </a><input type= "text" name= "text"/><input type= "button" value= "Jump" onclick= "check (this)"/>
</td>
</tr>
</table>
</div>