[SOLVED] Convert html table to cvs format

[zenag]

HI every body ...is there any way to convert html table to csv???if yes pls help me with codes.....

 

[zenag]

HI every body ...is there any way to convert html table to csv???if yes pls help me with codes.....

 

[vbnullchar]

how do you generate the contents of your table? from database?

[zenag]

no ...eg:

<table><tr><td>name</td><td>age</td></tr>
<tr><td>rajni</td></tr><tr><td>40</td></tr></table>

 

like that...

[vbnullchar]

is it generated dynamically?

[zenag]

yeah...

[sasa]

try

<?php
$a = 'blah bla
<table><tr><td>name</td><td>age</td></tr>
<tr><td>rajni</td><td>40</td></tr></table>
mbrwgb ';
preg_match('/<table(>| [^>]*>)(.*?)<\/table( |>)/is',$a,$b);
$table = $b[2];
preg_match_all('/<tr(>| [^>]*>)(.*?)<\/tr( |>)/is',$table,$b);
$rows = $b[2];
foreach ($rows as $row){
preg_match_all('/<td(>| [^>]*>)(.*?)<\/td( |>)/is',$row,$b);
$out[] = strip_tags(implode(',',$b[2]));
}
$out = implode("\n", $out);
print_r($out);
?>

[zenag]

yeah ...thank u friend ...worked fine....but one more thing if i need to display contents outside table what i have to do..(eg)...

$a = 'blah bla
<table><tr><td>name</td><td>age</td></tr>
<tr><td>rajni</td><td>40</td></tr></table>
mbrwgb ';
if i need to display "blah bla...mbrwgb"...??

[sasa]

$outside = preg_replace('/<table(>| [^>]*>)(.*?)<\/table(> |>)/is', '',$a);

[zenag]

wow...fine thank u friend ...it works great........thanks a lot..