<?php
header('Content-Type: text/html;charset=gb2312');
require 'lib/PDOHelper.php';
$db = new PDOHelper (array (
'host' => '127.0.0.1',
'username' => 'root',
'password' => '1234',
'database' => 'buweb',
'charset' => 'gb2312',
'prefix' => '',
'persistent' => false,
'debug'=>true
));
$username='bbbb31';
$password='aaaaa41';
//单行插入并获取id
// $id = $db->Insert( 'manageadmin', array ('username' => $username,'password' => $password) )->LastId();
//$result = $db->Select( 'manageadmin' )->FetchAll();
$pagecount=10;//每页显示数目</p>
$result = $db->Select( 'manageadmin' )
->Order( 'id desc' )
->Limit( $pagecount,3 )
->FetchAll();
print_r($result);
foreach ($result as $row)
{
?>
<TABLE width='683' border='0' cellpadding='4' cellspacing='1' align=center class=tab2>
<tr height=20>
<TD width='132' align='center' ><?php echo $row['id'];?> </TD>
<TD width='132' align='center' ><?php echo $row['username'];?> </TD>
<TD width='132' align='center' ><?php echo $row['password'];?> </TD>
<TD width='80' align='center' ><a href=?action=edit&id=<?php echo $row['id'];?>>修改</a</TD>
<TD width='73' align='center' ><a href=?action=del&id=<?php echo $row['id'];?> onclick='javascript:if (confirm('确定删除吗？')) { return true;}else{return false;};'>删除</a></TD>
</TR>
</TD>
<?php
}
?>
