Sql and Php, insert into sql select option

Question

i have one form in php, in this form have one select option

<select id="birdname" style="width: 150px; height: 25px; border-radius: 5px;">
    <option>--Cambiar vendedor --</option>
    <?php
    $selectagent = "SELECT * FROM `" . $prefix . "user`";
    $resultforagents = mysql_query($selectagent);
    while ($agent = mysql_fetch_object($resultforagents)) {
        ?>
        <option value="<?= $agent->user_id ?>" ><?= $agent->username ?></option> 
<?php } ?>                          
</select>
<div id="stage" style="display:none;"></div>

Showing name of username, i need insert selected username (reference not name) into sql

<?php
$userId = $_POST['birdname'];
$idtill = $_SESSION['caj'];
$cashid = $_SESSION['cash'];
$mvalue = number_format($givenamount, 2, '.', '');
$mdate = date("Y-m-d H:i:s");
$moption = '1';
$sql = "INSERT INTO `" . DB_PREFIX . "order_user`(`user_id`, `order_Id`, `till`, `value`, `operation`, `comment`, `date`,`cashid`) VALUES ('" . $userId . "','" . $lastorderidis . "','" . $cashid . "','" . $mvalue . "','" . $moption . "', '" . " " . "', '" . $mdate . "','" . $cashid . "')";
$common->showresultsql($sql, 'update', 1);

echo $lastorderidis;
?>

Thanks

on your select use a name to obtain the value on the form action page — Marco Mura
– Marco Mura, Commented Dec 10, 2014 at 9:51
possible duplicate of get the selected index value of <select> tag in php — Matheno
– Matheno, Commented Dec 10, 2014 at 9:54

Community · Accepted Answer · 2017-05-23 12:27:18Z

1

Add the name tag to your select value to get the value of select like this:

<select id="birdname" name="birdname">

Now you will have the value by $_POST['birdname']

More info here: get the selected index value of <select> tag in php

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Dec 10, 2014 at 9:53

Matheno

4,2126 gold badges40 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Sql and Php, insert into sql select option

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related