本文整理汇总了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;
}