$result=mysql_query("select * from userinfo limit $startCount,$perNumber");
//根据前面的计算出开始的记录和记录数
$i=$startCount;
while ($row=mysql_fetch_array($result))
{
echo $i."&;nbsp;&;nbsp;";
echo "username:".$row['username']."&;nbsp;&;nbsp;";
echo "password:".$row['password']."
";
//显示数据库的内容
$i++;
}if ($page != 1) {
//页数不等于1
?>
首页 上一页 1
//循环显示出页面?>
下一页 尾页
分页函数
$page=$_GET['page']; //获得当前的页面值 $count=mysql_query("select count(*) from $table"); //获得记录总数 $rs=mysql_fetch_array($count); $totalNumber=$rs[0]; $totalPage=ceil($totalNumber/$perNumber); //计算出总页数 if (!isset($page)) { $page=1; } //如果没有值,则赋值1 $startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的记录 $result=mysql_query("select * from $table limit $startCount,$perNumber"); //根据前面的计算出开始的记录和记录数 while ($row=mysql_fetch_array($result)) {
2
echo "username:".$row['username']."&;nbsp;&;nbsp;";
echo "pass
word:".$row['password']."
";
//显示数据库的内容
}if ($page != 1) {
//页数不等于1
?>
PHP?PAGE=1">首页
上一页 //循环显示出页面?>
下一页 尾页 } } ?>
增删改查函数
3
function select_page($tablename, $field, $condition, $taxis, $page, $page_size) { global $link; if (empty($field)) $field='*'; if (empty($condition)) { $exec = ' SELECT COUNT(*) FROM '. $tablename ; } else { $exec = ' SELECT COUNT(*) FROM '. $tablename .' WHERE '. $condition ; } $result = mysqli_query($link, $exec); $rs = @
mysqli_fetch_array($result); $num = $rs[0]; if ($num == 0 or $num == NULL) return 0; $last_page = ceil($num/$page_size);
if (empty($page)) $page = 1;
if ($page <= 0) $page = 1;
if ($page > $last_page) $page = $last_page;
if (empty($condition))
{
if($page_size > 1){
$exec = ' SELECT '. $field .' FROM '. $tablename .' ORDER
BY '. $taxis .' LIMIT '. $page_size*($page-1) .' , '. $page_size;
}else{
$exec = ' SELECT '. $field .' FROM '. $tablename .' ORDER
BY '. $taxis ;
}
} else {
if($page_size > 1){
$exec = ' SELECT ' . $field . ' FROM ' . $tablename . ' WHERE
' . $condition . ' ORDER BY ' . $taxis . ' LIMIT ' .
$page_size*($page-1) . ' , ' .$page_size;
}else{
$exec = ' SELECT ' . $field . ' FROM ' . $tablename . ' WHERE
' . $condition . ' ORDER BY ' . $taxis ;
}
}
$result = @mysqli_query($link, $exec);
$rs = array();
$rs['amount'] = $num;
$rs['page'] = $page;
4
$rs['pages'] = $last_page; $rs['result'] = $result; return $rs; }
//单/多表多记录
查询 function selects($tablename, $field, $condition, $taxis ) { global $link; if (empty($field)) $field='*'; if (empty($taxis)) { if($condition == '') { $exec = ' SELECT '. $field .' FROM '. $tablename; }else{ $exec = ' SELECT '. $field .' FROM '. $tablename .' WHERE '. $condition; } }else { if($condition == '') { $exec = ' SELECT '. $field .' FROM '. $tablename .' ORDER BY '.$taxis ; }else{ $exec = ' SELECT '. $field .' FROM '. $tablename .' WHERE '. $condition .' ORDER BY '.$taxis ; } } //echo $exec; $result = @my
sqli_query($link, $exec); echo $exec; $num = @mysqli_num_rows($result); //echo '
test sql:'.$exec; //echo '
test num:'.$num; if ($num == 0 or $num == NULL) { return 0; }else{ return $result; } }
5
//单记录查询
function select( $tablename, $field, $condition )
{
global $link;
if (empty($field)) $field='*';
if (empty($condition))
{
$exec = ' SELECT '. $field .' FROM '. $tablename;
}else
{
$exec = ' SELECT '. $field .' FROM '. $tablename .' WHERE '.
$condition;
}
$result = @mysqli_query( $link, $exec );
echo $exec.'
';
$num = @mysqli_num_rows( $result );
if ($num == 0 or $num == NULL)
{
return 0;
} else {
return $result;
}
}
//更新数据 function updates($tablename, $data, $condition) { global $link; $first = true; foreach ($data as $key => $value) { if ($first == true) { $up_date = $key . '=\'' . $value .'\''; $first = false; }else{ $up_date .= ' , '. $key . ' = \'' . $value .'\''; } }
if(empty($condition)){
6
return false;
}else{
$exec = ' UPDATE ' . $tablename . ' SET ' . $condition;
}
$result = @mysqli_query($link, $exec);
$num = mysqli_affected_rows ( $link );
return $num;
}
' . $up_date . ' WHERE
//插入数据 function inserts($tablename, $data) { global $link; $first = true; foreach ( $data as $key => $value ) { if ($first == true) { $filenames = $key; $values = '\'' . $value . '\''; $first = false; }else{ $filenames = $filenames . ', '. $key; $values .= ', \'' . $value . '\''; } }
$exec = ' INSERT INTO '. $tablename .' (' . $filenames . ') values
(' . $values . ')';
echo $exec;
$result = @mysqli_query($link, $exec);
$num = mysqli_affected_rows ( $link );
return $num;
}
//删除
function delete($tablename, $condition)
{
global $link;
$exec = ' DELETE FROM '. $tablename .' where '. $condition;
if(empty($condition)) return false;
$result = @mysqli_query($link, $exec);
7
$num = mysqli_affected_rows ( $link ); return $num; }
/****************************** @执行sql语句 *******************************/ function execSql( $sql ) { global $link; $result = @mysqli_query($link,$sql); $num = @mysqli_num_ro