If you are looking for a source code for Search Record System In PHP then you are at the right place. This is a simple program using PHP and MySQL for searching record in the database.

This program contains a TextBox where the user entering the keyword and button to generate searching and table to show the information. And, the user can search in the TextBox by FirstName, LastName, or ID Number.

Form Input Field - HTML

This HTML Form input field where the user types the keyword for search.

1. <form
   
   method
   
   =
   
   "post"
   
   action
   
   =
   
   ""
   
   name
   
   =
   
   "form1"
   
   id
   
   =
   
   "form1"
   
   >
   
2. <p
   
   style
   
   =
   
   "font-size:18px; margin-left:100px;"
   
   >
   
3. Type the First Name, Last Name, or ID Number of the User
   
4. </
   
   p
   
   >
   
5. <br
   
   /
   
   >
   
6. <p
   
   style
   
   =
   
   "font-size:18px; margin-left:100px;"
   
   >
   
   Search User <input
   
   type
   
   =
   
   "text"
   
   autofocus=
   
   "autofocus"
   
   name
   
   =
   
   "search_file"
   
   id
   
   =
   
   "search_file"
   
   style
   
   =
   
   "width:230px; font-size:18px;"
   
   class
   
   =
   
   "textboxclass"
   
   /
   
   >
   
7. <input
   
   type
   
   =
   
   "submit"
   
   style
   
   =
   
   "font-size:18px; margin-top:-9px;"
   
   class
   
   =
   
   "btn btn-primary"
   
   name
   
   =
   
   "submit"
   
   value
   
   =
   
   "Filter"
   
   ></
   
   p
   
   >
   
8. </
   
   form
   
   >
   

Showing Results

This source code where the information display.

1. <div class="container">
   
2. <div class="alert alert-success"><center> <h4>Record Results </h4></center> </div>
   
3. <br />
   
4. 
   
5. <table class="table table-striped">
   
6. <thead>
   
7. <tr>
   
8. <th class="text-center">No.</th>
   
9. <th class="text-center">FirstName</th>
   
10. <th class="text-center">LastName</th>
    
11. <th class="text-center">Phone Number</th>
    
12. <th class="text-center">Email Address</th>
    
13. </tr>
    
14. </thead>
    
15. 
    
16. <tbody>
    
17. <?php
    
18. error_reporting
    
    (
    
    0
    
    )
    
    ;
    
19. if
    
    (
    
    $_REQUEST
    
    [
    
    'submit'
    
    ]
    
    )
    
    {
    
20. $search_file
    
    =
    
    $_POST
    
    [
    
    'search_file'
    
    ]
    
    ;
    
21. $sql
    
    =
    
    mysql_query
    
    (
    
    "select * from information where firstname like '%$search_file
    
    %' o
    
    r lastname like '%$search_file
    
    %' or ID like '%$search_file
    
    %' Order by lastname ASC"
    
    )
    
    or die
    
    (
    
    'Error in query : $sql. '
    
    .
    
    mysql_error
    
    (
    
    )
    
    )
    
    ;
    
22. 
    
23. if
    
    (
    
    empty
    
    (
    
    $search_file
    
    )
    
    )
    
    {
    
24. echo
    
    '<script language="javascript">'
    
    ;
    
25. echo
    
    'alert("Text field cannot be empty. Please Try it again.")'
    
    ;
    
26. echo
    
    '</script>'
    
    ;
    
27. header
    
    (
    
    "refresh:2; url=index.php"
    
    )
    
    ;
    
28. }
    
29. else
    
    if
    
    (
    
    mysql_num_rows
    
    (
    
    $sql
    
    )
    
    >
    
    0
    
    )
    
30. {
    
31. $i
    
    =
    
    1
    
    ;
    
32. while
    
    (
    
    $row
    
    =
    
    mysql_fetch_array
    
    (
    
    $sql
    
    )
    
    )
    
    {
    
33. // Print out the contents of the entry
    
34. echo
    
    '<tr>'
    
    ;
    
35. echo
    
    '<td class="text-center">'
    
    .
    
    $i
    
    .
    
    '</td>'
    
    ;
    
36. echo
    
    '<td class="text-center">'
    
    .
    
    $row
    
    [
    
    'firstname'
    
    ]
    
    .
    
    '</td>'
    
    ;
    
37. echo
    
    '<td class="text-center">'
    
    .
    
    $row
    
    [
    
    'lastname'
    
    ]
    
    .
    
    '</td>'
    
    ;
    
38. echo
    
    '<td class="text-center">'
    
    .
    
    $row
    
    [
    
    'phonenumber'
    
    ]
    
    .
    
    '</td>'
    
    ;
    
39. echo
    
    '<td class="text-center">'
    
    .
    
    $row
    
    [
    
    'email'
    
    ]
    
    .
    
    '</td>'
    
    ;
    
40. $i
    
    ++;
    
41. }
    
42. }
    
43. else
    
44. {
    
45. echo
    
    '<div class="alert alert-danger" style="width:130px; float:right; margin-top:-142px;">No Results Found!!!</div>'
    
    ;
    
46. }
    
47. }
    
48. ?>
    
49. </tbody>
    
50. </table>
    
51. </div>
    

And, this is the database script.

1. <?php
   
2. mysql_select_db
   
   (
   
   'users'
   
   ,
   
   mysql_connect
   
   (
   
   'localhost'
   
   ,
   
   'root'
   
   ,
   
   ''
   
   )
   
   )
   
   or die
   
   (
   
   mysql_error
   
   (
   
   )
   
   )
   
   ;
   
3. ?>
   

Output:

This is the result if the user found the information in the database.



And, this is the result if the user did not found the information in the database.



So what can you say about this work? Share your thoughts in the comment section below or email me at [email protected]. Practice Coding. Thank you very much.

Download