Search This Blog

Thursday, April 7, 2016

HAM - PHP LAY DU LIEU TU MYSQL CO THAM SO TREN THANH URL

<?php

$iddm = $_GET["idDanhMuc"] ;
settype( $iddm ,"int");
$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  iddanhmuc = $iddm ");

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;
}
}
 
?>

No comments:

Post a Comment