How to put information from a bank in a select field in PHP

Question

How to put information from a bank in a select field in PHP

Navigation

#1 by (4 votes)
#2 by (-2 votes)

0

I have a page that connects to the database and brings information correctly, however I would like to put information on a form using the select field, but I'm having some difficulties if someone can help me follow my code.

<?php
require_once 'init.php';

// abre a conexão
$PDO = db_connect();

// SQL para selecionar os registros
$sql = "SELECT cliente FROM clientes";

// seleciona os registros
$stmt = $PDO->prepare($sql);
$stmt->execute();

?>

<html>
<head>
    <meta charset="utf-8">
    <title>Lab</title>
</head>
<body>
    <h1>Lab</h1>

    <?php while ($user = $stmt->fetch(PDO::FETCH_ASSOC)): ?>
    <?php echo $user['cliente'] ?>
    <?php endwhile; ?>

</body>
</html>

php mysql html

asked by anonymous 17.03.2016 / 22:19

2 answers

reversing the average cost of a product How do I connect php to the database of this cadaster? [closed]

score 4 · Answer 1

To make a select with your data:

<select>
  <?php while ($user = $stmt->fetch(PDO::FETCH_ASSOC)) { ?>
      <option value="<?php echo $user['cliente'] ?>">
        <?php echo $user['cliente'] ?>
      </option>
  <?php }  ?>
</select>

score -2 · Answer 2

-2

<select>
<?php 
    while ($user = $stmt->fetch(PDO::FETCH_ASSOC)){
        echo '<option value="'.$user['cliente'].'">'.$user['cliente'].'</option>';
    }
?>
</select>

18.03.2016 / 02:26