Tag : MySql

ItSolutionStuff.com have tutorials for MySql tag, here you can study articles of MySql tag, MySql tag posts collection, most popular and useful tutorials of MySql tag, here you can find list of all relevant posts and example about MySql tag, we have lists of tutorials and examples about MySql tag. very simple and quick example collection of Latest MySql 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: 8825 | July 17, 2019 | Category : Codeigniter

Angularjs PHP MySQL Pagination Example

Angularjs PHP MySQL Pagination Example

In this tutorial, I want to share with you simple example of php mysql pagination using angularjs. we will use dirPagination.js as Pagination Directive in angularjs paginate using php mysql database. we will create step by step very basic example of server side pagination in angularjs. pagination i.....

By Hardik Savani | Views: 11312 | May 30, 2019 | Category : PHP Bootstrap MySql AngularJS


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: 35613 | May 29, 2019 | Category : Laravel MySql

How to fetch single row from database in php codeigniter?

How to fetch single row from database in php codeigniter?

If you require to get only one record from database table using codeigniter query then you can do it using row(). we can easily return one row from database in codeigniter. I will give you simple example of fetch single record from database using mysql codeigniter. Sometime we need to get only one.....

By Hardik Savani | Views: 12209 | May 22, 2019 | Category : PHP MySql Codeigniter

Codeigniter Ajax Form Submit Example

Codeigniter Ajax Form Submit Example

In this tutorial, i will show you how submit form using jquery ajax without page refresh in codeigniter 3. i will write simple example of submit form using jquery ajax in codeigniter 3 website. When you click on submit button then it will automatically call submit event of jquery. In submit event i.....

By Hardik Savani | Views: 46309 | January 15, 2019 | Category : PHP jQuery MySql Codeigniter Ajax

How to find nearest location using latitude and longitude in laravel

How to find nearest location using latitude and longitude in laravel

In this post, i would like to fine neareby place using latitude and longitude query in laravel eloquent. you can simply get nearest geolocation by mysql radius query in laravel 5. If you have places, hotels, home, city, state, country, products, dealer, supplier etc with latitude and longitude loca.....

By Hardik Savani | Views: 37122 | January 11, 2019 | Category : PHP Laravel

How to get all tables list in Codeigniter 3?

How to get all tables list in Codeigniter 3?

It is a amazing deal with database to get all tables list using mysql query in php codeigniter 3 project. this type of task it might be required on big project. So if you require then i think you have knowledge of mysql query. here we will display add the table list using codeigniter mysql query. W.....

By Hardik Savani | Views: 16498 | November 5, 2018 | Category : PHP Codeigniter

How to create dynamic Highcharts in Codeigniter 3?

How to create dynamic Highcharts in Codeigniter 3?

In this example, i will tech you how to implement highcharts in codeigniter mysql app. we can create bar chart, line chart, pie chart, area chart, column chart, 3d chart, map chart etc using highchart js in codeigniter 3 application. we will create dynamic column chart from database using highchar.....

By Hardik Savani | Views: 36245 | October 31, 2018 | Category : PHP jQuery MySql Codeigniter Highcharts

Laravel 5.7 CRUD (Create Read Update Delete) Tutorial Example

Laravel 5.7 CRUD (Create Read Update Delete) Tutorial Example

Today, I want to describe step by step crud operation with laravel 5.7 application. In this tutorial, you will learn simple insert update delete operation with laravel 5.7 from scratch. You need to follow few step and you will get basic crud stuff using controller, model, route, bootstrap 4 and .....

By Hardik Savani | Views: 213456 | September 5, 2018 | Category : PHP Laravel Bootstrap MySql

Jquery Ajax CRUD Operations in PHP

Jquery Ajax CRUD Operations in PHP

Hi Guys, In this tutorial, i would like to show you how to create add edit delete and pagination operations using jquery ajax in php. You have to just follow 4 step to create php crud operation using ajax/jquery with bootstrap. I also added jquery validation using validatorjs plugin. In this post, .....

By Hardik Savani | Views: 36020 | August 30, 2018 | Category : PHP Javascript Bootstrap jQuery MySql Ajax