PHP - Default Selected Value In Dropdown

Hi freaks,

 I'm new to php first of all.  I'm dynamically binding a dropdownlist with mysql database . After the user selects an item from it , I want to match that item with another table so as to populate another database.

The code I'm using to populate dropdown:
Code: [Select]
<?php
 $con = mysql_connect("localhost","root","");
if(!$con)
{
  die ('Can not connect to : '.mysql_error());
}
mysql_select_db("ims",$con);
$result=mysql_query("select cat_id,cat_name from category");
echo "<select name=cat>";
while($nt=mysql_fetch_array($result))
{
 echo "<option value=$nt[cat_id]> $nt[cat_name] </option>";
}
echo "</select>";
        mysql_close($con);
  ?>

Now after the user selects any one of the item , I want to bind another dropdown on the same page using such query like
   $result=mysql_query("select subcategory.sc_id,subactegory.sc_name from subcategory,category where subcategory.sc_id=$nt[cat_id]");

Please anyone tell me the logic and code to do it. Also tell me do I need an intermediate page to  post the 1st dropdown value and then continue with 2nd dropdown. I couldn't figure out the concept anyhow.
Help on this will be highly appreiable .
(Tell me if I'm not clear with my question)

Hi guys,

Before we go further, yes, I know I should use prepared statements. This is just a project that will probably never go live. If I do decide to go live, I will change to prepared statements.

Anyways, I am populating a text box from the selection of an options dropdown and updating MySQL. This all works fine. However, what I want to do is have the newly inserted option display by default in the dropdown. Hope this makes sense.

Here is the dropdown code with the select statement...

                         <div class="row form-group">
                          <div class="col-6">
                        <div class="form-group"><label for="location" class=" form-control-label">location</label>
<?php
$sql = "SELECT location_name, location_phone FROM locations";
$result = $con->query($sql);
?>

 <select name="location" id="location" onchange="myFunction()" class="form-control">
<?php

        while($r = mysqli_fetch_row($result))
{
        echo "<option data-location_name='$r[1]'  data-location_phone='$r[2]'  value='$r[0]'> $r[0] </option>";
}
?>

</select>
<label>Phone</label><input type="text" class="form-control" name="location_phone" id="location_name" value = "<?php echo $row['location_phone']; ?>"/>

I am grabbing the location name and phone number from locations. Then inserting them into tours. So after the form is submitted, I want the location name to stay in the dropdown. This is in the table "tours". How do I implement that in here?

Thanks heaps.

Hello all,   For the UPDATE portion of my CRUD WebApp what I would like to do is to bring in (and display) the values (of a selected row) from my transaction table.   This is working just fine for all fields which are of the "input type". The problem I'm having is with two fields which are of the "select type" i.e. dropdown listboxes.   For those two fields, I would like to bring in all the valid choices from the respective lookup/master tables, but then have the default/selected value be shown based on what's in the transaction table. The way I have it right now, those two fields are showing (and updating the record with) the very first entry's in the two lookup tables/select query.   The attached picture might make things a little bit clearer. You'll notice in the top screenshot that the first row (which is the one I'm selecting to update) has a "Store Name" = "Super Store" and an "Item Description" = "Old Mill Bagels". Now, when I click the "update" botton and I'm taken to the update screen, the values for those two fields default to the very first entries in the SELECT resultset i.e. "Food Basics" and "BD Cheese Strings". Cricled in green (to the top-left of that screenshot) is the result of an echo that I performed, based on the values that are in the transaction record.   I cannot (for the life of me) figure out how to get those values to be used as default/selected values for the two dropdown's...so that if a user does not touch those two dropdown fields, the values in the transaction table will not be changed.   Your help will be greatly appreciated.   Here's a portion of the FORM code:  

            <form class="form-horizontal" action="update.php?idnumber=<?php echo $idnumber?>" method="post">
                <?php
                    // Connect to Store_Name (sn) table to get values for dropdown
                    $pdo = Database::connect();
                    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                    $sql = "SELECT DISTINCT store_name FROM store_master ORDER BY store_name ASC";
                    $q_sn = $pdo->prepare($sql);
                    $q_sn->execute();
                    $count_sn = $q_sn->rowCount();        
                    $result_sn = $q_sn->fetchAll();
                    Database::disconnect();

                    // Connect to Item_Description (id) table to get values for dropdown                    
                    $pdo = Database::connect();
                    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                    $sql = "SELECT DISTINCT product_name FROM product_master ORDER BY product_name ASC";
                    $q_id = $pdo->prepare($sql);
                    $q_id->execute();
                    $count_id = $q_id->rowCount();        
                    $result_id = $q_id->fetchAll();
                    Database::disconnect();

                    foreach($fields AS $field => $attr){
                        $current_store_name = $values['store_name'];
                        $current_item_description = $values['item_description'];
                        
                        //Print the form element for the field.
                        if ($field == 'store_name')
                            {
                                echo $current_store_name;
                                echo '<br />';
                                echo $current_item_description;
                            
                                echo '<div class="control-group">';
                                    echo "<label class='control-label'>{$attr['label']}: </label>";
                                    echo '<div class="controls">';                            
                                        //Echo the actual input. If the form is being displayed with errors, we'll have a value to fill in from the user's previous submission.
                                        echo '<select class="store-name" name="store_name">';                                            
                                            // echo '<option value="">Please select...</option>';
                                            foreach($result_sn as $row)
                                                {
                                                    echo "<option value='" . $row['store_name'] . "'>{$row['store_name']}</option>";
                                                }
                                                // $row['store_name'] = $current_store_name;
                                        echo "</select>";

                                    echo '</div>';
                                echo '</div>';
                            }
                        elseif ($field == 'item_description')
                            {
                                echo '<div class="control-group">';
                                    echo "<label class='control-label'>{$attr['label']}: </label>";
                                    echo '<div class="controls">';                            
                                        echo '<select class="item-desc" name="item_description">';
                                            // echo '<option value="">Please select...</option>';
                                            foreach($result_id as $row)
                                                {
                                                    echo "<option alue='" . $row['product_name'] . "'>{$row['product_name']}</option>";
                                                }    
                                        echo "</select>";
                                    echo '</div>';
                                echo '</div>';                                        
                            }
                        else
                            {
                                echo '<div class="control-group">';
                                    echo "<label class='control-label'>{$attr['label']}: </label>";
                                    echo '<div class="controls">';                            
                                        //Echo the actual input. If the form is being displayed with errors, we'll have a value to fill in from the user's previous submission.
                                        echo '<input type="text" name="'.$field.'"' . (isset($values[$field]) ? ' value="'.$values[$field].'"' : '') . ' /></label>';                            
                                    echo '</div>';
                                echo '</div>';                                        
                            }

    And here's some other declarations/code which I think might be required.  

    $fields = array(
        'store_name'         => array('label' => 'Store Name',
                                     'error' => 'Please enter a store name'),
        'item_description'     => array('label' => 'Item Description',
                                     'error' => 'Please enter an item description'),
        'qty_pkg'             => array('label' => 'Qty / Pkg',
                                     'error' => 'Please indicate whether it\'s Qty or Pkg'),
        'pkg_of'             => array('label' => 'Pkg. Of',
                                     'error' => 'Please enter the quantity'),
        'price'             => array('label' => 'Price',
                                     'error' => 'Please enter the price'),
        'flyer_page'         => array('label' => 'Flyer Page #',
                                     'error' => 'Please enter the flyer page #'),
        'limited_time_sale' => array('label' => 'Limited Time Sale',
                                     'error' => 'Please enter the days for limited-time-sale'),
        'nos_to_purchase'     => array('label' => 'No(s) to Purchase',
                                     'error' => 'Please enter the No. of items to purchase')
    );    
 
...
...
....
        {
            // If [submit] isn't clicked - and therfore POST array is empty - perform a SELECT query to bring in
            // existing values from the table and display, to allow for changes to be made
            $pdo = Database::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "SELECT * FROM shoplist where idnumber = ?";
            $q = $pdo->prepare($sql);
            $q->execute(array($idnumber));
            $values = $q->fetch(PDO::FETCH_ASSOC);

            if(!$values)
                {
                    $error = 'Invalid ID provided';
                }        
            Database::disconnect();
        }

    If there's anything I've missed please ask and I'll provide.   Thanks  

I must be missing something simple. I've got this little script that pulls rows from the database to populate a dropdown. If one of them matches a predetermined variable, then I want it to show selected. It's... almost working.

The dropdown prints, and shows the options. But the selected item shows separate, printed just below the dropdown?

Here's what I've got:

Code: [Select]
<?php
$quer3=mysql_query("SELECT discount_id, discount_name,discount_amount FROM tbl_discount order by discount_amount");
echo "&nbsp; &nbsp; <select name='discount_id'><option value=''>Select</option>";
while($row = mysql_fetch_array($quer3)) { 
if($row[discount_id]==$discount_id){echo "<option selected value='".$row[discount_id]."'>".$row[discount_name]."&nbsp; / &nbsp; $".$row[discount_amount]."</option>";}
else{echo  "<option value='$row[discount_id]'>$row[discount_amount]</option>";}
echo "</select>";
} ?>

The rest of my coding works however this part does not and I'm trying to figure out why. I'm sure my syntax isn't right so I hope someone can correct my mistake.


$contentpageID = $_GET['id'];
    $query = "SELECT  
        contentpages.contentpage, 
        contentpages.shortname,
        contentpages.contentcode,
        contentpages.linebreaks, 
        contentpages.backlink,
        contentpages.showheading,
        contentpages.visible,
        contentpages.template_id
    FROM 
        contentpages
    WHERE 
        contentpages.id = '" . $contentpageID . "'";

<label for="template">Template</label>
                <select class="dropdown" name="template" id="template" title="Template">
                <option value="0">- Select -</option>
                <?php
                $query = 'SELECT * FROM templates';
                $result = mysql_query ( $query );
                while ( $template_row = mysql_fetch_assoc ( $result ) ) {
                        print "<option value=\"".$template_row['id']."\" ";
if($template_row['id'] == $row['template_id']) {
     print " SELECTED";
}
                        print ">".$template_row['templatename']."</option>\r";
                }
                ?>
                </select>