将可排序列表转换为查询并检索它并再次显示

Question

Here I have an example of me creating a string using JQuery UI sortable event I wanted to take multiple string like this

$string: item[]=4&item[]=1&item[]=2

And call back a select one to present on a page. I am planning on storing these $string 's in a MySQL table.

Basically how would I receive said $string and and use it to display something in a particular order

Here's a JSfiddle to show you what stage I'm at.

https://jsfiddle.net/mjfncugx/

---

HTML:

<ul id="sortable">
        <li id="item_1">test1</li>
        <li id="item_2">test2</li>
        <li id="item_3">test3</li>
        <li id="item_4">test4</li>
        <li id="item_5">test5</li>
      </ul>
      Query String: <span></span>

JQuery UI

$(document).ready(function() {
  $('ul').sortable({
    axis: 'y',
    stop: function(event, ui) {
      var data = $(this).sortable('serialize');
      $('span').text(data);
      /*$.ajax({
          data: oData,
          type: 'POST',
          url: '/your/url/here'
      });*/
    }
  });
});

Answer 1

When you are saving in Db just use this

str_replace('[]=', '_', 'item[]=2&item[]=1&item[]=3&item[]=4&item[]=5');

AFter inserting..

I am assuming that $data = item_2&item_1&item_3&item_4&item_5; which is coming from DB.

<?php
$data = !empty($data) ? explode('&', $data) : '';
?>


<ul id="sortable">
<?php
    if(!is_array($data))
    {
?>
    <li id="item_1">test1</li>
    <li id="item_2">test2</li>
    <li id="item_3">test3</li>
    <li id="item_4">test4</li>
    <li id="item_5">test5</li>
    <?php
    } else {
    ?>
        foreach($data as $data_row)
        {
            ?>
            <li id="<?= $data_row ?>"><?= str_replace('_', '', $data_row); ?></li>
            <?php
        }
    <?php
    }
    ?>
</ul>

There might be some syntax error if so please correct it.