Q&A 板块

本例实现问答的板块。

相关sql:

1.questions: {id, asker, title, content, keyword, time};

2.answers  : {id, answer, question_id, content, time};

问题前台：question.php

            <?php
                $str = "SELECT * FROM questions";
                 $res = mysql_query($str);
                for($i=1; $res && $row=mysql_fetch_array($res); $i++){
                    echo "<div>";
                    echo "$row[id]<br/>";
                    echo "<a href='answer.php?question_id=$row[id]'>$row[title]</a><br/>";
                    echo "$row[content]<br/>";
                    echo "$row[keyword]		$row[time]		$row[asker]<br/>";
                    echo "<br/><br/></div>";
                }
            ?>

回答前台：answer.php

<?php
    include "process.php";
    include "login.php";
    // question
    if(@!$_GET["question_id"])
        exit('非法访问！点击此处 <a href="javascript:history.back(-1);">返回</a><br/>');
    else{
        $str = "SELECT * FROM questions WHERE id='$_GET[question_id]'";
        $res = mysql_query($str);
        $row = mysql_fetch_array($res);
        echo "<div><h1>问题</h1></div>";
        echo "<div>";
        echo "$row[id]<br/>";
        echo "$row[title]<br/>";
        echo "$row[content]<br/>";
        echo "$row[keyword]		$row[time]		$row[asker]<br/>";
        echo "<br/><br/></div>";
    }
    // answers
    echo "<div><h1>回答</h1></div>";
    $str = "SELECT * FROM answers WHERE question_id='$_GET[question_id]'";
     $res = mysql_query($str);
    for($i=1; $res && $row=mysql_fetch_array($res); $i++){
        echo "<div>";
        echo "$row[content]<br/>";
        echo "$row[time]		$row[answer]<br/>";
        echo "<br/><br/></div>";
    }
?>

<form action="process.php?question_id=<?php echo "$_GET[question_id]"; ?>" method="post" /><br/>
    回答:<textarea  name="content" rows=10 cols=20></textarea><br/>
    <input type="submit" name="answer_submit", value="submit" />
</form>

Q&A后台：process.php

    // submit the ask form
    if(@$_POST["ask_submit"]){
        session_start();
        if(empty($_SESSION["username"]))
            exit("您还未登录！<a href='javascript:history.back(-1);'>返回</a>");
        
        $str = "SELECT COUNT(*) FROM questions";
        $res = mysql_fetch_array( mysql_query($str) );
        $str = "INSERT INTO questions VALUES($res[0]+1, '$_SESSION[username]', '$_POST[title]', '$_POST[content]', '$_POST[keyword]', now())";
        //$str = "INSERT INTO questions(asker, title) VALUES('$_POST[asker]', '$_POST[title]')";
        if(mysql_query($str))
            exit("提交成功 点击此处 <a href='javascript:history.back(-1);'>返回</a>");
        else
            exit("提交失败 点击此处 <a href='javascript:history.back(-1);'>返回</a>");
    }

    // submit the answer form
    if(@$_POST["answer_submit"]){
        session_start();
        if(empty($_SESSION["username"]))
            exit("您还未登录！<a href='javascript:history.back(-1);'>返回</a>");
        
        $str = "SELECT COUNT(*) FROM answers";
        $res = mysql_fetch_array( mysql_query($str) );
        $str = "INSERT INTO answers VALUES($res[0]+1, '$_SESSION[username]', '$_GET[question_id]', '$_POST[content]', now())";
        if(mysql_query($str))
            exit("提交成功 点击此处 <a href='javascript:history.back(-1);'>返回</a>");
        else
            exit("提交失败 点击此处 <a href='javascript:history.back(-1);'>返回</a>");
    }