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.




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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | July 22, 2016 | Category : PHP MySql

How to get last record of database table in Laravel?

How to get last record of database table in Laravel?

Sometimes we may require to get only last record of table in our project, we can get several way. We can fetch last record of database table using latest() or orderBy(). In bellow example you can see how i get then last record of table. I have "items" table and i want to get last record of "items" .....

By Hardik Savani | July 14, 2016 | Category : Laravel

How to get current year rows using MySql Query PHP?

How to get current year rows using MySql Query PHP?

If you require to get all the records of current year using mysql query. for example you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this year. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In follo.....

By Hardik Savani | June 14, 2016 | Category : MySql