用PHP代码中的选项写html select

Question

I have in my html page this php code, how to user ... from the echo.

$stid = oci_parse($conn, "select user_id, username,user_job from users");
    oci_execute($stid);

    while (($row = oci_fetch_array($stid,OCI_ASSOC+OCI_RETURN_NULLS))!= false){

        echo $row['user_id'] . " " . $row['username'] .$row['user_job'] . "<br>
";
   }

Answer 1

You can do like below:

$stid = oci_parse($conn, "select user_id, username,user_job from users");
oci_execute($stid);

echo "<select>";
while (($row = oci_fetch_array($stid,OCI_ASSOC+OCI_RETURN_NULLS))!= false){

    echo "<option value=$row[user_id]>". $row['username'] .$row['user_job'] . "</option>";
}
echo "</select>";