PHP / MYSQL查询HTML表单字段中的打印结果

Recently I have been assigned a group project for a college class and I will need to query a customers name from a database and then print out the rest of the row in form fields. I have the select menu working correctly and it will print to the form field. However, the problem occurring is the query results will only show the last row in the MYSQL table I selected. Any help here would be greatly appreciated. I have been spinning my wheels for a few days on this issue. I am only a beginner coder, so it might be a little messy.

Thanks,

Connection.PHP File

<?php


function Connect()
{
 $dbhost = "localhost";
 $dbuser = "root";
 $dbpass = "";
 $dbname = "medley";

 // Create connection
 $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);

 return $conn;
}

?>

My Query Page

 <?php
require 'connection.php';
$conn    = Connect();

$sql = "SELECT * FROM cust_info";
$result = $conn->query($sql);

echo "<select id='firstName' name='firstname' onchange=populatesecondbox()>";
while ($row = mysqli_fetch_array($result)) {
echo "<option value='" . $row['F_Name'] . "', '" . $row['L_Name'] . "'> " . $row['F_Name'] . " " . $row['L_Name'] . "</option>";

$pphone = $row['P_Phone'];

}
echo "</select>";
?>

<input id="secondinputbox" type="text" />



<script type="text/javascript">
function populatesecondbox(val) {
    var dropdown = document.getElementById("firstName");
    var pphone = document.getElementById("secondinputbox");
    var secondfname = document.getElementById("thirdinputbox");
    var str = "<?php echo $pphone ?>";
    var sfname = "<?php echo $sfname ?>";
    pphone.value = str;
    secondfname.value = sfname;
}
</script>







​

Instead of using

$row = mysqli_fetch_array($result)

on line 10, use

$row = $result->fetch_assoc()

or

$row = $result->fetch_array()

The difference between fetch_assoc and fetch_array is that fetch_array contains both numeric indices and named indices. For example echo $row[0] will output as same as echo $row['id']. Whereas, fetch_assoc only contains named indices.

Based on the provided loop statement

$pphone = $row['P_Phone'];

$pphone is getting assigned to the last row on termination of the loop because each iteration is overriding $pphone with the current row until at which point in the loop $pphone gets the last value.

Instead of using

$pphone = $row['P_Phone'];

Try the following in the loop.

$pphone[] = $row['P_Phone'];

Your concatenated phones should be provided after the loop.

$pphones = "['".join("','" , $pphone)."']";

In your js script tag just get $pphones as a string;

var pphones = <?php echo $pphones; ?>;

ddl = document.getElementById('firstname');
pphone.value = pphones[ddl.selectedIndex];