Tag : Database



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 | | 30806 Viewer | Category : PHP Javascript Bootstrap jQuery MySql JSON Ajax
READ MORE

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 | | 72193 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 | | 38857 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 | | 4727 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 | | 8242 Viewer | Category : Laravel
READ MORE

    Jquery highlight search text in div using highlight JS with example

    Jquery highlight search text in div using highlight JS with example

    Open Post

    PHP - jquery datatables with mysql database example from scratch

    PHP - jquery datatables with mysql database example from scratch

    Open Post

    How to implement Email Verification with Activation Code example from Scratch in Laravel 5.2 ?

    How to implement Email Verification with Activation Code example from Scratch in Laravel 5.2 ?

    Open Post

    laravel 5.4 New Feature - Add eloquent whereKey method

    laravel 5.4 New Feature - Add eloquent whereKey method

    Open Post

    Laravel 5.5 CRUD Example from scratch

    Laravel 5.5 CRUD Example from scratch

    Open Post

    Laravel 5 mailchimp api integration from scratch with example

    Laravel 5 mailchimp api integration from scratch with example

    Open Post