Answer to Question #52632 in Programming & Computer Science for Makinon

Question

A database table called PERSON contains the fields NAME, BASIC and HRA. Write a computer program to print a report with employee name and total salary for those employees whose total salary is more than 10,000. Total Salary = BASIC + HRA. At the end, the program should also print the total number of employees whose total salary is
more than 10,000.

Answer 1

Code (MySQL).
SELECT * FROM PERSON
WHERE BASIC + HRA > 10000;
Code(PHP).
$sql = " SELECT *FROM PERSON WHERE BASIC + HRA > 10000";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
echo$result->num_rows . " results";
while($row = $result->fetch_assoc()) {
        echo"Name: " . $row["NAME"]. "Basic: " . $row["BASIC"]
. " " . $row["HRA"] . "<br>";
    }
} else {
    echo "0 results";
}