以下代码我实现了 单条数据 在鼠标失去焦点后自动保存数据库 可是我的数据是
<input name="name1[]" type="hidden" value=""/><input name="name2[]" type="hidden" value=""/>
<input name="name1[]" type="hidden" value=""/><input name="name2[]" type="hidden" value=""/>
<input name="name1[]" type="hidden" value=""/><input name="name2[]" type="hidden" value=""/>
.......这样多条重名的input 请好心人帮帮我
---ooo-----ooooo-----------oooooooo-oooo
代码如下::
index.php<?php
$res = mysql_query("select * from demo where state = 0 order by id desc limit 1");
$row=mysql_fetch_array($res);
?>
<head>
<script src="js.js"></script>
<meta http-equiv="Content-Type" content="text ml; charset=utf-8" />
</head>
<body>
<form action="submit.php" action="POST">
<input id="userid" name="userid" type="hidden" value="<?php echo $row['id']?>"/>
XX:<input id="user" name="user" type="text" value="<?php echo $row['user']?>" onBlur="update(this.value)"/><br/>
XX:<input id="age" name="age" type="text" value="<?php echo $row['age']?>" onBlur="update(this.value)"/><br/>
XX:<input id="address" name="address" type="text" value="<?php echo $row['address']?>" onBlur="update(this.value)"/><br/>
<input type="submit" value="确定" />
<span id="txtHint"></span>
</form>
</body>
js.jsvar xmlHttp
function update(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML=""
return
}
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var userid = document.getElementById("userid").value;
var user = document.getElementById("user").value;
var age = document.getElementById("age").value;
var address = document.getElementById("address").value;
//更新页面及参数
var url="update.php"
url=url+"?userid="+userid
url=url+"&user="+user
url=url+"&age="+age
url=url+"&address="+addressxmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtHint").innerHTML=xmlHttp.responseText
}
}
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
submit.php
<?php
if($_GET['userid']!=''){
mysql_query("update demo set state=1 where id=".$_GET['userid']);
}header("location:index.php");
?>
update>php
<?php$id = $_GET['userid'];
$user = $_GET['user'];
$age = $_GET['age'];
$address = $_GET['address'];
mysql_connect("127.0.0.1","root","root");
mysql_select_db("test");$res = mysql_query("select * from demo where state = 0 order by id desc limit 1");
$row=mysql_fetch_array($res);if($row['id']!=''){
mysql_query("update demo set user='$user',age='$age',address='$address' where id = ".$row['id'].";");
}
else{
mysql_query("insert into demo(user,age,address) values('$user','$age','$address');");
}
?>
<input name="name1[]" type="hidden" value=""/><input name="name2[]" type="hidden" value=""/>
<input name="name1[]" type="hidden" value=""/><input name="name2[]" type="hidden" value=""/>
<input name="name1[]" type="hidden" value=""/><input name="name2[]" type="hidden" value=""/>
.......这样多条重名的input 请好心人帮帮我
---ooo-----ooooo-----------oooooooo-oooo
代码如下::
index.php<?php
$res = mysql_query("select * from demo where state = 0 order by id desc limit 1");
$row=mysql_fetch_array($res);
?>
<head>
<script src="js.js"></script>
<meta http-equiv="Content-Type" content="text ml; charset=utf-8" />
</head>
<body>
<form action="submit.php" action="POST">
<input id="userid" name="userid" type="hidden" value="<?php echo $row['id']?>"/>
XX:<input id="user" name="user" type="text" value="<?php echo $row['user']?>" onBlur="update(this.value)"/><br/>
XX:<input id="age" name="age" type="text" value="<?php echo $row['age']?>" onBlur="update(this.value)"/><br/>
XX:<input id="address" name="address" type="text" value="<?php echo $row['address']?>" onBlur="update(this.value)"/><br/>
<input type="submit" value="确定" />
<span id="txtHint"></span>
</form>
</body>
js.jsvar xmlHttp
function update(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML=""
return
}
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var userid = document.getElementById("userid").value;
var user = document.getElementById("user").value;
var age = document.getElementById("age").value;
var address = document.getElementById("address").value;
//更新页面及参数
var url="update.php"
url=url+"?userid="+userid
url=url+"&user="+user
url=url+"&age="+age
url=url+"&address="+addressxmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtHint").innerHTML=xmlHttp.responseText
}
}
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
submit.php
<?php
if($_GET['userid']!=''){
mysql_query("update demo set state=1 where id=".$_GET['userid']);
}header("location:index.php");
?>
update>php
<?php$id = $_GET['userid'];
$user = $_GET['user'];
$age = $_GET['age'];
$address = $_GET['address'];
mysql_connect("127.0.0.1","root","root");
mysql_select_db("test");$res = mysql_query("select * from demo where state = 0 order by id desc limit 1");
$row=mysql_fetch_array($res);if($row['id']!=''){
mysql_query("update demo set user='$user',age='$age',address='$address' where id = ".$row['id'].";");
}
else{
mysql_query("insert into demo(user,age,address) values('$user','$age','$address');");
}
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货