Jinu Jawad – Code With Me

Read data from Excel and store in MySQL database using PHP

jinu July 13, 2020 comments off

This is continuation of my previous video https://www.youtube.com/watch?v=LWXEsVFbED4. In this video I have shown how you can import data from excel file and insert into a table in MySQL database….

PHP

Read any Excel File using PHPExcel in PHP

jinu June 27, 2020 comments off

In this video I have shown how to read any excel file using PHPExcel in PHP. Kindly download the library Classes.zip here. 1. Project Structure. 2.index.php

<html>
<body>
<center>
<h2>Read Excel By PHPExcel</h2>
<?php
require_once "Classes/PHPExcel.php";
$path="test1.xlsx";
$reader= PHPExcel_IOFactory::createReaderForFile($path);
$excel_Obj = $reader->load($path);

//Get the last sheet in excel
//$worksheet=$excel_Obj->getActiveSheet();

//Get the first sheet in excel
$worksheet=$excel_Obj->getSheet('0');
echo $worksheet->getCell('E33')->getValue();
$lastRow = $worksheet->getHighestRow();
$colomncount = $worksheet->getHighestDataColumn();
$colomncount_number=PHPExcel_Cell::columnIndexFromString($colomncount);
echo $lastRow.'     ';
echo $colomncount;
echo "<table border='1'>";
	for($row=0;$row<=$lastRow;$row++){
		echo "<tr>";
		for($col=0;$col<=$colomncount_number;$col++){
			echo "<td>";
			echo $worksheet->getCell(PHPExcel_Cell::stringFromColumnIndex($col).$row)->getValue();
			echo "</td>";
		}
		echo "</tr>";
	}	
echo "</table>";
?>
</center>
</body>
</html>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

<html>

<body>

<h2>Read Excel By PHPExcel</h2>

<?php

require_once "Classes/PHPExcel.php";

$path="test1.xlsx";

$reader= PHPExcel_IOFactory::createReaderForFile($path);

$excel_Obj = $reader->load($path);

//Get the last sheet in excel

//$worksheet=$excel_Obj->getActiveSheet();

//Get the first sheet in excel

$worksheet=$excel_Obj->getSheet('0');

echo $worksheet->getCell('E33')->getValue();

$lastRow = $worksheet->getHighestRow();

$colomncount = $worksheet->getHighestDataColumn();

$colomncount_number=PHPExcel_Cell::columnIndexFromString($colomncount);

echo $lastRow.' ';

echo $colomncount;

echo "<table border='1'>";

for($row=0;$row<=$lastRow;$row++){

echo "<tr>";

for($col=0;$col<=$colomncount_number;$col++){

echo "<td>";

echo $worksheet->getCell(PHPExcel_Cell::stringFromColumnIndex($col).$row)->getValue();

echo "</td>";

}

echo "</tr>";

}

echo "</table>";

?>

</center>

</body>

</html>

The above code…

java

JAVA JSP upload image and show it in JSP page

jinu June 25, 2020 comments off

This project is continuation of my previous video JAVA JSP file upload example In this video I have shown how you can host a project in tomcat server. Then you…

postgres

java.lang.ClassNotFoundException: org.postgresql.Driver [solved]

jinu March 16, 2020 comments off

1. In this video I have shown how you can solve the error.

java.lang.ClassNotFoundException: org.postgresql.Driver
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at com.jinujawad.com.ConnectDB.get_connection(ConnectDB.java:23)
	at com.jinujawad.com.ConnectDB.main(ConnectDB.java:10)

1

2

3

4

5

6

7

8

9

java.lang.ClassNotFoundException: org.postgresql.Driver

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at com.jinujawad.com.ConnectDB.get_connection(ConnectDB.java:23)

at com.jinujawad.com.ConnectDB.main(ConnectDB.java:10)

2. This error came for me on running the below java program in Eclipse IDE.

package com.jinujawad.com;
import java.sql.Connection;
import java.sql.DriverManager;
public class ConnectDB {
	public static void main(String[] args) {
		ConnectDB obj_ConnectDB=new ConnectDB();
		obj_ConnectDB.get_connection();
	}
    public Connection get_connection() {
        Connection connection = null;
        String host="localhost";
        String port="5432";
        String db_name="jinujawad";
        String username="postgres";
        String password="root";
        try {
            Class.forName("org.postgresql.Driver");
            connection = DriverManager.getConnection("jdbc:postgresql://"+host+":"+port+"/"+db_name+"", ""+username+"", ""+password+"");
            if (connection != null) {
                System.out.println("Connection OK");
            } else {
                System.out.println("Connection Failed");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
		return connection;
    }
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

package com.jinujawad.com;

import java.sql.Connection;

import java.sql.DriverManager;

public class ConnectDB {

public static void main(String[] args) {

ConnectDB obj_ConnectDB=new ConnectDB();

obj_ConnectDB.get_connection();

}

public Connection get_connection() {

Connection connection = null;

String host="localhost";

String port="5432";

String db_name="jinujawad";

String username="postgres";

String password="root";

try {

Class.forName("org.postgresql.Driver");

connection = DriverManager.getConnection("jdbc:postgresql://"+host+":"+port+"/"+db_name+"", ""+username+"", ""+password+"");

if (connection != null) {

System.out.println("Connection OK");

} else {

System.out.println("Connection Failed");

}

} catch (Exception e) {

e.printStackTrace();

}

return connection;

}

…

command prompt

How to take back up of PostgreSQL Database – Windows PC using CMD

jinu March 16, 2020 comments off

In this video I have shown how to take back up of PostgreSQL database in windows PC using Command Prompt. This is demonstrated in windows 10 pc. 1. Open the…

command prompt

How to Auto back up PostgreSQL Database

jinu March 15, 2020 comments off

In this video I have shown how to create Auto Back up for PostgreSQL Database. This method is demonstrated in Windows 10 PC using task scheduler. 1. First create batch…

java

How to connect to PostgreSQL using JAVA JDBC

jinu February 6, 2020 comments off

In this video I have shown how you can connect to PostgreSQL using JAVA JDBC. This example is shown in eclipse IDE. You should download the jar file from official…

PHP

How to create a zip file using PHP

jinu December 29, 2019 comments off

In this video I have shown how you can create a zip format of any file using PHP code. This example is shown in XAMPP server installed in windows 10…

java

Change Computer IP address using JAVA

jinu December 25, 2019 comments off

In this video I have shown how you can change IP address using java project. I have shown this using Eclipse IDE. 1. Project Structure in Eclipse IDE is shown…

java

JAVA Extract text from PDF using PDFBox library OCR Optical Character Recognition

jinu November 11, 2019 comments off

In this video I have shown how you can extract text from PDF using java. All the dependencies and project source code is below. 1. Project Structure in Eclipse IDE….