Jump to content

How to populate table with sql data's based on value selected from combo


saravanataee

Recommended Posts

Dear All,

I have a scenario where i want to display database field's with values after selecting the id from combo.

 

For eg:

 

I am having a stock table with stcid as primary key.

 

I have other fields in stock table such as itemname, qty,package,rate,disc,amount etc.

 

What i m looking to do is,

 

In a php form, i want to have a combo alone initially that has to be loaded with available stcid's from db.

 

Based on the id that is selected i want to load the fields dynamically with values from db for that particular id.

 

The point is, i want to show the table field with label and boxes only after i select the id. which means initially my php page will have only the combo box.

 

How can i do this.. Any examples or methods to achieve this??

 

Thanks!

Link to comment
Share on other sites

here's a sample

 

<?php
$mysqli = new mysqli('localhost', 'root', 'maxwell', 'clem');

/**********************
* Get combo item list
* *********************/
$sql = "SELECT id, itemname
    FROM stock
    ORDER BY itemname";
$res = $mysqli->query($sql);
$options = "<option value=''>- Select an item -</option>\n";
while (list($id, $desc) = $res->fetch_row()) {
   $select = (isset($_POST['id']) && $_POST['id']==$id) ? "selected='selected'":'';
   $options .= "<option $select value='$id'>$desc</option>\n";
}
$res->free();

/************************
* Get selected item data
*************************/
$itemdata = 'No item selected';
if (isset($_POST['id'])) {
   $id = intval($_POST['id']);
   $sql = "SELECT *
	    FROM stock
	    WHERE id = $id";
   $res = $mysqli->query($sql);
   $row = $res->fetch_assoc();
   if ($row) {
    $itemdata = "<table cellspacing='4'>\n";
    foreach ($row as $fname=>$val) {
	    $itemdata .= "<tr><td>$fname :</td><td>$val</td></tr>\n";
    }
    $itemdata .= "</table>\n";     
   }
}
?>

<form method="post">
   Stock item <br>
   <select name="id">
    <?php echo $options; ?>
   </select><br>
   <input type="submit" name="btnSubmit" value="Submit">
</form>
<hr>
<?php echo $itemdata ?>

Link to comment
Share on other sites

  • 8 months later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.