jeudi 14 février 2019

Display Json data in laravel view with Joins

I'm trying to retrieve json data from database to laravel blade view with join associate table.

in my case I have two tables called interesting courses and courses. here some student can have many interesting courses. Courses id stored as json array in database as follows.

["1","11","15","16"] 

but I need to join the courses table to get the associate course name as follows.

["Hospitality","Business Management","Auto Mobile","Health Care"]

How can I do it.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire