Lab Sql

i want to access to data in the function of the controller using relationships on Laravel. I will e… Read more Acces To Data Using Relationships Laravel

How to convert this raw query to Laravel eloquent way: select c.name as country from country c, add… Read more Convert Raw Query To Laravel Eloquent

From a fresh project, I tried to rename the 'users' table to 'app.users'. I manage… Read more Laravel Sql Issue On 5.5 Auth Validation

I have a big problem with my program (WebAPI) made in Laravel. First, this is software's config… Read more Laravel Collection Accentuation Error

How do I convert the following into Eloquent syntax? I know there is a derived table in there, so u… Read more Laravel - How To Convert A Derived Table Containing Concatenation Queries Into Eloquent Syntax?

Hi guys I'm currently stuck in this issue. I'm trying to search something on DB and doesn&#… Read more Laravel Query Using Like Does Not Return Any Result

I thought this would be fairly simple but it's not playing ball currently. I have 2 tables for … Read more Laravel Eloquent - Where Relationship Field Does Not Equal

I am developing a web app that interfaces with an ERP production database and the data is being ret… Read more Making A Laravel Model Use Complex Query As Table

I am doing some joins and trying to get the data. My query builder is: $datasource = DB::table('… Read more Laravel 5 Sqlstate[42s22]: Column Not Found

Iam a software engineer (since a few months ready with my study) and for my work i develop a large… Read more Database Table Structure For Big And Scalable Applications

I tried to deploy my first Laravel project on Heroku. It's a small project, so I'm using SQ… Read more Deploying Laravel On Heroku "pdoexception In Connector.php Line 55" (sqlite)

I'm trying to create a foreign key, artisan does not show me any errors, just does not create m… Read more Laravel Migration Can't Create Foreign Key

I'm using SQLite with my Laravel app and trying to run a whereHas query: $payments = Payment::w… Read more Laravel Sqlite Wherehas Queries Not Working

I want to run a MySQL query like this- SELECT country_ID*2/id*3.159 as my_id FROM `state` WHERE … Read more Mysql - Search Into A Custom Column

I have been following some answers over stackoverflow. My odbc. ini (located in /etc/odbc.ini) [MSS… Read more Pdoexception: Sqlstate 01002 Adaptive Server Connection Failed (severity 9)

please help me with my format query in laravel 5. I am a beginner in using laravel 5, and i just se… Read more Laravel 5 Inner Join And Group By Query Syntax Error

In my Laravel project, in the database table ads, I have the following structure : id | col1 | col… Read more Laravel - Randomly Select N Number Of Rows Containing Same Value In Certain Column After Applying 'order By'

I got this error when i was executing this query on PostgreSQL: SQLSTATE[42803]: Grouping error: 7… Read more Postgresql Grouping Error

My Laravel Query Builder returns an empty collection, while the SQL string itself returns the corre… Read more Sql/laravel - Why Does My Query Returns An Empty Collection?

LARAVEL 5.4 (but probably it's a more general SQL question) Hello! I have a table with a struct… Read more Laravel/sql: Where Column Equals Not And Null