本文整理汇总了PHP中DBObject::importQueryResultToDbObject方法的典型用法代码示例。如果您正苦于以下问题:PHP DBObject::importQueryResultToDbObject方法的具体用法?PHP DBObject::importQueryResultToDbObject怎么用?PHP DBObject::importQueryResultToDbObject使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBObject
的用法示例。
在下文中一共展示了DBObject::importQueryResultToDbObject方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: findByName
public static function findByName($name)
{
global $mysqli;
$query = 'SELECT * FROM site_permission WHERE name=' . DBObject::prepare_val_for_sql($name);
$result = $mysqli->query($query);
if ($result && ($b = $result->fetch_object())) {
$obj = new SitePermission();
DBObject::importQueryResultToDbObject($b, $obj);
return $obj;
}
return null;
}
示例2: findByName
static function findByName($name)
{
global $mysqli;
$query = 'SELECT * FROM block WHERE name=' . DBObject::prepare_val_for_sql($name) . ' LIMIT 1';
$result = $mysqli->query($query);
if ($result && ($b = $result->fetch_object())) {
$obj = new Block();
DBObject::importQueryResultToDbObject($b, $obj);
return $obj;
}
return null;
}
示例3: findByName
static function findByName($name)
{
global $mysqli;
$query = 'SELECT * FROM vars WHERE name=' . DBObject::prepare_val_for_sql($name);
$result = $mysqli->query($query);
if ($result && ($v = $result->fetch_object())) {
$var = new Vars();
DBObject::importQueryResultToDbObject($v, $var);
return $var;
}
return null;
}
示例4: findByUId
public static function findByUId($uid)
{
global $mysqli;
$query = 'SELECT * FROM site_profile WHERE user_id=' . $uid;
$result = $mysqli->query($query);
if ($result && ($b = $result->fetch_object())) {
$obj = new SiteProfile();
DBObject::importQueryResultToDbObject($b, $obj);
return $obj;
}
return null;
}
示例5: findByCombo
static function findByCombo($bizid, $mid, $idx, $instance = "WechatArticle")
{
global $mysqli;
$query = "SELECT * FROM wechat_article WHERE biz_id=" . DBObject::prepare_val_for_sql($bizid) . " AND mid=" . DBObject::prepare_val_for_sql($mid) . " AND idx=" . $idx . " LIMIT 1";
$result = $mysqli->query($query);
if ($result && ($b = $result->fetch_object())) {
$obj = new $instance();
DBObject::importQueryResultToDbObject($b, $obj);
return $obj;
}
return null;
}
示例6: findAllByCountryId
static function findAllByCountryId($cid)
{
global $mysqli;
$query = "SELECT * FROM course WHERE country_id={$cid} ORDER BY weight ASC";
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new Institution();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例7: findByUid
static function findByUid($uid)
{
global $mysqli;
$query = 'SELECT * FROM site_user_role WHERE user_id=' . $uid;
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new SiteUserRole();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例8: findByAccountId
static function findByAccountId($account_id)
{
global $mysqli;
$query = "SELECT * FROM wechat_account_user WHERE account_id=" . $account_id;
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new WechatAccountUser();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例9: findAll
static function findAll()
{
global $mysqli;
$query = "SELECT * FROM carousel ORDER BY weight ASC";
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new Carousel();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例10: findAllPublished
static function findAllPublished()
{
global $mysqli;
$query = "SELECT * FROM page WHERE published=1";
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new Page();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例11: getPermissions
public function getPermissions()
{
global $mysqli;
$query = "SELECT P.* FROM site_permission_role AS PR, site_permission AS P WHERE P.id=PR.permission_id AND PR.role_id=" . $this->getid();
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new SitePermission();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例12: findAll
static function findAll($limit = false)
{
global $mysqli;
$query = "SELECT * FROM news ORDER BY date DESC" . ($limit ? " LIMIT {$limit}" : "");
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new News();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例13: findAllByCountryId
static function findAllByCountryId($cid)
{
global $mysqli;
$query = 'SELECT * FROM menu WHERE country_id=' . DBObject::prepare_val_for_sql($cid);
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new Menu();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例14: findAllByMenuId
static function findAllByMenuId($menu_id)
{
global $mysqli;
$query = "SELECT * FROM menu_item WHERE menu_id={$menu_id}";
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new MenuItem();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}
示例15: findAllToCrawl
static function findAllToCrawl($span = 3600)
{
global $mysqli;
$query = "SELECT * FROM wechat_account WHERE active=1 AND (last_scheduled IS NULL OR last_scheduled < " . (time() - $span) . ")";
$result = $mysqli->query($query);
$rtn = array();
while ($result && ($b = $result->fetch_object())) {
$obj = new WechatAccount();
DBObject::importQueryResultToDbObject($b, $obj);
$rtn[] = $obj;
}
return $rtn;
}