PHP Simple Search Form
<p>I'm new to PHP and would like to start a simple query system by just searching identification number and it will print out full name, date of birth, gender and identification number.</p>

<p>The first file name of the page is <em>search.php</em>.
Inside of the file contains</p>

<pre><code>&lt;html&gt;
&lt;body&gt;

&lt;form action="result.php" method="get"&gt;
  ID Number: &lt;input type="text" name="idnumber"&gt; &lt;input type="submit" value="Search"&gt;&lt;br&gt;
&lt;/form&gt;

&lt;p&gt;Input ID number&lt;/p&gt;

&lt;/body&gt;
&lt;/html&gt;
</code></pre>

<p>After that, I created a database named users and with following columns (<code>id, full_name, date_of_birth, gender, identification_number</code>)</p>

<p>What code should I write into result.php to let the search result of identification number match and found it will print all the details of the person and the search keyword must 100% match.</p>

<p>Example of the scenario.
In database has <code>John Doe, 20 September 1990, Male, 900920A44</code>.
Search keyword <code>"900920A44"</code> will print out corresponding user's information but if search keyword <code>"900920A"</code> will not print out anything because other user might had a <code>"900920A55"</code> identification number.</p>

<p>Files:</p>

<p>search.php &amp; result.php</p>

<p>Please advise.</p>