Ban Quản Trị Kết quả Tra Cứu Danh Sách

[insert_php]

$dieukien=””;
$ten=””;if(isset($_POST[‘ten’])){ $ten = $_POST[‘ten’]; $ten=trim($ten);$dieukien=”Ten=’$ten'”;};
$phuong=””;if(isset($_POST[‘phuong’])){ $phuong=$_POST[“phuong”]; $phuong=trim($phuong);$dieukien=”Phuong=’$phuong'”;};
$quan=””;if(isset($_POST[‘quan’])){ $quan=$_POST[“quan”]; $quan=trim($quan);$dieukien=”Quan=’$quan'”;};
$tinhthanh=””;if(isset($_POST[‘tinhthanh’])){ $tinhthanh=$_POST[“tinhthanh”]; $tinhthanh=trim($tinhthanh);};
$dantoc=””;if(isset($_POST[‘dantoc’])){ $dantoc=$_POST[“dantoc”]; $dantoc=trim($dantoc);};
$ngonngu=””;if(isset($_POST[‘ngonngu’])){ $ngonngu=$_POST[“ngonngu”]; $ngonngu=trim($ngonngu);};
$cmnd=””;if(isset($_POST[‘cmnd’])){ $cmnd=$_POST[“cmnd”]; $cmnd=trim($cmnd);};
$ngaysinh=””;if(isset($_POST[‘ngaysinh’])){ $ngaysinh=$_POST[“ngaysinh”]; $ngaysinh=trim($ngaysinh);};
$hocvan=””;if(isset($_POST[‘hocvan’])){ $hocvan=$_POST[“hocvan”]; $hocvan=trim($hocvan);};
$nghenghiep=””;if(isset($_POST[‘nghenghiep’])){ $nghenghiep=$_POST[“nghenghiep”]; $nghenghiep=trim($nghenghiep);};
$tel=””;if(isset($_POST[‘tel’])){ $tel=$_POST[“tel”]; $tel=trim($tel);};
$database=”danhsachdangky”;
$db=mysqli_connect (“localhost”, “chuaong_wit”,”chuaongthuduc88″,”chuaong_wit”) ;
if (!$db) {
die(‘Connect Error (‘ . mysqli_connect_errno() . ‘) ‘
. mysqli_connect_error());
}
mysqli_query($db,”SET CHARACTER SET ‘utf8′”);
mysqli_query($db,”SET SESSION collation_connection =’utf8_general_ci'”);

$lenhdau= “select * from $database where “;
$lenhcuoi=” order by MesID desc”;
$query=”$lenhdau $dieukien $lenhcuoi”;
echo “$query

“;
$result = mysqli_query($db,$query);

echo “

“;
[/insert_php]