How To Use WITH RECURSIVE in Laravel

Question

I have a query but i don't know how to run in Laravel

WITH RECURSIVE category_path (id, name, lvl) AS(SELECT id, name, 0 lvl FROM category WHERE parent =1  UNION ALL SELECT c.id, c.name,cp.lvl + 1 FROM category_path AS cp JOIN category AS c ON cp.id = c.parent) SELECT * FROM category_path GROUP BY lvl ORDER BY lvl DESC limit 1

AiverReaver · Accepted Answer · 2019-07-06 12:12:35Z

2

You can use DB::select('your query here'); here is official link to doc laravel

answered Jul 6, 2019 at 12:12

AiverReaver

1641 gold badge2 silver badges10 bronze badges

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

Comments

Muhammad Bilal · Accepted Answer · 2019-07-06 12:12:16Z

0

I Think You want to use Raw Query You Can try this:

DB::select(DB::raw('your query here'));

answered Jul 6, 2019 at 12:12

Muhammad Bilal

5271 gold badge5 silver badges13 bronze badges

5 Comments

Muhammad Bilal Over a year ago

Can you show me what You get in response by this method

Narendra jhala Over a year ago

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RECURSIVE category_path (id, title, lvl) AS ( SELECT id, title, 0 lvl FROM' at line 1 (SQL: WITH RECURSIVE category_path (id, title, lvl) AS ( SELECT id, title, 0 lvl FROM category WHERE parent_id IS NULL UNION ALL SELECT c.id, c.title,cp.lvl + 1 FROM category_path AS cp JOIN category AS c ON cp.id = c.parent_id ) SELECT * FROM category_path ORDER BY lvl)

Namoshek Over a year ago

Does your query run if executed directly in sql?

Muhammad Bilal Over a year ago

This is a syntax error in your query laravel is executing query perfectly try to run your query in phpmyadmin

Narendra jhala Over a year ago

mysql version mismatch

Collectives™ on Stack Overflow

How To Use WITH RECURSIVE in Laravel

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related