Create a Website Search in PHP

// first create a HTML form

  --create a new file search.php

<form method="post" action="search.php">
<input type="text" class="srch" name="query" placeholder="Enter KeyWord" size="44" maxlength="500" required>
<input type="submit" name="submit" class="btn" value="Search">
</form>

-- add php in search.php

<?php

-- add database connection in search.php

include_once("control.php");
$obj= new Control();
$obj->connect();

-- using $_POST variable form submit and get data
if (isset($_POST['submit'])) {
$query=$_POST['query'];
$obj->search($query);
}
?>

-- and my class file control.php

<?php

class Control{
public $localhost ="localhost";
public $root ="root";
public $sdb ="shoppingcart";
protected $connection;

 function connect(){
$connection=mysql_connect($this->localhost,$this->root)or die(mysql_error());
$connection=mysql_select_db($this->sdb)or die(mysql_error());
}

function search($query){
$fields = array('name', 'address', 'city', 'state', 'zip');
$sql=mysql_query("SELECT * FROM `addproduct` WHERE pname like '%$query%' OR  bname like '%$query%' OR price like '%$query%' OR cat like '%$query%'")or die(mysql_error());
$count=mysql_num_rows($sql);
if ($count>0) {
while ($row=mysql_fetch_array($sql)) {
$id=$row['id'];
echo "<br><br><br><table style='margin-left:12px;'><tr><td style='color:blue; font-size:20px; text-transform:capitalize;'><a href='product.php?id=$id'>".$row['pname']."</a></td></tr><tr><td style='text-transform:capitalize;'>Brand Name:&nbsp;&nbsp;&nbsp;".$row['bname']."</td></tr><tr><td style='color:green;'>Price:&nbsp;&nbsp;&nbsp;$".$row['price']."</td></tr></table>";
}
}
if (empty($count)) {
echo"<p style='margin-left:12px;'>Product Are Not Found</p>";
}
}
}
?>