doujingdai5521 2018-05-02 05:50
浏览 98
已采纳

如何在mysql数据库中插入两个不同的数组?

Okay now i have 2 input field on checkbox and one more is input text like this

<input type="text" name="student[]">
<input type="checkbox" name="marks[]">

Now i want to insert the all data in the database.How to insert simultaneously.

this is the example of php want but only one array

foreach($student as $value){

    $sql = "INSERT INTO `academic` ('student', `mark`) VALUES ('$value','mark')";

        if(mysqli_query($conn, $sql)){
            echo "Insert mark for student ".$value." complete<br>";
        } else {
            echo "Error: " . mysqli_error($conn);
        }
    }

how to make it can insert 2 different array simultaneously?

  • 写回答

4条回答 默认 最新

  • douzinei6926 2018-05-02 06:34
    关注

    In this case you can use 2nd foreach for second array like

    foreach($student as $value){
     foreach($marks as $singlemarks){
    
        $sql = "INSERT INTO `academic` ('student', `mark`) VALUES ('$value','$singlemarks')";
    
            if(mysqli_query($conn, $sql)){
                echo "Insert mark for student ".$value." complete<br>";
            } else {
                echo "Error: " . mysqli_error($conn);
            }
         }
        }
    

    and you can also convert array in json for store multi array in database like json_encode($array) and same as you can decode when you want to use it

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

悬赏问题

  • ¥15 C++/QT设置函数调用条件(多个功能调用同一,且各自调用条件不同)
  • ¥15 UE5样条线生成的网格UV问题
  • ¥15 如何用最短的时间大致看懂springboot+vue的项目
  • ¥15 (有偿)懂数值分析和含时变参数微分方程的来
  • ¥15 abaqus随机生成二维颗粒
  • ¥15 安装ansys许可证管理器时出现了这个问题,如何解决?
  • ¥100 高价求算法,利用智能手机传感器计算车辆的三轴g值
  • ¥15 Blazor server 数据库操作异常,如何解决?(语言-c#)
  • ¥15 uni-app开发APP运行到浏览器访问接口跨域
  • ¥100 mfc消息自创建控件