CODEWITHSUNDEEP
javascriptphpmysqlcombobox
Crossyde
Crossyde

Reputation: 5

Insert from combo box using php

I am populating a combo box from database, the problem is when I select an item from the combo box and try to save to another table in the database it picks the record ID column instead of the item itself. this is the how am populating the combo box.

<label>State</label>
<select name="state" class="state" onChange="display(this.value)" width="142" style="width: 142px">
<option value="" selected="selected">-- Select State --</option>
<?php
$query="select * from tbl_state";
$query_result=mysql_query($query)or mysql_error();
                            while($row=mysql_fetch_array($query_result))
                        {
?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['state_name']; ?></option>
<?php
}
?>

  </select>
<div id="show_city" style="position: relative" height:5px;>
     <label>LGA</label>
      <select name="city" class="lga" width="142" style="width: 142px">
      <option value="" selected="selected">-- Select LGA --</option>
       </select>
</div>
</p>

Database connection

$state              = $_POST['state'];
$city               = $_POST['city'];

$sql="INSERT INTO members (state, city)
VALUES ('$state', '$city')";

NB. am using javascript to populate the combo box.

Upvotes: 0

Views: 3381

Answers (2)

Syahmi Azhar
Syahmi Azhar

Reputation: 49

When you submit a form, only the field name along with its value will be sent. In your case, when the user select the state and press submit, the row id will be sent as you specify the row id at the option value tag.

Either you can use <option value="<?= $row['state_name'] ?>"> ... </option>" and then get the state name ini php directly:

    $state = $_POST['state'];

or leave the populating code as is now and get the state name by querying database using the record id.

    $state_id = intval($_POST['state']);
    $city_id  = intval($_POST['city']);

    $sql = "SELECT `state_name` FROM tbl_state WHERE id=$state_id";
    $query_result = mysql_query($sql) or mysql_error();

    $state = mysql_result($query_result, 0);
    echo $state;

getcity.php

<?php
$con=mysql_connect('localhost','root','') or die('Mysql not connected');
mysql_select_db('thriftdb',$con) or die('DataBase not connected');

$state_id=$_REQUEST['state_id'];

$query="select * from lga where state_id='$state_id'";

?>
<label>LGA</label>
<select name="city" width="142" style="width: 142px">
<option value="" selected="selected">-- Select LGA --</option>
<?php
$query_result=mysql_query($query)or mysql_error();
while($row=mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['lga_name']; ?></option>
<?php
}
?>
</select>

database structure is as follows 'lga' table has...

lga_id --- state_id --- lga_name

'state' table has 

state_id  --- state_name

Upvotes: 1

Eduardo Y&#225;&#241;ez Parareda
Eduardo Y&#225;&#241;ez Parareda

Reputation: 10346

When a form sends the selected item of a combo, it sends the value of the option selected, not the text. If you want to send the text, add a hidden input for every combo, then in the onclick event of the combos, call a function that populates the text to the hidden input.

selectState = function() {
    $('#hiddenInputField').val($("select[name='state'] option:selected").text());
}

Then in the server side you must get the value of the input hidden field instead of the select field.

Upvotes: 0

Related Questions