使用PHP在mySQL中将HTML Form数组插入多行(Insert HTML Form array into multiple rows in mySQL with PHP)

 在编码时我是一个相对新手，但现在已经在一个侧面项目上工作了一段时间。 我的目的是使用HTML表单创建一个报表工具，通过PHP将信息输入MySQL。 对于单场输入，该过程没有问题。 我遇到问题的地方是当我尝试获取一个Form输入表（带有3个字段）并通过在html表单中添加另一行字段来创建数组时（如果有必要），然后将数组插入到多个MySQL中行。 我知道这个主题已经在StackOverflow中出现了几次，我已经阅读了大多数（如果不是全部）这些主题，但由于某些原因，所提供的答案对我不起作用。 
 
 这是我正在使用的代码示例。 这是表格部分： 
 
<form name="weekly" action="process_form.php" method="post">
 
 ... 
 
 售后 - 票证和错误数据 
 
  <div class="form-group">

  <table id="tac" class="form-group" border="1">

    <tbody>

      <tr>

        <p>

          <td class="ticket">

            <label>Customer</label><input type="text" name="customerTac[]" ng-model="customerTac[]" id="customerTac[]" />

          </td>

          <td class="ticket">

          <label>Ticket ID</label> <input type="text" name="tacTicket[]" ng-model="tacTicket[]" id="tacTicket[]">

        </td>

        <td class="comment">

          <label for="tacComments">Ticket Comments</label>

          <input type="text" name="tacComments[]" ng-model="tacComments[]" id="tacComments[]" cols="100">

        </td>

      </p>

      </tr>

    </tbody>

  </table>

  <p><input type="button" value="Add MOS Ticket" onclick="addRow('tac')" />

  </p>
 
 将此信息插入MySQL的process_form.php的PHP文件如下所示： 
 
$sql .= "INSERT INTO tac (date, userid, ticket, customer, comments) ";



foreach (array('tacTicket', 'customerTac', 'tacComments') as $tac) {

    foreach ($_POST[$tac] as $tacTix => $rowTac) {

    $_POST[$tac][$tacTix] = mysqli_real_escape_string($mysqli, $rowTac);



    }

}



    $tacTicket = ($_POST['tacTicket']);

    $customerTac = ($_POST['customerTac']);

    $tacComments = ($_POST['tacComments']);



    $itemsTac = array();

    $sizeTac = count($tacTicket);



   for($iTac = 0 ; $iTac < $sizeTac ; $iTac++) {

  // Check for ticket

    if (empty($tacTicket[$iTac]) || empty($customerTac[$iTac]) || empty($tacComments[$iTac])) {

    continue;

}

    $itemsTac[] = array(

        "tacTicket"     => $tacTicket[$iTac], 

        "customerTac"    => $customerTac[$iTac],

        "tacComments"       => $tacComments[$iTac]

    );

}



    if (!empty($itemsTac)) {

        $valuesTac = array();



        foreach($itemsTac as $itemTac){

            $valuesTac[] = "('{$itemTac['tacTicket']}', '{$itemTac['customerTac']}', '{$itemTac['tacComments']}')";

        }



        $valuesTac = implode(", ", $valuesTac);



        $sql .= "VALUES  (now(), '".$username."', ".$valuesTac.");"; 



    }
 
 我遇到的是当我将字段发布到表单中时： 
 
  
 
 我得到的MySQL命令如下： 
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', ('1206982096', 'test1', 'first test'), ('292526022', 'test2', 'second test'), ('3026909620', 'test3', 'third test')); 
 
 我尝试了多种不同的方式，有时我得到第一组值，有时我会得到所有值。 我最近将INSERT INTO部分移到foreach命令之上，这可能不是一个好主意，但在一天结束时，我希望看到以下情况发生： 
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', '1206982096', 'test1', 'first test'); 
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', '292526022', 'test2', 'second test');
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', '3026909620', 'test3', 'third test');
 
 如果有人对如何实现这一点有任何想法，我将不胜感激。 

