文章标题

上下页的文章跳转

<?php
session_start();
$type = 4;
?>
<!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=utf-8" />
        <title>内容页</title>
        <link href="css/comm.css" rel="stylesheet" type="text/css" />
        <link href="css/content.css" rel="stylesheet" type="text/css" />
        <link href="css/content_nav.css" rel="stylesheet" type="text/css" />
        <script type="text/javascript" src="myform.js"></script>
    </head>
    <body>
        <div id="box">
            <?php
            include_once 'top.php';
            ?>
            <div id="top_bg"></div>
            <div id="content">
                <div id="content_nav">
                    <ul>
                        <li class="spa_a"><a href="#">子栏目一</a></li>
                        <li><a href="#">子栏目二</a></li>
                        <li><a href="#">子栏目三</a></li>
                        <li><a href="#">子栏目四</a></li>
                        <li><a href="#">子栏目五</a></li>
                        <li><a href="#">子栏目六</a></li>
                    </ul>
                </div>
                <div id="position_nav">
                    <strong>当前位置:</strong>首页<span>></span>栏目页<span>></span>内容页
                    <img src="Library/images/Wap.gif"/>
                    <img src="Library/images/Rss.gif"/>
                </div>
                <div id="main">
                    <?php
                    include_once 'main_left.php';
                    ?>
                    <div id="main_right">
                        <?php
                        if (isset($_GET["aid"])) {
                            $aid = $_GET["aid"];
                        } else {
                            $aid = 1;
                        }
                        $sql = "select * from articles join user on articles.uid=user.id where articles.id={$aid}";
                        $row = sqlSelect1($sql);
                        ?>
                        <h5><?php echo $row["title"]; ?></h5>
                        <div id="main_right_top">
                            <h2><?php echo $row["title"]; ?></h2>
                            <span>作者:<?php echo $row["nicheng"]; ?> 来源:www.xinwenwang.com 更新时间:<?php echo $row["add_time"]; ?><br /></span>
                        </div>
                        <div id="main_right_middle">
                            <?php echo $row["content"]; ?><br />
                            <?php
                            $myimgs = explode(",", $row["content_imgs"]);
                            foreach ($myimgs as $myimg) {
                                echo "<br><img src=' images/{$myimg}'" . "width='300' height='150>'<br><br>";
                            }
                            ?><br />    
                        </div>
                        <div id="main_right_bottom">
                            <ul>
                                <?php
                                $sql1 = "select min(id) as minid,max(id) as maxid from articles";
                                $row1 = sqlSelect1($sql1);
                                if ($aid <= ($row1["minid"])) {
                                    ?>
                                    <li>上一篇:没有了</li>
                                    <?php
                                } else {
                                    $sql = "select * from articles where id=(select max(id) from articles where id<{$aid})"; //这里利用一个嵌套的子查询 查出比当前id稍小的id数
                                    $row11 = sqlSelect1($sql);
                                    ?>
                                    <li>上一篇:<a href="content.php?aid=<?php echo $row11["id"]; ?>"><?php echo $row11["title"]; ?></a></li>
                                    <?php
                                }
                                ?>
                                <?php
                                $sql1 = "select min(id) as minid,max(id) as maxid from articles";
                                $row1 = sqlSelect1($sql1);
                                if ($aid >= $row1["maxid"]) {
                                    ?>
                                    <li>下一篇:没有了</li>
                                    <?php
                                } else {
                                    $sql = "select * from articles where id=(select min(id) from articles where id>{$aid})"; //这里利用一个嵌套的子查询 查出比当前id稍大的id数
                                    $row11 = sqlSelect1($sql);
                                    ?>
                                    <li>下一篇:<a href="content.php?aid=<?php echo $row11["id"]; ?>"><?php echo $row11["title"]; ?></a></li>
                                    <?php
                                }
                                ?>
                            </ul>
                        </div>
                        <div id="main_right_bottom2">
                            <ul>
                                <li><a href="comment.php">发表评论</a></li>
                                <li><a href="#" onclick="window.close();">关闭窗口</a></li>
                                <li><a href="#top">返回顶部</a></li>
                            </ul>
                        </div>
                        <?php
                        if (isset($_SESSION["username"])) {
                            ?>
                            <div id="content_bottom">
                                <form action="public.php" method="post">
                                    <textarea id="message" name="message" onclick="textClear()">请发表评论
                                    </textarea><br></br>
                                    <input type="hidden" name="aid"  value="<?php echo $aid; ?>">
                                        <input type="submit" name="sbt" id="sbt" value="发表">
                                            </form>
                                            </div>
                                        <?php } ?>
                                        <?php
                                        //print_r($_SERVER); 系统数据
                                        ?>
                                        <h5>网友评论</h5>

                                        <ul>
                                            <?php
                                            $sql = "select * from comment join user on comment.user_id=user.id"
                                                    . " where comment.article_id={$aid} order by comment_time desc";
                                            $rows3 = sqlSelect($sql);
                                            foreach ($rows3 as $row3) {
                                                $mydate = explode(" ", $row3["comment_time"]);
                                                ?>
                                                <li>[<?php echo $mydate[0]; ?>]<?php echo $row3["username"]; ?><?php echo $row3["comm_content"]; ?></li>
                                            <?php } ?>
                                        </ul>
                                        </div>
                                        </div>
                                        </div>
                                        <?php
                                        include_once 'bottom.php';
                                        ?>
                                        </div>
                                        </body>
                                        </html>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值