Read data from Excel and store in MySQL database using PHP
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….
Read more »Read any Excel File using PHPExcel in PHP
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
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> <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> |
The above code…
Read more »How to create a zip file using PHP
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…
Read more »Create Simple Barcode using PHP
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…
Read more »How to manage timezones between users in different location
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…
Read more »Create txt file using PHP without using any libraries
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…
Read more »PHP Simple File Upload with HTML form without any validations
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…
Read more »PHP Get IP Address location details of the user and save in MySQL Database
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…
Read more »How to Create a Search Feature with PHP and MySQL
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…
Read more »PHP MySQL CRUD Application
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…
Read more »