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.....
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.....
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.....
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:
<pre class="prettyprint lang-php">
'fetch' => PDO::FETCH_CLASS,
'default' => env('DB_CONNECTION', 'mysql'),
'connections' => [
'sqlite' => [
'driver' => 'sqlite',
'database' => database_path('data.....