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.....
After complete 4 steps in our Part 1, we have to proceed next step from Part 2. In this part we write code for how to manage controller method and how to give response them. We also write code for view blade layout files.
This part is hart of "Laravel 5 dynamic autocomplete search using select2 JS Ajax" article, In this part you will see the logic of database and blade template. So you have to follow this bellow remaining steps.
<strong class="step">Step 5: Create Controller</strong>
In this point, now we should create new controller as Select2AutocompleteController in this path <stron.....
Today, we will learn how to implement simple infinite scroll using jquery, ajax, php and mysql example. After complete this example you will get load more data on scroll of your page.
Generally, sometime we require to make load more latest feed or post etc when you scroll like on facebook, twitter, linkedin etc, it is require when you have lots of data.When you reach at bottom of page it will load more data using jquery ajax. In this example you can easily built infinite scroll pagination using ajax. we will load more data using jquery ajax. In today, infinite scroll take places of traditiona.....
In this post i am going to give you example of how to integrate payment Paypal gateway in php with demo. It is very simple to use paypal payment method in your native php website because you don't need to use any api for paypal payment gateway integration. Paypal provide very simple way to do this and paypal also provide developer console i mean Sandbox account that way you can check it better. In this example i give you step by step payment integration of paypal.
<img src="/upload/PHP-Paypal.png" width="100%" style="border:1px solid red">
<strong>Step 1: Create Sen.....
Today, we learn how to implement google map with multiple marker using gmaps.js library in Laravel 5. We can also simply use google map API for maps, But gmaps.js is very popular and they provides very simple way to generate google map.
gmaps.js through we can make multiple markers, make routes, Geocoding, Map events etc. In this example i use multiple markers example.
If you are beginner then also you can do it simply following post, i did this example from scratch.
So, After finish all tutorial you will find layout as bellow:
In this post i am going to give you the example of Add Multiple input tags with autocomplete from MySQL database table using typeahead bootstrap JS and tagmanager JS.
Sometimes we require to make multiple input tags on our form. At that time we require to use jquery plugin for input multiple tags. But here we are going to use tagmanager.js plugin for add multiple input tags. I already added one simple tutorial for tagmanager.js here : <a href="http://itsolutionstuff.com/post/bootstrap-input-multiple-tags-example-using-tag-manager-jquery-pluginexample.html" target="_blank">Bootstrap - Input mu.....
In this post, we will learn how to populate dynamic dependent drop down select box using jquery ajax in our codeigniter application.
We may sometimes require to make dependent dropdown from database like when state select at that time bellow city drop down list should change, i mean related to selected state. In this example i have two tables and there are listed bellow:
So, when user will change state at that time, dynamically change city drop down box from database. you can implement this example in your application by follow bel.....
Angularjs Pagination is not simple like laravel, code php etc, because we have to manage it with JS. In this tutorial i give you to build simple way pagination in your angularjs application.
In this example we will use dirPagination directive to add paginate. Pagination Directive provide us very simple way to create paginate like set itemsPerPage, dir-pagination-controls etc. In this example you can see how it simple. You can get more information about Pagination Directive from here : <a href="https://github.com/michaelbromley/angularUtils/tree/master/src/directives/pagination#basic-example".....
Laravel 5's Blade template engine is awesome. you can easyly use PHP variable, js and js library in laravel view. i will create chart using Highcharts in my laravel application. Highcharts is a js library, this library through we can use bar chart, line chart, area chart, column chart etc, Highcharts also provide sevral theme and graph that way you can use more chart from here : <a target="_blank" href="http://www.highcharts.com/">HighCharts Site</a>.
whenever you need to add charts in laravel server side. then you can easily use following example you have to fetch data from database and then.....
In this example, we are going to lean how to implement infinite scroll example in our codeigniter application.
Infinite Scroll is amazing feature if you have news latter page, posts page or any listing page that way we don't require to load more records at time and not need to load page every time. we sometimes require to use infinite scroll in our project or application. So in this post we learn how to make infinite scroll example from scratch.
I also provide demo for infinite scroll example, so you can see there. In this example we will create "posts" table and you have to add some manual.....