Access Table Files via PHP 1

[douglagm]

Hi,
Hopefully someone out there can help me ?
I have got table files that I can only access through the program that creates them, but I want a web-interface so that others can see the info.

I can open the .REC files in Notepad, so I would imagine they are plain text files. The .TBL cotains ASCII characters when open through Notepad.

So, does anyone have any ideas on how I can get PHP to access these files (.TBL and .REC)

Thanks

 

[sleipnir214]

Sounds proprietary. Unless there is some kind of ODBC driver which will access that file format, you're going to have to write it yourself.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[OSR]

<?php
// get contents of a file into a string
$filename = &quot;/usr/local/something.rec&quot;;
$handle = fopen ($filename, &quot;r&quot;
$contents = fread ($handle, filesize ($filename));
fclose ($handle);
?>

see if that works - if the files are not within the web or server root u may have problems with PHP being able to access them b/c of permissions.

Rocco is the BOY!!

SHUT YOUR LIPS...

 

[douglagm]

I have been trying the script. Keep on getting &quot;failed to open stream: Permission denied&quot;. I even install apache and php on a w2k server and edited the php.ini and used the include_path, but still the same error. Is there another another file I need to edit inorder for PHP to have access to the directory ?

 

[ingresman]

Do you have a product name for these files ?

regrards

 

[DRJ478]

You need to make sure that the web server has read access top the folder and files. Check as what user the web server runs and apply read privileges to the necessary folders and files.

 

[douglagm]

I eventually got it right. I can now read the info of a table file in the web-browser, but now I want to select text from the table file. The text in the file is as follows
***** Computer Associates ALERT Event Log File *****



Application : ARCserve

Priority : Warning

Action : Broadcast,AlphaNumerical Pager,EMail,Trouble Ticket,Event Log,SNMP,Notes,Unicenter TNG,SMTP



Message :ARCALERT: [JobID:0 ] SPNNIS09: BrightStor ARCserve: E1145 Media write error - Drive or Media Failure.

From :ARCALERT
I want to be able to extract the server name (&quot;SPNNIS09&quot and the error code.

 

[DRJ478]

You would accomplish that by using regular expressions.
First you need to establish a specific pattern that you want to match. Is the message line always built the same?
If so, we can go from there using preg_match()

http://us4.php.net/preg_match

If you need help with the regexp, let us know.

 

[douglagm]

I have got it working, got so far as to create a csv file with : server_name,date,backup_message. The script access only one file though, but there are alot of files as each backup message is contained in a file. So I need to have a loop that scans all .REC files and saves the file name in an array. Then run the script to extract the server_name, date and backup_message for each file.