php - 根据php变量插入表列

Question

我有一个组合框，其中包含以下选项:转运、膳食和医疗。我想将值插入到与用户选择的选项相对应的列中。是否可以？

这是我最新的查询。

 $conn->query("INSERT INTO expenses
    SET employee_id = :emp_id,
    client_id = :client_id,
    CASE
      WHEN :cat == 'transpo' THEN transpo_exp = :worth
      WHEN :cat == 'meal' THEN meal_exp = :worth
      WHEN :cat == 'medical' THEN medical_exp = :worth");

Answer 1

 please use array [] symbol in select name.

  <select name="expenses[]" multiple="multiple">
    <option value=""></option>
    <option value=""></option>
    <option value=""></option>
  </select>     

  and get array variable.

  $expenses= $_POST['expenses'];

    for($i = 0; $i < count($expenses); $i++){
        echo $expenses[$i];
        $Qry = mysql_query("INSERT INTO expenses VALUES('$expenses[$i]]')"); 
    }