Skip navigation links

MySQL Forums :: PHP :: query mysql and pass array to a form to create dynamic drop down list in PHP


Advanced Search

query mysql and pass array to a form to create dynamic drop down list in PHP
Posted by: NOT_FOUND NOT_FOUND ()
Date: January 22, 2013 08:40AM

I am new to PHP mysql progamming, so please excuse me if I am doing something silly.


My objective is to create a form that presents a drop down list, which is dynamically populated based on a query from a mysql database. I have the main controller (sell.php), which should query the database and then should pass an array to the form called sell_form.php.

The form seems to be working ok when I define the array within the form manually or even within the controller manually. So, it seems that somehow when I am querying the database and trying to build the array, I am doing something wrong.

Hopefully, someone can point me to the right direction.

content of sell_form.php :


<form action="sell.php" method="post">
<?php
// $stocksym = array(5,6,7);
?>
<fieldset>
<div class="control-group">
<?php
echo '<select>';
foreach ($stocksym as $key => $value)
{
echo "<option value=$key> $value </option>";
}
echo '</select>';
?>

</div>
<div class="control-group">
<button type="submit" class="btn">Sell</button>
</div>
</fieldset>
</form>




The relevant content of sell.php (this is where I beleive I am doing something wrong):


$rows = query("SELECT * FROM portfolio WHERE id = ?", $_SESSION["id"]);
foreach ($rows as $row))
{
$stocksym = $row["symbol"];
}


The relevant mysql table is:


mysql> select * from portfolio;
+----+--------+--------+
| id | symbol | shares |
+----+--------+--------+
| 1 | AAPL | 2 |
| 1 | MSFT | 15 |
+----+--------+--------+
2 rows in set (0.00 sec)

Options: ReplyQuote


Subject Written By Posted
query mysql and pass array to a form to create dynamic drop down list in PHP NOT_FOUND NOT_FOUND 01/22/2013 08:40AM
Re: query mysql and pass array to a form to create dynamic drop down list in PHP Peter Brawley 01/22/2013 11:43AM
Re: query mysql and pass array to a form to create dynamic drop down list in PHP NOT_FOUND NOT_FOUND 01/22/2013 06:09PM
Re: query mysql and pass array to a form to create dynamic drop down list in PHP laptop alias 01/24/2013 06:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.