Tag : Database


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 | | 24776 Viewer | Category : PHP Bootstrap MySql JSON Highcharts
READ MORE

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 | | 10398 Viewer | Category : PHP Bootstrap MySql
READ MORE

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 | | 1404 Viewer | Category : MySql Ubuntu Server SQL Node JS
READ MORE

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 | | 3934 Viewer | Category : Laravel
READ MORE

    Laravel 5 Stripe example using Laravel Cashier from Scratch

    Laravel 5 Stripe example using Laravel Cashier from Scratch

    Open Post

    How to create blade view file using command line in Laravel?

    How to create blade view file using command line in Laravel?

    Open Post

    Laravel 5 - elasticsearch with pagination example

    Laravel 5 - elasticsearch with pagination example

    Open Post

    Laravel 5 - Custom Helper Facade Class Example from scratch

    Laravel 5 - Custom Helper Facade Class Example from scratch

    Open Post

    PHP Codeigniter - Ajax Infinite Scroll Pagination Example

    PHP Codeigniter - Ajax Infinite Scroll Pagination Example

    Open Post

    How to get gravatar image from email using Jquery?

    How to get gravatar image from email using Jquery?

    Open Post