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 | | 815 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 | | 3412 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 | | 1198 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 | | 5855 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 | | 33678 Viewer | Category : Laravel
READ MORE


parse File Pixel Xampp Event Login With FB Twitter API gmaps.js date_format() Automatically Email Animation ANDROID_HOME CSS Bitbucket Instagram API glob View Array execute query First Issue Gravatar Image Folder Paypal Payment Gateway nl2br screenshotmachine.com API Strip Tags Image Attr clearInterval() pop() is_null Magento 2 Scratch Interfaces XSS Export ACL Paypal Integration Datetimepicker RSS Feed Old Codeigniter Search array_combine Attribute max_file_uploads HTML Dropzone.js Null gulp Tooltip Namespace tree view Bootstrap Tokenfield Plugin Snippet Image Gallery Object php artisan serve Linkedin API chumper/zipper ppa Timepicker guzzle http client unicodeveloper/laravel-password Jquery UI FadeOut Capitalize Library Special Middleware Message Modal Ubuntu 14.04 Custom Pull Windows Strings INTERVAL Laravel 5.4 - Markdown Mailables Parsleyjs Chart.js ajaxStart COUNT() Index Image Upload Redirect characters filter Plugins Exists roumen/feed package MySql Laravel 5.2 Specific uppercase Data Value Magento Percentage Backup str_replace chmod Control Sort Recursive validator.js Client side validation Mailgun API SMTP Failed Letter Javascript whitespace URL virtual host groupBy() Mailchimp API String Scroll Laravel 4 CURL Convert Laravel Cashier Cross Laravel 5 Rewrite Ionic framework Zip Algolia Package setInterval() throttle Empty Form Validation xoxco tags input length Links Collapse mCustomScrollbar Plugin Prompt modal strtolower Particular Laravel Passport Dropbox API WHERE Query Node JS Ubuntu PHP php_ini_loaded_file