search data from html input in mysql

by

first, change your input-search’s name to ‘search’:

<input  type="text" name="search">

You are sending your form, to the same .php file, using the ‘POST’ method.
This means you can access what ever information being sent to the page, by accessing the $_POST variable.

Add this to the top of your search.php file, inside the <?php ?> tags:

if (isset($_POST['search']) {
  echo $_POST['search'];
}

this will give you the idea of how to handle data being post from a <form>.

Have a look at this PHP doc, regarding dealing with forms.

mysqli allows you to use prepared-statements, which is a safe way to pass user-input to database-queries.

An example on how to query DB with prepared statments:

if (isset($_POST['search']) {
  $stmt = $mysqli->prepare("SELECT * FROM produckte WHERE beschreibung = ? LIMIT 100;")
  $stmt->bind_param("s", $_POST['search']);
  $stmt->execute();

  $result = $stmt->get_result();
  while ($row = $result->fetch_array(MYSQLI_NUM))
  {
    .....handle your data here....
  }
  $stmt->close();
}

More Related Contents:

  1. PHP – Verify user token on every request
  2. How to hide css and js version details from weppalyzer in PHP
  3. My games being hacked easily by right click inspect. How can i prevent this?
  4. Datepicker validation 18 years of age [closed]
  5. How do you modify a file using JavaScript together with PHP?
  6. Preventing my form to refresh using ajax
  7. PHP get contents of a div, and echo the div contents in same page
  8. php How to save post and save show to php file like this [closed]
  9. Download the text over image using jquery
  10. How to create these webpages
  11. Load php function onClick [closed]
  12. Tally value in dynamically generated textbox
  13. Is the following code valid? [closed]
  14. Dynamic page load can’t load Java with page
  15. How To See Who Has Liked A Picture In Php And My Sql Database
  16. “Mixed content blocked” when running an HTTP AJAX operation in an HTTPS page
  17. How to prevent page from reloading after form submit – JQuery
  18. How to convert HTML to JSON using PHP?
  19. how to assign javascript variable value to php variable
  20. Number with leading zeroes gets changed in JavaScript
  21. Putting default value in
  22. How to replace html element with ajax response?
  23. How do I edit PHP variable with JavaScript/jQuery?
  24. how to get the base url in javascript
  25. How do I refresh a DIV content?
  26. How to make a button execute a php script?
  27. Remove everything within script and style tags
  28. Change form action on select option
  29. How do I execute a PHP query on select option choice using AJAX?
  30. How to replace the entire html webpage with ajax response?

Leave a Comment