基于mysql的论坛（6）_php基础

# post.php
<?php
require(“config.inc.php”);
$sql=”select * from boardinfo where name=’$board'”;
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
?>

发新贴子
<link rel=”stylesheet” type=”text/css” href=”css/index.css”>

发贴子

（您必须注册以后才能发表新主题，不然您只能查看主题。

如果您还未注册，请点击这里转到注册页）

您的贴子将被发表在<?php echo $sql_row[chinesename];?>版块

用户名：

” size=”17″ maxlength=”16″>
*

密码：

主题：

内容：

使用签名
“>

<?php include “footer.p

本&文来源gaodai^.ma#com搞#代!码网

搞gaodaima代码hp”;?>

# query.php
<?php
require(“func.php”);
$sql=”select * from boardinfo”;
$sql_result=mysql_query($sql);
?>

main
<meta http-equiv=”Content-Type” content=”text/html; charset=gb2312″>
<link rel=”stylesheet” type=”text/css” href=”css/page.css”>

论坛贴子查询

在

请选择版面
<?php
while($sql_row=mysql_fetch_array($sql_result)){
?>
“><?php echo $sql_row[chinesename];?>
<?php
}
?>

中查询

论坛信息

<?php include “info.php”;?>

# query_list.php
<?php
require(“func.php”);
if (!empty($query_str)) {

if(!is_board_exits($board)){
$board=”computer”;
}
if ($title){
$submit=”title”;
}
elseif ($cont) {
$submit=”cont”;
}
elseif ($writer) {
$submit=”writer”;
}
else {
$submit=”title”;
}
$sql=”select * from $board where ($submit like ‘%$query_str%’)”;
$temp=mysql_query($sql);
$sum=mysql_num_rows($temp);
if ($sum!=0) {
$sql=”select * from boardinfo where name=’$board'”;
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$chinesename=$sql_row[chinesename];
setcookie (“jl_forum[chinesename]”,$chinesename);
$sql=”select name from user where slaveboard=’$board'”;
$sql_result=mysql_query($sql);
?>

List
<meta http-equiv=”Content-Type” content=”text/html; charset=gb2312″>
<link rel=”stylesheet” type=”text/css” href=”css/index.css”>
<script language=”javascript”>
function openwin(board,id){ window.open(“good_read.php?board=”+board+”&id=”+id,””,”height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no”);
}
function post(board){ window.open(“post.php?board=”+board,””,”height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no”);
}
</script>

版面：<?php
echo $chinesename;
?>

版主：<?php
while ($sql_row=mysql_fetch_array($sql_result))
{
echo “$sql_row[name]”.” “;
}
# 选择出留言纪录;

$totalpage=ceil($sum/$pagesize);
# 分页
if($page<1 or empty($page)){
$page=1;
}
elseif ($page>$totalpage){
$page=$totalpage;
}
elseif ($totalpage==0) {
$page=0;
}
$offset=($page-1)*$pagesize;
$sql=”select * from $board where ($submit like ‘%$query_str%’) order by id desc limit $offset,$pagesize”;
$sql_result=mysql_query($sql);
?>

查询到<?php echo $sum; ?>条纪录

“)’>

<?php
while ($sql_row=mysql_fetch_array($sql_result))
{
echo”

“;
echo”

“;
}
?>

回应	主题	时间	人气

“; echo “[*]”; echo”	$sql_row[title]	$sql_row[writetime]	$sql_row[hits]

“>
” value=”y”>
“>
共<?php echo $totalpage;?>页第<?php echo $page;?>页·<?php
if ($page!=1){
$back=$page-1;
echo”首页　上一页”;
}
if ($page==1){
echo”首页　上一页”;
}
if($page!=$totalpage){
$next=$page+1;
echo”　下一页　尾页”;
}
if($page==$totalpage){
echo”　下一页　尾页”;
}
?>·转到

页

<?php include “footer.php”;?>

<?php
}
else
{
show_error(10);
}
}
else {
show_error(9);
}
# read.php
<?php
require (“func.php”);
if ($re){
$sql=”select slaveid from $board where id=$id”;
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
if($sql_row[slaveid]!=0){
show_error(1);
$founderr=1;
}
if (!check_user_password($name,$password)){
show_error(4);
$founderr=1;
}
if (empty($title)){
show_error(2);
$founderr=1;
}
if ($qm){
$qm=expl_qm($name);
}
if(!$founderr){
re_doc($board,$id);
setcookie (“jl_forum[name]”,$name);
$sql=”select * from $board where id=$id”;
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$title=$sql_row[title];
$writer=$sql_row[writer];
$cont=$sql_row[cont];
$writetime=$sql_row[writetime];
$hits=$sql_row[$hits];
$fromip=$sql_row[fromip];
$sql=”select * from $board where slaveid=$id”;
$sql_result=mysql_query($sql);
# $sql_row=mysql_fetch_array($sql_result);
}

}
elseif ($add){
if (!is_board_exits($board)){
show_error(7);
$founderr=1;
}
if (empty($title)){
show_error(2);
$founderr=1;
}
if (!check_user_password($name,$password)){
show_error(4);
$founderr=1;
}
if ($qm){
$qm=expl_qm($name);
}
if (!$founderr){
add_doc($board);
$add=1;
setcookie (“jl_forum[name]”,$name);
}
}
else {
if (!is_board_exits){
show_error(7);
}
add_one_hit($board,$id);
$sql=”select * from $board where id=$id”;
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$title=$sql_row[title];
$writer=$sql_row[writer];
$cont=$sql_row[cont];
$writetime=$sql_row[writetime];
$hits=$sql_row[$hits];
$fromip=$sql_row[fromip];
$sql=”select * from $board where slaveid=$id”;
$sql_result=mysql_query($sql);
# $sql_row=mysql_fetch_array($sql_result);
}
?>

<?php echo $title;?>
<meta http-equiv=”Content-Type” content=”text/html; charset=gb2312″>
<link rel=”stylesheet” type=”text/css” href=”css/index.css”>
<script language=”javascript”>
function sendmsg(name){ window.open(“sendmsg.php?name=”+name,””,”height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no”);
}
</script>

标题：<?php echo $title;?>

作者：<?php echo “$writer”;?>(<?php echo $writetime;?>)　’)”>　”>

<?php echo $cont;?>

※ 来源：<?php echo $jl_forum[chinesename];?> [◆FROM：<?php echo $fromip;?>]

<?php
if ($add!=1){
while($sql_row=mysql_fetch_array($sql_result)) {
?>

标题：<?php echo $sql_row[title];?>

作者：<?php echo “$sql_row[writer]”;?>(<?php echo $sql_row[writetime];?>)　’)”>　”>

<?php echo $sql_row[cont];?>

※ 来源：<?php echo $jl_forum[chinesename];?> [◆FROM：<?php echo $sql_row[fromip];?>]

<?php
}
?>

用户名	“> *	密码	*
标题：	*
内容：
	使用签名 “> “>

<?php
}
?>

<?php include”footer.php”;?>

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：基于mysql的论坛（6）_php基础

Hi，您需要填写昵称和邮箱！