The logic is as follows: I have a data entry form consisting of

<select name="status"> <option value="1">Не выбрано</option> <option value="2">Не женат</option> <option value="3">Не замужем</option> <option value="4">Встречаюсь</option> <option value="5">Помолвлен</option> <option value="6">Женат</option> <option value="7">Замужем</option> <option value="8">В гражданском браке</option> <option value="9">Влюблён</option> <option value="10">Всё сложно</option> <option value="11">В активном поиске</option> </select>

I need the data from select go to the database with the name users in the status field Then the select field to remember the value from the database and not the first value from the select, but the corresponding value that is stored in the database

And, for example, you could display this value in the format:

  <?php echo 'Ваш статус' . 'соответствующее значение из БД'; ?>

Here is the whole code:

  <?php $save = $_POST; if( isset($save['do_login']) ) { mysqli_query($connection, "UPDATE `users` SET `name`='".$save['name']."', `date`='".$save['date']."', `status`='".$save['status']."' WHERE id=$id "); echo '<div style="background-color: green; color: white; font-weight: light; font-size: 17px;">Данные сохранены!</div>'; } ?> <form action="/new.php" method="POST"> <?php $data_save = mysqli_query($connection, "SELECT * FROM `users` WHERE `id`=$id"); if( mysqli_num_rows($data_save) <= 0 ) { echo 'Unexpected error!'; } else { $get_data_user = mysqli_fetch_assoc($data_save); } ?> <input type="text" name="name" placeholder="name" value="<?php echo $get_data_user['name'] ?>"> <input type="text" name="date" placeholder="date" value="<?php echo $get_data_user['date'] ?>"> <p>Статус</p> <select name="status"> <option value="1">Не выбрано</option> <option value="2">Не женат</option> <option value="3">Не замужем</option> <option value="4">Встречаюсь</option> <option value="5">Помолвлен</option> <option value="6">Женат</option> <option value="7">Замужем</option> <option value="8">В гражданском браке</option> <option value="9">Влюблён</option> <option value="10">Всё сложно</option> <option value="11">В активном поиске</option> </select> <button type="submit" name="do_login">Войти</button> </form>

    1 answer 1

    Select is sent the same way as input. Those. access to the selected one goes to $_POST['status'] In order to select this value when selecting data from the database, you must assign the selected field to the corresponding field. You can do this with jQuery / js. On jQuery, it looks like this:

     $('select option[value=' <?php echo $user['user_status']; ?>']').attr('selected', 'selected');
    • Can you tell where to insert this code and how - Alexander_eanautt
    • Tell me, please, I really just need to be new - Alexander_eanautt