Why where clause doesn't affect of the query?

Question

Here is my code:

$tracking_codes_obj = new TrackingCode;
$tracking_code = 140;

if ( !is_null($tracking_code) )
    $tracking_codes_obj->where('tracking_code', $tracking_code);

$tracking_codes = $tracking_codes_obj->orderBy('expired')->orderBy('id')->paginate(10);

As you can see $tracking_code is not null, so that condition is true and that where clause should be applied. But still the result is the same as when I completely remove that condition.

Why and how can I fix it?

Alexey Mezenin · Accepted Answer · 2017-12-09 09:38:38Z

3

The correct syntax is:

$tracking_codes_obj = $tracking_codes_obj->where('tracking_code', $tracking_code);

answered Dec 9, 2017 at 9:38

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

stack Over a year ago

Also one PHP question, when exactly should I initialize an object into a variable and when shouldn't? For example in a database connection, no need to initialize anything and everything will be applied by using ->. i.e $db_con = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); $db_con->exec("set names utf8");

stack · Accepted Answer · 2017-12-09 09:47:44Z

1

you need to replace if condition like this :

if ($tracking_code != null)

Instead of

if ( !is_null($tracking_code) )

and code will be like this

$tracking_codes_obj = new TrackingCode;
$tracking_code = 140;

if ($tracking_code != null)
{
    $tracking_codes_obj = $tracking_codes_obj->where('tracking_code', $tracking_code);
}

$tracking_codes = $tracking_codes_obj->orderBy('expired')->orderBy('id')->paginate(10);

edited Dec 9, 2017 at 9:47

stack

10.3k22 gold badges73 silver badges134 bronze badges

answered Dec 9, 2017 at 9:39

parth patel

1417 bronze badges

1 Comment

stack Over a year ago

I'm not sure why did you say I shouldn't have used is_null() function, but anyway your code would work as well because of initializing the object. Thank you

Collectives™ on Stack Overflow

Why where clause doesn't affect of the query?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related