dongxia4880 2014-10-24 09:44
浏览 27

从带有数组的html表插入mysql

i search a lot on Stack, try with couple of examples, but no result. Question is probably duplicate, but no one of examples work for me...

So, here is my html page, row.html

<form  id="calx" method="POST" action="obrada.php">
<script>
function addRow(tableID) { 

        var table = document.getElementById(tableID);

        var rowCount = table.rows.length;
        var paki= rowCount+1;
        var row = table.insertRow(rowCount);

        var cell1 = row.insertCell(0);
        var element1 = document.createElement("input");
        element1.type = "checkbox";
        element1.name="chkbox[]";
        cell1.appendChild(element1);

        var cell2 = row.insertCell(1);
        cell2.innerHTML = "<input type='text' name='broj_oper[]' value='"+paki+"'>";

        var cell3 = row.insertCell(2);
        cell3.innerHTML = "<input type='text'  name='oper[]' />";


        }
</script>

     <td><INPUT type="button" value="Add Row" onClick="addRow('dataTable')" /></td>
  <tr>
<td>

<TABLE width="425" border="1">
<thead>
<tr>
<th width="40" align="center"></th>
<th width="94">Broj operacije</th>
<th width="121">Operacija</th>


</tr>
</thead>
<tbody id="dataTable">

</tbody>
</TABLE>

/** PLEASE DON'T TAKE A CARE OF HTML, this is just a part of huge page,and it is all fine **/

I use Js+Html form to create dinamic table,and it work realy good.

Now, on page obrada.php, i use this part of code for insert data into database :

$materijal_upis = $connection->db->prepare("INSERT INTO operacije (id,prva,druga,treca,cetvrta) VALUES ('',?,?,?,?)  ");
                $materijal_upis ->bind_param('ssss',$prva,$druga,$treca,$cetvrta);
                $materijal_upis->execute();

Now, problem is here:

I need to post oper[] from rows.html to obrada.php and store values in this order:

 oper[0]=>$prva
 oper[1]=>$druga
 oper[2]=>$treca
 oper[3]=>$cetvrta

I guess it is a smiple solution, but I am without ideas :)

Tnx, P

  • 写回答

2条回答 默认 最新

  • doujiyun0041 2014-10-24 09:54
    关注

    Use jQuery serialize() before form sending.

    var From = $('form').serialize();          
    
    评论

报告相同问题?

悬赏问题

  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思
  • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
  • ¥15 划分vlan后,链路不通了?
  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
  • ¥15 Vue3 大型图片数据拖动排序
  • ¥15 Centos / PETGEM
  • ¥15 划分vlan后不通了