Roy Tutorials

Introduction In this guide we will walk through Spring Boot Data JPA left, right, inner and cross join examples on three tables. In pas we have seen similar example on two tables but I got some requests on how to perform similar joins on three tables. Therefore I am going to show you how to perform joins – left, right,…

Introduction In this guide I will show you how to detect and delete empty rows from excel file using Apache POI in Java. I will see also how to read and write excel file using Apache POI. If you have few cells or columns in a row then you can deal with those empty cells but if you have entire…

Introduction In this post we will create social share links in WordPress without plugin. Clicking on such social media links or social share buttons populates a message and image (if any) that can be shared on social media. The social media link on your content minimize the time it takes to promote your content on social networks.

Introduction We will discuss here how to build a simple online visitor tracking system using Python Flask. Every website owner would like to know the progress to the count of the online visitors because it gives them overall idea on the website’s analytical measurements. It will also give them how to make improvements on the websites. We will use here…

Introduction In this post you will see how to convert pdf to image using Python language. I will use here pdf2image module for extracting image from pdf file and convert to image file. Though there are number of tools available for converting pdf to image file but still you may need to convert pdf using programming language for certain situations. Here I…

Introduction In this post you will see how to convert image to pdf using Python language. I will use here img2pdf module for converting image file to pdf file. Though there are number of tools available for converting image to pdf file but still you may need to convert image using programming language for certain situations. Here I am going…

Cloudflare This tutorial will explain you how to configure Cloudflare for DNS, Email – MX, Webuzo control panel hosted on VPS server. If you are using shared hosting then it is very easy to setup Cloudflare because you can configure Cloudflare through cpanel. Then Cloudflare pulls the required information from your cpanel. But when you want to configure VPS hosting…

Introduction Here I will guide you how to migrate existing website from shared hosting to VPS hosting. I will talk about mainly PHP based website, for example, WordPress that has MySQL database for storing the information and runs on Apache web server. But this website may be based on any technology with any database as its persistent storage. The same…

Backup and Restore This guide will show you how to backup and restore MySQL database using command line tool in VPS server on CentOS 7 and PhpMyAdmin. You need to take backup of your MySQL database on a daily basis to have minimal impact on your web site’s data loss. Similarly for some inconsistent situations you may need to restore…

Introduction This guide will walk you through the installation process of LAMP stack on CentsOS 7 in VPS server. LAMP is an acronym that represents Linux operating system, Apache web server, MySQL database server and PHP scripting language, which is used to build a dynamic web application whose data are stored into MySQL server and run this web application on…