Jinu in postgreSQL, program
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; …
How to create CSV file using java
In this video I have shown how you can create a CSV file or Comma Separated Values file using java. The below source code is explained in the video, Create_CSV.java package com.chillyfacts.com; import java.io.File; import java.io.PrintWriter; public class Create_CSV { public static void main(String[] args) { try { PrintWriter pw= new PrintWriter(new File(“C:\\Users\\MIRITPC\\Desktop\\csv\\books_table.csv”)); StringBuilder sb=new …
Hide .php extensions, Custom url for PHP pages with parameters, htaccess
In this video I have shown how you can have custom URL for you PHP web site. It is done by htaccess file, Please note that htaccess file should be created in ROOT folder of your project. 1. Project files Web pages 2. index.php <a href=”index.php”>INDEX</a> | <a href=”ABOUT”>ABOUT</a> | <a href=”PRODUCT”>PRODUCT</a> | <a href=”CONTACT”>CONTACT</a> …
Connect MySQL database using PHP and Select values from Table
In this video I have shown how you can Connect to your MySQL database and select values from the table in that database. Here in this example I am connecting to local host MySQL database Connect to Database with below code <?php echo ‘Hello<br>’; $hostname=’localhost’; $username=’root’; $password=’root’; $database=’test’; $conn=new mysqli($hostname,$username,$password,$database); if(!$conn){ die(‘Error In connection’.mysqli_connect_error()); }else{ …