include "Up.php";
include "backend/Mis.php";
$_SESSION["bstrSQL"]=="";
$_SESSION["cstrSQL"]=="";
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_RS1 = 5;
$pageNum_RS1 = 0;
if (isset($_GET['pageNum_RS1'])) {
$pageNum_RS1 = $_GET['pageNum_RS1'];
}
$startRow_RS1 = $pageNum_RS1 * $maxRows_RS1;
$conn = $db_conn;
mysql_select_db($database);
//增加點閱率
$SQl = "update sd_clicl set Click=Click+1 where Title ='QandA'";
//echo $SQl;
$result = mysql_query($SQl);
$table = "sd_qanda";
//if (($_SESSION["qstrSQL"]!=""))
// $query_RS1 =$_SESSION["qstrSQL"];
//else
$query_RS1 = "SELECT * FROM ".$table." WHERE status='1' ORDER BY QID desc";
$query_limit_RS1 = sprintf("%s LIMIT %d, %d", $query_RS1, $startRow_RS1, $maxRows_RS1);
$RS1 = mysql_query($query_limit_RS1, $conn) or die(mysql_error());
$row_RS1 = mysql_fetch_assoc($RS1);
if (isset($_GET['totalRows_RS1'])) {
$totalRows_RS1 = $_GET['totalRows_RS1'];
} else {
$all_RS1 = mysql_query($query_RS1);
$totalRows_RS1 = mysql_num_rows($all_RS1);
}
$totalPages_RS1 = ceil($totalRows_RS1/$maxRows_RS1)-1;
$queryString_RS1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_RS1") == false &&
stristr($param, "totalRows_RS1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_RS1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_RS1 = sprintf("&totalRows_RS1=%d%s", $totalRows_RS1, $queryString_RS1);
?>
 |
聲明書 | 版主的話 |
|
//$a=$startRow_RS1+1;
$a=$totalRows_RS1-($pageNum_RS1*5);
do {
$Content =$row_RS1['Content'];
$HiddName =$row_RS1['HiddName'];
$NikeName =$row_RS1['NikeName'];
$Content= str_replace("\n", " ", $Content);
$Who =$row_RS1['Who'];
$AddDate =$row_RS1['AddDate'];
$Response =$row_RS1['Response'];
$QID =$row_RS1['QID'];
if ($HiddName=="Y")
{
if ($NikeName=="")
$CName="NLP小天使";
else
$CName=$NikeName;
}
else
{
$result = mysql_query("select CName from sd_operator where Account ='".$Who."'");
$RS= mysql_fetch_array($result,MYSQL_ASSOC);
$CName=$RS['CName'];
}
if (trim($Response)!='')
{
$result = mysql_query("select CName from sd_operator where Account ='".$ResponseMan."'");
$RS= mysql_fetch_array($result,MYSQL_ASSOC);
$ResponseMan=$RS['CName'];
$ResponseDate=$row_RS1['ResponseDate'];
$ResponseMan =$row_RS1['ResponseMan'];
$Response= str_replace("\n", " ", $Response);
if ($ResponseMan='mousep3@gmail.com')
{
$ResponseMan='版主 ';
}
}
?>
$DateTime_Now=date("Y-m-d");
if ((trim($ResponseDate))!="0000-00-00 00:00:00")
{
$news_date = strtotime($ResponseDate); //必需先把字串型態的日期變數轉換為日期型的變數
$news_date_Y = date("Y" , $news_date); //取得新聞時間的年
$news_date_m = date("m" , $news_date); //月
$news_date_d = date("d" , $news_date); //日
$DateTime_7Day =date("Y-m-d" , mktime( 0, 0, 0, $news_date_m, $news_date_d + 7, $news_date_Y ) );
if ($DateTime_7Day >= $DateTime_Now)
{
echo " ";
}
}
?>
Q: |
於提問
|
if (trim($Response)!='')
{
?>
A: |
<閱讀全文>
於回答
|
}
$a--;
} while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
if ($pageNum_RS1 >= 0) {
for($i=0;$i<=$totalPages_RS1;$i++)
{
if (($i)==$pageNum_RS1)
{
echo "/ ".($pageNum_RS1+1)."";
}
else
{
?>
/ 1
}
}
}
?> |
|
mysql_free_result($RS1);
include "Down.php";
?>