how to import data from excel to mysql using PHP?

how to import data from excel to mysql using PHP?

 

check this class
http://www.jooria.com/projects/view?project=992

 

Export data from excel to CSV, i.e.
a1,a2,a3,a4
b1,b2,b3,b4

Then:
$data = file_get_contents("./file");
$lines = explode("\n", $data);
$num = count($lines); //number of lines
$ctr = 0;
while ($ctr < $num)
{
$line = explode(",", $lines[$ctr]);
$num2 = count($line);
$ctr2 = 0;
while ($ctr2 < $num2)
{
echo $line[$ctr2]; //this is your field
$ctr2++;
}
$ctr++;
}

 

PEAR has a good package you can install, Excel_Spreadsheet_Reader.

Used it on a project and it worked flawless.

- Scripteen.com

 

Hi,
It is only example