SELECT Dynamic and option selected by default

Question

SELECT Dynamic and option selected by default

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

I am completely new and without any experience, I indicate: As shown in the image I already made the SQL query so that the countries from the database are loaded to the SELECT of my page, now I want to leave selected by default a Country (for example, ECUADOR) how do I make this country selected in the cycle? Thanks (html5, php)

html5 php select

asked by dmlisto 18.06.2017 в 01:12

source

2 answers

Update a record in a table and from this create a record in another table What is a class variable and an instance variable?

score 0 · Answer 1

0

change:

<option selected disabled>seleccione un pais</option>

for

<option selected>Ecuador</option>

<select>
  <option selected>Ecuador</option>
  <option>Rusia</option>
</select>

answered by 18.06.2017 в 02:26

score 0 · Answer 2

Based on your code and using an alternative notation for the while

<?php
$sql_consulta = 'SELCT * FROM pais ORDER BY nombre';
$consulta = mysqli_query($cone, $sql_consulta) or die(mysqli_errno());
?>
<select name="pais" id="pais">
    <option disabled>Selecciona un Pais</option>
    <?php while ($fila = $consulta->fetch_assoc()): ?>
        <?php $atributo = ($fila['nombre'] == $nombre) ? 'selected' : '' ?>
        <option <?= $atributo ?> ><?= $fila['nombre'] ?></option>
    <?php endwhile; ?>
</select>

The line that does everything is this

<?php $atributo = ($fila['nombre'] == $nombre) ? 'selected' : '' ?>

since if the name value of the row is the name you are looking for it assigns 'selected' otherwise it assigns empty.