/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $sql = $request->input('sqlStatement'); $data = executeQuery($sql); $format = getHeaders($data); Sql::firstOrCreate(['sqlhash' => md5($sql), 'sql' => $sql]); return view('sql.index', compact('data', 'format', 'sql')); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { $sql = $request->input('sqlStatement'); Sql::firstOrCreate(['sql' => $sql]); $sqlSelect = new SqlSelect($sql); $data = $sqlSelect->executeQuery(); $format = $sqlSelect->parseSql(); return view('sql.index', compact('data', 'format', 'sql')); }