In this tutorial, we are going to explain how we can use “Cart class in CodeIgniter”. This cart class allows us to add and remove products to a shopping cart and to update them. The Cart Class only provides the core “cart” functionality. It does not provide other processing components. Steps For Shopping Cart using Codeigniter […]
Just today, I was looking at using a ternary operator in Laravel’s Blade templating system. However, instead of writing a ternary statement, Blade provides you with the following convenient short-cut: In this example, if the $string variable exists, its value will be displayed. However, if it does not exist, the word something will be displayed.
In last tutorial, we have had a glimpse about how to use Group By clause. Rows in a table can be grouped by using one or more columns. For example, rows in products table can be grouped by CategoryID values so that we can see summarized information for each group of the product categories (e.g. […]
You can build your query step-by-step and then call get() method. But sometimes it gets a little tricky for more complicated queries – for example, if you have multiple whereIn OR whereIn conditions and you want to put brackets, do it like this.
A search engine has become a useful tool in today’s internet world. It is very helpful for developers, testers, managers, and other internet users. Using this we can get the information on any topic of our choice. In this article, we will talk about creating our own search engine with the help of PHP, MySQL, […]
This tutorial shows you how to write or like query in codeigniter. This method is identical to the one above, except that multiple instances are joined by OR. Let’s create a or_like method in codeigniter Note: or_like() was formerly known as orlike(), which has been removed.
To perform a “cross join” use the crossJoin method with the name of the table you wish to cross join to. Cross joins generate a Cartesian product between the first table and the joined table. Let’s create a crossJoin method in laravel 5
In this tutorial, we will show you how to prevent multiple and duplicate form submissions using PHP and MySQL. Below you will find two simple tricks for preventing duplicate submissions, you can use either of these or a combination of both. HTML Code PHP Code
The count_all_results() method is used to get the number of rows in a MySQL result handle. Permits you to determine the number of rows in a particular Active Record query. Queries will accept Query Builder restrictors such as where(), or_where(), like(), or_like(), etc. More Example count_all_results() method also resets any field values that you may […]
If you want to get duplicate values count in an comma separated string in laravel 5, first need to create array using explode function. Count duplicate value in array using below function. The array_count_values() function counts all the values of an array. OUTPUT