Tag: laravel

Laravel put array into selectbox

I am facing some problems with my selectbox, where i will put all available categories into the In my controller i am using this snip: return View::make(“stories.add”) ->with(“title”,”…

Safely remove migration In Laravel

artisan-migrate database laravel php

In Laravel, there appears to be a command for creating a migration, but not removing. Create migration command: If I want to delete the migration, can I just safely delete the corresponding migrations file within the database/migrations folder? Migrations file: Answer I accidentally created a migration with a…

Laravel Add a new column to existing table in a migration

laravel laravel-migrations php

I can’t figure out how to add a new column to my existing database table using the Laravel framework. I tried to edit the migration file using… In terminal, I execute php artisan migrate:install and migrate. How do I add new columns? Answer To create a migration, you may use the migrate:make comma…

How to echo to console in Laravel and Artisan?

console laravel laravel-4 migration php

I was curious, I’m using Laravel and Artisan for my migrations. Is there a method to output information to the console? I can’t seem to find any information on this. For example: Answer Don’t know if you are using Laravel 3 or Laravel 4, and if its also possible in Laravel 3, but i found thi…

manipulate a result set from laravel eloquent

eloquent laravel php

I’ve just picked up laravel after deciding to move to a php framework. I’m retrieving a result set of articles from a database using an eloquent query: this works fine and results come out as expected. However I now want to change the format of the article date from the mysql date format to anothe…

Laravel 4 always returns HTTP status code 200

laravel laravel-4 php

I have below code in error.php, which is triggered using App::abort(404, $error) in my controller. Still my response status code is 200(ok). I tried with various error codes like 400, 403 Answer For anyone still googling this problem: I was struggling with this problem for hours. For me the problem was caused…

Why don’t large files download easily in Laravel?

laravel laravel-3 php

My file (126 MB size, .exe) is giving me issues. I’m using the standard laravel download method. I tried increasing the memory but it still either says I have run out of memory, or I download a 0 KB size file. The documentation doesn’t mention anything about large file sizes. My code is Anything I…

Is there any way to detect if a database table exists with Laravel

laravel php

I want to be able to create a table using But before that I would like to check if the table already exists, perhaps something like However, the above function does not exist. What else can I use? Answer If you are using Laravel 4 or 5 then there is the hasTable() method, you can find it in the L4

Summing over multiple fields in Laravel

laravel php

I’m wondering if it is possible to take the sum of multiple fields in one query using the fluent query builder. I currently have two tables: events and attendees. Attendees belong to events and have two fields: total_raised and total_hours. What I want to do is select all events and the total amount rai…

Select from multiple tables with laravel fluent query builder

laravel mysql php

I’m re-writing some PHP/MySQL to work with Laravel. One thing I would like to do is make the DB queries more succinct with the Fluent Query Builder but I’m a bit lost: SELECT p.post_text, p….