I have a address column(with , and .) in my table, when i download table using php it will not coming in proper manner here is my code
my address column data is like 'Plot No: 34, Krishna Mahalaxmi Nagar, XXX, Beside XXXX XXXX, XXXXX.'
foreach ($stmt1 as $row) {
if (!$flag) {
echo implode("\t", array_keys($row)) . "
";
$flag = true;
}
foreach ($row as $k => $v) {
if ($k == 'id') {
$row[$k] = $count;
}
if ($k == 'previous_school') {
$row[$k] = str_replace('/[ ,]+/', ' ', trim($v));;
}
if ($k == 'address') {
$row[$k] = str_replace('/[ ,]+/', ' ', trim($v));;
}
}
echo implode("\t", array_values($row)) . "
";
$count++;
}
Try this
$row[$k] = str_replace(' ,', ' ', trim($v));
or
$row[$k] = preg_replace('/[ ,]+/', ' ', trim($v));