Tag : Query

ItSolutionStuff.com have tutorials for Query tag, here you can study articles of Query tag, Query tag posts collection, most popular and useful tutorials of Query tag, here you can find list of all relevant posts and example about Query tag, we have lists of tutorials and examples about Query tag. very simple and quick example collection of Latest Query tag.




How to get current month in Codeigniter?

How to get current month in Codeigniter?

In this example, we will learn how to get current month data in codeigniter. we can get current month data using codeigniter query builder. we will use MONTH() and YEAR() mysql function for getting current month data. I will share with you simple example example of getting current month data in cod.....

By Hardik Savani | Views: 6630 | July 17, 2019 | Category : Codeigniter

How to use if condition in laravel select query?

How to use if condition in laravel select query?

We will learn how to use if condition in laravel select query. we can use mysql case when statement with db raw in laravel. If you want to use mysql function then you must have to use db raw function. in this example i will show you laravel select query with if condition. In minor case we need to u.....

By Hardik Savani | Views: 18400 | May 29, 2019 | Category : Laravel MySql


PHP Codeigniter get last executed query example

PHP Codeigniter get last executed query example

In this post, i would like to show you how to get last executed query in php codeigniter 3 website using last_query() function. you can print last executed sql query like select query, create query, update query, delete query etc. Whenever you are working on big amount of project and you write lon.....

By Hardik Savani | Views: 12733 | January 8, 2019 | Category : PHP MySql Codeigniter

How to get last executed query in PHP Codeigniter?

How to get last executed query in PHP Codeigniter?

Are you wanted to get last executed sql query in codeigniter 3 project then i will help to get last query in codeigniter. We can get last executed query using last_query() function of db class in codeigniter. It is a very simple to use $this->db->last_query() function to see SQL statements of last .....

By Hardik Savani | Views: 50913 | November 23, 2018 | Category : PHP Codeigniter

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

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

As you know laravel is very popular php framework in today. So every point will be require for database related and that important. In this post i would like to share with you how to use subquery with whereIn and whereNotIn clause from scratch. We may sometimes require to use select query with wher.....

By Hardik Savani | Views: 110744 | March 23, 2017 | Category : Laravel MySql

How to get last record from MySQL table in Codeigniter?

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 .....

By Hardik Savani | Views: 59390 | March 9, 2017 | Category : MySql Codeigniter

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

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 in.....

By Hardik Savani | Views: 48765 | March 2, 2017 | Category : Laravel MySql

How to get filename from file path in MySQL?

How to get filename from file path in MySQL?

Sometimes we require to get filenames from path of table column in MySQL. If you are working on PHP then you can simply use basename() pre-define function of code PHP, But in MySQL you can't use basename() in select query. This mysql function you can use in code PHP, PHP framework like laravel, code.....

By Hardik Savani | Views: 41382 | November 30, 2016 | Category : PHP MySql

How to connect mysql database in node js with example?

How to connect mysql database in node js with example?

Node.js is very popular in Todays for make chat system, real-time notification, real-time developing etc. So, Today, I am going to give you very simple example of How to use MySQL Query in Node JS. If you use node.js then you can see how it is work and there are several driver for different task li.....

By Hardik Savani | Views: 52473 | September 29, 2016 | Category : MySql Ubuntu Server SQL Node JS

How to get last 2 days records from table using Mysql Query?

How to get last 2 days records from table using Mysql Query?

We may sometimes require to get few days ago records from table like last 2 days, last 3 days, last 10 days or last 15 days etc. Most of developer choose other logic but we can easily get using mysql query(using CURDATE and INTERVAL). In this example mysql query i have one table "elements" and colu.....

By Hardik Savani | Views: 58650 | July 22, 2016 | Category : PHP MySql