<html><head></head><body><?phpif ($name==""){echo "请输入您的姓名";exit;}elseif ($address==""){echo "请输入您的地址";exit;}elseif{echo "请输入您的电话";exit;}elseif ($content==""){echo "请输入内容";exit;}else$conn=mysql_connect("localhost","root", "000000");if (!$conn) {echo "Unable to connect to DB: " . mysql_error();exit;}if (!mysql_select_db("mailbox")) {echo "Unable to select mailbox: " . mysql_error();exit;}$query="insert into sometable values('$name','$address','$tel','$content');$result=mysql_query($query);echo "您的邮件已经成功的加入到数据库！";<?php$conn=mysql_connect("localhost","root","000000");mysql_select_db("mailbox");$del_id=$_GET["id"];$exec="delete from mailbox where id=$del_id";mysql_query($exec, $conn);echo "邮件删除成功!";mysql_close($conn);?>$conn=mysql_connect("localhost","root", "000000");if (!$conn) {echo "Unable to connect to DB: " . mysql_error();exit;}if (!mysql_select_db("mailbox")) {echo "Unable to select mailbox: " . mysql_error();exit;}$sql = "SELECT * FROM sometable";$result = mysql_query($sql);if(!$result){echo "Could not successfully run query ($sql) from DB: ".mysql_error();exit;}if (mysql_num_rows($result) == 0) {echo "No rows found, nothing to print so am exiting";exit;}?><table width="100%" border="0"><tr><td width="30%">ID</td><td width="30%">名字</td><td width="19%">地址</td><td width="19%">电话</td><td width="51%">内容</td></tr><?while ($row = mysql_fetch_assoc($result)) {?><tr><td><? echo $row["id"]; ?></td><td><? echo $row["name"]; ?></td><td><? echo $row["address"]; ?></td><td><? echo $row["tel"]; ?></td><td><? echo $row["content"]; ?></td></tr><?}mysql_free_result($result);mysql_close($conn);?></table></body></html>请高手帮我完善这个程序，实现邮件的插入、删除功能最后显示结果。要能运行成功！O(∩_∩)O谢谢！
1 回答
UYOU
TA贡献1878条经验 获得超4个赞
代码从功能上没什么问题 主要是有点小毛病
1.if ($name=="") 等等 不要直接引用变量，把register global关掉吧，不安全没的说！要用 _GET['name']
2.if ($name=="")
{
echo "请输入您的姓名";
exit;
}
太冗余了，执行效率将受到很大影响。应该这样
try {
if (empty('name')) throw new Exception('姓名未输入！');
if (empty('address')) throw new Exception('地址未输入！');
if (empty('content')) throw new Exception('内容未输入！');
}
catch (Exception $error){
echo '<script language=javascript>alert("'.$error->getMessage().'")</script>';
exit;
}
其它的问题都不大 主要是连接数据库写个函数比较好
function mysqlconn(){
$ip='localhost';//这里改成你的数据库IP
$name='root';//这里是数据库用户名
$pass='XXXXX';//这里是密码
return mysql_connect($ip,$name,$pass)
}
这样调用 $conn=mysqlconn();
为什么要这样做？这会给你后期维护带来极大方便！
还有magic quotes gpc最好开着 否则被注入了可不是好玩的～
- 1 回答
- 0 关注
- 208 浏览
添加回答
举报
0/150
提交
取消