php常用代码.docVIP

1、连接MYSQL数据库代码 ?php $connec=mysql_connect(localhost,root,root)?or?die(不能连接数据库服务器：?.mysql_error());? mysql_select_db(liuyanben,$connec)?or?die?(不能选择数据库:?.mysql_error()); mysql_query(set?names?gbk); ? 2、读取数据库，并实现循环输出 ?php $sql=select?*?from?liuyan?order?by?ly_id?desc; $conn=mysql_query($sql,$connec); while($rs=mysql_fetch_array($conn)){?? ? table?width=476?border=1?cellspacing=0?cellpadding=0 ??tr ????td?width=135?height=30div?align=center留言主题/div/td ????td?width=204?height=30div?align=center留言时间/div/td ????td?width=129?height=30div?align=center留言人/div/td ??/tr ??tr?bgcolor=#CC9999 ????td?height=30?=?$rs[ly_title]? ??????div?align=center/div/td ????td?height=30?=?$rs[ly_time]? ??????div?align=center/div/td ????td?height=30?=?$rs[ly_author]? ??????div?align=center/div/td ??/tr ??tr ????td?height=30div?align=centera?href=huifu.php?id=?php?echo?$rs[ly_id]?回复留言/a/div/td ????td?height=30div?align=centera?href=viewhuifu.php?id=?php?echo?$rs[ly_id]?查看回复信息/a/div/td ????td?height=30div?align=center已有回复/div/td ??/tr /table ?php? ?} ??? 3、如何实现分页，包括两个函数，两个调用 1）两个函数 ? //分页函数 ?function?genpage($sql,$page_size=2) ?{ ??????global?$prepage,$nextpage,$pages,$sums;??//out?param ??????$page?=?$_GET[page]; ??????$eachpage?=?$page_size; ??????$pagesql?=?strstr($sql,?from?); ??????$pagesql?=?select?count(*)?as?ids?.$pagesql; ??????$conn?=?mysql_query($pagesql)?or?die(mysql_error()); ??????if($rs?=?mysql_fetch_array($conn))?$sums?=?$rs[0]; ??????$pages?=?ceil(($sums-0.5)/$eachpage)-1; ??????$pages?=?$pages=0?$pages:0; ??????$prepage?=?($page0)?$1:0; ??????$nextpage?=?($page$pages)?$page+1:$pages;?? ??????$startpos?=?$page*$eachpage; ????$sql?.=?limit?$startpos,$eachpage?; ?} ?//显示分页 function?showpage() { ????global?$page,$pages,$prepage,$nextpage,$queryString;?//param?from?genpage?function ????$shownum?=10/2; ????$startpage?=?($page=$shownum)?$$shownum:0; ????$endpage?=?($page+$shownum=$pages)?$page+$shownum:$pages; ??? ????ech