i am inserting record into mysql table from CSV but php code skip all those enteries which content " ' " in CSV file. its working fine with normal data working fine with , Jams Bond , but skipping this data : jam's bond
function readCSV($csvFile)
{
$file_handle = fopen($csvFile, 'r');
while (!feof($file_handle) )
{
$line_of_text[] = fgetcsv($file_handle, 1024);
fclose($file_handle);
}
$csvFile = $target_file;
$csv = readCSV($target_file);
for($i=0;$i<sizeof($csv);$i++)
{
if($i>=0)
{
if($csv[$i][3]!='')
{
$dd=date('Y-m-d H:i:s', strtotime($csv[$i][2]));
mysqli_query($conn123,"insert into call_detail_record (date, caller_id_from,extension, caller_id_to, duration, cost, destination, cost_rate, cost_centre) values('".$dd."','".$csv[$i][3]."','".$csv[$i][4]."','".$csv[$i][5]."','".$csv[$i][6]."','".$csv[$i][7]."','".$csv[$i][8]."','".$csv[$i][10]."','".$csv[$i][11]."')");
}
}
if($i==(sizeof($csv)-1))
{
?>
<div class="form-group">
<label><font color="#009933">File Uploaded Successfully...</font></label>
</div>
<?php
unlink($target_file);
}
}