Studiati questo codice:
Codice PHP:<?php
$files = glob($directory . '/*.dat');
foreach ($files as $file) {
if (!is_readable($file)) {
print("File not readable: {$file}\r\n");
continue;
}
$handle = @fopen($file, "r");
if ($handle) {
while (!feof($handle)) {
$line = trim(fgets($handle, 255));
if ($line != '') {
$vett = explode(',', $line);
if ($vett[0] != '-9999') {
$sql = sprintf('INSERT INTO cr10 (id, id_letto) VALUES ("", "%s")', mysql_real_escape_string($vett[0]));
mysql_query($sql) or die(sprintf('Unable to execute the query "%s" : %s', $sql, mysql_error()));
}
}
}
fclose($handle);
}
}
?>

Rispondi quotando