HAM - TIM KIEM DU LIEU THEO TU KHOA TREN THANH URL

<?php

$tukhoa = $_GET["tukhoa"] ;
settype( $tukhoa ,"string");
$mang = array() ; 

mysql_connect("MYSQL5014.HostBuddy.com","9f4d6d_home","mật khẩu") ;
mysql_select_db("db_9f4d6d_home");
mysql_query("SET NAMES 'utf8'");



$db  = mysql_query(" SELECT * FROM `shop_sanpham` WHERE tensanpham LIKE '%$tukhoa%' "); 

while($row = mysql_fetch_array($db)){

$idsanpham = $row["id"] ;
$tensanpham = $row["tensanpham"] ;
$gia = $row["gia"];
$urlhinh = $row["urlhinh"] ;
$mota = $row["mota"];
$motachitiet = $row["motachitiet"];

array_push($mang , new DanhSachSanPham ($idsanpham ,$tensanpham,$gia,$urlhinh,$mota,$motachitiet));
}


header('Content-Type:application/json');

echo json_encode($mang);

class DanhSachSanPham{

var $idsanpham ;
var $tensanpham ;
var $gia ;
var $urlhinh;
var $mota ;
var $motachitiet ;


function DanhSachSanPham($idsp,$tensp,$g,$url,$mt,$mtct){

$this->idsanpham = $idsp;
$this->tensanpham = $tensp;
$this->gia = $g;
$this->urlhinh = $url;
$this->mota = $mt;
$this->motachitiet = $mtct;
}
}
   
?>