Insert Query is not working with phpexcel Script

[bc080400222]

I am using phpExcel library for import data from excel(csv) file into mysql data. Every thing is working fine except mysql insert query below is my source code. Please after review my codes let me know where is problem. I have tried with an array but im fail too. Please review my mysql query and let me know which query will be better in this PhpExcel Library. Thanks in advance.

$objPHPExcel = PHPExcel_IOFactory::load("myfile.csv");
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {

$worksheetTitle     = $worksheet->getTitle();
$highestRow         = $worksheet->getHighestRow();
$highestColumn      = $worksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) - 64;

for ($row=2; $row<=$highestRow; $row++) {
$cell = $worksheet->getCellByColumnAndRow(3, $row)->getValue();

 mysql_query("INSERT INTO myTableName (`title`) VALUES ('$cell')");   

}
} 

[Belrick]

Where is the rest of your mysql query? There is no connect nor a db select
Never done it your way before though.

[bc080400222]

hi,

thanks for your response. My problem has been resolved for insert data into database. But another problem has been occored. I have an excel file with field 'Description(May be more than 1000 characters in each cell)' including 248 rows right now. When i try to insert it into database table insert then first 92 lines executed into database. Can you assist me regard this matter why phpExcel is limiting this. In near future may be excel rows should be more than 50000. Please tell me how can i handle large files data. Thanks

[bc080400222]

I got it. The description cell contains on html elements i.e{<table>, <p>, <b> font so on....}. Each excel cell is heavy therefore i need proper method which will deal with html. Is there any function or method in phpexcel that will handle this html cell data and take it from excel and insert into database from start to end? If yes please give me at least one example. Thanks