Fill a dropdown list with query result from php table

Question

I've been trying to populate a dropdown list with results from a query using php from a mysql table but the list is empty. Could someone please take a look at my code and tell me what it is that I'm doing wrong.

My query is Select cat from kernel

I used the code : $results = $query->fetchAll();

Heres my code:

<?php

$dbhandle = new PDO('host','username','password');


$sql = "SELECT cat FROM kernel";
$results = $query->fetchAll();

echo "<select name='cat'>";
while ($row = mysql_fetch_array($result)) {
echo "<option value='" . $row['cat'] . "'>" . $row['cat'] . "</option>";
}
echo "</select>";

?>

are there results in your query? If so you're going to need to post a lot more code before we can help. — Matt Busche
– Matt Busche, Commented Mar 31, 2014 at 2:35
This is a duplicate. Check here: stackoverflow.com/questions/5327235/… — broinjc
– broinjc, Commented Mar 31, 2014 at 2:36
Is your query already working? Nobody will solve your problem entirely.. you must provide more information! I Suggest you to google a litle bit more! :P — Elias Soares
– Elias Soares, Commented Mar 31, 2014 at 2:37
you're off to a good start, now do something with the results. :) — Bryan
– Bryan, Commented Mar 31, 2014 at 2:37

Community · Accepted Answer · 2023-11-20 22:45:59Z

0

<?php

$sth = $dbhandle->prepare("SELECT cat FROM kernel");
$sth->execute();
$results = $sth->fetchAll(PDO::FETCH_ASSOC);

echo "<select name='cat'>";
foreach($results as $row) {
    echo "<option value='" . $row['cat'] . "'>" . $row['cat'] . "</option>";
}    
echo "</select>";

?>

https://www.php.net/manual/en/pdostatement.fetchall.php

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Mar 31, 2014 at 2:45

broinjc

2,7094 gold badges30 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aab Over a year ago

Thanks it worked! there is an extra bracket close at the line: "$results = $sth->fetchAll(PDO::FETCH_ASSOC));" which should be "$results = $sth->fetchAll(PDO::FETCH_ASSOC);"

Collectives™ on Stack Overflow

Fill a dropdown list with query result from php table

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related