public static function get_product() { $db = oralceinit(2); $sql = "SELECT id,name FROM tbl_product WHERE is_exist=1"; $query = $db->Select($sql); $data = array(); while ($row = $db->FetchArray($query)) { if (!$row) { return false; } $data[] = array_change_key_case($row); } return $data; }
public static function get_coopinfo_boss($coop_id) { $db = oralceinit(2); $query = $db->fetch_first("SELECT * FROM tbl_subcooperatotr WHERE "); }
public function dealdata($uid) { $sql = "SELECT * from SS_USER where ID =" . $uid; $db = oralceinit(2); $result = $db->FetchRow($db->query($sql)); $sql_insert = "INSERT into iosadm_admin_user set user_name='{$result['2']}',truename='{$result['3']}',bossname='{$result['2']}',email='{$result['1']}',password='******'4']}'"; return pm_db::query($sql_insert); }