HTML下拉菜单&PHP动态创建


HTML dropdown & php dynamic creation

我在创建选项并将其与表单一起发布时遇到了麻烦。

这是我目前拥有的。db连接器已经工作。

 <select class="form-dropdown validate[required]" style="width:150px" id="input_5"       name="account">
 <?php
 while($row = mysql_fetch_row($result)){
 $bid =$row[0];
$account = $row[1];
echo '<option value="'.$bid.'>"'.$account.'"</option>"';
}
?>
</select>

它不会发送到:

   function calculateBilling(){ 
        $date = date('mdY');
        $bid = mysql_real_escape_string($_POST['bid']);
        $account = mysql_real_escape_string($_POST['account']);
        $timein = mysql_real_escape_string($_POST['timein']);
        $desc = mysql_real_escape_string($_POST['desc']);
        $hrs2calc1 = mysql_real_escape_string($_POST['hrly']);
        $hrs2calc2 = mysql_real_escape_string($_POST['rhrly']);

        $query = 'SELECT bid, account, hrly, rhrly, bal FROM billing WHERE bid="'.$bid.'"';
        echo $query;
        $result = mysql_query($query);
        while($row = mysql_fetch_row($result)){
                $accounttobebilled = $row[1];
                $first = $row[2];
                $second = $row[3];
                $curbal = $row[4];
            }
            $sub1 = $hrly * $hrs2calc1;
            $sub2 = $rhrly * $hrs2calc2;
            $subtotal = $sub1 + $sub2;
            $total = $curbal + $subtotal;
            mysql_query("UPDATE billing SET bal = '" . $total . "' WHERE bid ='" . $bid . "'");

        // Update Billing Log for this customer
        mysql_query("INSERT INTO billingLog (bid, date, hrsOnsite, hrsRemote, timein, descript, total) VALUES ('$bid', '$date', '$hrs2calc1', '$hrs2calc2', '$timein', '$desc', '$subtotal')");
   }

我的问题是账单id(出价)不张贴随着它被包裹在形式。如果我在发布之前在html页面上返回$bid,它会很好。它只是不发送到上面的函数。

谢谢! !

你的引号很奇怪:

echo '<option value="'.$bid.'>"'.$account.'"</option>"';

将输出:<option value="123>"My Account Name"</option>"

试试这个:

echo '<option value="'.$bid.'">'.$account.'</option>';

应该输出:<option value="123">My Account Name</option>

拍卖品上没有我的名字。固定!