To perform where clause on comma separated string/values, MySQL has an inbuilt function called FIND_IN_SET which will search for values within a comma separated values.…
Leave a CommentCategory: PHP / MySQL
Laravel provides pagination for Eloquent results out of the box, but for custom data, we need to do the pagination manually. In this tutorial, I’ll…
13 Comments
I received a tutorial request from my reader that asked me how to access CI’s base URL inside the JavaScript/external JavaScript files. Editing base URL…
Leave a Comment
Laravel5.3 is coming with following new features, 1. Rollback one migration 2. Blade Foreach Loops (new $loop variable) 3. Eloquent Collections are cleanly serialized and…
Leave a Comment
Slim is a full-featured, open-source PHP micro framework that helps you quickly write simple yet powerful web applications and APIs. It comes with a sophisticated…
90 Comments
In this tutorial, you will learn how to use MySQL IF function. MySQL IF function is one of the MySQL control flow functions that returns…
Leave a Comment
The router component allows you to define routes that are mapped to callback handlers that should receive the request. The Slim Framework’s router is built…
Leave a Comment
In Laravel world, a facade is a class that provides access to an object from the container. Laravel “facades” serve as “static proxies” to underlying…
3 Comments
Slim is a PHP micro framework that helps you write simple web applications and APIs quickly. It comes with a sophisticated URL dispatcher and middleware…
1 Comment
Slim is a full-featured, open-source PHP micro framework that helps you quickly write simple yet powerful web applications and APIs. It comes with a sophisticated…
8 Comments
Slim lets you group related routes. Route groups allow you to share route attributes, such as middleware or URL segments across a large number of…
Leave a Comment
This tutorial describes how to use laravel’s elixir to run Gulp tasks. Gulp is a javascript task runner, it keeps things simple and makes the…
Leave a Comment
This post shows the possible ways to remove specific element from array based on value of the element. Removing specific value Using array_diff() Using this…
Leave a Comment
This tutorial will describe the usage of the PHPExcel library to generate an Excel file from a PHP array. Usage of PHPExcel library is very…
5 Comments
This article shows how to read RSS feeds using php script. If you are reading this post you might know about RSS feeds and it’s…
Leave a Comment