php使用PDO下exec()函數查詢執行后受影響行數的方法
708
2024-01-10
本文實例為大家分享了php留言板功能的具體代碼，供大家參考，具體內容如下
數據庫用到的三張表
一.登錄界面 （denglu.php login.php）
1.denglu.php
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> </head> <body> <h1>開發部內部留言板</h1> <form action="login.php" method="post"> <div>用戶名：<input type="text" name="UserName" /></div> <div>口令：<input type="password" name="PassWord" /></div> <input type="submit" value="登錄" /> <a style="text-decoration:none"><input type="button" value="復位" /></a> </form> </body> </html>
2.login.php
<?php
session_start();
$UserName = $_POST["UserName"];
$PassWord = $_POST["PassWord"];
require "DBDA.class1.php";
$db = new DBDA();
$sql = "select PassWord from yuangong where UserName = '{$UserName}'";
$arr = $db->query($sql);
if(count($arr))
{
if($arr[0][0] == $PassWord && !empty($PassWord))
{
//存儲用戶名
$_SESSION["UserName"] = $UserName;
header("location:main.php");
}
}
else
{
header("location:denglu.php");
}
二.主界面（main.php tuichu.php）
1.main.php
<!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>
</head>
<body>
<?php
session_start();
// 防止繞過登陸直接進入主界面
if(empty($_SESSION["UserName"]))
{
header("location:denglu.php");
exit;
}
require "DBDA.class1.php";
$db = new DBDA();
$UserName = $_SESSION["UserName"];
?>
<div>
<a >發布信息</a>
<a >退出系統</a>
</div><br /><br />
<h1>留言信息：</h1>
<table width="100%" border="1" >
<tr>
<td>發送人</td>
<td>發送時間</td>
<td>接收人</td>
<td>信息內容</td>
</tr>
<?php
//顯示接收者是我的，或者是所有人的
$sql = "select * from liuyan where Recever='{$UserName}' or Recever='suoyou'";
$arr = $db->query($sql);
foreach($arr as $v)
{
echo "<tr>
<td>{$v[1]}</td>
<td>{$v[3]}</td>
<td>{$v[2]}</td>
<td>{$v[4]}</td>
</tr>";
}
?>
</table>
</body>
</html>
2.tuichu.php
<?php
session_start();
unset($_SESSION["UserName"]);
header("location:denglu.php");
三.發送頁面（fabu.php fabuchuli.php）
1.fabu.php
<!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>
</head>
<body>
<div>
<a >查看信息</a>
<a >退出系統</a>
</div>
<h1>信息發送：</h1>
<form action="fabuchuli.php" method="post">
<div>接收人：
<select name="jsr">
<option value="suoyou">所有人</option>
<?php
session_start();
$UserName = $_SESSION["UserName"];
require"DBDA.class1.php";
$db = new DBDA();
//方法一
$sql = "select friend.Friend,yuangong.Name from friend,yuangong where friend.Friend = yuangong.UserName and friend.Me = '{$UserName}'";
$arr = $db->query($sql);
foreach($arr as $v)
{
echo "<option value='{$v[0]}'>{$v[1]}</option>";
}
//方法二
/*$sql = "select Friend from friend where Me ='{$UserName}'";
$arr = $db->query($sql);
foreach($arr as $v)
{
$v[0];
$sname = "select Name from yuangong where UserName = '{$v[0]}'";
$aname = $db->query($sname);
echo"<option value='{$v[0]}'>{$aname[0][0]}</option>";
}*/
?>
</select></div>
<div>信息內容：<textarea name="neirong"></textarea></div>
<input type="submit" value="發送" />
<a style="text-decoration:none"><input type="button" value="復位" /></a>
</form>
</body>
</html>
2.fabuchuli.php
<?php
session_start();
$UserName = $_SESSION["UserName"];
$jsr = $_POST["jsr"];
$nr = $_POST["neirong"];
$Times = date("Y-m-d H:i:s");
require"DBDA.class.php";
$db = new DBDA();
$sql = "insert into liuyan values('','{$UserName}','{$jsr}','{$Times}','{$nr}')";
$db->query($sql,0);
header("location:fabu.php");
以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持綠夏網。
