Tag : Database

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

Multiple Database Connection in PHP Codeigniter 3

Today, I want to share with you how to connect multiple databases in PHP CodeIgniter 3 application. it is very easy to configure multiple databases in CodeIgniter app. you can simply add database query, join etc with multiple databases. As we know well, in today we may need to add multiple databases on our application. all then framework provides multiple database connections. Codeigniter also provide multiple database connections in a single app. We have to simply add database configuration array to database.php file. Then we can simple load specific database data by using "$this->load->dat.....

By Hardik Savani | February 27, 2018 | | 18901 Viewer | Category : PHP MySql Codeigniter

How to integrate jQuery Fullcalendar using Bootstrap, PHP and MySQL ?

Today, i would like to share with you integration of jquery full calendar events crud operation using bootstrap, php & mysql example. Fullcalendar is jquery library that provide us to display calendar with events and more. Fullcalendar js provide year, month, week and day calendar for displaying and it amazing with drag & drop events management. If you are working on event management, task management or any thing that related date to date, at that time if you use event calendar like fullcalendar then it's better. In this example we will create "events" table in mysql database and create cru.....

By Hardik Savani | June 16, 2017 | | 133080 Viewer | Category : PHP Javascript Bootstrap jQuery MySql JSON Ajax

Simple Highcharts Chart Example using PHP MySQL Database

Highcharts is a one type js library, that provide to populate bar chart, line chart, area chart, column chart etc. Highcharts library also provide several theme and graphic design that way you can make better layout. Highcharts is a very popular and simple library for php developer. We can simply use it in our code PHP project and other php framework like laravel(<a href="http://itsolutionstuff.com/post/how-to-add-charts-in-laravel-5-using-highcharts-example.html" target="_blank">How to add charts in Laravel 5 using Highcharts ?</a>), codeigniter, symfony, cakephp etc. In this post, we are le.....

By Hardik Savani | December 20, 2016 | | 163091 Viewer | Category : PHP Bootstrap MySql JSON Highcharts

PHP - import excel file into mysql database tutorial

In this post, i going to explain how to import excel file into mysql database using PHP. In this post i will give you full example of csv file, ods file, xls file, xlsx file import into database using phpexcel package. We always require to add data from admin panel like products, items, users, emails etc. If we have few records and require to add manually then it is ok, But if we have more data on excel file or csv file then it take long time to store data, At that time we can use direct import xls file or csv file into mysql database. So, In this tutorial i am using Spreadsheet_Excel_Reade.....

By Hardik Savani | November 27, 2016 | | 110825 Viewer | Category : PHP Bootstrap MySql

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 like redis, socket io, express etc. But Node.js have a driver for MySQL that way we can easily connect with database and you can use select, insert, update and delete sql query. So, in this example i going to give from scratch so if you are beginner and you haven't installed nodejs on your server th.....

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

Multiple database connections in laravel 5 Application

you can set multiple database connections in same laravel application. Laravel provide configration file for setup multiple database connections. you can see config/database.php file and see mysql multiple database connections. you can add setting another mysql database detail like this way: <strong>config/database.php</strong> <pre class="prettyprint lang-php"> return [ <br/> 'fetch' => PDO::FETCH_CLASS, <br/> 'default' => env('DB_CONNECTION', 'mysql'), <br/> 'connections' => [ 'sqlite' => [ 'driver' => 'sqlite', 'database' => database_path('data.....

By Hardik Savani | May 8, 2016 | | 31106 Viewer | Category : Laravel