Export Data to CSV (Using PHP)

[nikomou]

hey, i cant seem to get it working
I dont get any error messages, just a blank page..

<?php 
ob_start(); 
include ("http://www.mobiles4everyone.com/_exporths.asp"); 
$inc = ob_get_contents(); 
ob_end_clean(); 
$s = array(); preg_match('/<body\b[^>]*>(.*?)<\/body>/', $inc, $s); $inc = str_replace(" | ", "|", str_replace("            ", "", $inc)); $inc = $s[1];
echo ("$inc");?>

[Twey]

Call preg_match() after the str_replace() calls.

[nikomou]

nope, still get a blank page!!

<?php 
ob_start(); 
include ("http://www.mobiles4everyone.com/_exporths.asp"); 
$inc = ob_get_contents(); 
ob_end_clean(); 
$s = array(); 
$inc = str_replace(" | ", "|", str_replace("            ", "", $inc)); 
preg_match('/<body\b[^>]*>(.*?)<\/body>/', $inc, $s); 
$inc = $s[1];
echo ("$inc");?>

[Twey]

Try

$inc = $s[0];

[nikomou]

nope!! still gettin a blank page..

[mwinter]

Try

$inc = $s[0];

That would show the substring that the pattern matched, not the parenthesised expression.

The problem here is that, by default, the dot (.) pattern token doesn't match line terminators. As one exists just after the opening body tag, the match halts pretty quickly. The 's' flag will include these line terminators.

More luck can be had with:

$data = file_get_contents('http://www.mobiles4everyone.com/_exporths.asp');
$data = str_replace(' | ', '|', $data);

if (preg_match('/<body\b[^>]*>\s*(.*?)\s*<\/body>/s', $data, $content)) {
  echo $content[1];
}

Notice that leading and trailing white space will be excluded from the capturing parentheses, so one of the str_replace function calls can be removed.

Mike

[nikomou]

your a genious!! lol, works great! thanks to everyone, twey, mike..

[nikomou]

hey!

does anyone know why this script doesnt work with php 5.2.1?
PHP has just been updated on my host, and none of my databases are being updated!!! grr!!

Anyone got any ideas? help is much appreciated!

[Twey]

What's the error?

[nikomou]

there is no error..
just get a blank page!
if i remove the preg_match part, the script works, but all the html tags are not removed..