douyangqian5243 2017-03-06 09:30
浏览 23

如何插入多个表数组

I'm trying to insert data a form 4 table normal insert finish but data array cannot query. Could you help me, please? 

Code:

for ($i = 1; $i <= (int)$_POST["hdnCount"]; $i++) {
    $sql = "INSERT INTO status_b(emp_id,name_baby,date_baby,status_baby,class,age,id_card_baby,stay) VALUES ('" . $_POST["emp_id$i"] . "','" .
            $_POST["name_baby$i"] . "','" .
            $_POST["date_baby$i"] . "','" .
            $_POST["status_baby$i"] . "','" .
            $_POST["class$i"] . "','" .
            $_POST["age$i"] . "','" .
            $_POST["id_card_baby$i"] . "','" .
            $_POST["stay$i"] . "');";
}

$sql = "INSERT INTO personal (st_date,emp_id,emp_date,division,department,sc,name_th,lname_th,blood,name_en, lname_en,per_date,id_card,exp_card,id_fund,date_fund,rate,acc_id,name_bank, m_bank,add_h,district_h,amphoe_h,province_h,add_n,district_n,amphoe_n,province_n, tel_home,tel,images,education,e_major,institution,name_e,tel_e)
VALUES('" . $_POST["st_date"] . "','" .
        $_POST["emp_id"] . "','" .
        $_POST["emp_date"] . "','" .
        $_POST["division"] . "','" .
        $_POST["department"] . "','" .
        $_POST["sc"] . "','" .
        $_POST["name_th"] . "','" .
        $_POST["lname_th"] . "','" .
        $_POST["blood"] . "','" .
        $_POST["name_en"] . "' ,'" .
        $_POST["lname_en"] . "','" .
        $_POST["per_date"] . "','" .
        $_POST["id_card"] . "','" .
        $_POST["exp_card"] . "','" .
        $_POST["id_fund"] . "','" .
        $_POST["date_fund"] . "','" .
        $_POST["rate"] . "','" .
        $_POST["acc_id"] . "','" .
        $_POST["name_bank"] . "' ,'" . 
        $_POST["m_bank"] . "','" .
        $_POST["add_h"] . "','" .
        $_POST["district_h"] . "','" .
        $_POST["amphoe_h"] . "','" .
        $_POST["province_h"] . "','" .
        $_POST["add_n"] . "','" .
        $_POST["district_n"] . "','" .
        $_POST["amphoe_n"] . "','" .
        $_POST["province_n"] . "' ,'" . 
        $_POST["tel_home"] . "','" .
        $_POST["tel"] . "','" .
        $_POST["images"] . "','" .
        $_POST["education"] . "','" .
        $_POST["e_major"] . "','" .
        $_POST["institution"] . "','" .
        $_POST["name_e"] . "','" .
        $_POST["tel_e"] . "');";

$sql .= "INSERT INTO status (name_m,lname_m,date_m,id_card_m,date_r,location,tel_m,status,mary,num_baby)
VALUES
('" . $_POST["name_m"] . "','" .
        $_POST["lname_m"] . "','" .
        $_POST["date_m"] . "','" .
        $_POST["id_card_m"] . "','" .
        $_POST["date_r"] . "','" .
        $_POST["location"] . "','" .
        $_POST["tel_m"] . "','" .
        $_POST["status"] . "','" .
        $_POST["mary"] . "','" .
        $_POST["num_baby"] . "');";



$sql .= "INSERT INTO tax (f_name,f_id,f_date,claim_f,mf_name,mf_id,mf_date,claim_mf,mm_name,
mm_id,mm_date,claim_mm,insurance,num_in,insurance_l,num_inl,unit,num_un,interest,
num_int,support,num_su,donate,num_do,buy,num_b,other,num_o)
VALUES
('" . $_POST["f_name"] . "','" .
        $_POST["f_id"] . "','" .
        $_POST["f_date"] . "','" .
        $_POST["claim_f"] . "','" .
        $_POST["mf_name"] . "','" .
        $_POST["mf_id"] . "','" .
        $_POST["mf_date"] . "','" .
        $_POST["claim_mf"] . "','" .
        $_POST["mm_name"] . "','" .
        $_POST["mm_id"] . "','" .
        $_POST["mm_date"] . "','" .
        $_POST["claim_mm"] . "','" .
        $_POST["insurance"] . "','" .
        $_POST["num_in"] . "','" .
        $_POST["insurance_l"] . "','" .
        $_POST["num_inl"] . "','" .
        $_POST["unit"] . "','" .
        $_POST["num_un"] . "','" .
        $_POST["interest"] . "','" .
        $_POST["num_int"] . "','" .
        $_POST["support"] . "','" .
        $_POST["num_su"] . "','" .
        $_POST["donate"] . "','" .
        $_POST["num_do"] . "','" .
        $_POST["buy"] . "','" .
        $_POST["num_b"] . "','" .
        $_POST["other"] . "','" .
        $_POST["num_o"] . "');";



if (mysqli_multi_query($conn, $sql)) {
    echo "New records created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 关于大棚监测的pcb板设计
    • ¥15 stm32开发clion时遇到的编译问题
    • ¥15 lna设计 源简并电感型共源放大器
    • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)
    • ¥15 Vue3地图和异步函数使用
    • ¥15 C++ yoloV5改写遇到的问题
    • ¥20 win11修改中文用户名路径
    • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入