主要功能:可以在当前位置,实时的修改数据库里的内容,不用提交到另外一个页面。
有很多的不足之处,希望大家能帮我完善一下,在下先谢过了。
文件abc.php
1 require_once('Connections/temp.php');
1
2/*
3#
4# 数据表的结构 `temp`
5#
6
7CREATE TABLE temp (
8id int(3) NOT NULL auto_increment,
9name char(10) default NULL,
10PRIMARY KEY (id),
11KEY id (id)
12) TYPE=MyISAM;
13*/
14mysql_select_db($database_temp, $temp);
15if(isset($delete)&& isset($menuname)){
16$query="delete from temp where name='".$menuname."'";
17$result=mysql_query($query,$temp) or die(mysql_error());
18if(!$result)
19echo "
<script>alert('删除失败,请重试!')</script>
1";
2}
3$query_Recordset1 = "SELECT * FROM temp ORDER BY id ASC";
4$Recordset1 = mysql_query($query_Recordset1, $temp) or die(mysql_error());
5$row_Recordset1 = mysql_fetch_assoc($Recordset1);
6$totalRows_Recordset1 = mysql_num_rows($Recordset1);
1<html>
2<head>
3<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
4<title>实时动态修改,添加,删除</title>
5</head>
6<body>
7<!--右键菜单开始//-->
8<div id="menu" onmouseup="this.style.display='none'" style="position:absolute; z-index:1;display:none">
9<table bgcolor="#FFFFFF" border="1" bordercolor="#666666" cellpadding="0" cellspacing="1" width="80">
10<tr>
11<td align="center" bgcolor="#FFFFFF" bordercolordark="000000" bordercolorlight="ffffff"><a href="javascript:add()"><font color="#000000">添加</font></a></td>
12</tr>
13<tr>
14<td align="center" bgcolor="#FFFFFF" bordercolordark="000000" bordercolorlight="ffffff"><a href="javascript:modify()"><font color="#000000">修改</font></a></td>
15</tr>
16<tr>
17<td align="center" bgcolor="#FFFFFF" bordercolordark="000000" bordercolorlight="ffffff"><a href="javascript:deletemenu()"><font color="#000000">删除</font></a></td>
18</tr>
19</table>
20</div>
21<!--右键菜单结束//-->
22<table border="1" bordercolor="#FF00FF" cellpadding="3" cellspacing="0" id="tbl" width="200">
if ($totalRows_Recordset1 > 0) { // Show if recordset not empty
do {
1<tr>
2<td id="```
3 echo td.$row_Recordset1['id'];
4```">```
5 echo $row_Recordset1['name'];
6```</td>
7</tr>
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
}else{ // Show if recordset not empty
1<tr><td id="td0">数据库中无记录....</td></tr>
}
1</table>
2<script language="JavaScript"></script></body></html>