dongyi1939 2016-04-30 20:37
浏览 89
已采纳

如何在一个字段更改的表单数据中输入mySQL中的多行

I've got a form which asks some basic questions about a job, and then asks to person entering to list all those colleagues that were with them at the time. What I want to do is for all colleagues present to have a row entered in to the database - so all the other details remain the same except for their work_id (which is the identifier for the person). My code below seems to submit 1 row to the db with the workID field empty

<?php
require_once('includes/dbconnect.php');

$varWorkID = $_POST['workid'];
$varDate = $_POST['date'];
$varType = $_POST['type'];
$varSuper = $_POST['supervisor'];
$varReference = $_POST['reference'];

//Remove last part of array as extra 1 sent through by form 
$workID = array_pop($varWorkID);

for ($i=0; $i < count($workID); $i++ )
{
    mysqli_query($conn,"INSERT INTO searches (workid,date,type,super,reference) VALUES('".$workID."','".$varDate."','".$varType."','".$varSuper."','".$varReference."')");
}
echo "Completed";

I think I'm fairly close but I just need to get workid to be populated with each of the Work IDs for each of the employees present.

Any assistance greatly appreciated

  • 写回答

1条回答 默认 最新

  • duanfengshang1088 2016-05-01 02:45
    关注

    the problem here is that you're calling $workID = array_pop($varWorkID); before you go into the loop for ($i=0; $i < count($workID); $i++ ), so the PHP interpreter thinks you just want to iterate over the length of that one element. what you actually wanted to do was pop an element off the array while inside the loop.

    <?php
    require_once('includes/dbconnect.php');
    
    $varWorkID = $_POST['workid'];
    $varDate = $_POST['date'];
    $varType = $_POST['type'];
    $varSuper = $_POST['supervisor'];
    $varReference = $_POST['reference'];
    
    
    // iterate over the count of the whole array $varWorkID = $_POST['workid']
    for ($i=0; $i < count($varWorkID); $i++ )
    {
        // now pop off the array inside the loop
        //Remove last part of array as extra 1 sent through by form 
        $workID = array_pop($varWorkID);
        mysqli_query($conn,"INSERT INTO searches (workid,date,type,super,reference) VALUES('".$workID."','".$varDate."','".$varType."','".$varSuper."','".$varReference."')");
    }
    echo "Completed";
    

    now I think @Dima Fitiskin's comment proposes a better approach because you don't really need the expense of calling another function array_pop or throwing another variable on the stack $workID when you've already got an iterated reference to the index $i inside the loop.

    <?php
    require_once('includes/dbconnect.php');
    
    $varWorkID = $_POST['workid'];
    $varDate = $_POST['date'];
    $varType = $_POST['type'];
    $varSuper = $_POST['supervisor'];
    $varReference = $_POST['reference'];
    
    
    // iterate over the count of the whole array $varWorkID = $_POST['workid']
    for ($i=0; $i < count($varWorkID); $i++ )
    {
        mysqli_query($conn,"INSERT INTO searches (workid,date,type,super,reference) VALUES('".$varWorkID[$i]."','".$varDate."','".$varType."','".$varSuper."','".$varReference."')");
    }
    echo "Completed";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型