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{ …
JAVA – Send SOAP XML Request and Read Response
In the video I have shown how you can create an XML request and send to an endpoint URL, Then receive the response from the server. You can send both get request and post request with below examples. Send_XML_Post_Request_1.java and Send_XML_Post_Request_2.java are 2 different example codes. Send_XML_Post_Request_1.java package com.chillyfacts.com; import java.io.BufferedReader; import java.io.DataOutputStream; import java.io.InputStreamReader; …
JAVA send http Get Post request with basic authentication
In the video I have shown how you can send HTTP get request and Post request with a real time example. The server is giving response in JSON format. The JSON response is parsed with java to get the parameters output. This source code is demonstrated with reddit login API documents. You will have to …