php 点击按钮 update mysql function_求助如何点击按钮更新数据？

我希望点击“updqte”按钮后按钮变成“save”，然后单元格变成文本框，编辑完文本框后点击“save”结果提交给了数据库。按钮改变用js做完了，其他的实在是不回了，各位大神帮帮忙吧。/p>

"http://www.w3.org/TR/html4/loose.dtd">

content="text/html;

charset=UTF-8">

Insert title here

$db = mysql_connect('localhost','root','root');

mysql_select_db('ec',$db);

if (!$db)

{

die('Could not connect: ' . mysql_error());

}

$result = mysql_query("select * from goods");

echo "

GoodsIDBarCodeGoodsNameCategorySpecificationsManufacturersNumbersInstructionsPicturesUpdateDelete";

$n = 0;while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['id'] . ""; echo "" . $row['barcode'] . "";

echo "

" . $row['goods_name'] . "";

echo "

" . $row['category'] . "";

echo "

" . $row['specifications'] . "";

echo "

" . $row['manufacturers'] . "";

echo "

" . $row['number'] . "";

echo "

" . $row['instruction'] . "";

echo "

" . " " . "";

echo "

".

"".

"

".

"

".

"".

"

"; echo ""." "."Delete".""."";

echo "

";

++$n;

}

mysql_close($db);

?>

回复讨论(解决方案)

1.给你的save按钮一个onclick方法 点击后触发

2.用ajax 提交参数到后台，调用php程序

3.然后将接收内容提交到数据库

4.成功or失败返回到页面

你这里要用到ajax来提交数据

1.给你的save按钮一个onclick方法 点击后触发

2.用ajax 提交参数到后台，调用php程序

3.然后将接收内容提交到数据库

4.成功or失败返回到页面/p>

"http://www.w3.org/TR/html4/loose.dtd">

content="text/html; charset=UTF-8">

Insert title here

$db = mysql_connect('localhost','root','root');

mysql_select_db('ec',$db);

if (!$db)

{

die('Could not connect: ' . mysql_error());

}

$result = mysql_query("select * from goods");

echo "

GoodsIDBarCodeGoodsNameCategorySpecificationsManufacturersNumbersInstructionsPicturesUpdateDelete";

$n = 0;

while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['id'] . "";

echo "

" . $row['barcode'] . "";

echo "

" . $row['goods_name'] . "";

echo "

" . $row['category'] . "";

echo "

" . $row['specifications'] . "";

echo "

" . $row['manufacturers'] . ""; echo "" . $row['number'] . "";

echo "

" . $row['instruction'] . "";

echo "

" . " " . "";

echo "

".

"".

"

".

"

".

"".

"

";

echo "

"." "."Delete".""."";

echo "

";

++$n;

}

mysql_close($db);

?>

我表上红色的部分是一个数组，我想让这个数组变成动态的，要不然所有按钮都只操作一条数据。有什么好办法没？

1.给你的save按钮一个onclick方法 点击后触发

2.用ajax 提交参数到后台，调用php程序

3.然后将接收内容提交到数据库

4.成功or失败返回到页面

不好意思是第24行，刚才没标上颜色。

要是我做的话就是都设为隐藏的

一个.show()

一个.hide()

当点击完一个操作就触发函数转换到另一个按钮

建议lz选择jq选择器都很强大

搭配ajax 足够完成大量input提交工作

你这里要用到ajax来提交数据/p>

"http://www.w3.org/TR/html4/loose.dtd">

content="text/html; charset=UTF-8">

Insert title here

$db = mysql_connect('localhost','root','root');

mysql_select_db('ec',$db);

if (!$db)

{

die('Could not connect: ' . mysql_error());

}

$result = mysql_query("select * from goods");

echo "

GoodsIDBarCodeGoodsNameCategorySpecificationsManufacturersNumbersInstructionsPicturesUpdateDelete";

$n = 0;

while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['id'] . "";

echo "

" . $row['barcode'] . "";

echo "

" . $row['goods_name'] . "";

echo "

" . $row['category'] . "";

echo "

" . $row['specifications'] . "";

echo "

" . $row['manufacturers'] . "";

echo "

" . $row['number'] . "";

echo "

" . $row['instruction'] . "";

echo "

" . " " . "";

echo "

".

"".

"

".

"

".

"".

"

";

echo "

"." "."Delete".""."";

echo "

";

++$n;

}

mysql_close($db);

?>

第24行的那个数组能不能改成动态的，要不然所有按钮都只操作同一条数据，应该怎么改啊？

updatesave

刚才描述的不是很清楚 写了个测试的代码 你可以参考

XML/HTML code

?

12345678910111213141516171819202122