explode.php

<?php
require 'lesson44.php';
?>
<form action = "explode.php" method = "post">
search: <input type= "text" name ="s_text">
<input type= "submit" value="search">
</form>

<?php

if (isset ($_POST ['s_text'])){
$s_text = $_POST ['s_text'];
echo 'u entered:'.$s_text. '<br/>';
$namesar = explode(' ' , $s_text);
$size= sizeof($namesar);

$i=0;
while ($i < $size)
{
$search= $namesar[$i]  ;
echo 'search engine started' . $search;
$query = "SELECT `name` FROM `foods` WHERE `name` LIKE '%$search%' ";
$query_run = mysqli_query($mycon, $query);
$num_rows = mysqli_num_rows($query_run);

if ($num_rows >= 1) {
echo '<h1>' .$num_rows.'results found</h1>';
while ($row = mysqli_fetch_assoc($query_run)){
echo $row['name']. '<br><br>';
}
}else{
echo 'no results found';
}



$i++;
}

}


?>