Latest Post

Mysql Hexadecimal color code store in binary datatype.

If you have thousands of record store, that time database size would be large. but you can some field can save your number of bites in the database. you have color field then most of you choose string(6) data type and you wast 6 bites on every record, but you can save number of bites data by using BINARY(3) data type. following example through you can set data type for hexa color code with only allocate binary(3) on every records. first how to create table and assign data type with following query. <pre class="language-mysql"> CREATE TABLE IF NOT EXISTS `colors` ( `id` int(10) unsigned NOT N.....

By Hardik Savani | January 7, 2016 | | 951 Viewer | Category : PHP MySql

How to get Lat and Lon from google map API in Jquery PHP?

if you are working on php, asp or any other framwork and you want to integrate google API and also you want to get Latitude and Longitude for location. we have mostly fetch some problem when we set google map because i tried and i also fetch problem. but i am giving you with search location and get Latitude and Longitude of that location. you have to use html file, css file and js file as i write under and use them in your system. first you have to create simple html file. so create folder in your system and create new index.html file and copy index.html file as i give you under. <strong>Inde.....

By Hardik Savani | January 6, 2016 | | 1148 Viewer | Category : PHP Javascript jQuery Google Map

How to add pagination with union in Laravel 4 and Laravel 5 ?

You are using union and you want to give pagination, but you can't give. i also fetch that problem if you use union with pagination. you have to create pagination manually using Paginator Class. if you are using Laravel 4 then you can use Paginator Class library and if you use Laravel 5 then you have to give help of \Illuminate\Pagination\LengthAwarePaginator Class function. you have to many times need give a manually pagination like if you are using having, union etc. now i am giving you example of Laravel 4 and Laravel 5 both you can do this way. <strong>Laravel 5</strong> <pre class="langu.....

By Hardik Savani | January 6, 2016 | | 2670 Viewer | Category : PHP Laravel

How to create a text file for JSON and file download in Laravel 5?

If you want create your own text file, html file, css file, php file, json file etc in Laravel. then we do not need to use any PHP library or Class because Laravel Framwork Provide its own "File" Facade. File Class through you can create your own html file, txt file, php file etc as you want. File Facade Class also provide several function like you can create file, remove file, update file etc. now i am giving you example of how to create json file in Laravel. you also want to download file that you created now, i mean you want to give download file, then you can also give download that file .....

By Hardik Savani | January 6, 2016 | | 3682 Viewer | Category : Laravel

Ajax Request Location Scout Package bootstrap-progressbar.js Solve Chart.js php_ini_loaded_file JS Email Verification Current Page Remember me roumen/sitemap helper Now Config Sublime text 2 DATE_SUB Attribute Paypal Integration Directory View daterangepicker gmaps.js read more AngularJS Filter select2.js xoxco tags input mac mod_rewrite JWT Percentage Bitbucket Confirm Box Nodejs Client side validation Jquery Modal Database nl2br clipboard.js Foreach 500 error page GuzzleHttp Artisan Homepage Phonegap csv str_replace ajaxComplete socket inner join encrypter Global Variable Listener Toggle Ckeditor SUM() apache2 array_combine Capitalize DATEDIFF() whitespace Windows refspec Route Repo jquery.lazyload.js Update Log Select Query Request Method Remove milon/barcode Pagination setInterval() Page Mediafıre API bootstrap-growl After Twitter Bootstrap datatables Link Rewrite select box search json() bplist-parser Form JS Plugin Specific pop() Upgrade Field ACL Sql Tag Manager plugin Scroll User Notification Express strpos Base URL gulp Frontside Validation Excel length virtual host Enable FILTER_VALIDATE_URL Ip Address User Agent Each google recaptcha code FIND_IN_SET() clearbit API Message hasColumn Accordion toSql php.ini Apache Opencart Custom Command Typeahead JS Prompt modal mysqld.sock node.js Loading Jquery UI CSS voyager package Gravatar Image Mailchimp API Controluser Highchart Popup Box Plugins Bootstrap-lightbox Plugin Twitter OAuth Localization JSON Request Master Carbon PostgreSQL SUBSTRING_INDEX() CURL Cordova Admin Panel laravel-elixir Numeric Script