I will show you how we can use DataTable API 1.10 in Codeigniter framework. You may also be interested in DataTable CRUD Example using Codeigniter, MySQL and AJAX Grid view in an Web page is a very important now-a-days. Functions like sorting, searching, pagination is not an easy job in HTML tables. One of many grid […]
We know that Google chart basically displays different statistical data on different chart types such as column chart, bar chart, line chart, pie chart etc. You can have a look at the URL https://developers.google.com/chart/ for more information. You can check the tutorial which shows year value in yyyy format http://www.roytuts.com/google-column-chart-using-codeigniter/ You can integrate Google chart […]
This tutorial will show you how we can stored procedure using Spring SimpleJdbcCall. For this tutorial we will create a standalone maven project in Eclipse. If you already have an idea on how to create a maven project in Eclipse will be great otherwise I will tell you here how to create a maven project […]
This tutorial will show you how we can use MySQL Event Scheduler to schedule or automate some tasks periodically at a particular interval. MySQL Events are tasks that run according to a schedule. Therefore, it is sometimes referred to as scheduled events. When we create an event, we are creating a named database object containing […]
This tutorial shows how to find the entire path from root to child for nested category and subcategory. We have a tables in such a way it contains unlimited level of categories and we have another column in the same table which holds the entire path for the nested categories.
This tutorial shows how to generate zero-fill auto-incremented unique identifier in MySQL. Sometimes we need to generate such keys which are used in some part of the application for business logic.
This tutorial shows how to select items randomly from each category in MySQL. So here we will select exactly one item randomly from each category. People who need sometimes to select photo from each photo category and display them on the page for animation purpose will be benefited.
This tutorial shows how to replace the characters in a string or text using regular expression in MySQL function. There is no built-in function available to replace any character in a string or text in MySQL so here I am creating a custom function.
I wanted to build the infinite level of categories and subcategories on the fly from a MySQL database. So I am going to give an example how to build a dynamic infinite level of nested categories. You may read also Infinite dynamic Multi-level nested category with Codeigniter and MySQL
This tutorial shows how to create effective pagination in PHP and MySQL. When there are lots of data need to be shown on a page then the data grows at the bottom of the page hence the scroll appears. Most of the times it becomes very irritating to go to the bottom so pagination comes […]