I'm looking to create a table in html to be used to insert the track listing for a CD album. This is not pull info out of the database but rather to insert new data.
我想用html创建一个表来插入CD专辑的曲目列表。这不是拉出数据库的信息，而是插入新数据。
I don't want to put one by one with a single form but rather do all for that album at once
我不想一个接一个地用一个表格，而是一次为该专辑做所有
Something like this
像这样的东西
How can this be done with HTML and php to be inserted into a mysql db
如何将HTML和php插入到mysql数据库中
I understand this can be done if I put the info into an excel file and upload it to the serever but I want it to be done right on the server
我知道如果我将信息放入excel文件并将其上传到serever但我希望它可以在服务器上完成
2 个解决方案
#1
2
Ok after banging my head around I have discovered what I was after was a CRUD Datagrid.
在敲了敲我的头后，我发现了我之后的CRUD Datagrid。
I have gone with the jqery east ui grid as it the exact thing for my use
我已经使用了jqery east ui网格，因为它确切适用于我
http://www.jeasyui.com/tutorial/app/crud2.php
http://www.jeasyui.com/tutorial/app/crud2.php
This grid is pretty simple to use and all the demo files are available from jquery wich makes it even better.
这个网格使用非常简单，所有的演示文件都可以从jquery获得，这样可以让它变得更好。
A Thanks to PEM for pointing me in the right direction
感谢PEM让我指出了正确的方向
#2
1
I'd recommand looking at Dojo Toolkit DataGrid or dgrid, with stores (jsonRest stores or itemFileWriteStore) for the php side, you'd just have to do a fromJson (json_decode) in your controller, then populate some model object (or directly put the info into db after some cleaning to avoid sql injections).
我建议在php端查看Dojo Toolkit DataGrid或者dgrid，以及商店（jsonRest stores或itemFileWriteStore），你只需要在你的控制器中做一个fromJson（json_decode），然后填充一些模型对象（或直接放入）一些清理后的信息进入db，以避免sql注入）。
#1
2
Ok after banging my head around I have discovered what I was after was a CRUD Datagrid.
在敲了敲我的头后，我发现了我之后的CRUD Datagrid。
I have gone with the jqery east ui grid as it the exact thing for my use
我已经使用了jqery east ui网格，因为它确切适用于我
http://www.jeasyui.com/tutorial/app/crud2.php
http://www.jeasyui.com/tutorial/app/crud2.php
This grid is pretty simple to use and all the demo files are available from jquery wich makes it even better.
这个网格使用非常简单，所有的演示文件都可以从jquery获得，这样可以让它变得更好。
A Thanks to PEM for pointing me in the right direction
感谢PEM让我指出了正确的方向
#2
1
I'd recommand looking at Dojo Toolkit DataGrid or dgrid, with stores (jsonRest stores or itemFileWriteStore) for the php side, you'd just have to do a fromJson (json_decode) in your controller, then populate some model object (or directly put the info into db after some cleaning to avoid sql injections).
我建议在php端查看Dojo Toolkit DataGrid或者dgrid，以及商店（jsonRest stores或itemFileWriteStore），你只需要在你的控制器中做一个fromJson（json_decode），然后填充一些模型对象（或直接放入）一些清理后的信息进入db，以避免sql注入）。