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.



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 | | 103043 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 | | 133960 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 | | 82083 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 | | 6907 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 | | 13865 Viewer | Category : Laravel
READ MORE

    Crop, Resize, Frames etc on selected image in php using Aviary

    Crop, Resize, Frames etc on selected image in php using Aviary

    Open Post

    Laravel 5.3 - import export csv and excel file into database

    Laravel 5.3 - import export csv and excel file into database

    Open Post

    Laravel 5 - generate PDF from html view file and download using dompdf

    Laravel 5 - generate PDF from html view file and download using dompdf

    Open Post

    PHP - How to create zip file and download using ZipArchive ?

    PHP - How to create zip file and download using ZipArchive ?

    Open Post

    Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 2

    Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 2

    Open Post

    How to add charts in Laravel 5 using Highcharts ?

    How to add charts in Laravel 5 using Highcharts ?

    Open Post