Creating a php search bar

I want to put a search box so that when you type in a persons name it selects that persons details from the database.

This is my search box:

<html>
<body>

<form action="users.php" method="GET">
<input id="search" type="text" placeholder="Type here">
<input id="submit" type="submit" value="Search">
</form>
</body>
</html>

Then here is my PHP to return the users:

<?php 

$connection = mysql_connect("localhost","root","");

mysql_select_db("blog1")or die(mysql_error());


$result = mysql_query("SELECT username FROM member");
 while ($row = mysql_fetch_assoc($result)) {
echo "<div id='link' onClick='addText(\"".$row['username']."\");'>" . $row['username'] . "</div>";  
 }


  ?>

How to get it to just return the user that i type in the search bar instead of all the users? Any help would be great as I am just learning PHP.

Related Posts:

  1. How to set 777 permission on a particular folder? [closed]
  2. What is a slug?
  3. What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
  4. PHP page redirect
  5. What are namespaces?
  6. Get the full URL in PHP
  7. S_SESSION variable (user role) not recognised
  8. Is SAJAX dead? What to replace with?
  9. Data source name not found, and no default driver specified
  10. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  11. How do I redirect a page in jQuery?
  12. What is difference between PHP cli and PHP cgi?
  13. Illegal string offset Warning PHP
  14. Why use $_SERVER[‘PHP_SELF’] instead of “”
  15. phpMyAdmin: secret passphrase?
  16. What’s the purpose of ini_set() in php? (especially for error reporting)
  17. PHP how to make URL something like product.php?id=1
  18. Send email with PHP from html form on submit with the same script
  19. Mixing a PHP variable with a string literal
  20. How to insert an item at the beginning of an array in PHP?
  21. PHP Deprecated: Methods with the same name
  22. How do I pass JavaScript variables to PHP?
  23. Print array to a file
  24. Call to undefined function curl_init().?
  25. I have a string with “\u00a0”, and I need to replace it with “” str_replace fails
  26. How to verify password against database?
  27. what is a good method to sanitize the whole $_POST array in php?
  28. Finding the number of days between two dates
  29. Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes)
  30. MySqli Commands out of sync; you can’t run this command now
  31. Trying to get property of non-object in
  32. Difference between $_SERVER[‘DOCUMENT_ROOT’] and $_SERVER[‘HTTP_HOST’]
  33. CURL ERROR: Recv failure: Connection reset by peer – PHP Curl
  34. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  35. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  36. Refresh a page using PHP
  37. Laravel 5.2 Storage::makeDirectory($dir) is not creating directory
  38. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  39. SSL error SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
  40. PDO closing connection
  41. “Valid CSRF Token Required” in Osticket After login?
  42. How to find the date of a day of the week from a date using PHP?
  43. PHP multidimensional array search by value
  44. Trying to get property of non-object – Laravel 5
  45. nginx: connect() failed (111: Connection refused) while connecting to upstream – after update nginx –
  46. ‘xmlParseEntityRef: no name’ warnings while loading xml into a php file
  47. Child theme css not overriding parent
  48. Convert timestamp to readable date/time PHP
  49. Get user role by ID WordPress
  50. How to fix syntax error, unexpected T_IF error in php?
  51. How can I capture the result of var_dump to a string?
  52. Html encode in PHP
  53. Is Angularjs Clientside or Serverside or Both
  54. file_put_contents: Failed to open stream, no such file or directory
  55. Laravel 5 Class ‘Collective\Html\HtmlServiceProvider’ not found on AWS
  56. MySQL query to get column names?
  57. Fatal error: Out of memory, but I do have plenty of memory (PHP)
  58. Changing permissions via chmod at runtime errors with “Operation not permitted”
  59. php – How do I fix this illegal offset type error
  60. PHP $_POST not working?
  61. PHP cURL HTTP PUT
  62. Getting ’ instead of an apostrophe(‘) in PHP
  63. WooCommerce action hooks and overriding templates
  64. Convert timestamp to readable date/time PHP
  65. Updating php version on mac
  66. How to send a GET request from PHP?
  67. Unzip a file with php
  68. Difference between require, include, require_once and include_once?
  69. What does the PHP error message “Notice: Use of undefined constant” mean?
  70. select * from table where column = value ^ column2= value
  71. Why I get “ERR_RESPONSE_HEADERS_TOO_BIG” on chrome?
  72. Object of class mysqli_result could not be converted to string
  73. How to write a link like which link to the same page in PHP?
  74. Laravel – Model Class not found
  75. Download files from server php
  76. No query results for model [App\Products] Laravel
  77. Sending POST data without form
  78. Fatal error: Call to a member function fetch_assoc() on a non-object
  79. Strict Standards: Only variables should be assigned by reference PHP 5.4
  80. mysqlworkbench giving version error on exporting database
  81. Steam Market API?
  82. Resetting MySQL Root Password with XAMPP on Localhost
  83. PHP – syntax error, unexpected T_CONSTANT_ENCAPSED_STRING
  84. How can I force users to access my page over HTTPS instead of HTTP?
  85. How to install a specific version of package using Composer?
  86. A non well formed numeric value encountered
  87. Getting a 500 Internal Server Error on Laravel 5+ Ubuntu 14.04
  88. Access PHP variable in JavaScript
  89. PHP Multiple Checkbox Array
  90. CSS background images in WordPress
  91. Session variables not working php
  92. Reset PHP Array Index
  93. Is there any difference between aes-128-cbc and aes-128 encryption?
  94. Convert timestamp to readable date/time PHP
  95. Get JSON object from URL
  96. How to push both value and key into PHP array
  97. In where shall I use isset() and !empty()
  98. Find the last element of an array while using a foreach loop in PHP
  99. Popup window in PHP?
  100. WordPress get_template_directory_uri() not returning https and only return http

Leave a Comment