READ FROM FILE

emi87

Hello,
I have a problem reading from files, please help me .
I have a directory named "car". In that directory(car) I have 30 .txt files which are named differently, for example(mercedes.txt, audi.txt), where each .txt file contain just one line with a number, for example (if you open the audi.txt file you will see just this number: 416.38).
With a PHP script I need to open the CAR directory, to read all 30 .txt files(to read the number from each .txt), and after that I must to copy theyr contents(the numbers I have read) into a database table column.
PLEASE PLEASE helppppp !
I started like this but I don't know how to continue:
<?php
$dir=opendir("/car/");
while($file=readdir($dir)){
if ($file!="." and $file!="..") {
print "$file ";
$lines = file('$file');
foreach ($lines as $line_num => $line){
print "Line #{$line_num} : " . $line . " \n";
}
}
}
closedir($dir);

It doesn't work. It just shows the .txt files names ...but the next step to show the numbers from files doesn't work (it gives error at foreach loop and show the number from just one file)...
Please tell me someone what to do.
Thank you in advance.

rsmith

=> means Greater than or Equal To. Try just putting:

foreach($lines as $line_num -> $line){
echo "<font color='red'>Line #".$line_num."</font> : ".$line."<br />";
}

And FFR, make sure you use the built in php and /php tags to enclose your syntax for proper formatting so we can better help you.

emi87

previously it show me the number from just one file, and now nothing ... Look what error I have:

Warning: file(audi.txt) [function.file]: failed to open stream: No such file or directory in /home/.../public_html/test2.php on line 6

Warning: Invalid argument supplied for foreach() in /home/.../public_html/test2.php on line 7

lines 6 and 7 are:

$lines = file($file);
foreach($lines as $line_num -> $line){

and this 2 errors I recieve 30 times for each .txt ...and just for one is working and it shows the number.... (the last .txt file from folder maybe this will help you)
Thank you!

emi87

Somebody already told me the good answer which is the following and works:
<?php
$path="/car/";
$dir=opendir($path);
while($file=readdir($dir)){
if ($file!="." and $file!="..") {
print "$file ";

$lines = file($path.$file);
foreach ($lines as $line_num => $line){
print "Line #{$line_num} : " . $line . " \n";
}
}
}
closedir($dir);
?>

BUT now one more thing ...I want every number to copy it into a database table column
BUT every number to be placed into different fields of the column not all the numbers into just one field of the column ...
PS: I know how to connect to database, I need just these important pieces of code how to insert in a different field every number
Thanks a lot!

dougal85

get_file_contents not do what you want?

emi87

I solved the file contents problem, but now I want one more thing ...every number to copy it into a database table column
BUT every number to be placed into different fields of the column not all the numbers into just one field of the column ...
PS: I know how to connect to database, I need just these important pieces of code how to insert in a different field every number
Thanks a lot!

emi87

I have tried the following code but it inserts only the number from last file that I have read in script(only the number from the 30th .txt file is inserted into the column colorprice, but I want all the 30 numbers to be inserted in the column and in different fields of the column ..not all the numbers in the same field of that column). Can anyone help me pls?

<?php
$path="/car/";
$dir=opendir($path);
while($file=readdir($dir)){
if ($file!="." and $file!="..") {
  print "$file<br>";

  $lines = file($path.$file);
    foreach ($lines as $line_num => $line){
    print "<font color=red>Line #{$line_num}</font> : " . $line . "<br />\n";
    }
  }
}
closedir($dir);
mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("datab") or die(mysql_error());
mysql_query("INSERT INTO cars (colorprice) VALUES ($line) ") or die(mysql_error());
?>