If I have a table In database which called occupations columns are: workid, workname, salary and sector workid is a primary key and increase I insert to the table 1, fireman , 500, 2
If I have a table In
columns are: workid, workname, salary and sector
workid is a primary key and increase
I insert to the table
1, fireman , 500, 2
2, officer, 800, 1
the code in html / php
Will show a drop menu select the workname from the table in the database so the menu will show the fireman and the officer
As soon the user choose one of them(onchange) the salary will be written / displayed under .
the question is how to write the salary out when I choose from the drop menu?
thanks in advance
//PHP Code
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();
?>
Step by step
Solved in 3 steps
