易截截图软件、单文件、免安装、纯绿色、仅160KB

php学习笔记(13):PHP+MYSQL简单分页

conn.php
<?php
/*
 * Created on 2010-1-6
 * Author:CHAUVET
 * Function:连接字符串
 */
 $conn=@mysql_connect("localhost","root","")or die("连接数据库出错!");
 mysql_select_db("newdb",$conn);
 mysql_query("set names 'gb2312'");
 function ReplaceSomeWords($words){
  $words=str_replace("\n","<br/>",str_replace(" ","&nbsp;",$words));
  return $words;
 }
?>
list.php
<?php
/*
 * Created on 2010-1-7
 * Author: CHAUVET
 * Function:
 */
 include("conn.php");
 $pageSize=5;
 $url=$_SERVER["REQUEST_URI"];
 $url=parse_url($url);
 $url=$url[path];
$numq=mysql_query("select * from `splitpage`");
$num=mysql_num_rows($numq);
if($_GET[page]){
 $pageval=$_GET[page];
 $page=($pageval-1)*$pageSize;
 $page.=',';
}
if($num>$pagesize){
 if($pageval<=1){
  $pageval=1;
 }
 echo "共 $num 条 "."<a href=$url?page=".($pageval-1).
">上一页</a> <a href=$url?page=".($pageval+1).">下一页</a>";
}
$sql="select * from `splitpage` limit $page $pageSize";
$query=mysql_query($sql,$conn);
while($row=mysql_fetch_array($query)){
 echo("<hr/>".$row['id']." | ".$row["name"]." | ".$row[sex]);
}
?>


相关文档:

MySQL中各种字段的取值范围

TINYINT
-128 - 127
TINYINT UNSIGNED
0 - 255
SMALLINT
-32768 - 32767
SMALLINT UNSIGNED
0 - 65535
MEDIUMINT
-8388608 - 8388607
MEDIUMINT UNSIGNED
0 - 16777215
INT 或 INTEGER
-2147483648 - 2147483647
INT UNSIGNED 或 INTEGER UNSIGNED
0 - 4294967295
BIGINT
-9223372036854775808 - 92233720 ......

MySql操作要点整理

TINYINT 1 字节
SMALLINT 2 个字节
MEDIUMINT 3 个字节
INT 4 个字节
INTEGER 4 个字节
BIGINT 8 个字节
FLOAT(X) 4 如果 X < = 24 或 8 如果 25 < = X < = 53
FLOAT 4 个字节
DOUBLE 8 个字节
DOUBLE PRECISION 8 个字节
REAL 8 个字节
DECIMAL(M,D) M字节(D+2 , 如果M < D)
NUMERIC(M,D) M字节(D ......

MySQL安裝指南

要安裝 MySQL,可以在終端提示符后運行下列命令:
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// 安装php5-mysql 是将php和mysql连接起来
一旦安裝完成,MySQL 服務器應該自動啟動。您可以 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号