Create shortcut to change the IP address of the PC
In this video I have shown how you can create a short cut to change the IP address of your PC. This method will work in all windows versions and it is done with the help of Command prompt bat file. 1 . First find the name of the adapter you want to change the …
ORA-12560: TNS:protocol adaptor error SOLVED
In this video I have shown how you can solve the error ORA-12560: TNS:protocol adaptor error.This error comes when the oracle service ‘OracleServiceORCL’ gets stopped in the PC or Server. Here I have shown you 2 methods to solve it. Method 1 – Turn on the service from windows services1. Open run window by pressing …
How to reset MySQL root Password
In this video I have shown step by step how you can reset the MySQL root password in a windows PC. Login to your PC as Administrator Mode Stop all MySQL services or APPS that is using MySQL in your PC.First open the services from windows. Press the Win + R keys on your keyboard, …
Reset PostgreSQL password on Windows
In this video I have shown how to reset the forgotten password of PostgreSQL on windows 10 PC. 1. First locate the pg_hba.conf file inside the installation directory of PostgreSQL. In this example the file is located in ‘C:\Program Files\PostgreSQL\12\bin’. 2. Open the file in notepad and comment the below lines by putting # at …
Send SOAP Request with custom variables and read XML response from PHP page
In this video I have shown how we can send XML request with custom variables set from a HTML form. The XML Response received is parsed and shown in same page. For testing this, I have found the website holidaywebservice.com which will give response for XML request we send. 1. The Sample XML Request we …
Create excel file in PHP without using any libraries
In this video I have shown you how you can create excel file in PHP without using any libraries. Just add 2 lines of code mentioned below in your php page. The page will create an excel file and download it. header(“Content-type: application/vnd.ms-excel”); header(“Content-Disposition: attachment; filename=chillyfacts.com.xls”); The example page I shown in the video is, …
Send SOAP Request and read XML response from PHP page
In this video I have shown how you can send a XML Soap request and read the XML response with in a PHP page. For testing this, I have found the website holidaywebservice.com which will give response for XML request we send. 1. The below image shows the request and response for a service from …
Convert Image to Text Optical Character Recognition OCR Using PHP
In this video I have shown how you can convert image to text or do Optical Character Recognition OCR using PHP as front end. You can upload the file you want to do the OCR and the result will show on the page itself. First you have to download the tesseract application and install. …
Run command prompt commands from PHP page
In this video I have shown how you can run command prompt commands from PHP page. shell_exec(‘ ‘) can be used for executing cmd commands from php page. The below image shows the ipconfig/all command executed from my pc. We can run the same command from PHP page. The code is as below. <?php $out=shell_exec(‘ipconfig/all’); …
Export MySQL Table in to CSV file using JAVA
In this video I have shown how you can export MySQL table into a CSV file. You will need to import MySQL jar file into class path of eclipse IDE to work on this program. You can download here, mysql-connector-java-5.1.42-bin.rar 1. Project Structure in Eclipse IDE. 2.Create_CSV.java package com.chillyfacts.com; import java.io.File; import java.io.PrintWriter; import java.sql.Connection; …