Latest Post

How to use Select with MySQL DATE_FORMAT() in Laravel?

We sometimes require to use MySQL pre-define function like sum(), date_format(), year(), month(), group_concat() etc. But laravel query builder not provide to directly use with select statement. However, we can use all the pre-define function of Mysql using DB::raw(). So, In this post i am going to share with you how to use date_format() in Laravel 5 Query Builder. date_formt() help us to change date format. We may sometimes require to change date format using mysql date_format(). In this example i have simple "users" table and there are some dummy users with created_at row with current time.....

By Hardik Savani | March 16, 2017 | | 2583 Viewer | Category : Laravel MySql

PHP - How to make dependent dropdown list using jquery Ajax?

In this post, i am going to share with you how to make dynamic dependent dropdown list using jquery ajax with php MySQL. In this simple example through we understand how to work dependent dropdown in core PHP even if you beginner. I also posted for php laravel framework <a href="" target="_blank">How to make simple dependent dropdown using jquery ajax in Laravel 5?</a>. We sometimes require to make dependent dropdown like when state select at that time bellow city drop down list sho.....

By Hardik Savani | March 15, 2017 | | 1946 Viewer | Category : PHP Javascript Bootstrap HTML jQuery MySql

Laravel 5 notification alert using bootstrap notify plugin example

We always require to notification alert after some action like if you remove items then notification popup will open with message like "Item removed successfully", same as on every action like create, update, listing or others. As specially we are working on admin panel, it's mandatory. So, i would like show you how to add bootstrap notify js plugin notification popup in Laravel 5.4 from scratch. bootstrap notify plugin provide us success message notification, info message notification, warning message notification, error message notification that way we can add notification with good layout .....

By Hardik Savani | March 11, 2017 | | 2142 Viewer | Category : PHP Laravel Bootstrap jQuery

Magento 2 - How to solve one or more indexers are invalid by command line?

When i was starting to work on my magento project from scratch, i installed successfully but when i added two or three products but it was not displaying on homepage or category page. I though what will be issue. after search i found it was issue because i require to reindex of product. I again found how to reindex, i though it re-index from admin panel, but i couldn't find any option in admin panel. At Last i found i can solve "one or more indexers are invalid solved" error from command line, i open my terminal and go on root directory. I run bellow command on my root directory. <strong>Re-i.....

By Hardik Savani | March 10, 2017 | | 761 Viewer | Category : Magento

How to get last record from MySQL table in Codeigniter?

In this post we are going to learn how to get last single record from MySQl database table using Codeigniter database library. We sometime require to get only single row result in our Codeigniter application. In this post you can see how to get whole last record using Codeigniter db query. Few day ago i posted <a href="" target="_blank">"How to get last inserted id in Codeigniter?"</a>, in that post we can simply get last inserted id from Codeigniter db query. In this database query i used order_by(), limit.....

By Hardik Savani | March 9, 2017 | | 324 Viewer | Category : MySql Codeigniter

Directory Scout Package auth() Redis Schema 500 error page Snippet MSSQL LIKE Query POST Ajax Convert Lightbox MySQL Subquery Form Validation DB Statement Particular Key Folder Sortable Bootstrap Plugin Tag Manager plugin Object Access Interface Barcode Month Message File Index Multiple Jquery Dialog Box SMTP Where Not In Query Express Modal Redirect Paypal Integration Email Verification Version Laravel Cashier Select Sublime text 2 croppie.js Laravel 5.2 Backup league/flysystem-dropbox Xampp Confirm Box is_null Animation timestamps Dynamic Dependant Dropdown SUM() Inserted Id lowercase Pixel glob Magento 2 strpos Form Jquery scrollTop Site SUBSTRING_INDEX() Components & Slots Behance API Multi Auth Prompt modal Login With FB read more Specific XML Foreign Key Javascript away() Collapse select2.js Chat Popup Box Capitalize bootstrap-progressbar.js ajaxComplete split FadeOut Opencart Trigger API Datetimepicker bplist-parser thujohn/twitter package Trans Helper Permission Ubuntu Element Pagination clearbit API Control Mail filter_var WHERE Query Foreach Botdetect Captcha Installation Jquery Modal typed.js plugin Controller ngclipboard.js npm User Agent upload_max_filesize Stripe voyager package refspec bootstrap-growl AngularJS pngquant laravel-elixir Query Builder Autocomplete 404 error page Global Variable Scratch Failed Query maatwebsite Current Page Current Calculate Codeigniter 3 RAND() toSql Auth Variable Sublime Custom phpmyadmin Linux Facade Server basename() Each chumper/zipper bootstrap-multiselect plugin Ip Address Interfaces Service Provider Chart.js Nodejs Remote Manual