使用Foreach进行MYSQL INSERT

Question

When I want to add

data1 sum1
data2 sum2

to database, what is actually happening :

data1 data1
sum1 sum1
data2 data2
sum2 sum2

My form element is;

<input id="alan_" name="alanlar[]" type="text" class="form-control">
<input id="miktar_" name="alanlar[]" type="text" class="form-control">

And PHP;

foreach ($_POST['alanlar'] as $key => $value) {

            $baglanti->query(sprintf("INSERT INTO ders (ders_adi, ders_miktar) VALUES ('%s','%s')", ($value),($value)));
            $eklenen_ders_id = $baglanti->insert_id;

Jquery Code :

var sayac = 1;
    $(function () {
        $('#ekle').click(function () {
            sayac += 1;
            $('#dersler tbody').append(
                '<tr><th><strong>Ders ' + sayac + '</strong></th><td><input id="alan_' + sayac + '" name="alanlar[]' + '" type="text" class="form-control" /></td><td><input id="miktar_' + sayac + '" name="alanlar[]' + '" type="text" class="form-control" /></td><td><a href="#" class="sil btn btn-danger">Sil</a></td></tr> ');
        });

Thanks all.

Answer 1

Setting up the form control names sensibly greatly enhanced the form data processing on the server:

HTML

<input name="alanlar[0][alan]" type="text" class="form-control">
<input name="alanlar[0][miktar]" type="text" class="form-control">
<input name="alanlar[1][alan]" type="text" class="form-control">
<input name="alanlar[1][miktar]" type="text" class="form-control">
<!-- etc. -->

PHP

foreach ($_POST['alanlar'] as $set) {
  $alan = $set['alan'];
  $miktar = $set['miktar'];
  // ...
}