Support the ongoing development of Laravel.io →

4,603 Threads

Select from subquery

hi, i need to do this query: SELECT avg(vote) FROM (SELECT max(timestamp), vote FROM votes_table WHE...

0 Likes
1 Replies
posted 10 years ago

Selects with joins and wheres

I'm trying to select specific columns from two tables however when I add the ->select() method in...

0 Likes
3 Replies

Database query returns null

This code returns true when run and I don't get it. What am I doing wrong. Thanks guys! profile = DB...

0 Likes
2 Replies
posted 10 years ago

Where NOT in pivot table.

In the old forum there was a thread called the same asking for an „ItemsNot()“ function: http://foru...

0 Likes
1 Replies

Eager loaded results not sorting

I have a query with eager loaded results that need to be sorted. I've used similar code in other are...

0 Likes
0 Replies

Eloquent join not working

For some reason when I do the following it only lists this. Any ideas as to what I am doing wrong....

0 Likes
10 Replies

ErrorException (E_UNKNOWN) Undefined variable...

Hi, I have this function for password recovery public function postForgotPassword() {...

0 Likes
3 Replies
Solved

Visually Change and Save Row Order to Database

I am using "Bllim" Package (Server-side handler of DataTables Jquery Plugin for Laravel 4)...

0 Likes
4 Replies

Eloquent ORM find related object

What is the correct way to find a related object based on a where clause with Eloquent ORM? For exam...

0 Likes
1 Replies
posted 10 years ago

Error: SQLSTATE[42000]: Syntax error or access violation: 1064

Hi, I have the following error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an...

0 Likes
1 Replies

Get Json In desired format

Hello Every One, I am working on a web application ,which takes json as input and display it on web...

0 Likes
0 Replies

syntax error, unexpected '$test' (T_VARIABLE)

Can someone please tell me why assigning the content of another variable to the protected $table var...

0 Likes
1 Replies

How to stop Encypting/Decrypting saved data from losing everything after double quotes?

I have an app that is taking data from a form, encrypting it, writing the encrypted data to a field...

0 Likes
3 Replies
Solved

Eloquent Models/Relations

Previously I was using raw SQL statements in a non-Laravel environment so this is a port from that t...

0 Likes
2 Replies

Can I specify a database connection for an individual unit test?

My test suite currently has 67 tests and 167 assertions. If I run the tests in a SQLite memory datab...

0 Likes
2 Replies
Solved
posted 10 years ago

Laravel recipes site

Hello, I'm new in laravel. My question regards a creation of a recipes site. I created one for my sc...

0 Likes
1 Replies
posted 10 years ago

How to optimize speed for thousands of inserts

Hi I have the following Problem: I have to insert more than 75 000 rows into one myisam table. I'm u...

0 Likes
9 Replies

4.1 - Database Sessions - CSRF issue

I am using Laravel 4.1.30 (employer is stuck on php 5.3). I am new to this so please be kind ;-) Th...

0 Likes
0 Replies

MySQL default credentials and database

I have setup Laravel and trying to run the artisan migrate command however I am getting the error [P...

0 Likes
3 Replies
Solved

Nested Select

Hey, not sure how this is done using Query Builder? I want to do something like this: getDetails($id...

0 Likes
1 Replies

Thanks to our community

Solutions given in the past year. Excluding solutions from thread authors.

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.