Showing posts with label query builder. Show all posts
Showing posts with label query builder. Show all posts

Wednesday, May 3, 2017

Insert using DB table doesnt update timestamp

In laravel there are two ways to insert data/record, using DB table or using model, but i found a problem when inserting the data using DB t...

Tuesday, May 2, 2017

How to insert, update and delete in Laravel

If you are just learning about laravel, meaning you are beginner of laravel, you probably want to know about how to do insert, update and de...

Sunday, April 30, 2017

How to get raw SQL query in Laravel

Using eloquent in laravel is very convenient, but sometimes you want to know the raw SQL query that's executed behind the scene, so how ...

How to do insert using DB table in Laravel

In laravel you can insert data to a table in two ways, the first one and the most common is using a model, create a model for that table and...

Sunday, April 23, 2017

How to do raw query in Laravel

Besides the standard methods for database query that are available on laravel, you also have an option to do raw query, in this article i wi...

Laravel query builder example

Instead of hand coding SQL code on your application, you should try to use query builder in laravel, in this article i will show some of the...

Tuesday, April 4, 2017

How to check table column exist or not in Laravel

Besides the 'hasTable' static method, you also have 'hasColumn' method which can check column exist or not on database table...

How to check table exist or not in Laravel

Is it possible to check existence of database table in laravel code? the answer is yes, it is possible to check whether a table already exis...

Laravel 4.2 schema table column types

These are list of schema table column types that you can use when creating database migration on laravel 4.2, most of these column types als...

Wednesday, March 22, 2017

How to get table prefix in Laravel 4.2

On your database configuration (app/config/database.php), you can specify a prefix for every table that you use on your database, the questi...