「経験して初めてその奥深さがわかります。」 このシステムを開発する目的は、主に学習し、システム開発プロセスを合理化し、さらに理論と実践を組み合わせることにあります。 phpを学ぶための高度な方法 重要なマイルストーン。
開発環境: Apache2.0+php5.4+mysql5.5
開発ツール: texteditor(dreamweaver/editplus)
1. バックステージメンバーシップ
2. 、権限の検証
3.オブジェクト、クラスのカプセル化
1.MySQLデータベース
には主に5つのデータテーブルがあります:完全なサイト構成テーブルp_config code>、バックエンドメンバーシップ テーブル <code>p_admin
、ニュース分類テーブル p_<a href="http://www.php.cn/wiki/165.html" target="_blank">新しい <code>p_config
、后台会员表p_admin
、新闻分类表p_<a href="http://www.php.cn/wiki/165.html" target="_blank">new</a>s<a href="http://www.php.cn/wiki/164.html" target="_blank">class</a>
、新闻标题表p_newsbase
、新闻内容表p_newscontent
,如下图所示:
2.程序文件
网站目录结构一览表,如图:
下面将按照一定流程分项讲解细节(css等文件不详细列出):
1.mysql数据库的创建
下面依次贴上各个表的配置图:
p_config表
p_admin表
p_newsclass表
p_newsbase表
p_newscontent表
详解:
p_newsclass,p_newsbase,p_newscontent
这三个表存在关联关系:p_newsbase|cid --> p_newsclass|id
p_newscontent|nid --> p_newsbase|id
p_newsclass
中f_id=0
时为顶级栏目,f_id=1
sクラス
p_newsbase
、ニュース コンテンツ テーブル p_newscontent
、以下に示すように: css およびその他のファイルは詳細にはリストされていません ):
1.mysqlデータベースの作成
次の手順 各テーブルの構成図を貼り付けます:
🎜🎜
🎜🎜
🎜🎜
p_newscontent テーブル🎜🎜詳細な説明: 🎜
p_newsclass、p_newsbase、p_newscontent
これら 3 つのテーブルは関連しています: 🎜 p_newsbase| cid --> p_newsclass|id
🎜p_newscontent|nid -->p_newsbase|id
🎜🎜p_newsclass
中f_id= 0
が最上位列の場合、f_id=1
は、そのカテゴリが ID 1 のカテゴリのサブカテゴリに属していることを意味します。 🎜🎜🎜🎜🎜2.smartyの設定🎜🎜次のステップ🎜インストール🎜設定:🎜(1).config.php🎜設定ファイル🎜、ソースコードを設定します。 🎜<?php> //数据库常用变量配置 $myhost ="localhost"; //主机名 $mydbuser ="root"; //数据库用户名 $mydbpw ="password"; //数据库密码 $mydbname ="news_system"; //数据库名称 $mydbcharset ="GBK"; //数据库编码 //smarty常用变量配置 $smarty_template_dir ='./templates/'; //模板路径变量 $smarty_compile_dir ='./templates_c/'; //编译目录模板变量 $smarty_config_dir ='./configs/'; //配置目录变量 $smarty_cache_dir ='./cache/'; //缓存目录变量 $smarty_caching ='false'; //缓存开关变量 $smarty_delimiter =explode("|","{|}"); //定界符变量,返回数组array([0]=>'{',[1]=>'}') ?>
<?php include_once('./configs/config.php'); //引入config.php include_once('./common/smarty/Smarty.class.php'); //引入smarty.class.php include_once('./common/mysql.class.php'); //引入mysql语句类文件 include_once('./common/action.class.php'); //引入动作执行类文件 include_once('./common/page.class.php'); //引入分页类文件 //实例化类,这里action已事先在继承了Mysql类 $db=new action($myhost,$mydbuser,$mydbpw,$mydbname,ALL_PS,$mydbcharset); //配置smarty $smarty = new smarty(); $smarty->template_dir = $smarty_template_dir; //模板目录 $smarty->compile_dir = $smarty_compile_dir; //编译目录 $smarty->config_dir = $smarty_config_dir; //配置目录 $smarty->cache_dir = $smarty_cache_dir; //缓存目录 $smarty->caching = $smarty_caching; //缓存开关 $smarty->left_delimiter = $smarty_delimiter[0]; //左定界符 $smarty->right_delimiter = $smarty_delimiter[1]; //右定界符 $smarty->assign("t_dir",$smarty_template_dir); //模板路径变量映射 ?>
<?php class mysql{ private $db_host; private $db_user; private $db_pwd; private $db_database; private $coding; private $conn; private $sql; private $row; private $result; private $bulletin=true; //是否开启错误记录 private $show_error=true; //测试阶段,显示所有错误,具有安全隐患,默认关闭 //构造函数,初始化赋值,实例化后可直接传参 public function construct($db_host,$db_user,$db_pwd,$db_database,$conn,$coding){ $this->db_host=$db_host; $this->db_user=$db_user; $this->db_pwd=$db_pwd; $this->db_database=$db_database; $this->conn=$conn; $this->coding=$coding; $this->connect(); } //连接数据库 public function connect(){ if ($this->conn == "pconn") { //永久链接 $this->conn = mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd); } else { //即时链接 $this->conn = mysql_connect($this->db_host, $this->db_user, $this->db_pwd); } if (!mysql_select_db($this->db_database, $this->conn)) { if ($this->show_error) { $this->show_error("数据库不可用:", $this->db_database); } } mysql_query("set names $this->coding"); } //数据库执行 public function query($sql){ if($sql=""){ $this->show_error("SQL语句错误:","SQL查询语句为空"); } $this->sql=$sql; $result=mysql_query($this->sql,$this->conn); if (!$result) { //调试中使用,sql语句出错时会自动打印出来 if ($this->show_error) { $this->show_error("错误SQL语句:", $this->sql); } } else { $this->result = $result; } } //取得记录值,获取数组-索引和关联 public function fetch_array(){ return mysql_fetch_array($this->result); } //简化查询 public function select($table,$columnName="*",$condition='',$debug=''){ $condition=$condition ? "where" . $condition : NULL; if($debug){ echo "select $columnName from $table $condition"; }else{ $this->query("select $columnName from $table $condition"); } } //简化查询select public function findall($table){ $this->query("select * from $table"); } //取得上一步 INSERT 操作产生的 public function insert_id() { return mysql_insert_id(); } //错误记录 public function show_error($message="",$sql=""){ if(!$sql){ echo "<font color='red'>" . $message . "</font>"; echo "<br />"; }else{ echo "<fieldset>"; echo "<legend>错误信息提示:</legend><br />"; echo "<p style='font-size:14px; clear:both; font-family:Verdana, Arial, Helvetica, sans-serif;'>"; echo "<p style='height:20px; background:#000000; border:1px #000000 solid'>"; echo "<font color='white'>错误号:12142</font>"; echo "</p><br />"; echo "错误原因:" . mysql_error() . "<br /><br />"; echo "<p style='height:20px; background:#FF0000; border:1px #FF0000 solid'>"; echo "<font color='white'>" . $message . "</font>"; echo "</p>"; echo "<font color='red'><pre class="brush:php;toolbar:false">" . $sql . ""; $ip=$this->getip(); if ($this->bulletin) { $time = date("Y-m-d H:i:s"); $message = $message . "\r\n$this->sql" . "\r\n客户IP:$ip" . "\r\n时间 :$time" . "\r\n\r\n"; $server_date = date("Y-m-d"); $filename = $server_date . ".txt"; $file_path = "error/" . $filename; $error_content = $message; //$error_content="错误的数据库,不可以链接"; $file = "error"; //设置文件保存目录 //建立文件夹 if (!file_exists($file)) { if (!mkdir($file, 0777)) { //默认的 mode 是 0777,意味着最大可能的访问权 die("upload files directory does not exist and creation failed"); } } //建立txt日期文件 if (!file_exists($file_path)) { //建立 “建立日期文件” fopen($file_path,"w+"); //首先要确定文件存在并且可写 if (is_writable($file_path)) { //使用添加模式打开$filename,文件指针将会在文件的开头 if(!$handle=fopen($file_path,'a')){ echo "不能打开文件 $filename"; exit; } //将$somecontent写入到我们打开的文件中。 if(!fwrite($handle,$error_content)){ echo "不能写入到文件 $filename"; exit; } echo "——错误记录被保存!"; //关闭文件 fclose($handle); }else{ echo "文件 $filename 不可写"; } }else{ //首先要确定文件存在并且可写 if (is_writable($file_path)) { //使用添加模式打开$filename,文件指针将会在文件的开头 if (!$handle = fopen($file_path, 'a')) { echo "不能打开文件 $filename"; exit; } //将$somecontent写入到我们打开的文件中。 if (!fwrite($handle, $error_content)) { echo "不能写入到文件 $filename"; exit; } //echo "文件 $filename 写入成功"; echo "——错误记录被保存!"; //关闭文件 fclose($handle); }else{ echo "文件 $filename 不可写"; } } } echo "
<?php session_start(); include_once ("../common/mysql.class.php"); //mysql类 include_once ("../configs/config.php"); //配置参数 include_once ("common/action.class.php"); //数据库操作类 include_once ("common/page.class.php"); //数据库操作 $db = new action($mydbhost, $mydbuser, $mydbpw, $mydbname, ALL_PS, $mydbcharset); //数据库操作类 //将存在的session[uid]和session[shell]赋值,便于后续的调用判断 $uid = $_SESSION[uid]; $shell = $_SESSION[shell]; ?>
<?php include_once('admin_global.php'); if(!empty($_POST[username]) && !empty($_POST[password])){ $db->Get_user_login($_POST[username],$_POST[password]); } ?> <html> <head> <meta http-equiv='Content-Type' content='text/html; charset=gb2312'> <meta name='Author' content='Alan'> <link rev=MADE href='mailto:haowubai@hotmail.com'><title>后台管理</title> <link rel='stylesheet' type='text/css' href='images/private.css'> <script> if(self!=top){ window.open(self.location,'_top'); } </script> </head> <body> <br><br><br> <form action="" method="post"> <table border=0 cellspacing=1 align=center class=form> <tr> <th colspan="2">用户登录</th> </tr> <tr> <td align="right">登录用户:</td> <td><input type="text" name="username" value="" size="20" maxlength="40"/> </td> </tr> <tr> <td align="right">登录密码:</td> <td><input type="password" name="password" value="" size="20" maxlength="40"/> </td> </tr> <tr> <td colspan="2" align="center" height='30'> <input type="submit" name="update" value=" 登录 "/> </td> </tr> </table> </form> </body> </html>
到此已实现用户的后台登录验证,用户权限的判断只需将以下代码粘贴到每个后台页面即可:
include_once('admin_global.php'); $r=$db->Get_user_shell_check($uid,$shell);
(4).后台管理页面:
后台全局调用页面admin_global.php
后台首页main.php
左侧导航页面admin_left.php
网站参数配置页面admin_main.php
新闻栏目分类管理页面admin_news_class.php
新闻列表页面admin_news_list.php
新闻编辑添加页面admin_news_add.php
各个页面源码如下:
admin_global.php:引入各类文件
<?php session_start(); include_once ("../common/mysql.class.php"); //mysql类 include_once ("../configs/config.php"); //配置参数 include_once ("common/action.class.php"); //数据库操作类 include_once ("common/page.class.php"); //数据库操作 $db = new action($mydbhost, $mydbuser, $mydbpw, $mydbname, ALL_PS, $mydbcharset); //数据库操作类. $uid = $_SESSION[uid]; $shell = $_SESSION[shell]; ?>
main.php:利用frame标签引入各个功能页面
<!DOCTYPE html> <html> <head><title>网站后台控制面板</title> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <script language=JavaScript> window.self.focus(); </script> </head> <frameset border=0 frameSpacing=0 frameBorder=0 cols=150,*> <frame name=menu src="admin_left.php" scrolling=yes> <frame name=main src="admin_main.php" scrolling=yes> <noframes> </noframes> </frameset> </html>
admin_left.php:后台左侧导航
<?php include_once('admin_global.php'); $r=$db->Get_user_shell_check($uid,$shell); ?> <!DOCTYPE HTML> <html> <head> <title>PHP100_left</title> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <link href="images/private.css" type=text/css rel=stylesheet> <script language=javascript> <!-- function menu_tree(meval) { var left_n=eval(meval); if (left_n.style.display=="none") { eval(meval+".style.display='';"); } else { eval(meval+".style.display='none';"); } } --> </script> </head> <body> <center> <table class=Menu cellSpacing=0> <tbody> <tr><th onClick="javascript:menu_tree('left_1');" align=middle>≡ 基础操作 ≡</th></tr> <tr id=left_1> <td> <table width="100%"> <tbody> <tr> <td> <A href="admin_main.php" target=main>配置信息</A></td> </tr> <tr> <td> <A onClick="return confirm('提示:您确定要退出系统吗?')" href="admin_main.php?action=logout" target=_parent>退出后台</A> </td> </tr> </tbody></table> </td></tr></tbody></table> <table class=Menu cellSpacing=0 style="margin-top:5px"> <tbody> <tr> <th onClick="javascript:menu_tree('left_2');" align=middle>≡ 新闻内容 ≡</th></tr> <tr id=left_2> <td> <table width="100%"> <tbody> <tr> <td> <A href="admin_news_class.php" target=main>新闻分类</A></td> </tr> <tr> <td> <A href="admin_news_list.php" target=main>新闻列表</A></td> </tr> <tr> <td> <A href="admin_news_add.php" target=main>添加新闻</A></td> </tr> </tbody></table> </td></tr></tbody></table> <table class=Menu cellSpacing=0 style="margin-top:5px"> <tbody> <tr> <th align=middle>〓 版本信息 〓</th></tr> <tr> <td align=middle><a href="http://www.php100.com" target="_blank">PHP100news 1.0</a></td></tr> <tr> <td align=middle>PHP100.com</td></tr></tbody></table> </center> </body> </HTML>
admin_main.php:网站参数配置页面
<?php include_once ('admin_global.php'); $r=$db->Get_user_shell_check($uid, $shell); if($_GET[action]=='logout')$db->Get_user_out(); $query=$db->findall("p_config"); while($row=$db->fetch_array($query)){ $row_arr[$row[name]]=$row[values]; } if(isset($_POST['update'])){ unset($_POST['update']); foreach($_POST as $name=>$values){ $db->query("update p_config set `values`='$values' where `name`='$name'"); } $db->Get_admin_msg("admin_main.php"); } ?> <html> <head><title>后台管理</title> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <link href="images/private.css" type=text/css rel=stylesheet> </head> <body> <table class=navi cellSpacing=1 align=center border=0> <tbody> <tr> <form action="" method="POST"> <th>后台 >> 系统配置</th></tr></tbody></table><br> <table border=0 cellspacing=1 align=center class=form> <tr> <th colspan="2">系统配置</th> </tr> <tr> <td align="right">网站名称:</td> <td><input type="text" name="websitename" value="<?php echo $row_arr[websitename]?>"/> </td> </tr> <tr> <td align="right">网站地址:</td> <td><input type="text" name="website_url" value="<?php echo $row_arr[website_url]?>"/> </td> </tr> <tr> <td align="right">关键字:</td> <td><input type="text" name="website_keyword" size=40 value="<?php echo $row_arr[website_keyword]?>"/> </td> </tr> <tr> <td align="right">说明:</td> <td><input type="text" name="website_cp" size=40 value="<?php echo $row_arr[website_cp]?>"/> </td> </tr> <tr> <td align="right">电话:</td> <td><input type="text" name="website_tel" size=40 value="<?php echo $row_arr[website_tel]?>"/> </td> </tr> <tr> <td align="right">email:</td> <td><input type="text" name="website_email" size=40 value="<?php echo $row_arr[website_email]?>"/> </td> </tr> <tr> <td colspan="2" align="center" height='30'> <input type="submit" name="update" value=" 更新 "/> </td> </form> </tr> </table> </body> </html>
admin_news_class.php:新闻栏目分类管理页面
<?php include_once ('admin_global.php'); $r=$db->Get_user_shell_check($uid,$shell); if(isset($_POST['into_class'])){ $db->query("INSERT INTO `p_newsclass` (`id`,`f_id`,`name`,`keywrod`,`remark`) VALUES (NULL,'$_POST[f_id]','$_POST[name]','','')"); $db->Get_admin_msg("admin_news_class.php","已经成功添加分类"); } if(!empty($_GET[del])){ $db->query("DELETE FROM `p_newsclass` WHERE `id` = '$_GET[del]' LIMIT 1;"); $db->Get_admin_msg("admin_news_class.php","删除成功"); } if(isset($_POST[update_class])){ $db->query("update `p_newsclass` set `name` = '$_POST[name]' WHERE `id` = '$_POST[id]' LIMIT 1;"); $db->Get_admin_msg("admin_news_class.php","更新成功"); } ?> <html> <head> <title>后台管理</title> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <link href="images/private.css" type=text/css rel=stylesheet> </head> <body> <table class=navi cellSpacing=1 align=center border=0> <tbody> <tr> <th>后台 >> 新闻分类</th></tr></tbody></table><br> <table border=0 cellspacing=1 align=center class=form> <tr> <th colspan="2">添加分类</th> </tr> <form action="" method="post" > <tr> <td colspan="2" align="center" height='30'> <select name="f_id"> <option value="0">添加大类</option> <?php $query=$db->findall("p_newsclass where f_id=0"); while ($row=$db->fetch_array($query)) { $news_class_arr[$row[id]]=$row[name]; echo "<option value=\"$row[id]\">$row[name]</option>"; } ?> </select> <input type="text" name="name" value="" /> <input type="submit" name="into_class" value=" 添加分类 "/> </td> </form> </tr> </table> <br> <table border=0 cellspacing=1 align=center class=form> <tr> <th>系统分类</th> </tr> <?php foreach($news_class_arr as $id=>$val){ ?> <tr> <form action="" method="post"> <td> <input type="hidden" name="id" value="<?php echo $id ?>" /> <input type="text" name="name" value="<?php echo $val ?>"/> <input type="submit" name="update_class" value="更新"/> <input type="button" value="删除" onclick="location.href='?del=<?php echo $id ?>'"/> </form> <?php $query_fid=$db->findall("p_newsclass where f_id=$id"); while($row_fid=$db->fetch_array($query_fid)){ ?> <form action="" method="post"> ┗<input type="hidden" name="id" value="<?php echo $row_fid[id]?>" /> <input type="text" name="name" value="<?php echo $row_fid[name]?>"/> <input type="submit" name="update_class" value="更新"/> <input type="button" value="删除" onclick="location.href='?del=<?php echo $row_fid[id]?>'"> </form> <?php } ?> </td> </tr> <?php } ?> </table> </body></html>
admin_news_list.php:新闻列表页面
<?php include_once('admin_global.php'); $r=$db->Get_user_shell_check($uid,$shell); $query=$db->findall("p_newsclass"); while($row=$db->fetch_array($query)){ $news_class_arr[$row[id]]=$row[name]; } if(!empty($_GET[del])){ $db->query("DELETE FROM `p_newsbase` WHERE `id` = '$_GET[del]'"); $db->query("DELETE FROM `p_newscontent` WHERE `nid` = '$_GET[del]' LIMIT 1;"); $db->Get_admin_msg("admin_news_list.php","删除成功"); } ?> <html> <head> <title>后台管理</title> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <link href="images/private.css" type=text/css rel=stylesheet> </head> <body> <table class=navi cellSpacing=1 align=center border=0> <tbody> <tr> <th>后台 >> 新闻管理</th></tr></tbody></table><br> <table border=0 cellspacing=1 align=center class=form> <tr> <th width='100'>新闻分类</th><th>新闻标题</th><th width='100'>作者</th><th width='100'>日期</th><th width='100'>操作</th> </tr> <?php $result = mysql_query("select id from p_newsbase"); $total = mysql_num_rows($result); pageft($total, 2); if ($firstcount < 0) $firstcount = 0; $query = $db->findall("p_newsbase limit $firstcount, $displaypg"); while ($row = $db->fetch_array($query)) { ?> <td><?php echo $news_class_arr[$row[cid]]?></td><td><?php echo $row[title]?></td><td><?php echo $row[author]?></td> <td><?php echo date("Y-m-d H:i",$row[date_time])?></td><td><a href='?del=<?php echo $row[id]?>'>删除</a> / <a href='admin_news_edit.php?id=<?php echo $row[id]?>'>修改</a></td> </tr> <?php } ?> <tr> <th colspan="5"><?php echo $pagenav; echo $displaypg ?></th> </tr> <tr> <th colspan="5"></th> </tr> </table> <br> </body> </html>
admin_news_add.php:新闻编辑添加页面
<?php include_once('admin_global.php'); $r=$db->Get_user_shell_check($uid,$shell); if(isset($_POST[into_news])){ $db->query("insert into `p_newsbase` (`id`,`cid`,`title`,`author`,`date_time`)" . "values (NULL,'$_POST[cid]','$_POST[title]','$_POST[author]','".mktime()."')"); $last_id=$db->insert_id(); $db->query("insert into `p_newscontent` (`nid`,`keywrod`,`content`,`remark`)" . "values ('$last_id','$_POST[keywrod]','$_POST[content]','')"); $db->Get_admin_msg("admin_news_add.php","添加成功"); } ?> <html> <head> <title>后台管理</title> <meta http-equiv=Content-Type content="text/html; charset=gb2312"> <link href="images/private.css" type=text/css rel=stylesheet> <meta content="MShtml 6.00.6000.16890" name=GENERATOR></head> <body> <table class=navi cellSpacing=1 align=center border=0> <tbody> <tr> <th>后台 >> 添加新闻</th></tr></tbody></table><br> <table border=0 cellspacing=1 align=center class=form> <tr> <th colspan="2">添加分类</th> </tr> <form action="" method="post" onsubmit="syncTextarea()" > <tr> <td width=80>新闻分类</td> <td> <select name="cid"> <option value="0">添加大类</option> <?php $query=mysql_query("select * from `p_newsclass` where `f_id` = 0"); while($row=mysql_fetch_array($query)){ echo "<option value=\"$row[id]\">$row[name]</option>"; $query_son=mysql_query("select * from `p_newsclass` where `f_id` = '$row[id]'"); while($row_son=mysql_fetch_array($query_son)){ echo "<option value=\"$row_son[id]\"> ┗$row_son[name]</option>"; } } ?> </select> </td></tr> <tr> <td width=80>新闻标题</td> <td> <input type="text" name="title" size=50> </select> </td> </tr> <tr> <td width=80>新闻作者</td> <td> <input type="text" name="author" size=20> </td> </tr> <tr> <td width=80>新闻关键字</td> <td> <input type="text" name="keywrod" size=80> </td> </tr> <tr> <td width=80>新闻内容</td> <td> <textarea id="edited" name="content" style="width:95%;height:280px;"></textarea> <script language="javascript" type="text/javascript" src="edit/whizzywig.js"></script> <script type="text/javascript">buttonPath = "edit/images/";makeWhizzyWig("edited", "all");</script> </td> </tr> <tr> <td width=80></td> <td> <input type="submit" name="into_news" style="height:30px;" value="添加新闻"> </td> </tr> </form> </table> <br> </body></html>
(5)分页功能page.class.php
后台和前台分别调用了不同的分页函数,以免混淆,不过由于函数功能基本不一样,这里只贴出前台的分页函数源码:
<?php $page=$_GET['page']; if(!function_exists(pageft)){ function pageft($total,$displaypg){ global $page,$pagenav,$firstcount; $GLOBALS["displaypg"]=$displaypg; if(!$page) $page=1; //获取url $url=$_SERVER['REQUEST_URI']; $parse_url=parse_url($url); $url_query=ereg_replace("(^|&)page=$page","",$parse_url["query"]); $url=$parse_url[path]."?".$url_query."&page"; $lastpg=ceil($total/$displaypg); $page=min($lastpg,$page); $prepg=$page-1; $nextpg=$page+1; //数据记录提取初始值 $firstcount=($page-1)*$displaypg; $pagenav=''; $pagenav.='共'.$total.'条记录 '; if($page==1){ $pagenav.=" <span>首页</span> "; }else{ $pagenav.="<a href='$url=1'>首页</a> "; } if($page==1){ $pagenav.=" <span>上一页</span> "; }else{ $pagenav.="<a href='$url=$prepg'>上一页</a> "; } for($i=1;$i<=$lastpg;$i++){ if($i==$page) $pagenav.=" <span>$i</span> "; else $pagenav.=" <a href='$url=$i'>$i</a> "; } if($page==$lastpage){ $pagenav.=" <span>下一页</span> "; }else{ $pagenav.="<a href='$url=$nextpg'>下一页</a> "; } if($page==$lastpg){ $pagenav.=" <span>末页</span> "; }else{ $pagenav.="<a href='$url=$lastpg'>末页</a> "; } } } ?>
(6)前台首页
包括首页程序文件index.php,smarty模板文件index.html,源码如下:
index.php:
<?php include_once('global.php'); $sql="select * from `p_newsclass` where f_id=0 order by id DESC"; $query=$db->query($sql); while($row_class=$db->fetch_array($query)){ $sm_class[]=array('name'=>$row_class[name],'id'=>$row_class[id]); } $smarty->assign("sm_class",$sm_class); $sql="select * from `p_newsbase` order by id DESC limit 5"; $query=$db->query($sql); while($row_news=$db->fetch_array($query)){ $sm_news[]=array('title'=>$row_news[title],'id'=>$row_news[id]); } $smarty->assign('sm_news',$sm_news); $sql="select * from `p_config`"; $query=$db->query($sql); while($row_config=$db->fetch_array($query)){ $sm_config[$row_config[name]]=$row_config[values]; } $smarty->assign('sm_config',$sm_config); $smarty->display("index.html"); ?>
index.html:
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>{$sm_config.websitename}</title> <link href="{$t_dir}css/common.css" rel="stylesheet" type="text/css" /> <link href="{$t_dir}css/layout.css" rel="stylesheet" type="text/css" /> <link href="{$t_dir}css/red.css" rel="stylesheet" type="text/css" /> </head> <body> <p class="content border_bottom"> <ul id="sub_nav"> <li><a href="{$sm_config[0]}">设为首页</a></li> <li><a href="#">加入收藏</a></li> <li class="nobg"><a href="#">联系我们</a></li> </ul> <br class="clear" /> </p> <p class="content dgreen-bg"> <p class="content"> <ul id="main_nav"> <li class="nobg"><a href="index.php">新闻首页</a></li> {section name=l loop=$sm_class} <li><a href="list.php?cid={$sm_class[l].id}">{$sm_class[l].name}</a></li> {/section} </ul><br class="clear" /> </p> </p> <p class="content"> <p id="left-nav-bar" class="bg_white"> <p id="top-contact-info"> 姓名:<br /> 电话:<br /> OICQ:<br /> 手机:<br /> 地址: </p> <h2>招商信息</h2> <ul> <li><a href="#">千亿美元进中国 推高股价房价</a></li> <li><a href="#">千亿美元进中国 推高股价房价</a></li> <li><a href="#">千亿美元进中国 推高股价房价</a></li> <li><a href="#">千亿美元进中国 推高股价房价</a></li> </ul> <h2>企业资讯</h2> <ul> <li><a href="#">千亿美元进中国 推高股价房价</a></li> <li><a href="#">千亿美元进中国 推高股价房价</a></li> <li><a href="#">千亿美元进中国 推高股价房价</a></li> <li><a href="#">千亿美元进中国 推高股价房价</a></li> </ul> <h3><a href="http://www.php100.com">[站外图片上传中……(4)]</a></h3> <span id="hits">现在已经有[122]次点击</span> </p> <p id="right-cnt"> <p class="col_center"> <p class="sub-title"><h2>促销活动</h2><span><a href="#" class="cblue">MORE</a></span><br class="clear" /> </p> <ul> {section name=l loop=$sm_news} <li><a href="view.php?id={$sm_news[l].id}">{$sm_news[l].title}</a></li> {/section} </p> <p class="col_center right"> <p class="sub-title"><h2>公司简介</h2><span><a href="#" class="cblue">MORE</a></span><br class="clear" /></p> <p id="intro"> 入贯彻落实科学发展观的自觉性和坚定性湖南一 考生高考4门课程故意考零分温家宝调研太湖污染代表 中央向居民致歉湖南73人涉黑集团麻醉强奸女服务员 被公诉女大学生卖淫被抓警察让其参加毕被公诉女大学生卖淫被抓警察让其参加毕...[<a href="#" class="cgray">详细</a>] </p> </p><br class="clear" /> <p id="m_adv"></p> <p class="pages"><h2>产品展示</h2><span>产品分类:展示 | 展示 | 展示 | 展示 | 展示 | 展示 | 展示 | 展示 | 展示</span><p id="more"><a href="#" class="cblue">MORE</a></p> <br class="clear" /></p> <ul id="products-list"> <li> <h3>产品展示</h3> <ul> <li>规格:</li> <li>产地:</li> <li>价格:1200 <span>[<a href="#" class="cdred">详细</a>]</span></li> </ul> </li> <li> <h3>产品展示</h3> <ul> <li>规格:</li> <li>产地:</li> <li>价格:1200 <span>[<a href="#" class="cdred">详细</a>]</span></li> </ul> </li> <li> <h3>产品展示</h3> <ul> <li>规格:</li> <li>产地:</li> <li>价格:1200 <span>[<a href="#" class="cdred">详细</a>]</span></li> </ul> </li> <li> <h3>产品展示</h3> <ul> <li>规格:</li> <li>产地:</li> <li>价格:1200 <span>[<a href="#" class="cdred">详细</a>]</span></li> </ul> </li> </ul><br class="clear" /> </p> <br class="clear" /> </p> <p id="about"> <p class="content"> <span class="left"><a href="#">网店首页</a> | <a href="#">公司介绍</a> | <a href="#">资质认证</a> | <a href="#">产品展示</a> | <a href="#">视频网店</a> | <a href="#">招商信息</a> | <a href="#">招聘信息</a> | <a href="#">促销活动</a> | <a href="#">企业资讯</a> | <a href="#">联系我们</a></span> <span class="right">我的邮件:{$sm_config.website_email}</span> </p> </p> <p id="copyright"> </p> </body> </html>
(7)新闻列表页
包含列表程序文件list.php,smarty模板文件:list.html
list.php
<?php include_once('global.php'); //id为空,不执行该页 if(empty($_GET[cid])) exit(); //引入title $query=$db->findall('p_config'); while($row_config=$db->fetch_array($query)){ $sm_config[$row_config[name]]=$row_config[values]; } $smarty->assign('sm_config',$sm_config); //配置导航 $sql="select * from `p_newsclass` where f_id=0 order by id DESC"; $query=$db->query($sql); while($row_class=$db->fetch_array($query)){ $sm_class[]=array('name'=>$row_class[name],'id'=>$row_class[id]); } $smarty->assign('sm_class',$sm_class); $query = $db->findall("p_newsclass"); while ($row = $db->fetch_array($query)) { $news_class_arr[$row[id]] = $row[name]; } //打印左侧当前文章栏目分类 $query=$db->findall("p_newsclass where f_id = $_GET[cid]"); while($row_chlidclass=$db->fetch_array($query)){ $news_class_in.=$row_chlidclass[id].","; $news_class_list_arr[]=array('name'=>$row_chlidclass[name],'id'=>$row_chlidclass[id]); } $news_class_in.="$_GET[cid]"; //文章列表 $sql="select id from `p_newsbase` where cid in ($news_class_in)"; $total=mysql_num_rows(mysql_query($sql)); pageft($total,2); if($firstcount<0) $firstcount=0; $query=$db->query("select * from `p_newsbase` where cid in ($news_class_in) limit $firstcount,$displaypg"); while($row_list=$db->fetch_array()){ $sm_list[]=array( "title"=>$row_list[title], 'cid'=>$row_list[cid], 'id'=>$row_list[id], 'cidname'=>$news_class_arr[$row_list[cid]]); } $smarty->assign("news_class_list_arr",$news_class_list_arr); $smarty->assign("sm_list",$sm_list); $smarty->assign("pagenav", $pagenav); //新闻分页 $smarty->display("list.html"); ?>
list.html
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>{$sm_config.websitename}</title> <link href="{$t_dir}css/common.css" rel="stylesheet" type="text/css" /> <link href="{$t_dir}css/layout.css" rel="stylesheet" type="text/css" /> <link href="{$t_dir}css/red.css" rel="stylesheet" type="text/css" /> </head> <body> <p class="content border_bottom"> <ul id="sub_nav"> <li><a href="{$sm_config[0]}">设为首页</a></li> <li><a href="#">加入收藏</a></li> <li class="nobg"><a href="#">联系我们</a></li> </ul> <br class="clear" /> </p> <p class="content dgreen-bg"> <p class="content"> <ul id="main_nav"> <li class="nobg"><a href="index.php">新闻首页</a></li> {section name=l loop=$sm_class} <li><a href="list.php?cid={$sm_class[l].id}">{$sm_class[l].name}</a></li> {/section} </ul><br class="clear" /> </p> </p> <p class="content"> <p id="left-nav-bar" class="bg_white"> <p id="top-contact-info"> {section name=l loop=$news_class_list_arr} <a href=list.php?cid={$news_class_list_arr[l].id}>{$news_class_list_arr[l].name}</a><br> {/section} </p> </p> <p id="right-cnt"><br class="clear" /> <p class="pages"> <h2>类别</h2> <span>新闻标题</span> <p id="more"><a href="#">时间</a></p> </p> {section name=l loop=$sm_list} <p class="listtt"> <h2><a href="list.php?cid={$sm_list[l].cid}">{$sm_list[l].cidname}</a></h2> <span><a href="view.php?id={$sm_list[l].id}">{$sm_list[l].title}</a></span> <p id="more">{$sm_list[l].date_time}</p> </p> {/section} {$pagenav} </p> <br class="clear" /> </p> <p id="about"> <p class="content"> <span class="left"><a href="#">网店首页</a> | <a href="#">公司介绍</a> | <a href="#">资质认证</a> | <a href="#">产品展示</a> | <a href="#">视频网店</a> | <a href="#">招商信息</a> | <a href="#">招聘信息</a> | <a href="#">促销活动</a> | <a href="#">企业资讯</a> | <a href="#">联系我们</a></span> <span class="right">我的邮件:{$sm_config.website_email}</span> </p> </p> <p id="copyright"> </p> </body> </html>
(8) 新闻内容页
包括新闻内容程序文件view.php,smarty模板文件view.html
view.php
<?php include_once('global.php'); if(empty($_GET[id])) exit(); //配置标题 $sql="select * from `p_config`"; $query=$db->query($sql); while($row_config=$db->fetch_array($query)){ $sm_config[$row_config[name]]=$row_config[values]; } $smarty->assign("sm_config",$sm_config); //配置栏目导航 $sql="select * from `p_newsclass` where f_id=0"; $query=$db->query($sql); while($row_class=$db->fetch_array($query)){ $sm_class[]=array('name'=>$row_class[name],'id'=>$row_class[id]); } $smarty->assign("sm_class",$sm_class); $sql="select * from `p_newsbase` as a,p_newscontent as b where a.id=b.nid and a.id=$_GET[id]"; $query=$db->query($sql); $row_news=mysql_fetch_array($query,MYSQL_ASSOC); $smarty->assign("row_news",$row_news); $smarty->display("view.html"); ?>
view.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>{$sm_config.websitename}</title> <link href="{$t_dir}css/common.css" rel="stylesheet" type="text/css" /> <link href="{$t_dir}css/layout.css" rel="stylesheet" type="text/css" /> <link href="{$t_dir}css/red.css" rel="stylesheet" type="text/css" /> </head> <body> <p class="content border_bottom"> <ul id="sub_nav"> <li><a href="{$sm_config[0]}">设为首页</a></li> <li><a href="#">加入收藏</a></li> <li class="nobg"><a href="#">联系我们</a></li> </ul> <br class="clear" /> </p> <p class="content dgreen-bg"> <p class="content"> <ul id="main_nav"> <li class="nobg"><a href="index.php">新闻首页</a></li> {section name=l loop=$sm_class} <li><a href="list.php?cid={$sm_class[l].id}">{$sm_class[l].name}</a></li> {/section} </ul><br class="clear" /> </p> </p> <p class="content"><br /> <h2>{$row_news.title}<br /> <br /> </h2> 时间:{$row_news.date_time|date_format:"%D"} 作者:{$row_news.author}<br /> <br /> <hr /> <br /> <p> {$row_news.content} </p> <br class="clear" /> </p> <p id="about"> <p class="content"> <span class="left"><a href="#">网店首页</a> | <a href="#">公司介绍</a> | <a href="#">资质认证</a> | <a href="#">产品展示</a> | <a href="#">视频网店</a> | <a href="#">招商信息</a> | <a href="#">招聘信息</a> | <a href="#">促销活动</a> | <a href="#">企业资讯</a> | <a href="#">联系我们</a></span> <span class="right">目前已有[2222]点击</span> </p> </p> <p id="copyright"> </p> </body> </html>
以上がマイクロニュースシステムの開発の詳細内容です。詳細については、PHP 中国語 Web サイトの他の関連記事を参照してください。