We always require to create virtualhost on each project because we don't want to run each project manually, so it is better way to create virtual host address for each project when you development like as bellow:
It will best way to run our project on local system. But if you want to create virtual host on ubuntu, you have to follow several step like site enabled, site enabled config, site directory permission, hosts entry and etc. You have to follow several step on each virtual host create time. I think it take a.....
Today, I am going to share with you How to use datatables in your laravel 5 application. In this example you can datatables using yajra/laravel-datatables-oracle package.
Datatables provides us quick search, pagination, ordering, sorting and etc. Datatables is basically jQuery plugins that allows you to add advanced interaction controls to your HTML tables data. Datatables also provide ajax for data searching and getting. you can give very quick layout for search and sorting using Datatables. You can also implement Datatables in your laravel application.
You have to just follow few step for .....
We always require to make multiple file or image uploading function in our common website or project. We use input with multiple with image upload but it's not looks great and user does not like pretty much, so you should make it better. Image uploads is very common for all website, But if you are working on PHP or any PHP framework like laravel, codeigniter, yii etc then you can simply use dropzoneJS library.
Sometimes we require to get filenames from path of table column in MySQL. If you are working on PHP then you can simply use basename() pre-define function of code PHP, But in MySQL you can't use basename() in select query. This mysql function you can use in code PHP, PHP framework like laravel, codeigniter etc.
However, you can get simply filename or image name from path using SUBSTRING_INDEX() of MySQL. You can extract filename from path using substring_index(), substring_index() take three argument, first for column name, second for split string chat, and third get last element from split. .....
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.....