Tag : DB


How to use Select with MySQL DATE_FORMAT() in Laravel?

We sometimes require to use MySQL pre-define function like sum(), date_format(), year(), month(), group_concat() etc. But laravel query builder not provide to directly use with select statement. However, we can use all the pre-define function of Mysql using DB::raw(). So, In this post i am going to share with you how to use date_format() in Laravel 5 Query Builder. date_formt() help us to change date format. We may sometimes require to change date format using mysql date_format(). In this example i have simple "users" table and there are some dummy users with created_at row with current time.....

By Hardik Savani | March 16, 2017 | | 2767 Viewer | Category : Laravel MySql
READ MORE

How to get last inserted id in Codeigniter?

Sometimes, we require to get last insert record id from database in controller, so in this example we will learn how to get last inserted row id in Codeigniter 3 project. It's very often need to get last insert id in programming field, if you are working on Codeigniter framework and you want to fetch last created id, i mean max id, then you do easily.Codeigniter provide method insert_id() to get last inserted id. insert_id() is function of "db" library. db library provides several function for connecting database task. insert_id() will return id of last inserted record. So here i give contro.....

By Hardik Savani | February 28, 2017 | | 550 Viewer | Category : MySql Codeigniter
READ MORE

How to get last executed query in Larave 5?

We have been many time need to get executed query log or you want to get last executed query or maybe if you want to diaplsy sql query from laravel query builder then you can do it that. so i have three example for display executed query in Laravel 5. when you are working on laravel application at that times , i think you need many time to print last run query or if you want to check direct from phpmyadmin sql box, so at that time you have to follow this three example. so, let's see three example of getting sql query from Laravel Query Builder. <strong class="step">Example 1:</strong> In this.....

By Hardik Savani | April 10, 2016 | | 3633 Viewer | Category : Laravel
READ MORE

How to get last inserted id in laravel 5?

Its very common need to get last insert id in programming field, if you are working on laravel framework and you want to fetch last created id, i mean max id, then you do easily.laravel provide method to get last inserted id. If you are working with DB::table() then you have to use insertGetId() for insert data into database. this function always return inserted record id(primary key).it is very simple way to get id, in following example you can see and undestand more: <strong>Example:</strong> <pre class="language-php"> public function getLastInsertedIdDB() { $id = DB::table('items')->inser.....

By Hardik Savani | February 6, 2016 | | 11835 Viewer | Category : Laravel
READ MORE

    PHP - How to Convert file(image, audio, video) extension using CloudConvert API?

    PHP - How to Convert file(image, audio, video) extension using CloudConvert API?

    Open Post

    Jquery highlight search text in div using highlight JS with example

    Jquery highlight search text in div using highlight JS with example

    Open Post

    PHP - How to make dependent dropdown list using jquery Ajax?

    PHP - How to make dependent dropdown list using jquery Ajax?

    Open Post

    iOS 7 style switches for checkboxes example using switchery JS

    iOS 7 style switches for checkboxes example using switchery JS

    Open Post

    Laravel 5 - Implementing datatables tutorial using yajra package

    Laravel 5 - Implementing datatables tutorial using yajra package

    Open Post

    How to add charts in Laravel 5 using Chart JS ?

    How to add charts in Laravel 5 using Chart JS ?

    Open Post