static function findByWechatId($wechat_id) { global $mysqli; $query = 'SELECT * FROM wechat_account WHERE wechat_id=' . DBObject::prepare_val_for_sql($wechat_id); $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { $obj = new WechatAccount(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }
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; }
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; }
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; }
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; }
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; }
static function findByWechatAccountId($wid) { global $mysqli; $user = MySiteUser::getCurrentUser(); $query = 'SELECT * FROM user_' . $user->getId() . '_account WHERE account_id=' . DBObject::prepare_val_for_sql($wid); $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { $obj = new UserWechatAccount(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }
static function findByEmail($email) { global $mysqli; $query = 'SELECT * FROM user WHERE email=' . DBObject::prepare_val_for_sql($email); $result = $mysqli->query($query); if ($result && ($u = $result->fetch_object())) { $user = new User(); DBObject::importQueryResultToDbObject($u, $user); return $user; } return null; }
static function findByEmail($email, $instance = 'SiteUser') { global $mysqli; $query = 'SELECT * FROM site_user WHERE email=' . DBObject::prepare_val_for_sql($email); $result = $mysqli->query($query); if ($result && ($b = $result->fetch_object())) { if (class_exists('MySiteUser')) { $instance = 'MySiteUser'; } $obj = new $instance(); DBObject::importQueryResultToDbObject($b, $obj); return $obj; } return null; }