tag:blogger.com,1999:blog-7017427187289644265Sun, 08 Sep 2024 15:57:58 +0000blogger seoseophpwordpressMySQLQGIScustom-highmaphighchartshighmapsAdsense parserAjaxadd meta tagsbloggercharacter count online toolemailfree online word counthtml to xml parserhtml-gmailinvoice scriptjQuerymailnodejsnpmsitemap submission googlesyntax highlighter bloggerSmartTutorials - php mysql jquery javascript ajax html5 css3 CAKEPHP tutorialhttp://blog.smarttutorials.net/noreply@blogger.com (muni)Blogger30125tag:blogger.com,1999:blog-7017427187289644265.post-5827525391639645819Mon, 05 Dec 2022 07:53:00 +00002022-12-04T23:53:34.226-08:00How to use SASS/SCSS with Laravel Vite <h2>Step 1: </h2> <pre><code class="language-bash"> npm add -D sass # OR yarn add sass -D </code></pre> <h2>Step 2: </h2> Update the `vite.config.js` file like this. <pre><code class="language-js"> import { defineConfig } from 'vite'; import laravel from 'laravel-vite-plugin'; export default defineConfig({ plugins: [ laravel({ input: [ 'resources/css/app.scss', 'resources/js/app.js', ], refresh: true, }), ], }); </code></pre> <h2>Step 3: </h2> Update the layout file. <pre><code class="language-html"> @vite(['resources/css/app.scss', 'resources/js/app.js']) </code></pre>http://blog.smarttutorials.net/2022/12/how-to-use-sassscss-with-laravel-vite.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-3509962585859527809Thu, 12 Sep 2019 08:03:00 +00002019-09-12T01:13:30.385-07:00How to Manually Set Language for Syntax Highlighting in Visual Studio Code<div dir="ltr" style="text-align: left;" trbidi="on"> Sometime we will copy code snippet into Visual studio code, but by default it will be not syntax highlighted.&nbsp; To enable syntax highlighting please check below video tutorial.<br /> <br /> <br /> <div class="embed-responsive embed-responsive-16by9"> <iframe class="embed-responsive-item" src="https://www.youtube.com/embed/c-1gXIE_1dQ"></iframe> </div> <br /> <h2> VsCode Syntax Highlighting Shortcut:</h2> <div class="alert alert-success"> <b>MacOS</b>: <kbd>Cmd+K</kbd>, then press <kbd>M</kbd> <br /> <b>Windows</b>: <kbd>Ctrl+K</kbd>, then press <kbd>M</kbd> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJd1nq65_sZlG8tIiz_DI-ACiJd7OPuwkciDVkxkFB8S4uWmNj3RMQYzCRv2TxnulsO1Vmab3rMqqJjYpcRZ58oYGgMZ6H4WGfKkxUSiEgmHaHnjgEjbn3cLVZ1MBt_PSew1OtA2_B8ZQ/s1600/How-to-Manually-Set-Language-for-Syntax-Highlighting-in-Visual-Studio-Code.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" class="img img-responsive" data-original-height="884" data-original-width="1200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJd1nq65_sZlG8tIiz_DI-ACiJd7OPuwkciDVkxkFB8S4uWmNj3RMQYzCRv2TxnulsO1Vmab3rMqqJjYpcRZ58oYGgMZ6H4WGfKkxUSiEgmHaHnjgEjbn3cLVZ1MBt_PSew1OtA2_B8ZQ/s1600/How-to-Manually-Set-Language-for-Syntax-Highlighting-in-Visual-Studio-Code.jpg" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitcLlN4KgvrsJuNoXkokIjSa5CehPl4QrFfym2nlyAGz3fDFanM-5-c26-qhwEDzjkQUGjU_u_geospz39xD3Iars0McGYaUg7U0jJg7heZf6NKha1cVjcXRGD2UoipvHdl4HWkGmldTM/s1600/How-to-Manually-Set-Language-for-Syntax-Highlighting-in-VSCode.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" class="img img-responsive" data-original-height="874" data-original-width="1200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitcLlN4KgvrsJuNoXkokIjSa5CehPl4QrFfym2nlyAGz3fDFanM-5-c26-qhwEDzjkQUGjU_u_geospz39xD3Iars0McGYaUg7U0jJg7heZf6NKha1cVjcXRGD2UoipvHdl4HWkGmldTM/s1600/How-to-Manually-Set-Language-for-Syntax-Highlighting-in-VSCode.jpg" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIjIsjNEgLEL5mRAhIPwHo3sHC3FhDIw_kXnZQ6TohamcLyycxwmQODxkie7RmFL6qGcXF66RfULRko9oZh0k7z3ZJFGGpO6RcbmV1FtEAQcVxN4I4iqKmcnZ5ax5_gM0yyOmvoacy_RU/s1600/VsCode-Syntax-Highlighting-Shortcut.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" class="img img-responsive" data-original-height="883" data-original-width="1200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIjIsjNEgLEL5mRAhIPwHo3sHC3FhDIw_kXnZQ6TohamcLyycxwmQODxkie7RmFL6qGcXF66RfULRko9oZh0k7z3ZJFGGpO6RcbmV1FtEAQcVxN4I4iqKmcnZ5ax5_gM0yyOmvoacy_RU/s1600/VsCode-Syntax-Highlighting-Shortcut.jpg" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr5xJSPfU-t-IKIJirzQCAebQ06ghPv9mxUgxWfYTZbb0g4LS6BeAW0HQqIGOnrb1CGz2V-vtKvXBvvcmwapHJGllh43SzF9fj0uQlu1TFOG526eR0cZChagRA7ZY2WBlqvxOVUy16OZg/s1600/Syntax-Highlighting-in-Visual-Studio-Code.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" class="img img-responsive" data-original-height="875" data-original-width="1200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr5xJSPfU-t-IKIJirzQCAebQ06ghPv9mxUgxWfYTZbb0g4LS6BeAW0HQqIGOnrb1CGz2V-vtKvXBvvcmwapHJGllh43SzF9fj0uQlu1TFOG526eR0cZChagRA7ZY2WBlqvxOVUy16OZg/s1600/Syntax-Highlighting-in-Visual-Studio-Code.jpg" /></a></div> <br /></div> http://blog.smarttutorials.net/2019/09/How-to-Manually-Set-Language-for-Syntax-Highlighting-in-Visual-Studio-Code.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-1455289981966881563Tue, 04 Dec 2018 09:00:00 +00002018-12-04T01:00:46.021-08:00Import MySQL Table Using Command Line<div dir="ltr" style="text-align: left;" trbidi="on"> Following command will help you to import MySQL table into the database. <pre> <code class="language-bash"> mysql -u root -p'mysql' -D security_insights_report_scheduler < defense_customer.sql </code> </pre> <br /></div> http://blog.smarttutorials.net/2018/12/import-mysql-table-using-command-line.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-3569924345395963186Fri, 30 Nov 2018 11:46:00 +00002018-11-30T03:46:42.336-08:00How to use multiple versions of jQuery in an Application<div dir="ltr" style="text-align: left;" trbidi="on"> Below scripts example to use multiple versions of jquery on same page. <br /> <pre> <code class="language-js"> &lt;script src=&quot;https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js&quot;&gt;&lt;/script&gt; &lt;script&gt;var jq142 = jQuery.noConflict();&lt;/script&gt; &lt;script src=&quot;https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js&quot;&gt;&lt;/script&gt; &lt;script&gt;var jq144 = jQuery.noConflict();&lt;/script&gt; &lt;script src=&quot;https://code.jquery.com/jquery-git.js?asdf&quot;&gt;&lt;/script&gt; &lt;script&gt;var jq15 = jQuery.noConflict();&lt;/script&gt; &lt;script&gt; var $jq142 = jq142(&quot;body&quot;); var $jq144 = jq144(&quot;body&quot;); var $jq15 = jq15(&quot;body&quot;); &lt;/script&gt; </code> </pre> </div> http://blog.smarttutorials.net/2018/11/how-to-use-multiple-versions-of-jquery-in-same-page.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-3622729037013611452Tue, 04 Sep 2018 05:43:00 +00002018-09-03T22:43:43.626-07:00Merge Videos On Mac Using QuickTime Player In 1 Minute<div dir="ltr" style="text-align: left;" trbidi="on"> Check this below video, where I explained <b>how to merge/combine two or more videos into single video using QuickTime Player</b> on Mac. <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/DqFFxBPeOj8"></iframe></div> <br /></div> http://blog.smarttutorials.net/2018/09/merge-videos-on-mac-using-quicktime-in-1-minute.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-2913894121878160330Thu, 16 Aug 2018 17:05:00 +00002018-08-16T10:05:03.872-07:00How To Add/Embed Youtube Video to Linkedin Post/Article<div dir="ltr" style="text-align: left;" trbidi="on"> <div dir="ltr" style="text-align: left;" trbidi="on"> Let's see how to add or embed youtube video's in your Linkedin post, article, profile or page. <br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/mcMT6ZAlwvs"></iframe></div> <br /> <h2>Step 1: Get Youtube video Link</h2> Go to your Youtube page and get the video link by clicking on the <b>share button</b>. It will open popup and now copy the video link. <br /> <div class="separator img-container" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX-CzjWqoJA1bzBazgLqtumaYRydpSOicQKn02FYh7CnaZzj6I6Q6JFYugSRfN_HyII65i6vWygWIiDhkttSmhvePhKFhIjIo56QVv0lciNg5FjaE0ZXINMkajswgLA9VLAGTYUlRsdE8/s1600/embed-youtube-video-in-linkedin-post-or-article.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" title="Embed youtube video in linkedin post or article"><img alt="Embed youtube video in linkedin post or article" border="0" data-original-height="836" data-original-width="1502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX-CzjWqoJA1bzBazgLqtumaYRydpSOicQKn02FYh7CnaZzj6I6Q6JFYugSRfN_HyII65i6vWygWIiDhkttSmhvePhKFhIjIo56QVv0lciNg5FjaE0ZXINMkajswgLA9VLAGTYUlRsdE8/s1600/embed-youtube-video-in-linkedin-post-or-article.jpg" /></a></div> </div> <br /> <h2>Step 2: Embed Youtube video In Linkedin Post, Article, Page or Profile:</h2><br /> <br /> Next go to your <a href="https://www.linkedin.com/" target="_blank">Linkedin profile</a>, and click on <b>Write An article</b>. Next click on <b>link</b> and paste video link and press enter key.<br /> <br /> <div class="separator img-container" style="clear: both; text-align: center;"> <a title="post youtube video on linkedin company page" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpzCp_CxCrceqc6vmBQQO_TaJ7b6h3TizkyYvPmGt6lWlSqZSOoe7GqUEAKV6ehrYZLd6lACMLmDcp83enaFjPYiH9quDYLk1UyFtJPcyOkr9DqfdBQfC5h93fW9E9yy50ZRe2kwwFJy8/s1600/post-youtube-video-on-linkedin-company-page.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="post youtube video on linkedin company page" border="0" data-original-height="347" data-original-width="1600" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpzCp_CxCrceqc6vmBQQO_TaJ7b6h3TizkyYvPmGt6lWlSqZSOoe7GqUEAKV6ehrYZLd6lACMLmDcp83enaFjPYiH9quDYLk1UyFtJPcyOkr9DqfdBQfC5h93fW9E9yy50ZRe2kwwFJy8/s1600/post-youtube-video-on-linkedin-company-page.jpg" /></a></div> <br /></div> http://blog.smarttutorials.net/2018/08/how-to-add-embed-youtube-video-to-linkedin-post-article.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-8556605997701476179Sun, 12 Aug 2018 11:15:00 +00002018-08-12T04:16:22.312-07:00emailhtml-gmailmailHow To Create and send HTML Email Template Using GMAIL <div dir="ltr" style="text-align: left;" trbidi="on"> In this tutorial we are going to see how to create and send HTML Email template using Gmail.<br /> <br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/YfgCl7_s9X8"></iframe></div> <b>Step 1: Open Email Template</b><br /> <b><br /></b> Please open your HTML Email template in your favorite browser.<br /> <br /> <div class="separator img-container" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjtHObpzthF5_-jQFPXrzly5WQSEXmyWQVI10lKwg3yUCJt5MpPg-_Yubqno7oCUDhDL8x6H_WKNAuqz38jqPvylUWcdDGKBjlLmx94_Yyzm2lqceMlGhbz42W_Mxt-ab0-z7lMQXryCw/s1600/send+an+HTML+email+template+through+Gmail.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1276" data-original-width="1600" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjtHObpzthF5_-jQFPXrzly5WQSEXmyWQVI10lKwg3yUCJt5MpPg-_Yubqno7oCUDhDL8x6H_WKNAuqz38jqPvylUWcdDGKBjlLmx94_Yyzm2lqceMlGhbz42W_Mxt-ab0-z7lMQXryCw/s1600/send+an+HTML+email+template+through+Gmail.png" alt="Send HTML Email Template Using GMAIL" /></a></div> <br /> <b>Step 2: Copy and Paste the HTML Template Opened in Gmail</b><br /> Now use <b>Command + A & Command + C</b> key ( or <b>Ctrl +A & Ctrl+C</b> in windows) shortcut to select and copy opened Email template in Browser. Next login into Gmail and click on Compose, then paste the copied email template into composed email body. <div class="separator img-container" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP8Rad5ohJWbw1cuz1KEx5KQoJziwo7Q5VImHxu6jcEpaphmLgtd1SHa187OyHTLWjvegt-RMLi9sipV80uGonfBqFmRkQI6FWyWOh2ZocCheOB9z8Vx1qtaTlr8pN_ziSEwz3bH5SSmk/s1600/How+to+Create+and+send+HTML+Email+in+Gmail.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP8Rad5ohJWbw1cuz1KEx5KQoJziwo7Q5VImHxu6jcEpaphmLgtd1SHa187OyHTLWjvegt-RMLi9sipV80uGonfBqFmRkQI6FWyWOh2ZocCheOB9z8Vx1qtaTlr8pN_ziSEwz3bH5SSmk/s1600/How+to+Create+and+send+HTML+Email+in+Gmail.png" data-original-width="1600" data-original-height="849" alt="How to Create and send HTML Email in Gmail" /></a></div> </div> http://blog.smarttutorials.net/2018/08/how-to-create-and-send-html-email-template-using-gmail.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-872546086573142488Sun, 05 Aug 2018 13:19:00 +00002018-08-05T07:27:03.230-07:00Ajax Drag and Drop Image/File Upload Using DropzoneJS, PHP<style> .img-container{width:100%;} .img-container img{width:100%;} </style> <div style="width:100%; padding:10px 10px;"> <div class="separator img-container" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAw-aCvfthrRiSkU8I0pc9wrQMuduIl42TPHo9yCnJ7_5cs-HzaRRC0-9Kr2aLBdtJH7YmeE4GAAKqRGfGGKt8U0Zu7BNM7K3PZ8WiXYVrIZDPAfBdjVTI36vVJDHpiMlv2BQe2bV6EWk/s1600/Ajax-Drag-And-Drop-ImageFile-Upload-Using-DropzoneJS%252C-PHP.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAw-aCvfthrRiSkU8I0pc9wrQMuduIl42TPHo9yCnJ7_5cs-HzaRRC0-9Kr2aLBdtJH7YmeE4GAAKqRGfGGKt8U0Zu7BNM7K3PZ8WiXYVrIZDPAfBdjVTI36vVJDHpiMlv2BQe2bV6EWk/s1600/Ajax-Drag-And-Drop-ImageFile-Upload-Using-DropzoneJS%252C-PHP.jpg" data-original-width="700" data-original-height="300" /></a></div> <div dir="ltr" style="text-align: left;" trbidi="on"> In this tutorial we are going to see how to Ajax Drag and Drop Image/File Upload Using DropzoneJS, PHP &amp; jQuery.<br /> <br /> <div class="text-center"> <a class="btn btn-success btn-bg" href="//demo.smarttutorials.net/php-image-drag-drop-image-file-upload-using-dropzoneJs/" target="_blank"> Demo Ajax Image Upload DropzoneJS</a> </div> <br/> <div class="text-center"> Also refer this tutorial on <br/> <a class="btn btn-success" href="//smarttutorials.net/ajax-image-upload-using-dropzone-js-normal-form-fields-button-click-using-php/" target="_blank"> Ajax Image Upload Using Dropzone.js with Normal Form Fields On Button Click Using PHP </a> </div> <br/> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/gtAkKH1jxUM"></iframe></div> <br/> <b>Step 1:</b><br /> <b><br /></b> Create new project called <b>"dropzone-tutorial" </b>in your server root either <b>htdocs/www</b> folder. Next create <b>index.html</b> file in it. Now copy paste the following html snippet in your index.html file.<br /> <pre><code class="language-html">&lt;!DOCTYPE html&gt; &lt;html lang=&quot;en&quot;&gt; &lt;head&gt; &lt;meta charset=&quot;UTF-8&quot;&gt; &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt; &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;ie=edge&quot;&gt; &lt;title&gt;Ajax Image Upload Using Dropzone.js with Normal Form Fields On Button Click Using PHP&lt;/title&gt; &lt;link rel=&quot;stylesheet&quot; href=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css&quot;&gt; &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/dropzone/5.5.1/min/dropzone.min.css&quot;&gt; &lt;/head&gt; &lt;body&gt; &lt;div class=&quot;container mt-2&quot;&gt; &lt;div class=&quot;row&quot;&gt; &lt;div class=&quot;col-md-6 offset-md-3&quot;&gt; &lt;h1 class=&quot;text-center&quot;&gt;Image Upload&lt;/h1&gt; &lt;form action=&quot;ajax.php&quot; class=&quot;dropzone&quot; id=&quot;my-awesome-dropzone&quot;&gt;&lt;/form&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/dropzone/5.5.1/min/dropzone.min.js&quot;&gt;&lt;/script&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <br /> <div class="text-center"> <a class="btn btn-default btn-success" style="padding: 15px 50px; display: inline-block; margin: 10px;" title="Download Image/File Upload Using DropzoneJS, PHP Script" href="http://www.smarttutorials.net/subscribers.php?id=70" target="_blank" rel="nofollow">Download Image/File Upload Using DropzoneJS, PHP Script </a> </div> <b>Step 2: File/Upload Using PHP</b><br /> Now write logic to handle the file upload by DropzoneJS via ajax. Next Create <b>ajax.php</b> file, then copy and paste below PHP scripts in it to handle the file/image upload logic. <pre><code class="language-php">&lt;?php /** * PHP Image uploader Script */ try { $uploaddir = './uploader/'; //create directory if not exists if (!file_exists($uploaddir)) { mkdir($uploaddir, 0777, true); } //Check real file exists if (!empty($_FILES['file']['name'])) { $image = $_FILES['file']; $data = []; $name = $image['name']; $uploadfile = $uploaddir . basename($name); if (move_uploaded_file($image['tmp_name'], $uploadfile)) { $data[$key]['success'] = true; $data[$key]['src'] = $name; } else { $data[$key]['success'] = false; $data[$key]['src'] = $name; } echo json_encode($data);exit; } } catch(Exception $e) { throw new Exception($e-&gt;message); } </code></pre> <br /></div> </div> http://blog.smarttutorials.net/2018/08/ajax-drag-and-drop-image-file-upload-using-dropzonejs-php-jquery.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-8282715328466756988Sat, 04 Aug 2018 16:09:00 +00002018-08-04T09:59:50.296-07:00How To Simplify GeoJSON File Size Using Mapshaper Online Tool<div dir="ltr" style="text-align: left;" trbidi="on"> <style> .img-container{width:100%;} .img-container img{width:100%;} </style> <br /> <div dir="ltr" style="text-align: left;" trbidi="on"> The converted GeoJSON file is more than 5 MB in size, that it will increase the page load time. So we need reduce the converted GeoJSON file size using Mapshaper online tool in order to improve page loading.<br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/MlDVbGpPYt4"></iframe></div> <br /> <div class="alert alert-success text-center"> Demo : <a href="https://demo.smarttutorials.net/how-to-create-custom-geojson-world-map-for-highmaps/" title="Custom GeoJSON World Map for HighMaps" target="_blank">Custom GeoJSON World Map for HighMaps</a> </div> <br /> <b>&nbsp;Step 1:&nbsp;</b><br /> <br /> &nbsp;Go to <a href="http://mapshaper.org/" target="_blank">http://mapshaper.org/</a> site, and drag and drop the GeoJSON file in it. Then using <strong>simplify</strong> option on the top right corner of the site to reduce the file size. <br /> <br /> <div class="separator img-container" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqerxKYPpqQHXan6-nwmoL4yIHTuPbwcnOBB6bVcdH5RIcbBxV3rOMXcrcgSL7Vl9cT0VuILfRIEQ1akwLAaPz2iZdGtTG-wAjKWdGXqeswPENwtDtLpraH7fcTJ5YOpRdDs4QJxfISaI/s1600/simplilfy-geojson-file-without-losing-attributes-using-mapshaper-online-tool.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="375" data-original-width="1200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqerxKYPpqQHXan6-nwmoL4yIHTuPbwcnOBB6bVcdH5RIcbBxV3rOMXcrcgSL7Vl9cT0VuILfRIEQ1akwLAaPz2iZdGtTG-wAjKWdGXqeswPENwtDtLpraH7fcTJ5YOpRdDs4QJxfISaI/s1600/simplilfy-geojson-file-without-losing-attributes-using-mapshaper-online-tool.jpg" /></a></div> <br /> <b>&nbsp;Step 2:&nbsp;</b></div> Next using settings slider on the top to reduce file size. Finally click on export on the top right to export the simplified GeoJSON file.<br /> <br /> <div class="separator img-container" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeaUhlUwhE9AN-nGtuwWPz-xSlwQnHs23e_zDfVhSbVpAW-49hBLU8UePI4ga7BplXLyO8cSNQeCIjxUskpTVkQJJIRMepEuiv452_EAGUjo4nwf1sNS4b1rOi6NpL1vLi6M-5NdSjdEI/s1600/Reduce-geojson-file-using-mapshaper-online-tool.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="534" data-original-width="1200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeaUhlUwhE9AN-nGtuwWPz-xSlwQnHs23e_zDfVhSbVpAW-49hBLU8UePI4ga7BplXLyO8cSNQeCIjxUskpTVkQJJIRMepEuiv452_EAGUjo4nwf1sNS4b1rOi6NpL1vLi6M-5NdSjdEI/s1600/Reduce-geojson-file-using-mapshaper-online-tool.jpg" /></a></div> <br /></div> http://blog.smarttutorials.net/2018/08/how-to-simplify-geojson-file-size-using-mapshaper-online-tool.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-1678553857327368242Fri, 03 Aug 2018 08:55:00 +00002018-08-04T10:00:48.921-07:00custom-highmaphighchartshighmapsQGISHow TO Reproject World Map and Save as GeoJSON Using QGIS<div dir="ltr" style="text-align: left;" trbidi="on"> We can change the <b>projection</b> of any map (i.e. World Map, US Map) to another projection (ex. <b>World Miller Projection, Mercator</b> etc. ) using <b>QGIS</b> editor.<br /> <br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/RKehyErtIpA"></iframe></div> <br /> <div class="alert alert-success text-center"> Demo : <a href="https://demo.smarttutorials.net/how-to-create-custom-geojson-world-map-for-highmaps/" title="Custom GeoJSON World Map for HighMaps" target="_blank">Custom GeoJSON World Map for HighMaps</a> </div> <br /> Now select any vector shapefile layer in layer panel and press <b>Shift + Command + P</b> key. It will open popup where select <b>CRS</b> option.<br /> <br /> &nbsp;Next in filter textbox type name of the projection, then it will list the filtered projection name. Next choose projection and click on OK button to reproject.<br /> <br /> Finally save the converted shapefile as <b>GeoJSON</b> by right click on the shapefile in vector layer panel and select Save as option. Next select <b>format as GeoJSON</b>, and in <b>CRS</b> - desired projection name and select the place where you want save the GeoJSON file by giving name to that. <br /> <br /> <div class="alert alert-info text-center well"> <a href="https://smarttutorials.net/create-custom-geojson-world-map-for-highmaps-using-qgis/" target="_blank">Create Custom GeoJSON World Map for HighMaps Using QGIS</a></div> </div> http://blog.smarttutorials.net/2018/08/how-to-reproject-world-map-and-save-as-geojson-using-qgis.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-3395791596136720569Fri, 03 Aug 2018 08:43:00 +00002018-08-04T10:01:02.132-07:00How To Merge Multiple ShapeFiles Into One Shapefile Using QGIS<div dir="ltr" style="text-align: left;" trbidi="on"> <br /> <b>Step 1:</b><br /> <b><br /></b> Import the all Shapefiles you want to merge into one single shapefile in QGIS editor<br /> <br /> Refer this tutorial on&nbsp;<a href="https://blog.smarttutorials.net/2018/08/how-to-import-shapefiles-qgis-editor.html" target="_blank">How To Import ShapeFiles QGIS Editor</a>.<br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/WJb0m-L6b24"></iframe></div> <br /> <div class="alert alert-success text-center"> Demo : <a href="https://demo.smarttutorials.net/how-to-create-custom-geojson-world-map-for-highmaps/" title="Custom GeoJSON World Map for HighMaps" target="_blank">Custom GeoJSON World Map for HighMaps</a> </div> <br /> <b>Step 2:&nbsp;</b><br /> <b><br /></b> Now choose V<b>ector -&gt; Data Management Tools -&gt; Merge Vector Layers</b>. Now select all ShapeFiles in input layers by clicking right side button next to input layer textbox. Finally click on <b>Run in Background </b>button to merge. Now it merge all the shapefiles into single shapefile and create new vector shape layer named <b>merged</b>.&nbsp; <br /> <br /> <div class="alert alert-danger well"> Note: While merge this vector shapefiles if you face issue like field datatype mismatch (POP_EST field in layer ne_50m_admin_0_countries has different data type than in other layers (Integer64 instead of Integer)), merge opartion will get aborted. So either you need remove the data fields from both the ShapeFiles or change the datatype in one of the Shapefile.</div> <br /> <br /> <div class="alert alert-info well text-center"> <a href="https://blog.smarttutorials.net/2018/08/how-to-merge-multiple-polygons-features-into-single-polygon-using-qgis.html" target="_blank">How To Merge Multiple Polygons/Features Into Single Polygon Using QGIS</a></div> <br /><br /> </div> http://blog.smarttutorials.net/2018/08/how-to-merge-two-shapefiles-into-one-shapefile-using-qgis.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-8070259432075977220Fri, 03 Aug 2018 08:32:00 +00002018-08-04T10:01:28.743-07:00custom-highmaphighchartshighmapsQGISHow To Merge Multiple Polygons/Features Into Single Polygon Using QGIS<div dir="ltr" style="text-align: left;" trbidi="on"> Select the vector shapefile layer in layer panel, and enable Toggle editing and select Feature by area or single click.<br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" src="https://www.youtube.com/embed/Jw4fwZjbM6M"></iframe></div> <br /> <div class="alert alert-success text-center"> Demo : <a href="https://demo.smarttutorials.net/how-to-create-custom-geojson-world-map-for-highmaps/" title="Custom GeoJSON World Map for HighMaps" target="_blank">Custom GeoJSON World Map for HighMaps</a> </div> <br /> <b>Step 1:</b><br /> <br /> &nbsp;Now hold command key (mac) or contrl key (windows) to select all the polygons/features you want to merge.<br /> <br /> <b>Step 2:</b><br /> &nbsp;Next select <b>Vector -&gt; Geoprocessing Tools -&gt; Dissolve</b> option. It will open popup where <b>check the checkbox of selected features only</b>.<br /><br /> <div class="alert alert-info well"> <a href="https://smarttutorials.net/create-custom-geojson-world-map-for-highmaps-using-qgis/" target="_blank">You may also like full tutorial how create custom GeoJSON from shapefiles using QGIS. Also drawing custom highmaps with world miller cylindrical projection. Create Custom GeoJSON World Map for HighMaps Using QGIS</a> </div> </div> http://blog.smarttutorials.net/2018/08/how-to-merge-multiple-polygons-features-into-single-polygon-using-qgis.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-8972353521946273946Fri, 03 Aug 2018 08:15:00 +00002018-08-04T10:01:47.059-07:00How to Import ShapeFiles QGIS Editor<div dir="ltr" style="text-align: left;" trbidi="on"> <style> .img-container{ width: 100%; } .img-container img{ width: 100%; } </style> <br /> <div dir="ltr" style="text-align: left;" trbidi="on"> Now extract the downloaded shape-files and import the file that have .shp extension in QGIS editor manually (Data Source Manager -&gt; Vector (add vector layer) -&gt; Vector Dataset) or drag and drop shape-files in layers panel.<br /> You can import shapefiles in QGIS editor in two way<br /> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"><iframe class="embed-responsive-item" src="https://www.youtube.com/embed/Fg11ZDV2HYI" allowfullscreen="allowfullscreen"></iframe></div> <br /> <div class="alert alert-success text-center"> Demo : <a href="https://demo.smarttutorials.net/how-to-create-custom-geojson-world-map-for-highmaps/" title="Custom GeoJSON World Map for HighMaps" target="_blank">Custom GeoJSON World Map for HighMaps</a> </div> <br /> 1. Manual way<br /> &nbsp;Data Source Manager -&gt; Vector (add vector layer) -&gt; Vector Dataset<br /> <div class="separator img-container" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3Sk7PO0EontDeYhSrCDCrmdaovQYbvkQmlDDOJRwLaowN2oxXoH67GuV1_OGfvpe-X1Xqps0Wf3fG5Qn5doltzEJovGHH_q0hwqpnVCotzFrI9skX7U3G8dKu2TdsY8VYjIFaHo0RxgA/s1600/how-to-import-shapefiles-using-qgis-editor.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="629" data-original-width="1600" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3Sk7PO0EontDeYhSrCDCrmdaovQYbvkQmlDDOJRwLaowN2oxXoH67GuV1_OGfvpe-X1Xqps0Wf3fG5Qn5doltzEJovGHH_q0hwqpnVCotzFrI9skX7U3G8dKu2TdsY8VYjIFaHo0RxgA/s1600/how-to-import-shapefiles-using-qgis-editor.jpg" /></a></div> <br /> <br /> 2. Drag and Drop shapefile in layer panel <br /> Now just drag and drag files layers panel.<br /> <br /> </div> <div class="alert alert-info well"> Refer full tutorial how to create custom world map from shapefiles using QGIS. <a href="https://smarttutorials.net/create-custom-geojson-world-map-for-highmaps-using-qgis/" target="_blank">Create Custom GeoJSON World Map for HighMaps Using QGIS</a> </div> </div> http://blog.smarttutorials.net/2018/08/how-to-import-shapefiles-qgis-editor.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-5988482080781713875Tue, 31 Jul 2018 07:44:00 +00002018-07-31T00:57:31.626-07:00PHP Invoice Script Using MySQL, jQuery, Bootstrap<style> blockquote { color: #31708f; background-color: #d9edf7; padding: .5em 1em; margin: 1em; border: 1px solid transparent; border-radius: 4px; line-height: 30px; font-size: 18px; } .img-container{ width:100%; } .img-container img{ width:100%; } </style> <div dir="ltr" style="text-align: left;" trbidi="on"> Here is the list PHP Script script that entirely done using PHP, MYSQL, jQuery, Bootstrap. This&nbsp;code for creating invoice in php help you to manage your business.<br /> <br /> &nbsp; &nbsp;This Invoice Script Using PHP, MySQL, jQuery and Bootstrap help you create Invoice effortlessly with jQuery autocomplete. This PHP Invoice script has features.<br /> <br /> <div class="text-center"><a class="btn btn-default btn-success" style="padding: 15px 50px;" title="Invoice Script PHP Demo" href="http://invoicegenerator.in/demo" target="_blank" rel="noopener">Smart Invoice Version 3 Demo</a></div> <div class="text-center"> <blockquote><p>Login email/ Password : muni@smart.com/ munihappy</p></blockquote> </div> <div class="text-center"><a class="btn btn-default btn-success" style="padding: 15px 50px;" title="Download PHP Invoice Script" href="http://invoicegenerator.in/#pricing" target="_blank" rel="noopener">Get Invoice System Version 3 Now.</a></div> <p>&nbsp;</p> <div class="text-center"><a class="btn btn-default btn-success" style="padding: 15px 50px; margin-bottom: 20px;" title="PHP Invoice Script" href="http://invoicegenerator.in/" target="_blank" rel="noopener">Know more about Invoice System Version 3.</a></div> Also check this invoice script done entirely using <b>Core PHP, MySQL, jQuery and Twitter Bootrap</b>: <div class="text-center"><a class="btn btn-default btn-success" style="padding: 15px 50px;" title="PHP Invoice Script Demo" href="http://www.smarttutorials.net/invoice_new/" target="_blank">PHP Invoice Script Demo</a></div> <br/> <div class="text-center"><a class="btn btn-default btn-success" style="padding: 15px 50px;" title="PHP Invoice Script Demo" href="https://smarttutorials.net/invoice-script-php/" target="_blank">Invoice Script Using Core PHP, MySQL</a></div> <h2> PHP Invoice Script Features: </h2> <div class="embed-responsive embed-responsive-16by9" style="margin: 20px auto;"><iframe class="embed-responsive-item" src="https://www.youtube.com/embed/bOOcYoyiZTc" allowfullscreen="allowfullscreen"></iframe></div> <blockquote> <ol> <li>PHP Invoice Script has Dashboard d3.js visualization. So now you can visually see your business performance over period of time using customized filter provided at the top the page. <div class="separator img-container" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXAvLc-aMpTZ6eWKBnLGRf7TV-PtnhHIMJhHJJuceR_LPIsJpNBGQDmtpF_acsRWS-sRTUOuZKo0L5UfbfZdKHZ3pnwabD7uwMV7td1Q7utGjlh5_g0MHSs6XEuvPP-Au0yDiohREY9rA/s1600/php-mysql-invoice-script-with-d3js-data-visualization.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" title="php mysql invoice script with d3js data visualization"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXAvLc-aMpTZ6eWKBnLGRf7TV-PtnhHIMJhHJJuceR_LPIsJpNBGQDmtpF_acsRWS-sRTUOuZKo0L5UfbfZdKHZ3pnwabD7uwMV7td1Q7utGjlh5_g0MHSs6XEuvPP-Au0yDiohREY9rA/s1600/php-mysql-invoice-script-with-d3js-data-visualization.jpg" alt="php mysql invoice script with d3js data visualization" data-original-width="1200" data-original-height="733" /></a></div> </li> <li>PHP Invoice Script is GST ready invoice. This can be enabled and disabled in the settings page. </li> <li> Facebook, Google, Twitter & Linkedin social login added to this php Invoice system. Now user can login and register effortlessly <div class="separator img-container" style="clear: both; text-align: center;width:100%;"><a title="php invoice script social login facebook google twitter &n linkedin" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0WKs1juX37tJOPufSIULf20R1mHHRtOGmu3h_t1yhDjFgE0yMmayQFAS4B8eZhPiTT6u4uxK2akrTh9hzlwGVZLVfpyfkR6YCRBGPdLLr5-3T2DHOgaralgepxZ8-cSN_PMH_zgaBU5Y/s1600/php-invoice-script-social-login-facebook-google-twitter-linkedin.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0WKs1juX37tJOPufSIULf20R1mHHRtOGmu3h_t1yhDjFgE0yMmayQFAS4B8eZhPiTT6u4uxK2akrTh9hzlwGVZLVfpyfkR6YCRBGPdLLr5-3T2DHOgaralgepxZ8-cSN_PMH_zgaBU5Y/s1600/php-invoice-script-social-login-facebook-google-twitter-linkedin.png" data-original-width="1018" data-original-height="968" alt="php invoice script social login facebook google twitter &n linkedin" /></a></div> </li> <li> This PHP invoice script has reports for Invoice, Quotes and Payments in preview, PDF, CSV format. Each report provided with customized filter, so you can filter either by customer, company or date. <div class="separator img-container" style="clear: both; text-align: center;"><a title="php invoice script reports for invoice quotes &payments in pdf & csv format" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh635yamxVJ6_VehRh67QUTS8eHrMPa6nZuQ_FIwQBW-MA-wdo18JjBXvLgMA4FPlUgiV30e9kDYAgAL3qXCJsyOKMDoXYVu4YeAA_q1rIvwL5aL-CbgcEfcno4nNICJxm6Oy6VvVkMr6o/s1600/php-invoice-script-reports-for-invoice-quotes-payments-pdf-csv.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh635yamxVJ6_VehRh67QUTS8eHrMPa6nZuQ_FIwQBW-MA-wdo18JjBXvLgMA4FPlUgiV30e9kDYAgAL3qXCJsyOKMDoXYVu4YeAA_q1rIvwL5aL-CbgcEfcno4nNICJxm6Oy6VvVkMr6o/s1600/php-invoice-script-reports-for-invoice-quotes-payments-pdf-csv.jpg" data-original-width="1600" data-original-height="748" alt="php invoice script reports for invoice quotes &payments in pdf & csv format" /></a></div> </li> <li>Seamless invoice creation by filling simple from assisted with jQuery Autocomplete.</li> <li>Ability&nbsp;to save, edit and delete unlimited&nbsp;invoices.</li> <li>Ability to&nbsp;print generated invoice.</li> <li>Ability&nbsp;to generate PDF of the invoice.</li> <li>Ability&nbsp;to add, edit and delete &nbsp;multiple client/consignee details. Saved client details will be used available for auto filling to make invoice creation an effortless process.</li> <li>Ability&nbsp;to add, edit and delete products. This acts as a simple inventory management system&nbsp;and yes, all the&nbsp;product details added will be available as&nbsp;autocomplete select while generating invoices.</li> <li>This invoice system has settings page where users can keep his/her company details that will helpful for easy invoice generation.</li> <li>User login system for secure access.</li> <li>Simple user registration system.</li> <li>Admin side dashboard for viewing list of invoices saved.</li> <li>Ability to save unlimited invoice.</li> <li>When user enters product name or product Id, the relevant text box shows an auto suggestion of the product name/id using jQuery autocomplete and then automatically fills the selected product id, product name, price and product quantity in their respective fields.</li> <li>Ability&nbsp;to add, delete any number table rows to add/delete product in the invoice system.</li> <li>Automatic calculation of total Line item price i.e. Number item * unit price&nbsp;Tax calculation.</li> <li>Automatic calculation of payment paid and payment due.</li> <li>This invoice system has a nice invoice template.</li> <li>Also, I kept following list features from the previous <a title="php invoice script tutorial" href="http://www.smarttutorials.net/invoice-system-using-jquery-autocomplete/" target="_blank">php invoice tutorial.</a></li> </ol> </blockquote> <br /></div> http://blog.smarttutorials.net/2018/07/php-invoice-sccript.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-1867579806882321717Tue, 03 Jan 2017 01:54:00 +00002017-01-02T17:56:25.319-08:00List Of Country Names with Currency Symbol SQL Query For MySQL<div dir="ltr" style="text-align: left;" trbidi="on"> Here is the list&nbsp;Country Names with Currency Symbol SQL Query dump For MySQL Database...<br /> <br /> <pre> <code class="language language-sql"> CREATE TABLE IF NOT EXISTS `currencies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `country` varchar(100) DEFAULT NULL, `currency` varchar(100) DEFAULT NULL, `code` varchar(25) DEFAULT NULL, `symbol` varchar(25) DEFAULT NULL, `thousand_separator` varchar(10) DEFAULT NULL, `decimal_separator` varchar(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=utf8; -- Dumping data for table invoice_new.currencies: 131 rows /*!40000 ALTER TABLE `currencies` DISABLE KEYS */; INSERT INTO `currencies` (`id`, `country`, `currency`, `code`, `symbol`, `thousand_separator`, `decimal_separator`) VALUES (1, 'Albania', 'Leke', 'ALL', 'Lek', ',', '.'), (2, 'America', 'Dollars', 'USD', '$', ',', '.'), (3, 'Afghanistan', 'Afghanis', 'AF', '؋', ',', '.'), (4, 'Argentina', 'Pesos', 'ARS', '$', ',', '.'), (5, 'Aruba', 'Guilders', 'AWG', 'ƒ', ',', '.'), (6, 'Australia', 'Dollars', 'AUD', '$', ',', '.'), (7, 'Azerbaijan', 'New Manats', 'AZ', 'ман', ',', '.'), (8, 'Bahamas', 'Dollars', 'BSD', '$', ',', '.'), (9, 'Barbados', 'Dollars', 'BBD', '$', ',', '.'), (10, 'Belarus', 'Rubles', 'BYR', 'p.', ',', '.'), (11, 'Belgium', 'Euro', 'EUR', '€', ',', '.'), (12, 'Beliz', 'Dollars', 'BZD', 'BZ$', ',', '.'), (13, 'Bermuda', 'Dollars', 'BMD', '$', ',', '.'), (14, 'Bolivia', 'Bolivianos', 'BOB', '$b', ',', '.'), (15, 'Bosnia and Herzegovina', 'Convertible Marka', 'BAM', 'KM', ',', '.'), (16, 'Botswana', 'Pula\'s', 'BWP', 'P', ',', '.'), (17, 'Bulgaria', 'Leva', 'BG', 'лв', ',', '.'), (18, 'Brazil', 'Reais', 'BRL', 'R$', ',', '.'), (19, 'Britain (United Kingdom)', 'Pounds', 'GBP', '£', ',', '.'), (20, 'Brunei Darussalam', 'Dollars', 'BND', '$', ',', '.'), (21, 'Cambodia', 'Riels', 'KHR', '៛', ',', '.'), (22, 'Canada', 'Dollars', 'CAD', '$', ',', '.'), (23, 'Cayman Islands', 'Dollars', 'KYD', '$', ',', '.'), (24, 'Chile', 'Pesos', 'CLP', '$', ',', '.'), (25, 'China', 'Yuan Renminbi', 'CNY', '¥', ',', '.'), (26, 'Colombia', 'Pesos', 'COP', '$', ',', '.'), (27, 'Costa Rica', 'Colón', 'CRC', '₡', ',', '.'), (28, 'Croatia', 'Kuna', 'HRK', 'kn', ',', '.'), (29, 'Cuba', 'Pesos', 'CUP', '₱', ',', '.'), (30, 'Cyprus', 'Euro', 'EUR', '€', ',', '.'), (31, 'Czech Republic', 'Koruny', 'CZK', 'Kč', ',', '.'), (32, 'Denmark', 'Kroner', 'DKK', 'kr', ',', '.'), (33, 'Dominican Republic', 'Pesos', 'DOP ', 'RD$', ',', '.'), (34, 'East Caribbean', 'Dollars', 'XCD', '$', ',', '.'), (35, 'Egypt', 'Pounds', 'EGP', '£', ',', '.'), (36, 'El Salvador', 'Colones', 'SVC', '$', ',', '.'), (37, 'England (United Kingdom)', 'Pounds', 'GBP', '£', ',', '.'), (38, 'Euro', 'Euro', 'EUR', '€', ',', '.'), (39, 'Falkland Islands', 'Pounds', 'FKP', '£', ',', '.'), (40, 'Fiji', 'Dollars', 'FJD', '$', ',', '.'), (41, 'France', 'Euro', 'EUR', '€', ',', '.'), (42, 'Ghana', 'Cedis', 'GHC', '¢', ',', '.'), (43, 'Gibraltar', 'Pounds', 'GIP', '£', ',', '.'), (44, 'Greece', 'Euro', 'EUR', '€', ',', '.'), (45, 'Guatemala', 'Quetzales', 'GTQ', 'Q', ',', '.'), (46, 'Guernsey', 'Pounds', 'GGP', '£', ',', '.'), (47, 'Guyana', 'Dollars', 'GYD', '$', ',', '.'), (48, 'Holland (Netherlands)', 'Euro', 'EUR', '€', ',', '.'), (49, 'Honduras', 'Lempiras', 'HNL', 'L', ',', '.'), (50, 'Hong Kong', 'Dollars', 'HKD', '$', ',', '.'), (51, 'Hungary', 'Forint', 'HUF', 'Ft', ',', '.'), (52, 'Iceland', 'Kronur', 'ISK', 'kr', ',', '.'), (53, 'India', 'Rupees', 'INR', 'Rp', ',', '.'), (54, 'Indonesia', 'Rupiahs', 'IDR', 'Rp', ',', '.'), (55, 'Iran', 'Rials', 'IRR', '﷼', ',', '.'), (56, 'Ireland', 'Euro', 'EUR', '€', ',', '.'), (57, 'Isle of Man', 'Pounds', 'IMP', '£', ',', '.'), (58, 'Israel', 'New Shekels', 'ILS', '₪', ',', '.'), (59, 'Italy', 'Euro', 'EUR', '€', ',', '.'), (60, 'Jamaica', 'Dollars', 'JMD', 'J$', ',', '.'), (61, 'Japan', 'Yen', 'JPY', '¥', ',', '.'), (62, 'Jersey', 'Pounds', 'JEP', '£', ',', '.'), (63, 'Kazakhstan', 'Tenge', 'KZT', 'лв', ',', '.'), (64, 'Korea (North)', 'Won', 'KPW', '₩', ',', '.'), (65, 'Korea (South)', 'Won', 'KRW', '₩', ',', '.'), (66, 'Kyrgyzstan', 'Soms', 'KGS', 'лв', ',', '.'), (67, 'Laos', 'Kips', 'LAK', '₭', ',', '.'), (68, 'Latvia', 'Lati', 'LVL', 'Ls', ',', '.'), (69, 'Lebanon', 'Pounds', 'LBP', '£', ',', '.'), (70, 'Liberia', 'Dollars', 'LRD', '$', ',', '.'), (71, 'Liechtenstein', 'Switzerland Francs', 'CHF', 'CHF', ',', '.'), (72, 'Lithuania', 'Litai', 'LTL', 'Lt', ',', '.'), (73, 'Luxembourg', 'Euro', 'EUR', '€', ',', '.'), (74, 'Macedonia', 'Denars', 'MKD', 'ден', ',', '.'), (75, 'Malaysia', 'Ringgits', 'MYR', 'RM', ',', '.'), (76, 'Malta', 'Euro', 'EUR', '€', ',', '.'), (77, 'Mauritius', 'Rupees', 'MUR', '₨', ',', '.'), (78, 'Mexico', 'Pesos', 'MX', '$', ',', '.'), (79, 'Mongolia', 'Tugriks', 'MNT', '₮', ',', '.'), (80, 'Mozambique', 'Meticais', 'MZ', 'MT', ',', '.'), (81, 'Namibia', 'Dollars', 'NAD', '$', ',', '.'), (82, 'Nepal', 'Rupees', 'NPR', '₨', ',', '.'), (83, 'Netherlands Antilles', 'Guilders', 'ANG', 'ƒ', ',', '.'), (84, 'Netherlands', 'Euro', 'EUR', '€', ',', '.'), (85, 'New Zealand', 'Dollars', 'NZD', '$', ',', '.'), (86, 'Nicaragua', 'Cordobas', 'NIO', 'C$', ',', '.'), (87, 'Nigeria', 'Nairas', 'NG', '₦', ',', '.'), (88, 'North Korea', 'Won', 'KPW', '₩', ',', '.'), (89, 'Norway', 'Krone', 'NOK', 'kr', ',', '.'), (90, 'Oman', 'Rials', 'OMR', '﷼', ',', '.'), (91, 'Pakistan', 'Rupees', 'PKR', '₨', ',', '.'), (92, 'Panama', 'Balboa', 'PAB', 'B/.', ',', '.'), (93, 'Paraguay', 'Guarani', 'PYG', 'Gs', ',', '.'), (94, 'Peru', 'Nuevos Soles', 'PE', 'S/.', ',', '.'), (95, 'Philippines', 'Pesos', 'PHP', 'Php', ',', '.'), (96, 'Poland', 'Zlotych', 'PL', 'zł', ',', '.'), (97, 'Qatar', 'Rials', 'QAR', '﷼', ',', '.'), (98, 'Romania', 'New Lei', 'RO', 'lei', ',', '.'), (99, 'Russia', 'Rubles', 'RUB', 'руб', ',', '.'), (100, 'Saint Helena', 'Pounds', 'SHP', '£', ',', '.'), (101, 'Saudi Arabia', 'Riyals', 'SAR', '﷼', ',', '.'), (102, 'Serbia', 'Dinars', 'RSD', 'Дин.', ',', '.'), (103, 'Seychelles', 'Rupees', 'SCR', '₨', ',', '.'), (104, 'Singapore', 'Dollars', 'SGD', '$', ',', '.'), (105, 'Slovenia', 'Euro', 'EUR', '€', ',', '.'), (106, 'Solomon Islands', 'Dollars', 'SBD', '$', ',', '.'), (107, 'Somalia', 'Shillings', 'SOS', 'S', ',', '.'), (108, 'South Africa', 'Rand', 'ZAR', 'R', ',', '.'), (109, 'South Korea', 'Won', 'KRW', '₩', ',', '.'), (110, 'Spain', 'Euro', 'EUR', '€', ',', '.'), (111, 'Sri Lanka', 'Rupees', 'LKR', '₨', ',', '.'), (112, 'Sweden', 'Kronor', 'SEK', 'kr', ',', '.'), (113, 'Switzerland', 'Francs', 'CHF', 'CHF', ',', '.'), (114, 'Suriname', 'Dollars', 'SRD', '$', ',', '.'), (115, 'Syria', 'Pounds', 'SYP', '£', ',', '.'), (116, 'Taiwan', 'New Dollars', 'TWD', 'NT$', ',', '.'), (117, 'Thailand', 'Baht', 'THB', '฿', ',', '.'), (118, 'Trinidad and Tobago', 'Dollars', 'TTD', 'TT$', ',', '.'), (119, 'Turkey', 'Lira', 'TRY', 'TL', ',', '.'), (120, 'Turkey', 'Liras', 'TRL', '£', ',', '.'), (121, 'Tuvalu', 'Dollars', 'TVD', '$', ',', '.'), (122, 'Ukraine', 'Hryvnia', 'UAH', '₴', ',', '.'), (123, 'United Kingdom', 'Pounds', 'GBP', '£', ',', '.'), (124, 'United States of America', 'Dollars', 'USD', '$', ',', '.'), (125, 'Uruguay', 'Pesos', 'UYU', '$U', ',', '.'), (126, 'Uzbekistan', 'Sums', 'UZS', 'лв', ',', '.'), (127, 'Vatican City', 'Euro', 'EUR', '€', ',', '.'), (128, 'Venezuela', 'Bolivares Fuertes', 'VEF', 'Bs', ',', '.'), (129, 'Vietnam', 'Dong', 'VND', '₫', ',', '.'), (130, 'Yemen', 'Rials', 'YER', '﷼', ',', '.'), (131, 'Zimbabwe', 'Zimbabwe Dollars', 'ZWD', 'Z$', ',', '.'); </code> </pre> <br /></div> http://blog.smarttutorials.net/2017/01/List-Of-Country-Names-with-Currency-Symbol-SQL-Query-For-MySQL.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-4642527828186897617Tue, 01 Nov 2016 10:34:00 +00002016-11-01T03:52:38.396-07:00Install Composer in XAMPP/WAMP Windows<div dir="ltr" style="text-align: left;" trbidi="on"> Composer Installation for windows users is very easy. All you need to do is just download .exe installer file from the <a href="https://getcomposer.org/download/" target="_blank" title="Composer download">Composer</a> site.<br /> <blockquote> <div style="text-align: center;"> Here is the .exe installer link to download <a href="https://getcomposer.org/Composer-Setup.exe">Composer-Setup.exe</a></div> </blockquote> Once you downloaded .exe file, then click on it to continue installation and follow the default Composer installation instructions.<br /> <br /> You can also install the Composer using <strong>curl</strong> using following command<br /> <pre><code class="language language-php"> php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');" php -r "if (hash_file('SHA384', 'composer-setup.php') === 'e115a8dc7871f15d853148a7fbac7da27d6c0030b848d9b3dc09e2a0388afed865e6a3d6b3c0fad45c48e2b5fc1196ae') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;" php composer-setup.php php -r "unlink('composer-setup.php');" </code> </pre> Once you successfully installed the Composer. Then open your command prompt then type composer and press enter in the terminal you will get following response like in the below image.<br /> <br /> <a class="text-center" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaU31djbPxYfFIPVyNVnjgyjI_JAvmOzjLAswe2wGgYU6tInVht8uPI_MbH80rmIRfQHPqSd789O1a7w7LS2UgXdowaKz-Qww67QpNx1So0Vs8HiaVdC33sawWE9dldyu-L5sQwA1HxJE/s1600/Install+Composer+in+XAMPP-WAMP+Windows.png" imageanchor="1" style="display: block;"><img class=" img-responsive" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaU31djbPxYfFIPVyNVnjgyjI_JAvmOzjLAswe2wGgYU6tInVht8uPI_MbH80rmIRfQHPqSd789O1a7w7LS2UgXdowaKz-Qww67QpNx1So0Vs8HiaVdC33sawWE9dldyu-L5sQwA1HxJE/s320/Install+Composer+in+XAMPP-WAMP+Windows.png" /></a></div> http://blog.smarttutorials.net/2016/11/install-composer-in-xampp-wamp-windows.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-1989708432010952874Wed, 29 Jun 2016 09:12:00 +00002016-06-29T02:12:30.839-07:00MySQLphpExport MySQL SELECT Query into CSV File<div dir="ltr" style="text-align: left;" trbidi="on"> Sometimes we need to export MySQL SELECT query results into CSV format for testing or some other purpose. Here we are going to see how to output MySQL query results in CSV format.<br /> <br /> We are going to use SELECT ... INTO OUTFILE MySQL query to store MySQL SELECT query results into CSV format.<br /> <br /> &nbsp;This SELECT ... INTO form of SELECT enables a query result to be stored in variables or written to a file: We can use SELECT ... INTO in following three way.<br /> <blockquote class="tr_bq"> &nbsp;SELECT ... INTO var_list selects column values and stores them into variables.<br /> SELECT ... INTO OUTFILE writes the selected rows to a file. Column and line terminators can be specified to produce a specific output format.<br /> &nbsp;SELECT ... INTO DUMPFILE writes a single row to a file without any formatting.&nbsp;</blockquote> <br /> Here is the SELECT ... INTO OUTFILE MySQL query outputs the results into CSV file in the specified location. <br /> <pre><code class="language-sql"> SELECT id, country, capital FROM `countries` INTO OUTFILE 'C:/Users/muni/Desktop/countries.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; </code> </pre> </div> http://blog.smarttutorials.net/2016/06/Export-MySQL-SELECT-Query-into-CSV-File.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-2629268795651317983Sat, 07 May 2016 02:39:00 +00002016-05-06T19:45:12.558-07:00Add/Set Windows Environment Variable Path<div dir="ltr" style="text-align: left;" trbidi="on"> In this tutorial we are going to set Environment Variable Path for MySQL utilities. Please follow below steps.<br /> <br /> Step 1:<br /> &nbsp;Right click on Computer and Click open properties.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioc3Mrr7gCb0pgCkLwLfU18bDyHZURCm9bkyctle6JrlHeK2_8bZMv9P46ntovw9KATyeZGV6EZOTjaS1CiYLqorYC_kEhvCyJsc_JAa3d8tBbIyli7UG_F1HIY_R-sno4Klw6sCK93nM/s1600/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25282%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioc3Mrr7gCb0pgCkLwLfU18bDyHZURCm9bkyctle6JrlHeK2_8bZMv9P46ntovw9KATyeZGV6EZOTjaS1CiYLqorYC_kEhvCyJsc_JAa3d8tBbIyli7UG_F1HIY_R-sno4Klw6sCK93nM/s320/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25282%2529.png" width="309" /></a></div> <div class="separator" style="clear: both; text-align: center;"> </div> Step 2:<br /> Next click <b>Advanced system settings, </b>it will open new window. Now click on <b>Environment Variables</b>. <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbPHdjyf8f_u9EUXAbdBu5XGySGBtuKpP05KGas4XblEPrwRvh9hOvae7akYSooYpV5KkjBMBJ7Q5QCGd5fq7CL_i0KBEHvDYSh0CwV_drO-uiuX3XSf_IR8K1pCE7-ep6TTZBSQ1g9BE/s1600/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25283%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbPHdjyf8f_u9EUXAbdBu5XGySGBtuKpP05KGas4XblEPrwRvh9hOvae7akYSooYpV5KkjBMBJ7Q5QCGd5fq7CL_i0KBEHvDYSh0CwV_drO-uiuX3XSf_IR8K1pCE7-ep6TTZBSQ1g9BE/s320/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25283%2529.png" width="320" /></a></div> <br /> <br /> <br /> <br /> Step 3:<br /> Now select <b>Path </b>from <b>System variables</b>&nbsp; then click on edit button.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm__MoXTThdJwN5YKaAdvgqYHw1HksCt-sigqbmKr9kEG12JFcXmzFnbNQVCuVfZiVUt7NA7cBpO68q41ZnDRu_Lmcm7Dujy-xO8_1wVieF1XfRmWoruexN6JG_ZN7htYB_BlPa8j5HDM/s1600/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25284%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="253" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm__MoXTThdJwN5YKaAdvgqYHw1HksCt-sigqbmKr9kEG12JFcXmzFnbNQVCuVfZiVUt7NA7cBpO68q41ZnDRu_Lmcm7Dujy-xO8_1wVieF1XfRmWoruexN6JG_ZN7htYB_BlPa8j5HDM/s320/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25284%2529.png" width="320" /></a></div> <br /> <br /> <br /> Step 4:<br /> Finally copy your path value you want to add and add it in the end, If semi colon not exists, then add like <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYyqpJEQMm0xVE_E1LS4SHGxBgUPy5MBkq8S_p0Y0PP7Esu2bzdP1ObhfrTFtjYoM2lZahHqs-UaLKhzEQGkSJoul5Ra7LkaDY3ZGuZ8xRzB-G3P0yzEnUEDkTL9lu1lXM39AV-SX4GiY/s1600/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25281%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYyqpJEQMm0xVE_E1LS4SHGxBgUPy5MBkq8S_p0Y0PP7Esu2bzdP1ObhfrTFtjYoM2lZahHqs-UaLKhzEQGkSJoul5Ra7LkaDY3ZGuZ8xRzB-G3P0yzEnUEDkTL9lu1lXM39AV-SX4GiY/s320/Add+Environment+Variable+Path+Windows+7%252C+8+%2526+10+%25281%2529.png" width="313" /></a></div> <br /> <br /> <br /> <br /> </div> http://blog.smarttutorials.net/2016/05/addset-windows-environment-variable-path.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-2779680112115336938Tue, 17 Nov 2015 09:08:00 +00002015-11-17T01:08:52.525-08:00nodejsnpmNodeJS and Npm Proxy Settings<div dir="ltr" style="text-align: left;" trbidi="on"> If you are behind the proxy, then proxy will block your package installation. It may throw errors like this.<br /> <blockquote class="tr_bq"> <ol style="text-align: left;"> <li>Tunneling socket could not be established cause=getaddrinfo ENOTFOUND.</li> <li>In most cases you are behind a proxy or have bad network settings</li> </ol> </blockquote> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1zesCmCvXIUgEe9ZxvF5-62m9h8cjep1xOgIacfRX0qFkaHezqbUUQEWgwy888SzGQYbelLE6Fue20cVH9MFjZLgTiKFDfO2RSR06FiCbu7WhCMZnX6aXkyAjxMBpPuVT_nAFhckmYys/s1600/npm+proxy+settings.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="NodeJS and Npm Proxy Settings Error" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1zesCmCvXIUgEe9ZxvF5-62m9h8cjep1xOgIacfRX0qFkaHezqbUUQEWgwy888SzGQYbelLE6Fue20cVH9MFjZLgTiKFDfO2RSR06FiCbu7WhCMZnX6aXkyAjxMBpPuVT_nAFhckmYys/s1600/npm+proxy+settings.png" title="NodeJS and Npm Proxy Settings Error" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">NodeJS and Npm Proxy Settings Error</td></tr> </tbody></table> <br /> Node package manager (NPM) uses the configuration file over the environment variable we set in windows system. So we need set proxy (http-proxy, https-proxy) in the Node configuration file using following commands.&nbsp; <br /> <pre><code class="language-javascript"> ​npm config set proxy http://proxy.com:8080 npm config set http-proxy http://proxy.com:8080 npm config set https-proxy https://proxy.com:8080 </code> </pre> If <b>npm</b> still have any issues then set registry using following command.<br /> <br /> <pre><code class="language-javascript"> npm config set registry http://registry.npmjs.org/ </code> </pre> If still you have any issues then close your command terminal and open it. Now try with npm install command </div> http://blog.smarttutorials.net/2015/11/nodejs-and-npm-proxy-settings.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-8688811411010146087Sun, 15 Nov 2015 02:12:00 +00002015-11-17T02:48:51.226-08:00phpwordpressInstall WordPress in Localhost<div dir="ltr" style="text-align: left;" trbidi="on"> Step 1: &nbsp;Download the Wordpress set-up from the following link.<br /> <br /> &nbsp;https://wordpress.org/download/<br /> <br /> Step 2:<br /> <br /> &nbsp;Now create a directory called "wordpress-site" in the root of the server (I am creating in htdocs/www folder).<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsphGh1bW-MFhvwkv95bs31COCH3gMa0EKR9hsH6Z9QzdEyC8m1dL6147rZrCcaaJEgFexEVK3EccCoTltlPvvo-AzevSrYszgF2D-eqZuCPEoviKd7qipjvzhBdBKu9OYTtwj5QIapqU/s1600/install+wordpress+in+localhost+xampp+-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsphGh1bW-MFhvwkv95bs31COCH3gMa0EKR9hsH6Z9QzdEyC8m1dL6147rZrCcaaJEgFexEVK3EccCoTltlPvvo-AzevSrYszgF2D-eqZuCPEoviKd7qipjvzhBdBKu9OYTtwj5QIapqU/s1600/install+wordpress+in+localhost+xampp+-1.png" /></a></div> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> Now extract the download Wordpress setup files and copy the extracted files into "wordpress-site" directory.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9YdArYo_Tjv5IJ0gJ9uotPB1LiglnS09WnqtJMDuGOHflbPiUL6j5MCrhPpmkrGrXz6j_KyfczaOVOUSAJHicECLsePC0NI8CMtK9zKx2RPpJaI8fkTszh_CnuwrRupGBwUlcG7K_QoQ/s1600/install+wordpress+in+localhost+xampp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9YdArYo_Tjv5IJ0gJ9uotPB1LiglnS09WnqtJMDuGOHflbPiUL6j5MCrhPpmkrGrXz6j_KyfczaOVOUSAJHicECLsePC0NI8CMtK9zKx2RPpJaI8fkTszh_CnuwrRupGBwUlcG7K_QoQ/s1600/install+wordpress+in+localhost+xampp.png" /></a></div> <br /> <div style='text-align:center'> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <ins class="adsbygoogle" style="display:inline-block;width:336px;height:280px" data-ad-client="ca-pub-4997600402648823" data-ad-slot="6651812194"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> Step 3: &nbsp;Now access your site using following URL "http://localhost/wordpress-site/" in the browser. Now Wordpress will automatically redirect you to the installation page.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidbLwrhzBqQRc6O3HFnM5xzREDAlM7QcvAjivskUlkoCwlq4v-RPdTvducgBsY01xJuAwR4M9kbrCTokI-DDKat_4Dj12W_Vf3C2PAKD2_RBJl_i4gECtVVCmVdg9HaGMDB6TGT5T7amc/s1600/install+wordpress+in+localhost+xampp+-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidbLwrhzBqQRc6O3HFnM5xzREDAlM7QcvAjivskUlkoCwlq4v-RPdTvducgBsY01xJuAwR4M9kbrCTokI-DDKat_4Dj12W_Vf3C2PAKD2_RBJl_i4gECtVVCmVdg9HaGMDB6TGT5T7amc/s1600/install+wordpress+in+localhost+xampp+-1.png" /></a></div> now click on continue.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi66TvsLQf-Emciog6T8EuUQvQb_fvqlx1dpEvA2Mn2PCG_EPtmDxgXHsrhtU2Qm0vnWGeB43kNa9fmUu-meYUx_bauxjcffBzOk_rUaNkR6MZYureEXo1D8IIYVo7svz0m7E0fJGSx3rE/s1600/install+wordpress+in+localhost+xampp+-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi66TvsLQf-Emciog6T8EuUQvQb_fvqlx1dpEvA2Mn2PCG_EPtmDxgXHsrhtU2Qm0vnWGeB43kNa9fmUu-meYUx_bauxjcffBzOk_rUaNkR6MZYureEXo1D8IIYVo7svz0m7E0fJGSx3rE/s1600/install+wordpress+in+localhost+xampp+-1.png" /></a></div> Now click on Let's go!.<br /> <br /> Step 4: Now create MySQL database for Wordpress Site. Go to your PHPmyAdmin and create database like this.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU7b7mVlEbSM9jTwwIzdnhJ1apsgX83OGvEyQQq1PvA_yeqLAskARI0SKRS7QlBU7fYLOwA8JjeCLkMgLJN39rpg-gj8_8XNZxisC0MR3i1HswnhFKRxQ2WP9NCFNPHEQ2Iy1Pr30rrGY/s1600/install+wordpress+in+localhost+xampp+-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU7b7mVlEbSM9jTwwIzdnhJ1apsgX83OGvEyQQq1PvA_yeqLAskARI0SKRS7QlBU7fYLOwA8JjeCLkMgLJN39rpg-gj8_8XNZxisC0MR3i1HswnhFKRxQ2WP9NCFNPHEQ2Iy1Pr30rrGY/s1600/install+wordpress+in+localhost+xampp+-1.png" /></a></div> <br /> Once you successfully created the database, now go your WordPress installation page, where we left. and give give your database credentials.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL15gvFWR-AD71I9qGjZcfLgmRuK75Piu21uVsm4f23G56jIB79Pv1quNx1bByejdXRjXL-5ARhn9716EB6Ijqx4PePZuEyom1yBwq71BEXqdU6ntXXiDegj7zSbR4h9BX7rWwM5qQ02U/s1600/install+wordpress+in+localhost+xampp+-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL15gvFWR-AD71I9qGjZcfLgmRuK75Piu21uVsm4f23G56jIB79Pv1quNx1bByejdXRjXL-5ARhn9716EB6Ijqx4PePZuEyom1yBwq71BEXqdU6ntXXiDegj7zSbR4h9BX7rWwM5qQ02U/s1600/install+wordpress+in+localhost+xampp+-1.png" /></a></div> I have given default MySQL database username and password (root/), and click on submit. If you are given correct database credentials then you will see following page that says WordPress can able to communicate with MySQL database.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPvHVk1sZvm62VbHqkb9_MiO3FAX0QxfLz9OmsKd2-Zfg66SXVVkPyaggYBAT92CXym_hk4WC87KAjxgSDUbkAqbOlOkU40ST_C9xYRqdRDhFD0FZ-enAl-kVfnG1RuBZRAb4DKaufNpw/s1600/install+wordpress+in+localhost+xampp+-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPvHVk1sZvm62VbHqkb9_MiO3FAX0QxfLz9OmsKd2-Zfg66SXVVkPyaggYBAT92CXym_hk4WC87KAjxgSDUbkAqbOlOkU40ST_C9xYRqdRDhFD0FZ-enAl-kVfnG1RuBZRAb4DKaufNpw/s1600/install+wordpress+in+localhost+xampp+-1.png" /></a></div> click on "Run the install" button to continue.<br /> <br /> Step 5: Finally give your site specific credentials like sitename, site username&amp; password and email.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJDc5NlYy7JynmFlb5qDGOPPdeS8fyV4KlGpitwmmfg_rZ9bOUKEJ4gWOzJgungEhYq3G5Km-OZFVFAQrDoPnM4d-j5WUUp-P0SNQXC-kzDEr_iBvXqrcwOizhp1bC5TpXBb7qZXfGmBo/s1600/install+wordpress+in+localhost+xampp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJDc5NlYy7JynmFlb5qDGOPPdeS8fyV4KlGpitwmmfg_rZ9bOUKEJ4gWOzJgungEhYq3G5Km-OZFVFAQrDoPnM4d-j5WUUp-P0SNQXC-kzDEr_iBvXqrcwOizhp1bC5TpXBb7qZXfGmBo/s1600/install+wordpress+in+localhost+xampp.png" /></a></div> Now click on "install WordPress" button to complete the WordPress installation process. Now you have successfully completed the WordPress installation on your local machine.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwz4XOk5mgjB16SKsZ40hyphenhyphen5jHSW35AmWdNRLPYpbKGGnNFYEWoLM78BsuT_TZ-CMVB4XxL4YGwn3DGjdKL9xnkmriEa3i6xb3xXMJNNRMZb-Ylat-Dfd0W2UIRWfFTU5emj8lD8OfofZ4/s1600/install+wordpress+in+localhost+xampp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwz4XOk5mgjB16SKsZ40hyphenhyphen5jHSW35AmWdNRLPYpbKGGnNFYEWoLM78BsuT_TZ-CMVB4XxL4YGwn3DGjdKL9xnkmriEa3i6xb3xXMJNNRMZb-Ylat-Dfd0W2UIRWfFTU5emj8lD8OfofZ4/s1600/install+wordpress+in+localhost+xampp.png" /></a></div> <br /> <br /></div>http://blog.smarttutorials.net/2015/11/install-wordpress-in-localhost.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-9169808232567269806Thu, 02 Apr 2015 02:33:00 +00002015-04-01T19:38:11.459-07:00Ajaxinvoice scriptjQueryMySQLphpInvoice Script Using PHP MySQL jQuery and Ajax<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-family: &quot;Trebuchet MS&quot;,sans-serif;"><a href="http://www.smarttutorials.net/invoice-system-using-jquery-php-mysql-bootstrap/" target="_blank">Smart invoice</a> makes your invoice generation and invoice maintenance so easy for your stock management system. <a href="http://www.smarttutorials.net/invoice-system-using-jquery-php-mysql-bootstrap/" target="_blank">Invoice script PHP</a> is created to save the time for Invoice generations when there are numerous products or clients are engaged in your business. Lesser your employees and manage your stock by just making few clicks and presses. You may get tired of typing Invoices for each and every company throughout the day, even if they are your old customers, but our <a href="http://www.smarttutorials.net/invoice-system-using-jquery-autocomplete/" target="_blank">free Invoice Script</a> will store your customers details such as Name, address, etc., so that the very next time when you try to enter their details it will be profiled in dropdowns and makes your job even simpler.&nbsp;</span><br /> <div class="text-center"> <a class="showpagePoint" href="http://demo.smarttutorials.net/invoice-script-php/" target="_blank" title="Invoice Script Demo"> Invoice Script Demo &nbsp;</a> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC7C7UY-N7bLmj3J2Lkai5bUC6G_dxWzZlpLHUlGe_2Rcj3SEYUNuVbUO_mtpZeb7wpbt-amAFYpIE3r2h5y_rS7ZtKIGfK1A1vw4pJduc63KrtQoEsiXBb2Ts5D0SqHELzhyFVnmg-XM/s1600/invoice-system-php-mysql-jquery-bootstrap.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC7C7UY-N7bLmj3J2Lkai5bUC6G_dxWzZlpLHUlGe_2Rcj3SEYUNuVbUO_mtpZeb7wpbt-amAFYpIE3r2h5y_rS7ZtKIGfK1A1vw4pJduc63KrtQoEsiXBb2Ts5D0SqHELzhyFVnmg-XM/s1600/invoice-system-php-mysql-jquery-bootstrap.png" height="273" width="640" /></a></div> <span style="font-family: &quot;Trebuchet MS&quot;,sans-serif;"><br />The dashboard of this Invoice generator gives you options like Managing Clients, Managing products, Signature of your company in settings, etc.,. Managing clients will show your existing customers from the database through which you can edit their information such as company name, phone number, address, etc., and also you can add a new client to your database right from here. Product management displays your existing product details from the database which gives way to edit things such as product code, product name, prices, etc., where here you can obviously add new products to your stock. Settings page of this Invoice software has some fields to enter your company details like company name, logo, address, etc., to get printed on your Invoices every time when you print it out.&nbsp;</span><br /> <br /> <div class="embed-responsive embed-responsive-16by9"> <iframe allowfullscreen="allowfullscreen" class="embed-responsive-item" frameborder="0" src="https://www.youtube.com/embed/AGawieZttJ0"></iframe></div> <br /> <span style="font-family: &quot;Trebuchet MS&quot;,sans-serif;"><br />This <a href="http://www.smarttutorials.net/invoice-system-using-jquery-php-mysql-bootstrap/" target="_blank">Invoice script</a> in PHP is mainly used to create invoices instantly for numerous products with the inclusion of tax percentage for each invoice. When you try to generate your invoice through this software there are some special options for you to notice. Once you enter Price of an Item, quantity and its Tax percentage then it will automatically fill up the fields such as Tax amount and Total amount. This Invoice script also calculates the balance amount that is yet to be paid when the Amount paid field is entered. Along with this obviously you can write some descriptions about the invoice on the given space for your future references.&nbsp; Apart from all the above usages this Invoice script open source helps you to retrieve the invoices for both hardcopy and softcopy. Meaning that you can edit and take a print out of those Invoices, save them as pdfs and also you can email every invoice.&nbsp;</span><br /> <span style="font-family: &quot;Trebuchet MS&quot;,sans-serif;"><br />Invoice script helps you here to reduce: <br />1.&nbsp;&nbsp;&nbsp; Employment<br />2.&nbsp;&nbsp;&nbsp; Time<br />3.&nbsp;&nbsp;&nbsp; Pressure</span><br /> <span style="font-family: &quot;Trebuchet MS&quot;,sans-serif;"><br />We are providing Invoice script as open source for your system to make use of the script to enhance your management easier and simpler, moreover, you can also use our entire application to manage and maintain your stock management system.&nbsp; So as said prior, this <a href="http://www.smarttutorials.net/invoice-system-using-jquery-php-mysql-bootstrap/" target="_blank">Invoice software</a> is there to help you in creating invoices instantly for any large number of products and keep track of your clients based on their products. One time usage of this script will make you feel very comfortable in using it for all your businesses globally. </span></div> http://blog.smarttutorials.net/2015/04/invoice-script-using-php-mysql-jquery-ajax.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-4588301052941565707Thu, 29 Jan 2015 11:14:00 +00002015-01-29T03:16:09.155-08:00wordpressWordpress wp_localize_script <div dir="ltr" style="text-align: left;" trbidi="on"> Wordpress offers wp_localize_script() function to assign some value from php to Javascript. This wp_localize_script() function makes any php data that's directly available in JavaScript.<br /> <br /> <pre class="prettyprint">&lt;?php wp_localize_script( $handle, $name, $data ); ?&gt; </pre> <br /> Where $handle – refers to script file<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $name – refers to name of the JavaScript object.<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $data – where we can specify list parameters for that JavaScript object ($name) going to have.<br /> <br /> For example I want following php data you want in ajax.js file. So we need to do following things. <br /> <pre class="prettyprint">// Register the script wp_register_script( 'ajax', 'path/to/ajax.js' ); wp_localize_script( 'ajax', 'php_data', array( 'name' =&gt; 'muni' ) ); // Enqueued script with localized data. wp_enqueue_script( 'ajax' ); </pre> <br /> While your page is excuted it will generate following scripts in your page. <br /> <pre class="prettyprint">&lt;script type='text/javascript'&gt; /* &lt;![CDATA[ */ var php_data = {"name":"muni"}; /* ]]&gt; */ &lt;/script&gt; &lt;script type='text/javascript' src='http://localhost/developersguide/wp-content/themes/developersguide/library/js/ajax.js'&gt;&lt;/script&gt; </pre> <br /> So we can easily access that php data in JavaScript like below. <br /> <pre class="prettyprint">&lt;script&gt; alert( php_data.name); &lt;/script&gt;&nbsp;</pre> <br /> To know more about please refer following Wordpress Forntend Login Tutorial.<br /> <br /> <blockquote class="tr_bq"> &nbsp;<a href="http://www.smarttutorials.net/wordpress-frontend-ajax-login-registration/" target="_blank">Light Weight </a><a href="https://www.blogger.com/null" target="_blank">WordPress Frontend Ajax Login and Registration</a></blockquote> </div> http://blog.smarttutorials.net/2015/01/wordpress-wp-localize-script.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-8678719727332902669Thu, 08 Jan 2015 07:21:00 +00002015-01-07T23:21:52.423-08:00wordpressRemove .lead class From First Paragraph of Wordpress Post<div dir="ltr" style="text-align: left;" trbidi="on"> You may came across situation like first paragraph each post or page has added lead class automatically, after you publishing each post or pages in your wordpress site.<br /><br />If it looks ugly on your site, then you want to remove that.&nbsp; Follow this simple steps to remove.<br /><br />Please comment out following PHP scripts in your functions.php file of your wordpress theme. <pre class='prettyprint'> function first_paragraph($content){ global $post; // if we're on the homepage, don't add the lead class to the first paragraph of text if( is_page_template( 'page-homepage.php' ) ) return $content; else return preg_replace('/&lt;p([^&gt;]+)?&gt;/', '&lt;p$1 class=&quot;lead&quot;&gt;', $content, 1); } add_filter('the_content', 'first_paragraph'); </pre> If you are using Wp bootstrap i.e. wordpress starter theme from http://320press.com. To remove lead class from first paragraph of the wordpress post or page. Comment out following lines in the functions.php file. <pre class="prettyprint"> function wp_bootstrap_first_paragraph( $content ){ global $post; // if we're on the homepage, don't add the lead class to the first paragraph of text if( is_page_template( 'page-homepage.php' ) ) return $content; else return preg_replace('/&lt;p([^&gt;]+)?&gt;/', '&lt;p$1 class=&quot;lead&quot;&gt;', $content, 1); } add_filter( 'the_content', 'wp_bootstrap_first_paragraph' ); </pre> </div> http://blog.smarttutorials.net/2015/01/remove-.lead-class-from-first-paragraph-of-wordpress-post.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-7574662618248382881Mon, 22 Dec 2014 03:15:00 +00002014-12-21T19:15:52.211-08:00blogger seoseoSubmit Blogger Sitemap To Bing/Yahoo Webmaster Tool<div dir="ltr" style="text-align: left;" trbidi="on"> Submitting you blogger sitemap to bing webmaster tool is just like you are telling to Bing and Yahoo search engines about content in your blog. So when someone comes and search something related to your content in Bing or Yahoo search engines. Bing/Yahoo will show your content in the search results and increases your blogger traffic in great way. <br /> <blockquote class="tr_bq"> Note: Submitting your sitemap to bing webmaster is enough, no need to submit your blogger sitemap to Yahoo. Because Yahoo search is get search results of bing.</blockquote> <h2> Login into Bing Webmaster Tool: </h2> Please login into Bing webmaster tool by going through below link. <br /> <blockquote class="tr_bq"> <a href="http://www.bing.com/toolbox/webmaster" rel="nofollow" target="_blank">Bing webmaster tool</a></blockquote> <br /> Now click on signin button to login into Bing webmaster using your existing microsoft live account or create new one.<br /> <h2> Add Your Blogger to Bing Webmaster Tool: </h2> Now enter your blog URL in the textbox and click on <b>ADD</b> button just like in the below picture. <br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgas6hvAkxOuhz3kuqiK-n0H_92R_NC79XjcCIf_QuFrvAtDyO8yN82YqX4aj1hs_egjBVLnZXu43LosVsCXudFXoUvWFETWserOVlAr_4S72zH8TStT0QaQPe7E0IKVPe4j124jdvPkfw/s1600/1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Your Blogger to Bing Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgas6hvAkxOuhz3kuqiK-n0H_92R_NC79XjcCIf_QuFrvAtDyO8yN82YqX4aj1hs_egjBVLnZXu43LosVsCXudFXoUvWFETWserOVlAr_4S72zH8TStT0QaQPe7E0IKVPe4j124jdvPkfw/s1600/1.png" height="308" title="Add Your Blogger to Bing Webmaster Tool" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Your Blogger to Bing Webmaster Tool</td></tr> </tbody></table> <h2> Add Your Blogger Sitemap in Bing Webmaster Tool: </h2> Now it will ask you to enter sitemap of your blogger. Before adding your blogger sitemap, please generate sitemap for your blog using below blogger sitemap generator tool .<br /> <blockquote class="tr_bq"> <a href="http://demo.smarttutorials.net/blogger-sitemap-generator-tool-online/" target="_blank">Blogger Sitemap Generator Tool </a></blockquote> Enter your blogger URL and click <b>generate</b> button to generate sitemap. Once you generated your sitemap, then copy and paste that in Bing webmaster tool just like in the below picture.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpTWN8GcK7At-YfiwKeMukEyhEHLXqTH_XtxI2tgcnC-A83WXmD9EKuz9xWkHxlVttL8NNiquc18i-ZsPMhPeL-Qbr09rJxi5RkCGGHvpt78brrqbMc2thbTCuMWtNxnK4UeJPYfLSGUA/s1600/2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Your Blogger Sitemap in Bing Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpTWN8GcK7At-YfiwKeMukEyhEHLXqTH_XtxI2tgcnC-A83WXmD9EKuz9xWkHxlVttL8NNiquc18i-ZsPMhPeL-Qbr09rJxi5RkCGGHvpt78brrqbMc2thbTCuMWtNxnK4UeJPYfLSGUA/s1600/2.png" height="240" title="Add Your Blogger Sitemap in Bing Webmaster Tool" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Your Blogger Sitemap in Bing Webmaster Tool</td></tr> </tbody></table> Now click on ADD button to finish your sitemap submission.<br /> <h2> Verify Ownership of Blogger Sitemap in Bing Webmaster Tool: </h2> Now it will ask you to verify ownership of your blog. So just copy that &lt;meta&gt; tag and paste it in your blogger just before closing of this &lt;/head&gt; tag.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgj-HqbHkbGUWonfOIUEp-UKNzZFqXmTItC5GGQkpszX2frOkNqeZTdZwzdvUnGn3oD_yK5taH_VuHY3Zw10e1r_8R8-PUCX0XTyrxKf6vbCKm28eCX9xlzFDBLi6Ai8qo1_YFWaQPb_J8/s1600/4.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Verify Ownership of Blogger Sitemap in Bing Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgj-HqbHkbGUWonfOIUEp-UKNzZFqXmTItC5GGQkpszX2frOkNqeZTdZwzdvUnGn3oD_yK5taH_VuHY3Zw10e1r_8R8-PUCX0XTyrxKf6vbCKm28eCX9xlzFDBLi6Ai8qo1_YFWaQPb_J8/s1600/4.png" height="263" title="Verify Ownership of Blogger Sitemap in Bing Webmaster Tool" width="320" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Verify Ownership of Blogger Sitemap in Bing Webmaster Tool</td></tr> </tbody></table> <br /> <h2> Add Bing Webmaster Verification meta Tag in Blogger: </h2> &nbsp;Now paste that bing webmater verification meta in your blogger just like in the below picture.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGTLHoi0H_DYxUgKIO7A5faH2jWB0DASTpOHUwWjINrm5eie8AhBs315wbH9C54yQ1t77LBPjRpoMJSR4k9t5SpVQ9u9p4NfzyguPjpZ9f2-bOjpEpoQuMc8FXXVKHPLYWdr0MQxLBb9Q/s1600/5.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Bing Webmaster Verification meta Tag in Blogger" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGTLHoi0H_DYxUgKIO7A5faH2jWB0DASTpOHUwWjINrm5eie8AhBs315wbH9C54yQ1t77LBPjRpoMJSR4k9t5SpVQ9u9p4NfzyguPjpZ9f2-bOjpEpoQuMc8FXXVKHPLYWdr0MQxLBb9Q/s1600/5.png" height="62" title="Add Bing Webmaster Verification meta Tag in Blogger" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Bing Webmaster Verification meta Tag in Blogger</td></tr> </tbody></table> Now click on the <b>SAVE TEMPLATE</b> button to apply&nbsp; the changes. Now go the Bing webmaster site and click VERIFY button. It checks and shows the verification success page.<br /> <br /> You are successfully added the sitemap of your blogger as well as verified ownership blogger. After successful completion your blogger sitemap submission to Bing webmaster tool, it shows following status of your blogger sitemap.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMjLl214tyRnYSDIvz46aBMlEVms5KmCAaePabRAl0d5iznJps3m2tFV_pBdzSkMeu3dEJTRu0HEMfcoqM9LBpsNl0umc-uUE6xqJ7ZCw_5sLj-KrT_oEqRiiz7X7875KAzMSgMdE_FVw/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMjLl214tyRnYSDIvz46aBMlEVms5KmCAaePabRAl0d5iznJps3m2tFV_pBdzSkMeu3dEJTRu0HEMfcoqM9LBpsNl0umc-uUE6xqJ7ZCw_5sLj-KrT_oEqRiiz7X7875KAzMSgMdE_FVw/s1600/6.png" height="187" width="400" /></a></div> <br /> <br /> <br /> <br /> <br /></div> http://blog.smarttutorials.net/2014/12/Submit-Blogger-Sitemap-Bing-Webmaster-Tool.htmlnoreply@blogger.com (muni)0tag:blogger.com,1999:blog-7017427187289644265.post-2036251509110403274Sun, 21 Dec 2014 16:29:00 +00002014-12-21T09:47:13.416-08:00blogger seoseositemap submission googleSubmit Blogger Sitemap To Google Webmaster Tool<div dir="ltr" style="text-align: left;" trbidi="on"> Most of us just writing the blog without concerning about whether his/her content reached someone or not. To make our content to available to someone, we must tell Google about our content by submitting our blogger sitemap in Google webmasters tool. It is very very easy to submit our blogger sitemap in Google webmaster tool.<br /> <h2> Login into Google Webmaster Tool: </h2> &nbsp;Please click on the below Google webmaster tool link.<br /> <blockquote class="tr_bq"> <a href="https://www.google.com/webmasters/tools/" rel="nofollow" target="_blank">Google Webmaster Tool </a> </blockquote> Now it will ask you login into Google webmaster tool, so please login into Google webmaster tool using your existing gmail account or create new account.<br /> <h2> Add Your Site in Google Webmaster Tool: </h2> <blockquote class="tr_bq"> &nbsp;Note : If you are added already your site or blogger in Google webamster tool, then skip below few steps, and continue from this <b>Submit Blogger Sitemap to Google Webmaster Tool step</b>.</blockquote> Once you logged in successfully, now it will ask you to add your site in webmaster tool. So please click on <b>ADD A SITE</b> button on the top right corner to continue.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivAOMaSu0gt0Ln_Et5699-VTDE02v_kXo_gfwstpEVDXc2QwzvRH23KycJU-_E4o-om39APpm9aQC3Qdb0_pjJkrAIw-GqRQAAGS5y1DYS5NPsUYVuuDLFLSLuK03QO1hkZ5lIIj4_pOI/s1600/1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Your Site in Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivAOMaSu0gt0Ln_Et5699-VTDE02v_kXo_gfwstpEVDXc2QwzvRH23KycJU-_E4o-om39APpm9aQC3Qdb0_pjJkrAIw-GqRQAAGS5y1DYS5NPsUYVuuDLFLSLuK03QO1hkZ5lIIj4_pOI/s1600/1.png" title="Add Your Site in Google Webmaster Tool" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Your Site in Google Webmaster Tool</td></tr> </tbody></table> Now enter your site URL in the textbox just like in the below picture, then click on continue.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfWmkGRspPkVW1yUydTr0T_1VTzJ8oKA74n5D8z6H3j5be2UHNA4bSp3cq-iGOg_xZZs1Zawv5nMtAbCwF0PZWRznAOdpcp4CAN-VHWeI2QdQnW6CeAntyTbtR8MRarFN2uqbNgMC8gZQ/s1600/2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Your Site in Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfWmkGRspPkVW1yUydTr0T_1VTzJ8oKA74n5D8z6H3j5be2UHNA4bSp3cq-iGOg_xZZs1Zawv5nMtAbCwF0PZWRznAOdpcp4CAN-VHWeI2QdQnW6CeAntyTbtR8MRarFN2uqbNgMC8gZQ/s1600/2.png" height="181" title="Add Your Site in Google Webmaster Tool" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Your Site in Google Webmaster Tool</td></tr> </tbody></table> <h2> Verify Ownership of Site or Blogger in Google Webmaster Tool:</h2> It will ask you to verify the ownership of the your blogger/site, So click on the<b> alternate method</b> link and select <b>HMTL TAG</b> option.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0gMIn36JdlM22q96YDa6gggx9sU8aR_2-Q-djk0U3mV9sqlr-Sb0ffuZ8EZvsHopjiGKnaOvE5YJYKU5DjE7k9YM3m5xGMX2LrK1R57ocMujDLxY6BT37uLLdxq5K77oTp6lJQLLyNlw/s1600/3.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Verify Ownership of Site or Blogger in Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0gMIn36JdlM22q96YDa6gggx9sU8aR_2-Q-djk0U3mV9sqlr-Sb0ffuZ8EZvsHopjiGKnaOvE5YJYKU5DjE7k9YM3m5xGMX2LrK1R57ocMujDLxY6BT37uLLdxq5K77oTp6lJQLLyNlw/s1600/3.png" height="216" title="Verify Ownership of Site or Blogger in Google Webmaster Tool" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Verify Ownership of Site or Blogger in Google Webmaster Tool</td></tr> </tbody></table> <h2> Adding&nbsp; Google Webmaster Site Verification Code To Blogger:</h2> All you needed to do is just copy the Google webmaster site verification meta tag and add it to your blogger just before &lt;/head&gt; closing head tag like in the below picture. Finally click on the <b>SAVE TEMPLATE</b> button to apply this change.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2z3Si65vtrIjm6E-2v84wFRdvjnIs2_tcrW9jO6iw5y929JSTemOXjn4gzes_Dhp3oeH1sGcM6E39W2CBJyKX9xF3OeWHkZenrXH-h1coEtXK8NoBUC-7tK-kB4BUQh3_ICmeLqnRopw/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Adding Google Webmaster Site Verification Code To Blogger" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2z3Si65vtrIjm6E-2v84wFRdvjnIs2_tcrW9jO6iw5y929JSTemOXjn4gzes_Dhp3oeH1sGcM6E39W2CBJyKX9xF3OeWHkZenrXH-h1coEtXK8NoBUC-7tK-kB4BUQh3_ICmeLqnRopw/s1600/4.png" height="51" title="Adding Google Webmaster Site Verification Code To Blogger" width="400" /></a></div> <br /> You successfully added Google webmaster site verifcation code to your blogger.<br /> <br /> Now go to the Google webmaster and click on the <b>VERIFY </b>button. It will check and shows the success page, if you are added in right way.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBKllFwhHe3931C35AqlrRnnAMh_Hwl05fvoS10ay5EkmV1EKtnQWd7XYIctsPIp2x1vzwqDtbPvpKpTpagV_-TPeJU7Ic8uXHAyc0UiQUmg91VzfVBrSUoKyDmyWh24q_Lc5d6mZyerA/s1600/5.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Google Webmaster Site Ownership Verification Success" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBKllFwhHe3931C35AqlrRnnAMh_Hwl05fvoS10ay5EkmV1EKtnQWd7XYIctsPIp2x1vzwqDtbPvpKpTpagV_-TPeJU7Ic8uXHAyc0UiQUmg91VzfVBrSUoKyDmyWh24q_Lc5d6mZyerA/s1600/5.png" height="82" title="Google Webmaster Site Ownership Verification Success" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Google Webmaster Site Ownership Verification Success<br /> <div style="text-align: left;"> <br /></div> </td></tr> </tbody></table> Now click on the <b>webmaster tools</b> link to go the webmaster dashboard. <br /> <h2> Submit Blogger Sitemap to Google Webmaster Tool:</h2> Now click on the <b>No Sitemaps</b> link on the top right corner to proceed to your sitemap submission.<br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfNM6lPLPBOeZDXo2HPT1Tm8MawqSYS5klWUmNM_Iv59OM1rFcUtqTwkZ35-ctat8CsvrTeUWBaQy4Ek4ud9DgcahXLRbfuad-_hbB76ga81wqihtudr6G_y4aRW_dfSYDEJSjaNRFdhA/s1600/6.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Submit Blogger Sitemap to Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfNM6lPLPBOeZDXo2HPT1Tm8MawqSYS5klWUmNM_Iv59OM1rFcUtqTwkZ35-ctat8CsvrTeUWBaQy4Ek4ud9DgcahXLRbfuad-_hbB76ga81wqihtudr6G_y4aRW_dfSYDEJSjaNRFdhA/s1600/6.png" height="57" title="Submit Blogger Sitemap to Google Webmaster Tool" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Submit Blogger Sitemap to Google Webmaster Tool</td></tr> </tbody></table> Now click <b>ADD/TEST SITEMAP</b> button on the top right corner to submit your sitemap.<br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikcI9zKyjE9CDmCE2VMTAGJlQwzwxrRp3PvGYHXZG53CTWu6HhuN5UEaS-QewB4z55Flzv1UvZxnTb7Tks1FCzDdUDQKtD0PZ4NOiFxO6VsUs_UFlOM4UV7ISvDg9FAkQpTz2G_ccP3PE/s1600/7.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Submit Blogger Sitemap to Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikcI9zKyjE9CDmCE2VMTAGJlQwzwxrRp3PvGYHXZG53CTWu6HhuN5UEaS-QewB4z55Flzv1UvZxnTb7Tks1FCzDdUDQKtD0PZ4NOiFxO6VsUs_UFlOM4UV7ISvDg9FAkQpTz2G_ccP3PE/s1600/7.png" title="Submit Blogger Sitemap to Google Webmaster Tool" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Submit Blogger Sitemap to Google Webmaster Tool</td></tr> </tbody></table> Please generate your blogger sitemap using this blogger sitemap generation tool.<br /> <blockquote class="tr_bq"> <a href="http://blog.smarttutorials.net/2014/12/Generate-Blogger-Sitemap-Using-Blogger-Sitemap-Generator-Tool.html" target="_blank">Generate Blogger Sitemap Using Blogger Sitemap Generator Tool</a></blockquote> Now copy that generated sitemap.<br /> <blockquote class="tr_bq"> <b>atom.xml?redirect=false&amp;start-index=1&amp;max-results=500</b> </blockquote> <h2> Add Blogger Sitemap to Google Webmaster Tool:</h2> Now paste that copied sitemap URL in the textbox just like in the below picture.<br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1fYbS3jVyFUsgr2Fi2jPbEF49vtCF3Zh1knOa_X4oeFj4WaJlkUBd9Lut_udFJIjJxNtnLiz098X658TSh9j0SfathLnPFwryhopMlCsU9C_wRKB9hchld4813AWQk9LIh4T7luzNsxE/s1600/9.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Blogger Sitemap to Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1fYbS3jVyFUsgr2Fi2jPbEF49vtCF3Zh1knOa_X4oeFj4WaJlkUBd9Lut_udFJIjJxNtnLiz098X658TSh9j0SfathLnPFwryhopMlCsU9C_wRKB9hchld4813AWQk9LIh4T7luzNsxE/s1600/9.png" height="170" title="Add Blogger Sitemap to Google Webmaster Tool" width="400" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Blogger Sitemap to Google Webmaster Tool</td></tr> </tbody></table> &nbsp;Click on the <b>Submit Sitema</b>p button to finish your blogger sitemap submission to Google webmaster tool. Now it will ask you to refresh the page.<br /> <br /> Now it will shows the number submit links to the Google webmaster tool.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNSYYJd2-y0fFQKfiNvGejXZsF_5SGp2IXTLUnEilL-_E7CdzKI_c4P4_iombtipj51QX9U535BXj_t5hdPswH1lJfdkkMFIoNmREzeKOVnz7mz5Hs7kYmsTM81szwXXLvDrd7QWpfnUU/s1600/10.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Add Blogger Sitemap to Google Webmaster Tool" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNSYYJd2-y0fFQKfiNvGejXZsF_5SGp2IXTLUnEilL-_E7CdzKI_c4P4_iombtipj51QX9U535BXj_t5hdPswH1lJfdkkMFIoNmREzeKOVnz7mz5Hs7kYmsTM81szwXXLvDrd7QWpfnUU/s1600/10.png" height="400" title="Add Blogger Sitemap to Google Webmaster Tool" width="328" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">Add Blogger Sitemap to Google Webmaster Tool</td></tr> </tbody></table> <br /> <br /> <br /></div> http://blog.smarttutorials.net/2014/12/Submit-Blogger-Sitemap-To-Google-Webmaster-Tool.htmlnoreply@blogger.com (muni)0