It Solution Stuff provide collection of tutorials about PHP, Laravel Framework, Codeigniter Framework, Mysql Database, Bootstrap Front-end Framework, Jquery, Node JS, Ajax Example, APIs, CURL Example, Composer Packages Example, AngularJS etc. You will find best example and article about PHP Language. So you can also search tutorial from bellow search box.

Latest Post


Sql function remove numeric characters from column example

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove numeric characters from table field value. this function through you can also remove numeric characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeNumber function:</strong> <pre class="prettyprint lang-mysql"> DROP FUNCTION IF EXISTS removeNumber; DELIMITER | CREATE FUNCTION removeNumber( str CH.....

By Hardik Savani | March 12, 2016 | | 5682 Viewer | Category : PHP MySql SQL MSSQL
READ MORE

How to remove special characters by mysql custom function.

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove special characters from table field value. this function through you can also remove special characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeSpacialChar function:</strong> <pre class="prettyprint lang-mysql"> CREATE FUNCTION `removeSpacialChar`(`in_str` varchar(4096)) RETURNS varchar(4096) C.....

By Hardik Savani | March 10, 2016 | | 15348 Viewer | Category : PHP MySql SQL MSSQL
READ MORE

How to redirect page using JQuery?

You can redirect page or url in your js file. when you require to redirect page form jquery thrn you can use window.location.href. window.location.href through you can redirect url using jquery/javascript. So, Let's see following example: <strong>Example:</strong> <pre class="prettyprint lang-js">window.location.href = "http://itsolutionstuff.com";</pre>

By Hardik Savani | March 10, 2016 | | 6936 Viewer | Category : Javascript jQuery
READ MORE

How to add multiple markers in google map

In this post we have to learn hoe to add a multiple location marker in google map. add following code for add multiple location marker. <img width="100%" style="border:2px solid cadetblue" src="/upload/Google map.png"> <strong>Add Google map canvas HTML code</strong> <pre class="prettyprint lang-html"> <div id="map_wrapper"> <div id="map_canvas" class="mapping"></div> </div> </pre> <strong>Add Google map canvas CSS code</strong> <pre class="prettyprint lang-css"> #map_wrapper { height: 400px; } #map_canvas { width: 100%; height: 100%; } </pre> <st.....

By Hardik Savani | March 9, 2016 | | 19378 Viewer | Category : Google Map jQuery HTML
READ MORE

Laravel 5 export to pdf using maatwebsite example

In this post i will show you how to export or download pdf file from database table by maatwebsite. maatwebsite packages throught you can easily generate pdf file. so now i show you simple example of items table data, you can donwload in pdf formate. In following few step you can implement export both function in your project. we have to also need to use dompdf package for pdf generater. let's follow step. <strong class="step">Step 1: Installation</strong> Open your composer.json file and add bellow line in required package. <strong>Laravel 5</strong> <pre>"maatwebsite/excel": "~2.1.0"</pre> <.....

By Hardik Savani | March 9, 2016 | | 89056 Viewer | Category : Laravel
READ MORE


GuzzleHttp Image Upload lowercase Ionic Add Zip Form Validation KCFinder Undefined Sort Apache Div dompdf Object to Array GET Ajax Email Verification Element Attribute Control Cache Mailchimp API milon/barcode Recursive Demo google recaptcha code Automatically Image Gallery orderBy Request Method Animate Redirect Dropzone.js Request Exists clearInterval() Email Now slice() jquery.email-autocomplete.min.js Highlight JS Datetimepicker Twitter API Controluser gmaps.js stevebauman/location composer package Sublime text 2 strpos filter_var Strip Tags Website filesize() Laravel Factory Special select box search Lavacharts str_random() Package File PHPExcel Magento 2 Select Google API 500 error page JS Client side validation Fullcalendar JS Bootstrap Plugin response() Moment JS Socket.io Query Builder setTimeout() auth() split Cross Subscribe array_combine Parameters Subscription Commit First php_ini_loaded_file Laravel Passport Composer Localization Where In Query read more Chart Custom Command Convert Export array_change_key_case QR Code Allow FadeOut Rewrite Nodejs Artisan Command SUBSTRING_INDEX() Gravatar Image Calculate Linux Sortable Resize Image Namespace RSS Algolia Package Repository Pattern roumen/sitemap DATE_SUB Select Query max_file_uploads Facebook API Laravel 5.4 Accordion Top Excel Master Parsleyjs guzzle http client Data Carbon yajra/laravel-datatables-oracle Append Opencart hasTable is_null Sublime Windows toArray() typed.js plugin Ip Address ixudra/curl composer package MySQL Subquery Pagination Column Blocked roumen/feed package apache2 Path Laravel Resource Terminal Letter Middleware Log daterangepicker csrf_token Value Bootstrap show password Plugin REST