PHP 使用 foreach post 向 mysql 添加多个数据 - Php use foreach post to add multiple data to mysql

Php use foreach post to add multiple data to mysql

您好，我有以下JavaScript，它可以填充我的字段并且工作正常

<script type="text/javascript">
var count = 0;
$(function(){
$('p#add_field2').click(function(){
    count += 1;
    $('#container').append(
            '<strong>Link #' + count + '</strong><br />'
            + '<input id="field_' + count + '" name="fields[]' + '" type="text" /><input     id="field1_' + count + '" name="idrima' + '" type="text" /><input id="field2_' + count + '" name="code_title' + '" type="text" /><input id="field3_' + count + '" name="name_title' + '" type="text" /><input id="field4_' + count + '" name="vathmos_title_a' + '" type="text" /><input id="field5_' + count + '" name="vathmos_title_d' + '" type="text" /><input id="field6_' + count + '" name="etos' + '" type="text" /><br />');
});
});
</script>

我的问题是，当我使用 foreach 时，我只能添加最后一个字段填充，而不是全部。所以我认为foreach不起作用，因为只添加最后一条记录。我的代码是

if ($_POST['fields']) {
    //get last inserted userid
    $inserted_user_id = $db->last_insert_id();
    //Loop through added fields
    foreach ( $_POST['fields'] as $key=>$value ) {
        //Insert into websites table
        $sql_website = sprintf("INSERT INTO spoudes (idrima,code_title) VALUES ('%s','%s')",
                    mysql_real_escape_string($_POST['idrima']),
                    mysql_real_escape_string($_POST['code_title']));
        $result_website = $db->query($sql_website);
        $inserted_website_id = $db->last_insert_id();

        //Insert into users_websites_link table
        $sql_users_website = sprintf("INSERT INTO spoudes_link (id_fakelos, id_spoudes) VALUES ('%s','%s')",
                               mysql_real_escape_string($inserted_user_id),
                               mysql_real_escape_string($inserted_website_id) );
        $result_users_website = $db->query($sql_users_website);

    }

您应该

使用 <input name="idrima[]"> 和 <input name="code_title">，因为每次添加新字段时，它都会覆盖帖子中的该字段。

foreach ( $_POST['fields'] as $key=>$value ) {
    //Insert into websites table
    $sql_website = sprintf("INSERT INTO spoudes (idrima,code_title) VALUES ('%s','%s')",
                mysql_real_escape_string($_POST['idrima'][$key]),
                mysql_real_escape_string($_POST['code_title'][$key]));
    $result_website = $db->query($sql_website);
    $inserted_website_id = $db->last_insert_id();

    //Insert into users_websites_link table
    $sql_users_website = sprintf("INSERT INTO spoudes_link (id_fakelos, id_spoudes) VALUES ('%s','%s')",
                           mysql_real_escape_string($inserted_user_id),
                           mysql_real_escape_string($inserted_website_id) );
    $result_users_website = $db->query($sql_users_website);

}