專案開發_討論區之3_reply_查看內容及回覆

<?php
session_start(); //啟動SESSION
include_once('./conn.inc.php'); //引入資料庫連線檔案
$ad_id = $_GET['id']; //宣告 $ad_id 接收 id
//echo $ad_id;
//1-1. 查詢文章
$sql = "SELECT * FROM `articledata_tab`
WHERE `ad_id` = '{$ad_id}'";
$result = mysqli_query($conn, $sql);
$single_article = mysqli_fetch_assoc($result);
//1-2. 查詢發言人
$sql = "SELECT `ud_name` FROM `userdata_tab`
WHERE `ud_id` = '{$single_article['ad_ud_id']}'";
$result_userdata = mysqli_query($conn, $sql); //執行SQL語法
$userdata = mysqli_fetch_assoc($result_userdata); //解析 result檔取得回應數
//2. 查詢回覆
$sql = "SELECT * FROM `replydata_tab`
WHERE `rd_ad_id` = '{$ad_id}'";
$result_reply = mysqli_query($conn, $sql); //執行SQL語法
//print_r($single_article);
//3. 增加點閱率
//第一種寫法
/*$ad_view = $single_article['ad_view'];
$ad_view++;
//$ad_view = $ad_view+1;
//$ad_view+=1;
$sql = "UPDATE `articledata_tab` SET
`ad_view` = '{$ad_view}'
WHERE `ad_id` = '{$ad_id}'";
mysqli_query($conn, $sql); //執行SQL語法*/
//第二種寫法
$sql = "UPDATE `articledata_tab` SET
`ad_view` = `ad_view`+1
WHERE `ad_id` = '{$ad_id}'";
mysqli_query($conn, $sql); //執行SQL語法
?>
<html>
<head>
<title>討論區-<?php /*echo $single_article['ad_title'];*/?><?=$single_article['ad_title'];//短標籤的寫法?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<div style="text-align:center;">
<table border="2" style="width:80%;background-color:#E5FFCD;margin-bottom:30px;">
<tr>
<td><?=$single_article['ad_title'];?></td>
</tr>
<tr>
<td>
<?php
echo '作者：'.$userdata['ud_name'].'<br />';
echo 'IP：'.$single_article['ad_ip'].'<br />';
echo '發文時間：'.$single_article['ad_datetime'];
?>
</td>
</tr>
<tr>
<td style="padding:10px;"><?=$single_article['ad_content'];?></td>
</tr>
</table>
<?php while($arr_reply = mysqli_fetch_assoc($result_reply)):
//2. 查詢發言人
$sql = "SELECT `ud_name` FROM `userdata_tab`
WHERE `ud_id` = '{$arr_reply['rd_ud_id']}'";
//echo $sql;
$result_userdata = mysqli_query($conn, $sql); //執行SQL語法
$userdata = mysqli_fetch_assoc($result_userdata); //解析 result檔取得回應數
?>
<table border="2" style="width:80%;background-color:#EBFFFF;margin-bottom:5px;">
<tr>
<td>回覆內容</td>
</tr>
<tr>
<td>
<?php
echo '回覆人：'.$userdata['ud_name'].'<br />';
echo 'IP：'.$arr_reply['rd_ip'].'<br />';
echo '回覆時間：'.$arr_reply['rd_datetime'];
?>
</td>
</tr>
<tr>
<td style="padding:10px;"><?=$arr_reply['rd_content'];?></td>
</tr>
</table>
<?php endwhile;?>
<?php
if(empty($_SESSION['user'])){
echo '回覆前請先<a href="./login.php">登入</a>';
}else{
?>
<hr />
<table border="2" style="width:80%;background-color:#FFEBF5;margin-bottom:5px;">
<tr>
<th>回覆專區</th>
</tr>
<tr>
<td>
<textarea style="width:100%;height:150px;" name="rd_content"></textarea>
</td>
</tr>
</table>
<?
}
?>
</div>
</body>
</html>

複製代碼

May

返回列表

專案開發_討論區之3_reply_查看內容及回覆

[收藏此主題] [關注此主題的新回復]

[通過 QQ、MSN 分享給朋友]