public function index() { $name = "Ivan"; $age = $_GET['age']; $results = DB::getQueryLog(); var_dump($results); exit; return view("sites.sites")->with("name", $name)->with("age", $age); }
/** * 打印原生态sql * @access protected * @param boolean $needLog 是否要记录日志 * @return array */ protected function printRawSql($needLog = false) { $queries = \DB::getQueryLog(); $formattedQueries = []; foreach ($queries as $query) { $prep = $query['query']; foreach ($query['bindings'] as $binding) { $prep = preg_replace("#\\?#", $binding, $prep, 1); } $formattedQueries[] = $prep; } if ($needLog) { \Log::info($formattedQueries); } return $formattedQueries; }
protected function response($response) { if (Utils::isNinjaDev()) { $count = count(\DB::getQueryLog()); Log::info(Request::method() . ' - ' . Request::url() . ": {$count} queries"); Log::info(json_encode(\DB::getQueryLog())); } $index = Request::get('index') ?: 'data'; if ($index == 'none') { unset($response['meta']); } else { $meta = isset($response['meta']) ? $response['meta'] : null; $response = [$index => $response]; if ($meta) { $response['meta'] = $meta; unset($response[$index]['meta']); } } $response = json_encode($response, JSON_PRETTY_PRINT); $headers = Utils::getApiHeaders(); return Response::make($response, 200, $headers); }
public function testPermissions() { \DB::enableQueryLog(); $user = \Auth::user(); // $role = Role::create(['name' => 'test', 'slug' => 'test', 'description' => 'test']); // $user->assignRole(Role::where('slug', 'test')->first()); // $user->revokeRole($role = Role::where('slug', 'test')->first()); // $role->delete(); dd([$user->getPermissions(), \DB::getQueryLog()]); }