CODEWITHSUNDEEP
phplaravel-5.1
Gaurav Mehta
Gaurav Mehta

Reputation: 1153

Controller Variable not Showing up in Query Builder Laravel

I am encountering a strange issue in Laravel.

The below is an index function in one of my controllers.

public function index($merchant_url_text)
{
    //
    $deals = DB::table('tbl_deal')
            -> join ('tbl_merchant', 'tbl_deal.merchant_id', '=', 'tbl_merchant.merchant_id')
            -> where ('merchant_url_text', $merchant_url_text) -> toSql();
    //return $merchant_url_text.$deal_id;
            dd($deals);
            //return $merchant_url_text;
}

As you can see I am passing merchant_url_text from route. 

Route::get('/testroute/{merchant_url_text}', ['uses' =>'dealsVisibleController@index']);

When I am trying to debug the query by printing it, I am getting

"select * from `tbl_deal` inner join `tbl_merchant` on `tbl_deal`.`merchant_id` = `tbl_merchant`.`merchant_id` where `merchant_url_text` = ?"

This means that the query builder is not reading the $merchant_url_text variable. However, when I return just that variable, it is being printed.

Just can't figure out why the query builder is not able to include the $merchant_url_text variable in the query when it is available in the index function.

Any suggestions.

Upvotes: 0

Views: 654

Answers (2)

Daniel Gasser
Daniel Gasser

Reputation: 5133

You may access all your queries by using

$queries = DB::getQueryLog();

It is also printing the query parameters as array.

To get the last query:

dd(end($queries));

To disable the log:

DB::connection()->disableQueryLog();

See the docs for further information.

Upvotes: 1

Koga
Koga

Reputation: 585

I am pretty sure that your code is correct. The SQL output function toSql() does not show the values of variables and only prints out a ? for security reasons.

Upvotes: 2

Related Questions