Using PHP array in a SQL query in Laravel 5.2

Question

I'm a beginner in Laravel. I have faced a issue in using a PHP array in a SQL statement. I have a array $waypointsand it contains names of cities.

$waypoints = array("Paris", "Moscow", "London","New York");

And i want to find their corresponding city id by a SQL query. Code is as follow.

$cityname = $waypoints[2];

$city = City::where('name', 'LIKE', "$cityname%")->firstOrFail();

But this query does not get executed. But if i set a string value to variable $cityname manually, it get executed. As example $cityname = "London";. I can't figure out the issue. Help Needed.

London has the index 2, not 3. We start counting on 0. What is print_r($waypoints)? — Christian Gollhardt
– Christian Gollhardt, Commented Mar 29, 2016 at 4:23
I am not familar with laravel, but as long $cityname = "London" works, $waypoints[2] is not "London". See var_dump($waypoints) — Christian Gollhardt
– Christian Gollhardt, Commented Mar 29, 2016 at 4:29
var_dump($waypoints) is as follows. array (size=4)' 0 => string 'Paris' (length=5) 1 => string 'Moscow' (length=6) 2 => string 'London' (length=6) 3 => string 'New York' (length=8) — AnuradhaH
– AnuradhaH, Commented Mar 29, 2016 at 4:45

Christian Gollhardt · Accepted Answer · 2016-03-29 04:34:28Z

1

You can always use ->toSql(); to get the query string for debugging.

edited Mar 29, 2016 at 4:34

Christian Gollhardt

17.1k17 gold badges82 silver badges119 bronze badges

answered Mar 29, 2016 at 4:33

L. Palaiokostas

9976 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Using PHP array in a SQL query in Laravel 5.2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related