Exemple #1
0
 /**
  * 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'));
 }
Exemple #2
0
 /**
  * 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'));
 }