[aniraka]

Hello!! Daily I receive a text file with certain information. I need to read it, process it and present it in a web site. The first thought I had was, read and process the information using C++ for example, since it was easy to do, and create a html file with the information I need it (It will be on tables). Then I thought that it would be great if I could process the information and write it into a database, since I could have just one dynamic web page, but I have no idea how to read a text file and write the information I need into the data base.

Does anyone know how I could do such a thing?.. Maybe I could read a common text file using php, and then introduce the information into the database without using others tools, but It should be done once a day everyday (just once)…..

I have no idea how could I do ?!.... Could you help me?

[FiRe]

You would need to use cron jobs to automatically read it once a day, otherwise you would manually have to go to the script once a day to do it!

PHP Code:

<?php



//filename

$filename = "file.txt";



$handle = fopen($filename, "r");



//data in text file is stored in $data

$data = fread($handle, filesize($filename));



fclose($handle);



//now you can do anything you like with the data

//here we will just print it onto the screen

print $data;



?>

[Keith]

You could also use file_get_contents()

PHP Code:

<?php



//filename

$filename = 'file.txt';



//data in text file is stored in $data

$data = file_get_contents($filename);



//now you can do anything you like with the data

//here we will just print it onto the screen

echo $data;



?>

[aniraka]

Thanks for your comments, let me try. However,... I wonder if I could run a php code as a cron job. I ask you because usually a php code is used on web pages and in this case it would run an application that it does not really anything to do with a web page, since It will run just to introduce the information into the database.

[sszettella]

PHP is a general purpose programming language, and can easily be run from a command line.

All you need to do (usually) is type "php myProgram.php" and you should be good to go. Cron will run the php executable with "myProgram.php" as an argument. Much as you might "cat myfile", where cat is the executable, and myfile is tha arguement.

Hope this helps