summaryrefslogtreecommitdiff
path: root/site/app/Http/Controllers/LookupController.php
blob: 5215704d9392fd0a0877b9128b617da59272fd4e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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);
    }
}