Latest Post

How to get filename from file path in MySQL?

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. .....

By Hardik Savani | November 30, 2016 | | 436 Viewer | Category : PHP MySql
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 | | 1440 Viewer | Category : PHP Bootstrap MySql
READ MORE

Laravel 5 - create quick backend admin panel tutorial

Today, I am going to share with you How to create admin panel in Laravel 5 Application. In this tutorial we will create quick simple back-end admin panel using voyager package. We always require to create admin area for every website. Admin Panel keep dynamic our website. Admin Panel through admin user can handle website dynamically like change title, meta-data, posts and etc other modules. So If you are working on Laravel framework and you require to create quick admin panel then you can do it using voyager package. voyager package through we can make quick back-end in our Laravel 5. This pa.....

By Hardik Savani | November 27, 2016 | | 8694 Viewer | Category : PHP Laravel Bootstrap Installation
READ MORE

AngularJS - convert comma separated string to array example

When i was working on my Laravel angularjs application, i require to make array from comma separated string, I was not expert in angularjs so i was thingking how is it possible ?, But Finally i was found solution using custom angularjs Filter. So, In this example, I will give you full example of how to convert comma separated string into array and how to print it. We will create array using split() of jquery. But if you know angularjs we can't do it anything directly from layout, So we should create our custom filter, as bellow you can see i created "customSplitString" filter. <strong>Filter:.....

By Hardik Savani | November 24, 2016 | | 516 Viewer | Category : Bootstrap jQuery AngularJS
READ MORE

Laravel 5 Instagram API tutorial with example

Today, I am going to show you how to access Instagram Feed using instagram API. We can get our instagram feed without using any composer package, I simply use GuzzleHttp for getting instagram feed, We can also get location, likes, comments, images, name, id and etc. GuzzleHttp provide use fire get request to given api, So i simply run "https://www.instagram.com/username/media" API like, It is very basic example without generate instagram token. Here you can access feed of any user by username. This example is very simple and you can get by follow few step, you can also check demo and after r.....

By Hardik Savani | November 21, 2016 | | 4119 Viewer | Category : Laravel Bootstrap Instagram API
READ MORE


Draggable Animate Example Progress Bar Google API Popup Box Capitalize Email Verification WHERE Query tree view Import Master JS PostgreSQL Prompt modal Phonegap Payment Gateway After Cordova Accordion Datetimepicker Client side validation tagsinput.js QR Code Google Chart Date Format Origin Convert phpmyadmin Message laravel-elixir throttle Strip Tags Namespace Lavacharts Blocked Cross ppa Excel Plugins Sublime Pixel CRUD SweetAlert Plugin Connection chmod CURL str_random() date_format() Manual GuzzleHttp validator.js Facade Laravel 5.2 Image XSS clearInterval() guzzle http client GET Ajax Data Source Code Update Frontside Validation Multi Auth 500 error page Schema DB::raw() Log lowercase Route Bootstrap-lightbox Plugin Failed URL 404 error page Link SUBSTRING_INDEX() yajra/laravel-datatables-oracle thomaswelton/laravel-gravatar API Opencart Custom Foreign Key Download read more Append refs Null Foreach Reset Ionic framework CSS Homepage Index upload_max_filesize array_combine Enable Behance API Solve Node JS croppie.js Javascript DATE_SUB Element COUNT() maatwebsite daterangepicker PHP Sublime text 2 Toggle Loading Path Amazon S3 Login With FB Elasticsearch DB Statement clockface plugin socket Application Website stevebauman/location composer package Version Last Google OAuth filter_var Top Migration Captcha code Remove Ubuntu 14.04 dompdf Check nl2br ANDROID_HOME Ionic Botdetect Captcha Scout Package gulp Loop View Sql Confirm Box Notification Installation toastr js Typeahead JS scrollTop User Agent Eloquent-Sluggable Package Facebook API Global Variable