本文整理匯總了PHP中DataProvider::Query方法的典型用法代碼示例。如果您正苦於以下問題：PHP DataProvider::Query方法的具體用法？PHP DataProvider::Query怎麽用？PHP DataProvider::Query使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DataProvider的用法示例。
在下文中一共展示了DataProvider::Query方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getTinhById
public static function getTinhById($id)
{
$strSQL = "select *\r\n\t\t\t\t\tfrom tinh where id={$id}";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_row($result, MYSQL_BOTH);
}示例2: GetAdvByID
public static function GetAdvByID($id)
{
$strSQL = "\tselect * from quangcao\r\n\t\t\t\t\t\twhere id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_array($result, MYSQL_BOTH);
}示例3: GetTTNDByID
public static function GetTTNDByID($id)
{
$strSQL = "select * \r\n\t\t\t\t\t from loaidichvu\r\n\t\t\t\t\t where id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_array($result);
}示例4: GetAll
public static function GetAll()
{
$strSQL = "\tselect * \r\n\t\t\t\t\t\tfrom user_role \t\t\t\t\r\n\t\t\t\t\t\t";
$result = DataProvider::Query($strSQL);
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$return[] = $row;
}
return $return;
}示例5: selectId
public static function selectId($id)
{
$strSQL = "select * from donvidichvu where id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_row($result, MYSQL_BOTH);
}示例6: GetPhapLyById
public static function GetPhapLyById($id)
{
$strSQL = "select *\r\n\t\t\t\t\tfrom tinhtrangphaply where id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_array($result);
}示例7: getALL
public static function getALL()
{
$strSQL = "select * from loaidichvu";
$result = DataProvider::Query($strSQL);
while ($row = mysql_fetch_row($result, MYSQL_BOTH)) {
$return[] = $row;
}
return $return;
}示例8: GetHuongNhaById
public static function GetHuongNhaById($id)
{
$strSQL = "select *\r\n\t\t\t\t\tfrom huongnha where id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_array($result);
}示例9: delete
public static function delete($id)
{
$strSQL = "delete from thuchi where id={$id}";
$result = DataProvider::Query($strSQL);
if (mysql_affected_rows() == 0) {
return null;
}
return mysql_fetch_row($result, MYSQL_BOTH);
}示例10: GetAllTienIchId
public static function GetAllTienIchId($id)
{
$strSQL = "select *\r\n\t\t\t\t\t from tienich where id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
return mysql_fetch_array($result);
}示例11: selectID
public static function selectID($id)
{
$strSQL = "select * from gioithieu where id='{$id}'";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
$row = mysql_fetch_row($result, MYSQL_BOTH);
return $row;
}示例12: getAllBySQL
public static function getAllBySQL($strSQL)
{
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
while ($row = mysql_fetch_row($result, MYSQL_BOTH)) {
$return[] = $row;
}
return $return;
}示例13: GetLevelByNhanVien
public static function GetLevelByNhanVien()
{
$strSQL = "select * \r\n\t\t\t\t\t from level\r\n\t\t\t\t\t where idlevel<3";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$return[] = $row;
}
return $return;
}示例14: getAllHinhAnhByDichVuID
public static function getAllHinhAnhByDichVuID($iddichvu)
{
$strSQL = "Select * from hinhanh where iddichvu={$iddichvu}";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$return[] = $row;
}
return $return;
}示例15: GetTinVipById
public static function GetTinVipById($id)
{
$strSQL = "select * from dichvuvip\r\n\t\t\t\t\t where iddichvu='{$id}' and status=0";
$result = DataProvider::Query($strSQL);
if (mysql_num_rows($result) == 0) {
return null;
}
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$return[] = $row;
}
return $return;
}