public static function query_allmemneweve() { $sql = "SELECT * FROM `tk_buburegusr`"; $result = dbconn::db_GetAll($sql); $m = 0; foreach ($result as $row) { $result[$m]['sns_info'] = dbconn::getFBUserById($row['usr_uid']); $result[$m]['definfo'] = dbconn::get_oneusr($row['usr_uid']); $sql2 = "SELECT * FROM `tk_bubu_deviceids` WHERE `dev_uid` = '" . $result[$m]['definfo']['id'] . "';"; $result[$m]['deviceids'] = dbconn::db_GetAll($sql2); $result[$m]['countn'] = dbconn::count_member_xu($row['usr_uid']); #$count = dbconn::count_comkey( $result[$m]['usr_makekey'] ); #$result[$m]['countn'] = $count + ( count( $result[$m]['deviceids'] ) * 50 ) ; $m++; } return $result; }
<?php #載入預設系統 include_once "libraries/load.php"; #執行應用程式 $userdata['definfo'] = dbconn::get_oneusr($_SESSION['user']['id']); $userdata['othinfo'] = dbconn::get_usruid($_SESSION['user']['id']); $userdata['count'] = dbconn::count_member_xu($_SESSION['user']['id']); #載入View if ($_SESSION['checkmobile'] == 1) { $view = 'views/mobile/m.index.php'; } else { $view = 'views/web/index.php'; } include_once $view;