动态属性和值保存到数据库

Question

I have a database table like :

id | title | Url

And i have a form like the screenshot...

i have tried like that

<div class="col-md-6">
  <input type="text" class="form-control " style="border-radius: 0px;" placeholder="Tittle" id="slider" name="title[]">
</div>
<div class="col-md-6">
  <input type="text" class="form-control col-md-6" style="border-radius: 0px;" placeholder="Link" id="slider" name="url[]">
</div>

And the submission result is :

Array
(
    [0] => Array
        (
            [title] => test1
        )

    [1] => Array
        (
            [url] => #1
        )

    [2] => Array
        (
            [title] => test2
        )

    [3] => Array
        (
            [url] => #2
        )

    [4] => Array
        (
            [title] =>title3
        )

    [5] => Array
        (
            [url] => #3
        )

)

The problem is i cannot filter which url for the title1,and which for the title 2 etc..

Is there any way to have the result like this array?

Array
(
    [0] => Array
        (
            [title] => test1,
            [url] => #1

        )

    [1] => Array
        (
            [title] => test2,
            [url] => #2
        )

    [2] => Array
        (
            [title] => test3,
            [url] => #3
        )


  )

Answer 1

The name of each field should end with [] For example

<input type="text" class="form-control " style="border-radius: 0px;" placeholder="Tittle" id="slider" name="titles[name][]">

This will make them available in an array in your PHP script, which you can then just iterate over, forming your query.

  $Q = 'insert into mytable (name, value) values ';
  $V = [];

  foreach ($titles as $idx => $title) {
    $V[] = "('".$title['name']."','".$title['value']."')";
  }
  $Q.= implode(',', $V);

[EDIT]

OK, make your fields look something like this

<INPUT TYPE=TEXT NAME="data[title][]">
<INPUT TYPE=TEXT NAME="data[url][]">

Then output it and see what you've got, and the PHP code above should help you form your query.