Jinu Jawad – Code With Me

Traditional Tourist Locations In Kerala You Cannot Miss

jinu September 24, 2021 comments off

Kelela is known as “God’s Own Country” because of its unspoiled tropical beauty. Kerala in south India is a popular tourist destination. This coastal state has something for everyone, whether…

Uncategorized

Things About The Onam Festival You Didn’t Know

jinu September 24, 2021 comments off

A harvest festival of Kerala, Onam, is very fundamental to the Keralites. The event is generally held in August or September, and people from all around India and the world…

Uncategorized

All You Need To Know About The Caravan Tourism Policy In Kerala

jinu September 24, 2021 comments off

One of the beautiful states in India is Kerala. It is the most popular for its beautiful destinations like beautiful beaches, green paddy fields, amazing forts, beautiful, cool, and stunning…

Uncategorized

5 Exciting Places in Kerala for Adventure Seekers

jinu September 24, 2021 comments off

Kerala is amongst the beautiful places that people love to visit, you might have been wondering where to head in this charming land, getting to know about the best places….

Uncategorized

The History Behind The Celebration Of Attukal Pongala

jinu September 24, 2021 comments off

Attukal Pongala is a harvest festival that is celebrated at the Attukal Bhagavathy temple. The reason behind this festival is worshipping the goddess Kannai, who is an avatar of Goddess…

Uncategorized

All Things Exciting About Thrissur Pooram To Explore

jinu September 17, 2021 comments off

The mother of festivals of Kerala embodies the spiritual and cultural essence of God’s own country – Kerala. Thrissur Pooram is a magnificent spectacle that one should see at least…

mysql

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;

}

…