Ajax and dynamic select - how to implement?

Question

PHP

! Everything is implemented in php + mysql.

There is a select with an option set, the values ​​for which are unloaded from the database.

While the user is browsing the page, the data in the select can be added. How, without reloading the page completely, but simply by clicking on a certain button, you can update the data in the select?

Thanks in advance for your help.

Answer 1

<select name="my-select">
  <option>...</option>
  <option>...</option>
  <option>...</option>
</select>

// jQuery
var myDynamoSelect = $('select[name="my-select"]');

$.ajax({
    type: "POST",
    url: "some.php",
    data: "name=John&location=Boston",
    success: function ( data ) {
      // empty() чистим HTML в селект
      // html(data) вставляем в select то что ответил сервер (<option>...</option>)
      // пример ответа: <option>...</option><option>...</option><option>...</option>
      myDynamoSelect.empty().html(data);
    }
 });

look for json - php - ajax information

Answer 2

Get the data and insert it into the page.
What exactly are you having problems with?

Answer 3

Make an ajax request to the server, get new data - and insert it into the select.
for example

// Пусть в res хранится ответ от сервера с данными
$('#id вашего селекта').append('<option>'+res+'</option>');