how to import data from excel to mysql using PHP

The easiest way to use Excel in PHP import and export of Excel function using PEAR. I just finished working there I have to export to Excel directly from the PHP project, and the other development and production of the import script, it's all very easy to use this news.

Hi,
thanks a lot for sharing your knowledge with all.it is a very helpful tool.now I have got the overall idea about the procedure of import data from excel to mysql using PHP.I want to know about the procedure.I definitely use this tool.

the best way is to create a *csv file of your excel file and import it via php then yuo can use it as sql database.




http://www.webyukti.com

Hey,

Do check out this link http://blog.tjitjing.com/index.php/2...in-5-easy.html . I think it is really useful and shows easy to follow steps regarding the matter. Nonetheless, PEAR excel functions are pretty effective as well.

Hello Friends
Try this code:

<?php

require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();

$data->read('Senator.xls');

error_reporting(E_ALL ^ E_NOTICE);
echo "<table border='1'>";
echo "<tr><th>STT</th><th>First Name</th><th>Middle Name</th><th>Last Name</th><th>Email ID</th></tr>";

for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++)
{
echo "<tr>";

echo "<td>";
echo $data->sheets[0]['cells'][$j+1][1];
echo "</td>";
echo "<td>";
echo $data->sheets[0]['cells'][$j+1][2];
echo "</td>";
echo "<td>";
echo $data->sheets[0]['cells'][$j+1][3];
echo "</td>";

echo "<td>";

echo $data->sheets[0]['cells'][$j+1][4];
echo "</td>";

echo "<td>";

echo $data->sheets[0]['cells'][$j+1][5];
echo "</td>";
//echo "<br>";

echo "</tr>";

}

echo "</table>";

?>

Originally Posted by ExpertsGuide

Explore fgetcsv()

php.net/manual/en/function.fgetcsv.php

Thank you so much!!

really that code was helpful

import using pear