Simple search MySQL database using php

Question

I currently have a small php script that searches a database based on user input  There is an html file that has one field that is used for entry of search strings into the database  Essentially  you can search for employees   It is supposed to retrieve the employee result  if found  and a  no employee found  message  if not   For some reason  however  no matter the search  the query returns every employee in the database   I ve been working on this for over an hour  and I am honestly stumped  It may be a simple error but I could do with some help    lt  php      con  new mysqli  localhost   root      Employee         name     post  search           query    SELECT   FROM employees       WHERE first name LIKE     name    OR last name LIKE     name              Check connection     if  mysqli connect errno                  echo  Failed to connect to MySQL      mysqli connect error              result   mysqli query  con   SELECT   FROM employees     WHERE first name LIKE     name    OR last name LIKE     name        while   row   mysqli fetch array  result             echo  row  first name            row  last name            echo   lt br gt          mysqli close  con         gt    Any help appreciated   Thanks

User · Answer

require once  functions php      errors   FALSE   errorMessage        if mysqli connect error        errors   TRUE     errorMessage     There was a connection error  lt br  gt      errorDisplay  errorMessage     die  errors     else if  errors     TRUE       errors    FALSE     if isset mysqli real escape string   POST  search          search   mysqli real escape string   POST  search       search search          gt   lt  php   This is functions php function search  searchQuery     echo   lt div class  col-md-10 col-md-offset-1  gt       searchTerm    query   query  SELECT   FROM  index  WHERE  keywords  LIKE     searchTerm          while  row   mysqli fetch array  query         results    lt  lt  lt  DELIMITER        lt div class  result col-md-12  gt           lt a href  index php search   row  id     gt    row  Title     lt  a gt           lt p class  searchDesc  gt   row  description    lt  p gt         lt  div gt  DELIMITER      echo  results        echo   lt  div gt       function errorDisplay  msg     if  isset   SESSION  errors            SESSION  errors      msg      showError  msg       else if           SESSION  errors       msg     lt br gt        showError  msg         function showError  msg      return  msg    unset   SESSION  errors           gt   Perhaps That Helps

User · Answer

This is a better code that will help you through  With your database  but rather  I have used mysql not mysqli Enjoy it    lt body gt    lt form action    method  post  gt      lt input name  search  type  search  autofocus gt  lt input type  submit  name  button  gt    lt  form gt    lt table gt     lt tr gt  lt td gt  lt b gt First Name lt  td gt  lt td gt  lt  td gt  lt td gt  lt b gt Last Name lt  td gt  lt  tr gt    lt  php   con mysql connect  localhost    root         db mysql select db  employee      if isset   POST  button           trigger button click     search   POST  search        query mysql query  select   from employees where first name like     search       last name like     search         if  mysql num rows  query   gt  0      while   row   mysql fetch array  query         echo   lt tr gt  lt td gt    row  first name     lt  td gt  lt td gt  lt  td gt  lt td gt    row  last name     lt  td gt  lt  tr gt         else      echo  No employee Found lt br gt  lt br gt          else                             while not in use of search  returns all the values    query mysql query  select   from employees       while   row   mysql fetch array  query         echo   lt tr gt  lt td gt    row  first name     lt  td gt  lt td gt  lt  td gt  lt td gt    row  last name     lt  td gt  lt  tr gt           mysql close      gt

User · Answer

Just with the above answer I hope it was the problem     POST  search   instead of   post  search    And again use LIKE    name   instead of LIKE     name

User · Answer

I think its works for everyone   lt html lang  quot en quot  gt    lt head gt       lt meta charset  quot UTF-8 quot  gt       lt meta name  quot viewport quot  content  quot width device-width  initial-scale 1 0 quot  gt       lt title gt Search lt  title gt   lt  head gt    lt body gt       lt form action  quot  quot  method  quot post quot  gt           lt input type  quot text quot  placeholder  quot Search quot  name  quot search quot  gt           lt button type  quot submit quot  name  quot submit quot  gt Search lt  button gt       lt  form gt   lt  body gt    lt  html gt   lt  php   if  isset   POST  submit            searchValue     POST  search         con   new mysqli  quot localhost quot    quot root quot    quot  quot    quot testing quot        if   con- gt connect error            echo  quot connection Failed   quot     con- gt connect error        else            sql    quot SELECT   FROM customer info WHERE name OR email LIKE    searchValue   quot             result    con- gt query  sql           while   row    result- gt fetch assoc                  echo  row  name      quot  lt br gt  quot               echo  row  email      quot  lt br gt  quot                                     gt

User · Answer

You need to use   POST not   post

User · Answer

If you do mysqli fetch array    you must put integer in  row index ex   row 3   If you read  row  id   or  row  example    you must use mysqli fetch assoc

User · Answer

First add HTML code    lt form action    method  post  gt   lt input type  text  name  search  gt   lt input type  submit  name  submit  value  Search  gt   lt  form gt    Now added PHP code    lt  php  search value   POST  search     con new mysqli  servername  username  password  dbname   if  con- gt connect error       echo  Connection Faild     con- gt connect error       else           sql  select   from information where First Name like    search value               res  con- gt query  sql            while  row  res- gt fetch assoc                 echo  First name      row  First Name                                        gt

[php] Simple search MySQL database using php

Examples related to php