Latest Post


How to get last record from MySQL table in Codeigniter?

In this post we are going to learn how to get last single record from MySQl database table using Codeigniter database library. We sometime require to get only single row result in our Codeigniter application. In this post you can see how to get whole last record using Codeigniter db query. Few day ago i posted <a href="http://itsolutionstuff.com/post/how-to-get-last-inserted-id-in-codeigniterexample.html" target="_blank">"How to get last inserted id in Codeigniter?"</a>, in that post we can simply get last inserted id from Codeigniter db query. In this database query i used order_by(), limit.....

By Hardik Savani | March 9, 2017 | | 1402 Viewer | Category : MySql Codeigniter
READ MORE

Laravel 5 - Custom Helper Facade Class Example from scratch

Today, In this post i am going to share with you how to create custom global helper functions using Helper Facade in our Laravel 5 application. We always need to define some global functions for our application because that way we can access that helper functions from every file of our project. In this tutorial i am going to share with you how we can make global helper function in Laravel framework from scratch. It is very important to create custom helper functions we have before start our projects. In this post we learn how to create custom Helper facade, i also posted few days ago <a href=.....

By Hardik Savani | March 5, 2017 | | 9369 Viewer | Category : PHP Laravel
READ MORE

Laravel - How to search with comma separated values using Query Builder ?

Sometimes, we require to manage to take single column for multiple integer ids, for example if we have "posts" table and require to set multiple tags on each post, so at that time we can take just single column and store selected tags ids. this way will use less memory. It is simple to store data into row, but as you think how we can search or find specific tag id data from comma separated column value using laravel query builder. However, It is possible using <strong class="path">"find_in_set()"</strong> of MySql predefine function, We can use find_in_set() using whereRow() of laravel query .....

By Hardik Savani | March 2, 2017 | | 2794 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 | | 1095 Viewer | Category : MySql Codeigniter
READ MORE

Laravel 5 - Simple user access control using Middleware

We always require to built user access control in our application, when we start. I posted <a href="http://itsolutionstuff.com/post/laravel-52-user-acl-roles-and-permissions-with-middleware-using-entrust-from-scratch-tutorialexample.html" target="_blank">User ACL Roles and Permissions using entrust</a> for laravel 5 application. But as you can see on my post it is very useful and fantastic, But if you have big application or like e-commerce application. Because User ACL is take a time to implement. Yes, if you have small or medium level application and you don't require to make permission with.....

By Hardik Savani | February 26, 2017 | | 29886 Viewer | Category : PHP Laravel
READ MORE


    How to make read more link from string in PHP?

    How to make read more link from string in PHP?

    Open Post

    Laravel 5 - Twitter API using thujohn/twitter composer package tutorial

    Laravel 5 - Twitter API using thujohn/twitter composer package tutorial

    Open Post

    Laravel - How to generate RSS Feed using roumen/feed package?

    Laravel - How to generate RSS Feed using roumen/feed package?

    Open Post

    Laravel 5 - whereIn and whereNotIn with subquery example using query builder

    Laravel 5 - whereIn and whereNotIn with subquery example using query builder

    Open Post

    Bootstrap - Input multiple tags example using Tag Manager Jquery Plugin

    Bootstrap - Input multiple tags example using Tag Manager Jquery Plugin

    Open Post

    PHP - import excel file into mysql database tutorial

    PHP - import excel file into mysql database tutorial

    Open Post