php mysql search from 2 columns

Question

$where = "";
$keywords =preg_split('/[\s]+/', $keywords);
$total_keywords = count($keywords);

foreach($keywords as $key=>$keyword) {
    $where .= "`title` LIKE '%$keyword%'";
    if ($key != ($total_keywords - 1)) {
        $where .= " AND ";
    }
}

    $results = "SELECT `id`, `username`, `title`, LEFT(`description`, 90) as `description`, `file`, `code`, `type`, `size`, `date` FROM `files` WHERE $where ORDER BY id DESC LIMIT $start, $per_page";


  $where .= "`title` LIKE '%$keyword%'"; // this case I am searching only in column `title` I want to search too in column `type` with sign '.' I don't know how to include '.' in search result for `type`

Example search for file.exe and get all results with this condition file.exe. Or somebode search only .exe get all results with type .exe $where .= "title, type LIKE '%$keyword%'";//I did it like this no result $where .= "title AND type LIKE '%$keyword%'";//I did it like this no result $where .= "title LIKE '%$keyword%' AND type LIKE '%$keyword%'";//I did it like this no result Someone knows how I can get it my results with title type with sign '.'???

I no discuss the syntax, but you should really need to understand the bottleneck of using wildcard search in MySQL. — ajreal
– ajreal, Commented Jan 31, 2013 at 7:08
Why not use Full-Text search? devzone.zend.com/26/using-mysql-full-text-searching. Of course, it assumes that the table engine is MyISAM. — web-nomad
– web-nomad, Commented Jan 31, 2013 at 7:29

Amir Bilal · Accepted Answer · 2013-01-31 07:35:11Z

2

$where .= "`title` LIKE '%$keyword%' OR type LIKE '$type'";

Updated Code

$pos = strpos($keyword, '.');
if($pos > 0) {
    $parts = explode('.', $keyword);
    $type = array_pop($parts);
    $file = array_pop($parts);
    $where .= "`title` LIKE '%$file%' AND type LIKE '%$type%'";
}
else {
$where .= "`title` LIKE '%$keyword%' OR type LIKE '%$type%'";
}

edited Jan 31, 2013 at 7:35

answered Jan 31, 2013 at 7:08

Amir Bilal

4573 silver badges7 bronze badges

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

9 Comments

Amir Bilal Over a year ago

If you want to match both .exe and exe then you should put wildcard with type. type LIKE '%$type%'

user1929805 Over a year ago

this is way I know but is not working I am write file all is gut but when I write file.exe it is not working

user1929805 Over a year ago

do you know where is the problem

user1929805 Over a year ago

second condition it is not searching 'OR type LIKE '$type''

Amir Bilal Over a year ago

use trim(array_pop($parts)) in place of array_pop($parts) that should search file .exe . If you want more options of search then try full text search or solr/lucene

|

Devang Rathod · Accepted Answer · 2013-01-31 07:32:37Z

1

$where .= "`title` LIKE '%$keyword%' OR type LIKE '%$type%'";

answered Jan 31, 2013 at 7:32

Devang Rathod

6,7342 gold badges25 silver badges32 bronze badges

Collectives™ on Stack Overflow

php mysql search from 2 columns

2 Answers 2

9 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related