Since I'm new to PHP, I'd like to start with a simple query system that prints out the full name, date of birth, gender, and identity number when I only search by identification number.
The page's search.php file is the first one on the list. The document's interior comprises
<html>
<body>
<form action="result.php" method="get">
ID Number: <input type="text" name="idnumber"> <input type="submit" value="Search"><br>
</form>
<p>Input ID number</p>
</body>
</html>
Then I made a database called users with the following columns: id, full name, date of birth, gender, and identification number.
What code should I add to result.php so that when a match is made between the identification number and the search term, all of the person's information is printed?
a case study of the scenario John Doe, a Male, age 20, and the database ID 900920A44. If you search with the keyword "900920A44," the information for the matching user will come out, but if you search with the term "900920A," nothing will print out because another person may have used the identification number "900920A55."