I am a relative novice when it comes to coding, but have been working on a side project for a little while now. My intent is to create a reporting tool using HTML forms that input the information into MySQL via PHP. For single field inputs, the process has been no problem. Where I am running into issues is when I attempt to take a Form input table (with 3 fields) and create an array by adding another row of fields in the html form, if they are necessary, and then inserting the array into MySQL in multiple rows. I know this topic has come up a few times in StackOverflow and I have read through most if not all of these topics, but for some reason the answers provided are not working for me. 
 
Here is an example of the code that I am using. This is the form portion:
 
<form name="weekly" action="process_form.php" method="post">
 
...
 
Post Sales - Ticket and Bug Data
 
  <div class="form-group">

  <table id="tac" class="form-group" border="1">

    <tbody>

      <tr>

        <p>

          <td class="ticket">

            <label>Customer</label><input type="text" name="customerTac[]" ng-model="customerTac[]" id="customerTac[]" />

          </td>

          <td class="ticket">

          <label>Ticket ID</label> <input type="text" name="tacTicket[]" ng-model="tacTicket[]" id="tacTicket[]">

        </td>

        <td class="comment">

          <label for="tacComments">Ticket Comments</label>

          <input type="text" name="tacComments[]" ng-model="tacComments[]" id="tacComments[]" cols="100">

        </td>

      </p>

      </tr>

    </tbody>

  </table>

  <p><input type="button" value="Add MOS Ticket" onclick="addRow('tac')" />

  </p>
 
The PHP file of process_form.php to insert this info into MySQL looks like this:
 
$sql .= "INSERT INTO tac (date, userid, ticket, customer, comments) ";



foreach (array('tacTicket', 'customerTac', 'tacComments') as $tac) {

    foreach ($_POST[$tac] as $tacTix => $rowTac) {

    $_POST[$tac][$tacTix] = mysqli_real_escape_string($mysqli, $rowTac);



    }

}



    $tacTicket = ($_POST['tacTicket']);

    $customerTac = ($_POST['customerTac']);

    $tacComments = ($_POST['tacComments']);



    $itemsTac = array();

    $sizeTac = count($tacTicket);



   for($iTac = 0 ; $iTac < $sizeTac ; $iTac++) {

  // Check for ticket

    if (empty($tacTicket[$iTac]) || empty($customerTac[$iTac]) || empty($tacComments[$iTac])) {

    continue;

}

    $itemsTac[] = array(

        "tacTicket"     => $tacTicket[$iTac], 

        "customerTac"    => $customerTac[$iTac],

        "tacComments"       => $tacComments[$iTac]

    );

}



    if (!empty($itemsTac)) {

        $valuesTac = array();



        foreach($itemsTac as $itemTac){

            $valuesTac[] = "('{$itemTac['tacTicket']}', '{$itemTac['customerTac']}', '{$itemTac['tacComments']}')";

        }



        $valuesTac = implode(", ", $valuesTac);



        $sql .= "VALUES  (now(), '".$username."', ".$valuesTac.");"; 



    }
 
What I am running into is when I post the fields into the form:
 
 
The MySQL command I get from this is as follows:
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', ('1206982096', 'test1', 'first test'), ('292526022', 'test2', 'second test'), ('3026909620', 'test3', 'third test')); 
 
I have tried multiple different ways and some times I get the first set of values and other times I will get all values. I recently moved the INSERT INTO portion up above the foreach commands which probably is not a good idea, but at the end of the day, I would like to see the following happen:
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', '1206982096', 'test1', 'first test'); 
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', '292526022', 'test2', 'second test');
 
INSERT INTO tac (date, userid, ticket, customer, comments) 
VALUES (now(), 'Test', '3026909620', 'test3', 'third test');
 
If anyone has any thoughts on how I can accomplish this, I would greatly appreciate it. 

原文：https://stackoverflow.com/questions/35633637