PHP searching multiple rows in database

Question

I am wanting to search more than column from one database with PHP and MySQL. Currently I have this working.

This is my form:

  <form action="products.php" method="POST">
  Search: <input type="text" name="search" />
  <input type="submit" value="submit"/>
  </form>

and here is my current working query:

$query = "SELECT * FROM `GraphicsCards` WHERE `Brand` LIKE '%". $search . "%'";
$run = mysqli_query ($connection, $query);

As you can see my query is searching my database to see if the user search entered matches anything in the column "Brand".

I have other columns such as "Model" "Price" etc etc, and would like to be able to search those as well as just "Brand". Is it possible to do this is one query?

In addition I have already tried ' AND ' and ' OR ' and also ' || ' but they do not work.

I don't know when I add OR the query no longer displays data :/ — Abdush Samad Miah
– Abdush Samad Miah, Commented Jan 8, 2015 at 22:10
Make sure $search is escaped correctly if it comes from user input, otherwise you'll have a SQL injection vulnerability. It is best to switch to parameterised queries if you can, for this reason. — halfer
– halfer, Commented Jan 16, 2015 at 21:31

Patrick Q · Accepted Answer · 2015-01-08 22:11:56Z

6

OR will work, you just have to do it correctly.

$query = "SELECT * FROM `GraphicsCards`
    WHERE `Brand` LIKE '%". $search . "%'
        OR `Model` LIKE '%" . $search . "%'
        OR `Price` LIKE '%" . $search . "%'";

And just FYI, Brand, Model, and Price are columns, not rows.

answered Jan 8, 2015 at 22:11

Patrick Q

6,3942 gold badges28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Abdush Samad Miah Over a year ago

Patrick you wonderful guy!! It works! Thank you and God Bless :)

Patrick Q Over a year ago

@AbdushSamadMiah You're welcome. If you could just mark the answer as accepted since it solved your problem, that would be appreciated.

Abdush Samad Miah Over a year ago

lool and cheers for the FYI above, I shall remember for future reference :)

Abdush Samad Miah Over a year ago

Just waiting for it to allow me and will do as soon as it does. Cheers

halfer · Accepted Answer · 2015-01-16 21:30:09Z

1

You should try:

$query = "
    SELECT * FROM `GraphicsCards`
    WHERE
        `Brand` LIKE '%". $search . "% OR `Model` LIKE %'" . $search . "%";
$run = mysqli_query ($connection, $query);

Let me know how it works.

edited Jan 16, 2015 at 21:30

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jan 8, 2015 at 22:13

Asaf Nevo

11.8k23 gold badges85 silver badges154 bronze badges

1 Comment

Abdush Samad Miah Over a year ago

Hi Asaf thanks for the response Patrick's answer above resolved my issue I appreciate your response. Cheers

Collectives™ on Stack Overflow

PHP searching multiple rows in database

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related