想了好一段时间,终于让我想出来了。不过功能不太完善,希望大家帮我修一修改一改。

主要功能:可以在当前位置,实时的修改数据库里的内容,不用提交到另外一个页面。
有很多的不足之处,希望大家能帮我完善一下,在下先谢过了。
文件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 &gt; 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>
Published At
Categories with Web编程
comments powered by Disqus