PHP – Jinu Jawad

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…

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…

html

Create Simple Barcode using PHP

jinu November 11, 2019 comments off

In this video I have shown how you can create simple barcode using PHP. This example is shown through XAMPP server in windows 10 pc. 1. First you need to…

html

How to manage timezones between users in different location

jinu September 26, 2019 comments off

In this video I have shown how we can manage timezones in users. If your web application is being accessed from different locations which is having different timezones, Our application…

PHP

Create txt file using PHP without using any libraries

jinu September 16, 2019 comments off

In this video I have shown how to create txt file using PHP without using libraries. This is demonstrated in xampp server in windows PC. Add the below header to…

html

PHP Simple File Upload with HTML form without any validations

jinu August 18, 2019 comments off

In this video I have shown how you can create simple file upload project with HTML form without any file type validations. This project is shown in XAMMP server installed…

mysql

PHP Get IP Address location details of the user and save in MySQL Database

jinu August 6, 2019 comments off

In this video I have shown how you can get the IP address of the user and further you can get the location details of the user also. I am…

PHP

How to Create a Search Feature with PHP and MySQL

jinu August 1, 2019 comments off

In this video I have shown how we can create a simple PHP search feature with MySQL as back end. This is the continuation of my previous project PHP MySQL…

PHP

PHP MySQL CRUD Application

jinu July 23, 2019 comments off

In the video series I have shown how you can create a simple CRUD application with PHP as front end and MySQL database as the back end. CRUD Stands for…

All posts in PHP