diff options
| -rw-r--r-- | site/app/Http/Controllers/LookupController.php | 26 | ||||
| -rw-r--r-- | site/routes/web.php | 2 |
2 files changed, 28 insertions, 0 deletions
diff --git a/site/app/Http/Controllers/LookupController.php b/site/app/Http/Controllers/LookupController.php new file mode 100644 index 0000000..5215704 --- /dev/null +++ b/site/app/Http/Controllers/LookupController.php @@ -0,0 +1,26 @@ +<?php +namespace App\Http\Controllers; +use Illuminate\Http\Request; +use App\Helpers\CryptoHelper; + +use Illuminate\Support\Facades\DB; +use App\Http\Controllers\Controller; + +use Illuminate\Support\Facades\Input; + +class LookupController extends Controller { + /** + * Shows the index page. + * + * @return Response + */ + public function showPage(Request $request) { + + + $query = "SELECT name, shop, spirit_type FROM all_view WHERE short_url = ? LIMIT 1)"; + + $data = DB::table('all_view')->select('name', 'shop', 'spirit_type')->where('url', "https://l.fuselkoenig.de/" . Input::get('short_url'))->limit(1)->get(); #$query, "https://l.fuselkoenig.de/" . Input::get('short_url')); + + return response()->json($data); + } +} diff --git a/site/routes/web.php b/site/routes/web.php index f2dc390..d467ce0 100644 --- a/site/routes/web.php +++ b/site/routes/web.php @@ -32,6 +32,8 @@ Route::get('/misc/feed', 'FeedController@showPage')->name('misc_feed'); Route::get('/all/feed', 'FeedController@showPage')->name('all_feed'); Route::get('/search/feed', 'FeedController@showPage')->name('search_feed'); +Route::get('/_/api/lookup', 'LookupController@showPage')->name('lookup'); + Route::get('/welcome', function () { return view('welcome'); }); |