Latest Post

How to increment or decrement a column value in laravel?

Whenever you need to increment or decrement value of column in database, then you do not need to first fetch that record and then update, so that way we will make long code and very hard code, so basically you can increment and decrement by using increment() and decrement() statment of laravel query builder. If you want to increment or decrement opration using update() method of laravel query builder then you also do that, in following example i am showing you how to increment and decrement value of column in table by using increment(), decrement() and update(). <pre class="language-php"> na.....

By Hardik Savani | February 2, 2016 | | 8807 Viewer | Category : Laravel

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Some time when you are open any link your website then browser display following massage <h2 style="margin:0px;padding:0px;">Not Found</h2> <span style="margin:0;padding:0;">The requested URL /test.html was not found on this server.</span> <span style="margin:0;padding:0;">Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.</span><br /> this problem fix by .htaccess write following code in your .htaccess file <pre class="language-mysql"> RewriteEngine on <IfModule mod_rewrite.c> RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f Rewrit.....

By Hardik Savani | February 1, 2016 | | 999 Viewer | Category : .htaccess

How to fix and recover a “corrupt history file” in zsh?

Many user use ubuntu OS and many user face one of the common problem several time like “corrupt history file in zsh" most of time face this problem when reboot your OS so, How to fix this problem please follow this command and fix that. <pre class="language-mysql"> mv .zsh_history .zsh_history_bad strings .zsh_history_bad > .zsh_history fc -R .zsh_history </pre>

By Hardik Savani | January 31, 2016 | | 847 Viewer | Category : Ubuntu

How to check empty or null in Mysql Query?

If you want to check empty or null value with conditional statement like case when and if in table row with Mysql database. you like to check empty or null value form table then you have multiple way check that. first we check empty value with case when statement then following example. <strong>Empty Check:</strong> <pre class="language-mysql"> SELECT (CASE WHEN COALESCE(email,'')!='' THEN email ELSE '' END) as test FROM `customers` ---------------------OR---------------------- SELECT (CASE COALESCE(email,'') WHEN '' THEN '' ELSE email END) as test FR.....

By Hardik Savani | January 31, 2016 | | 904 Viewer | Category : PHP MySql

How to copy one table data into another table using Mysql Query?

If you are working on php or any php framwork and you want to copy one table into other table by using sql query, so you could do it using simple SELECT and INSERT statement. just you need to think how you can use. In Following example you can see how to fetch data from "post" table and how to insert into "post_copy" table, so basically you have to select field of one that you want to copy and second one give name of table with proper field that you want insert. But don't forgot to give a name of field otherwise it generate error. <pre class="language-mysql"> INSERT INTO `post_copy` (name,sl.....

By Hardik Savani | January 30, 2016 | | 1906 Viewer | Category : PHP MySql

Linux MassAssignmentException Timepicker chumper/zipper Dropbox API Solve Paging Accordion Top Artisan Exists Sendgrid Ajax Request maatwebsite refspec JS Ajax mod_rewrite Twitter Bootstrap strpos Zoho mail filesize() Bootstrap Plugin Class Download Select Query Ionic framework google recaptcha code clockface plugin SUM() Send clearInterval() Strings Laravel 5.4 Chosen JS Number validator.js CloudConvert API Windows KCFinder Delete pngquant Sublime word-wrap Tooltip View Custom Command Convert npm Commit Git is_null Gmail Facade Progress Bar Bitbucket Backup Composer split Controller Collapse Client side validation Letter Botdetect Captcha file_exists Input Laravel Passport Node JS Redis Links file_exists() File socket Route Object Upgrade Allow After FadeIn ANDROID_HOME preg_match Mailgun API Join PHP Log Prompt modal Page Bootstrap Notify Plugin Percentage Facebook API Opencart array_map Where Not In Query Language Javascript roumen/sitemap Capitalize Query response() Middleware array_change_key_case inner join date_format() Search Inserted Id Laravel Eloquent Google Map Chart.js milon/barcode Folder Lavacharts COUNT() Event Laravel 5 Sitemap Index Migration Attribute Connection clipboard.js Email SMTP Application Multi Auth Ubuntu 14.04 sven/artisan-view package Admin Bootstrap Theme Specific Laravel Protection Datetimepicker daterangepicker Image Gallery Global Variable ajaxComplete Base URL csrf_token API PHPExcel Magento 2 Element Trans Helper helper ACL ppa execute query Namespace Switchery JS Current Page