<?
$date = date('Y-m-d H:i:s');
ini_set('max_execution_time', 300);
if ($_SERVER['REQUEST_METHOD'] === 'POST')
    $search = $_POST['search'];
else
	$search = $_GET['search'];
$search = str_replace("|"," ",$search);
$myfile = fopen("search.txt", "w") or die("Unable to open file!");
fwrite($myfile,$search);
fclose($myfile);
$searchArray = explode(" ",$search);
$condition = "";
$n = 0;
foreach($searchArray as $stext)
{
	if($n>0)
	{
		$condition = $condition." AND ";
	}
	$condition = $condition."productname LIKE '%".$stext."%'";
	$n++;
}
include("connect.php");
mysqli_query($mysqli,"SET character_set_results=utf8");
mysqli_query($mysqli,"SET character_set_client=utf8");
mysqli_query($mysqli,"SET character_set_connection=utf8");
$sql = "SELECT *  FROM allstores WHERE ".$condition." group by barcode LIMIT 0,100";
$result = $mysqli->query($sql);
while($row=$result->fetch_row())
{
	echo $row[0]."|".$row[1]."|".$row[2].chr(13).chr(10);
}
?>