如何在 php 表中使用 <选择> 标签


How to use <select> tag in php table?

我想把它添加到下面的php表中。我希望它格式化为在我的表中用作 php 字段。此示例是我希望它看起来像的 html 代码 echo "<td>" . "<select value=" ???????? " </td>";请别再贬低我了。我不会说英语。我只是在打赌,让你们明白我想要什么。

<select id="state1" name="name1">
    <option value="Resolved">Resolved</option>
    <option value="Pending">Pending</option>
    <option value="Cased">Cased</option>
    <option value="Resolved" selected>Resolved</option> 
</select> 

如何在此表中插入上述内容?

           while($row = mysqli_fetch_array($search_result)) {
              echo "<form action=edit_c_log.php method=post id=modif>"; 
              echo "<tr>";
              echo "<td>" . $row['device_id'] . "</td>";
              echo "<td>" . $row['title'] . "</td>";
              echo "<td>" . $row['description'] . "</td>";
              echo "<td>" . $row['date'] . "</td>";                  
              echo "<td>" . "<select name=status ?????????? " </td>";                                                   
              echo "<td>" . "<input type=text name=status value=" . $row['status'] . " </td>";
              echo "<td>" . "<input type=text name=pending_reason value=" . $row['pending_reason'] . " </td>";
              echo "<td>" . "<input type=text name=case_number value=" . $row['case_number'] . " </td>";
              echo "<td>" . "<input type=hidden name=call_id id=edition value=" . $row['call_id'] . " </td>";
              echo "<td>" . "<input type=submit id=insert10 name=update value=update>" . " </td>";
              echo "</tr>";
              echo "</form>";   
        }

edit_c_log.php

<?php
session_start();
?>
<?php               
$dbhost = 'localhost';
$dbuser = 'user2';
$dbpass = 'Pw32';
$dbname = 'db3';
$con=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
if(!isset($_SESSION['log_update'])){
$_SESSION['status'] = mysqli_real_escape_string($con,$_POST['status']);
$_SESSION['pending_reason'] = mysqli_real_escape_string($con,$_POST  ['pending_reason']);
$_SESSION['case_number'] = mysqli_real_escape_string($con,$_POST['case_number']);
$_SESSION['call_id'] = mysqli_real_escape_string($con,$_POST['call_id']);
$status = $_SESSION['status'];
$pending_reason = $_SESSION['pending_reason'];
$case_number = $_SESSION['case_number'];
$call_id = $_SESSION['call_id'];
Mysqli_query($con, "UPDATE oz2ts_call_logs SET status='$status', pending_reason='$pending_reason', case_number='$case_number' WHERE call_id='$call_id'");
 }
?>
我认为

,使用html代码(如html)的更好方法。喜欢这个:

<form action="edit_c_log.php" method="post" id="modif">
<table>
   <tr>
       <td><?php echo $row['date']; ?></td>
       <td>
           <select id="state1"  name="name1">
               <option value="Resolved">Resolved</option>
               <option value="Pending">Pending</option>
               <option value="Cased">Cased</option>
               <option value="Resolved" selected>Resolved</option> 
           </select> 
       </td>
       <td>
          <input type="text" name="status" value="<?php echo $row['status'] ?>"
       </td>
       ....
</table>
</form>
你可以

这样做: "(In PHP format)"

    echo "<form action=edit_c_log.php method=post id=modif>"; 
    echo "<tr>";
        echo "<td>" . $row['date'] . "</td>";
        echo "<td>";
            echo '<select id="state1"  name="status">';
                echo '<option value="Resolved">Resolved</option>';
                echo '<option value="Pending">Pending</option>';
                echo '<option value="Cased">Cased</option>';
                echo '<option value="Resolved" selected>Resolved</option>';
            echo "</select>";
        echo "</td>";             
        echo "<td>" . "<input type=text name=status value=" . $row['status'] . "> </td>";
        echo "<td>" . "<input type=text name=pending_reason value=" . $row['pending_reason'] . "> </td>";
    echo "</tr>";
echo "</form>";