Latest Post

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 | | 838 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 | | 1573 Viewer | Category : PHP MySql

How to add text on image in laravel 5?

if you are use laravel and you want to add text on image or resize, crop image then we can do with "intervention/image" pakacke. you have to just follow few step and you can add text on image. <strong>Step 1 : </strong>you have to add package on your laravel project by using composer like : <pre>composer require intervention/image</pre> <strong>Step 2 :</strong> then you have to add provider path and alias path in config/app.php file like : In $provides : <pre>'Intervention\Image\ImageServiceProvider'</pre> In $aliases : <pre>'Image' => 'Intervention\Image\Facades\Image'</pre> [ADDCODE].....

By Hardik Savani | January 30, 2016 | | 5339 Viewer | Category : Laravel

How to get days difference between two dates in laravel?

Whenever you need to get difference between two dates in date in laravel 5 then you can get easily using Carbon. Laravel by default provide Carbon class. Carbon class throught you can calculate difference between two dates in days. In Following example you can see, we have a two dates, first $to variable and second one $from variable. Carbon class diffInDays function using you can get difference between two dates. I hope you will find your solution. <strong>Example:</strong> <pre class="language-php"> $to = \Carbon\Carbon::createFromFormat('Y-m-d H:s:i', '2015-5-5 3:30:34'); $from = \Carbon\.....

By Hardik Savani | January 29, 2016 | | 3910 Viewer | Category : Laravel

How to remove null values from array in PHP?

you have array with null value and you want to remove all null value from that array without loop. you can remove your all null value from array without loop. PHP array_filter function through you can remove all null value, you see following example how to remove null value : <strong>Example:</strong> <pre class="language-php"> $example = array(100, "hardik", null, "hey", NULL, "", 77); $result = array_filter($example, function($value) { return !is_null($value); }); print_r($result); </pre> <strong>Output:</strong> <pre>Array ( [0] => 100 [1] => hardik [3] => hey [5.....

By Hardik Savani | January 28, 2016 | | 1899 Viewer | Category : PHP

Tutorial milon/barcode thujohn/twitter package Loading Technology Old apache2 Remember me Date Format Chart Excel Column ajaxComplete Protection Pull SEO Path Artisan Google API croppie.js Field Captcha code csrf_token Paypal Integration Paypal Payment Gateway Fetch Laravel Highchart Number Request groupBy() SUM() Version nl2br User Agent Laravel 5.3 gmaps.js Connection Attr Behance API DB Statement Laravel 5 toArray() DB Parsleyjs tree view roumen/sitemap Parsley Validation Instagram API Ionic Trans Helper Div Blade inject Update response() Sendgrid Permission hasColumn Where Not In Query Facade Laravel 4 PHP jQuery Custom Datetimepicker Google OAuth CloudConvert API Migration Folder jquery.lazyload.js FadeOut unicodeveloper/laravel-password ngclipboard.js Select Form Jquery Event Mailgun API Message Last Control json() Elasticsearch Node JS Page MySQL Subquery mod_rewrite Library array_combine Links Jquery UI Amazon S3 Confirm Box Lavacharts Service Provider Remote preg_match inner join bootstrap-progressbar.js Redirect AngularJS Filter filter_var Delete Database Seeder file_exists Linkedin API Twitter API Artisan Command whitespace Jquery Dialog Box Current Twitter Bootstrap Controller Flash Message Controluser SUBSTRING_INDEX() File Upload Subscribe toastr js PHPExcel parse Bootstrap show password Plugin Contact US Form Multiple Ionic framework tagsinput.js FadeIn Local ACL Eloquent-Sluggable Package toSql Windows Switchery JS Letter refs Email Bitbucket Inserted Id oauth CSS Laravel 5.2 Calculate Download First Google Map Repository Pattern 500 error page intervention/image