接下来就是编写php语言用来连接数据库啦
input.htm<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312">
<title>input</title>
</head>
<body>
<form method="POST" action="receive.php">
<p>您的姓名: <input type="text" name="T1" size="20"></p>
<p>您的性别:男<input type="radio" value="0" name="R1">
女<input type="radio" name="R1" value="1"></p>
<p>您的EMAIL:<input type="text" name="T2" size="35"></p>
<p>您的留言内容:</p>
<p> <textarea rows="16" name="S1" cols="45"></textarea></p>
<p></p>
<p> <input type="submit" value="提交" name="B1">
<input type="reset" value="重置" name="B2"></p>
</form>
</body>
</html>
receive.php
<?php
$user='root'
$password='123'
$db='guestbook'
$table='gbook'
$ip=getenv(REMOTE_ADDR)
$sql = "INSERT INTO `guestbook`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, '$T1', '$R1', '$T2', '$S1', '$ip', NOW())"
$connect=mysql_connect('localhost',$user,$password)
mysql_select_db($db)
mysql_query($sql)
$result=mysql_query("select * from $table")
while ($arr=mysql_fetch_array($result))
{
if ($arr[2]==0)
$gender='先生'
else
$gender='女士'
?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312">
<title>Receive</title>
</head>
<body style="background-attachment: fixed">
<table border="1" width="100%" id="table1" bgcolor="#FFFFFF">
<tr>
<td bordercolor="#FFFFFF" bgcolor="#C0C0C0"><?=$arr[6]?>(<?=$arr[5]?>)<p><?=$arr[1]?><?=$gender?><<a href="<?=$arr[3]?>"><?=$arr[3]?></a>>
写到:</td>
</tr>
<tr>
<td><?=$arr[4]?><p></p>
<p><a href="del.php?id=<?=$arr[0]?>">[删除]</a>
<a href="modify.php?id=<?=$arr[0]?>">[修改]</a>]</td>
</tr>
</table>
</body>
</html>
<?php
echo '<p>'
echo '<p>'
}
?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312">
<title>新建网页 1</title>
</head>
<body>
<p><a href="input.htm"><继续留言></a></p>
</body>
</html>
del.php
<?php
$user='root'
$password='123'
$db='guestbook'
$table='gbook'
$sql="DELETE FROM $table WHERE id=$id"
$connect=mysql_connect('localhost',$user,$password)
mysql_select_db($db)
$result=mysql_query($sql)
if ($result)
echo "删除成功"
else
echo "删除失败"
?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312">
<title>新建网页 1</title>
</head>
<body>
<p><a href="receive.php"><返回首页></a></p>
</body>
</html>
modify.php
<?php
$user='root'
$password='123'
$db='guestbook'
$table='gbook'
$ip=getenv(REMOTE_ADDR)
$connect=mysql_connect('localhost',$user,$password)
mysql_select_db($db)
$result=mysql_query("select * from $table where id=$id")
$arr=mysql_fetch_array($result)
?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312">
<title>input</title>
</head>
<body>
<form method="POST" action="modify_ok.php?id=<?=$id?>">
<p>您的姓名: <input type="text" name="T1" size="20" value="<?=$arr[1]?>"></p>
<p>您的性别:
<?php
if ($arr[2]==0) echo '男<input type="radio" value="0" name="R1" checked>
女<input type="radio" name="R1" value="1"></p>'
else echo '男<input type="radio" value="0" name="R1">
女<input type="radio" name="R1" value="1" checked></p>'
?>
<p>您的EMAIL:<input type="text" name="T2" size="35" value="<?=$arr[3]?>"></p>
<p>您的留言内容:</p>
<p> <textarea rows="16" name="S1" cols="45" ><?=$arr[4]?></textarea></p>
<p></p>
<p> <input type="submit" value="修改" name="B1">
<input type="reset" value="重置" name="B2"></p>
</form>
</body>
</html>
modify_ok.php
<?php
$user='root'
$password='123'
$db='guestbook'
$table='gbook'
$connect=mysql_connect('localhost',$user,$password)
mysql_select_db($db)
$sql = "UPDATE `guestbook`.`gbook` SET `name` = '$T1', `sex` = '$R1', `email` = '$T2', `info` = '$S1' WHERE `gbook`.`id` = '$id' LIMIT 1"
$result=mysql_query($sql)
if ($result)
echo "修改成功"
else
echo "修改失败"
?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312">
<title>新建网页 1</title>
</head>
<body>
<p><a href="input.htm"><继续留言></a></p>
</body>
</html>
<style>* {
font-size:12px
margin:0
padding:0
}
li {
margin-top:4px
}
</style>
<script type="text/javascript">
function Trim(text)//去左右空格
{
return text.replace(/^\s+|\s+$/g)//替换一个与正则表达式匹配的子串
}
function sendTxt(dom, ele)
{
if (Trim(document.getElementById(dom).value)=="")
{
alert("内容不能为空,请填写评价")
document.getElementById(dom).focus()
return false
}
var input = getPic(document.getElementById(dom).value)
var exist = document.getElementById(ele).innerHTML
if(exist.match(input) == input){
alert("不可添加重复的内容")
return false
}
document.getElementById(ele).innerHTML+="<font color='red'>评价</font>:"+input+"<br></p>"
}
function getPic(text)
{
return text
}
</script>
<ul id="ulContent_1" style="text-align:left"></ul>
<br>
<form action="" method="post" name="form1">
<p>
<textarea name="txtSendContent_1" id="txtSendContent_1" cols="20" rows="1"></textarea>
</p>
<p>
<input style="width: 60px height: 18px"/ type="button" name="button" id="button" value="评论" onClick="return sendTxt('txtSendContent_1', 'ulContent_1')">
</p>
</form>
<ul id="ulContent_2" style="text-align:left"></ul>
<br>
<form action="" method="post" name="form1">
<p>
<textarea name="txtSendContent_2" id="txtSendContent_2" cols="20" rows="1"></textarea>
</p>
<p>
<input style="width: 60px height: 18px"/ type="button" name="button" id="button" value="评论" onClick="return sendTxt('txtSendContent_2', 'ulContent_2')">
</p>
</form>
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)