PHP常用代码整合.doc

?php $result=mysql_query(select * from userinfo limit $startCount,$perNumber);/根据前面的计算出开始的记录和记录数$i=$startCount;while ($row=mysql_fetch_array($result)echo $i.  echo username:.$rowusername.  echo password:.$rowpassword.;/显示数据库的内容$i+;if ($page != 1) /页数不等于1?首页a href=paging.php?page=上一页?php for ($i=1;$ia href=paging.php?page= ?php if ($pagea href=paging.php?page=下一页a href=paging.php?page=尾页分页函数?php function paging($perNumber,$table) $page=$_GETpage;/获得当前的页面值$count=mysql_query(select count(*) from $table);/获得记录总数$rs=mysql_fetch_array($count);$totalNumber=$rs0;$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)echo username:.$rowusername.  echo password:.$rowpassword.;/显示数据库的内容if ($page != 1) /页数不等于1?首页a href=page_test.php?page=上一页?php for ($i=1;$ia href=page_test.php?page= ?php if ($pagea href=page_test.php?page=下一页a href=paging.php?page=尾页增删改查函数?phpini_set(memory_limit, 256M);$dbhost = ;$dbuser = root;$dbpass = root;$dbname = one;/$link = mysql_connect(localhost,root,root) or die(not connected!);/mysql_select_db(one,$con);/连接,选择编码$link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname ); mysqli_query($link,set names utf8);/单表分页查询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 = $rs0;if ($num = 0 or $num = NULL) return 0;$last_page = ceil($num/$page_size);if (empty($page) $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();$rsamount = $num; $rspage = $page;$rspages = $last_page;$rsresult = $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 = mysqli_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;elsereturn $result;/单记录查询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)return false;else$exec = UPDATE . $tablename . SET . $up_date . WHERE . $condition;$result = mysqli_query($link, $exec);$num = mysqli_affected_rows ( $link );return $num;/插入数据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);$num = mysqli_affected_rows ( $link );return $num;/*执行sql语句*/function execSql( $sql )global $link;$result = mysqli_query($link,$sql);$num = mysqli_num_rows($result);if ( $num = 1 )return mysqli_fetch_array($result);elsereturn $result;?函数调用例子新闻管理新闻管理列表 添加新闻 编号 标题 发布人 管理 ?$result = selects(news, *, , );$i = 1;while( $row = mysqli_fetch_array( $result, MYSQL_ASSOC ) echo ; echo .$i.; echo . $rowtitle .; echo . $rowadd_user .; echo 删除 编辑; echo ; $i+;? 登出普通使用选择$n)$n=$rowid; $restwo = mysql_query(select * from notice where id=.$n); $rowtwo=mysql_fetch_array($restwo,MYSQL_ASSOC); echo    .$rowtwocomment.; echo$rowtwoupdatetime.; ?/添加功能 $title,content = $content,updatetime =$updatetime);$tablename = post;$num = inserts($tablename, $data);if( $num = 1 )echo alert(你的帖子已成功发表);echo window.location=log.html; ; elseecho alert(发帖失败);echo window.location=post.php; ; */$con = mysql_connect(localhost,root,root);$userinfo_id = $_SESSIONid;if (!$con)die(Could not connect: . mysql_error();mysql_select_db(one, $con);if ($_FILESfiletype = image/gif)| ($_FILESfiletype = image/jpeg)| ($_FILESfiletype = image/pjpeg)| ($_FILESfiletype = image/png)| ($_FILESfilesize 0)echo Return Code: . $_FILESfileerror . ;elseecho Upload: . $_FILESfilename . ;echo Type: . $_FILESfiletype . ;echo Size: . ($_FILESfilesize / 1024) . Kb;echo Temp file: . $_FILESfiletmp_name . ;if (file_exists(./image_post/ . $_FILESfilename)echo $_FILESfilename . already exists. ;else$imagename=date(Y-m-d H:i:s,time();move_uploaded_file($_FILESfiletmp_name, ./image_post/ .$_FILESfilename);echo Stored in: . ./image_post/ . $_FILESfilename;echo ; $imagename=$_FILESfilename;/*$file_name = explode(.,$imagename);/按照 . 号分离文件名。这样你可以重命名文件，避免重名。echo $file_name0.;echo $file_name1.;*/echo $imagename.;$updatetime = date(Y-m-d H:i:s,time();$sql=INSERT INTO post (title