Bnu6ZsnC

1CREATE TABLE IF NOT EXISTS `interests` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `iName` varchar(255) NOT NULL,
4  `iDesc` varchar(255) NOT NULL,
5  PRIMARY KEY (`id`)
6) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
7	
8function funArray($var) {
9
10    if(!is_string($var)) { // no string
11      return "die " . $var;
12    } elseif(stripos($var,',') == FALSE) { // only one
13      return $var;
14    } else { // more than one
15      $var = explode(',', $var);
16      return $var;
17    }
18
19}
20
21$arrayInteresInput= isset($_POST['interes']) && $_POST['interes'] ? strip_slashes(trim($_POST['interes'])) : "";
22
23echo '<form action="" method="post" autocomplete="off">
24<input type="text" name="interes" placeholder="Search Input" /><br/>
25<input type="submit" value="Submit" name="searchf" />
26</form>';
27
28if (isset($_POST['searchf'])  &&  $_POST['searchf']) {
29
30    $intArr = funArray($arrayInteresInput);
31    $result = $db->query("
32    SELECT * FROM `interests` 
33    WHERE `iName`
34    LIKE '%" . $intArr . "%'");
35
36
37    if ($result->num_rows > 0) { 
38        while ($row = $result->fetch_array()) {
39            $storeArray[] =  $row;  
40        }
41        foreach ($storeArray as $row) {
42            $name = $row['iName'];
43            $desc = $row['iDesc'];
44            echo "$name $desc<br />n";
45        }
46    } else {
47            echo "No result";
48    }
49}