PHP数据库链接种

PHP数据库链接类

db.php

?

<?phpif (!isset ($_SESSION)) {session_start();}define('DB_HOST', '127.0.0.1');   //根据自己的情况填写define('DB_USER', 'root');define('DB_PASS', 'a123789');define('DB_NAME', 'db1');date_default_timezone_set('Asia/Shanghai');//获取一个数据库连接function getDBLink() {$link = mysql_connect(DB_HOST, DB_USER, DB_PASS);mysql_select_db(DB_NAME, $link);mysql_query("set names utf8");return $link;}?>

?

?

?

index.php

?

?

<?phpif($_SESSION['pass']=="ok")                 {require_once ('db.php');$link=getDBLink();$sql="select * from member";$result=mysql_query($sql);$total=mysql_num_rows($result);echo "<center>共有".$total."个会员</center><br>";$page=isset($_GET['page'])?intval($_GET['page']):1;  $info_num=3; $pagenum=ceil($total/$info_num); If($page>$pagenum || $page == 0){       Echo "Error : Can Not Found The page .";       Exit;}$offset=($page-1)*$info_num; $info=mysql_query("select * from member limit $offset,$info_num"); while($it=mysql_fetch_array($info)){       Echo "账号：  ".HTMLSpecialChars($it['member_account'])."<br>";   //防sql注入   Echo "姓名：  ".HTMLSpecialChars($it['member_name'])."<br>";   Echo "性别：  ".HTMLSpecialChars($it['sex'])."<br>";   Echo "学号：  ".HTMLSpecialChars($it['schoolnumber'])."<br>";   Echo "手机号码：".HTMLSpecialChars($it['phonenumber'])."<br>";   Echo "电子邮箱：".HTMLSpecialChars($it['email'])."<hr>";}  if( $page > 1 )    {    echo "<a href='member_index.php?page=".($page-1)."'>前一页</a>&nbsp";}else{   echo "前一页&nbsp&nbsp";}for($i=1;$i<=$pagenum;$i++){                                          //数字页面       $show=($i!=$page)?"<a href='member_index.php?page=".$i."'>".$i."</a>":"$i";       Echo $show." ";}if( $page<$pagenum)    {    echo "<a href='member_index.php?page=".($page+1)."'>后一页</a>";}else{echo "后一页";     }mysql_free_result($result);mysql_close();}?>