« Create and extract tarballs in Windows | Home | How to use dd to copy, move and erase disks »
Parsing text files in PHP with FlatfileTools
By admin | August 13, 2008
Compdigitec FlatfileTools is a API written in PHP to manipulate, read and modify plain text databases. It can also manipulate existing databases, such as CSV files. It is released under the GNU General Public License and therefore is free software.
To use it, download Compdigitec FlatfileTools. Then include_once it like this:
<?php
include_once(‘flatfiletools.lib.php’);
// The rest of your code goes here…
?>
For example, to parse the following CSV file – name it testdb.csv. Make sure there is no extra newline at the bottom. (UNIX line endings. To parse Windows/DOS line endings, change line in config.ini to “\r\n”). Do not forget to change config.ini’s div setting to “,”:
- From div = “|”
- To div = “,”
Software,License
Linux,GPL
Mozilla Firefox,GPL+LGPL+MPL
Compdigitec FlatfileTools,GPL
Use the following code:
<?php
// Include flatfiletools
include_once('flatfiletools.lib.php');
// Create new db and set file
$f = new FlatfileTools();
$f->set_datafile('testdb.csv');
// Populate - WARNING: Due to a bug in FlatfileTools v1.0, true means failure and false means success in this function.
if($f->populate()) {
echo "An error happened on line 8 during a call to populate().\n";
};
// Get number of lines
$lines = $f->get_number_of_lines();
// Output table header
echo "<table border=\"1\">";
// Until the last line get line
for($i = 0; $i <= $lines; $i++) {
$var = $f->get_line($i);
if($var === false) {
echo "An error happened on line 16 during a call to get_line() - Current Row Number is $i. \n";
} else {
echo "<tr>";
if($i == 0) {
foreach($var as $val) {
echo "<th>$val</th>";
}
} else {
foreach($var as $val) {
echo "<td>$val</td>";
}
};
echo "</tr>";
};
}
// Output footer
echo "</table>";
?>
If you run this code and receive the error “An error happened on line 16 during a call to get_line() – Current Row Number is 5. ” , it’s because your CSV file has an extra newline at the bottom of it. You can supress this error by commenting out the error on line 18.
So as you can see, Compdigitec FlatfileTools is an powerful API to manipulate, parse and read flat text files in PHP. The example above could have easily been customized to manipulate tab delimited text files by changing config.ini’s div to “\t” instead. You can also write to text files with this API – read the full documentation for more details.
If you found this article interesting, please help us spread the word or please leave a comment. You can also subscribe to Compdigitec Labs via RSS.
If you found this article helpful or interesting, please help Compdigitec spread the word. Don’t forget to subscribe to Compdigitec Labs for more useful and interesting articles!
Topics: Internet, Linux, PHP, Windows | 7 Comments »
August 24th, 2008 at 20:08
[…] one word for each typo) and parse it with Compdigitec FlatfileTools. If you don’t know how, read the article on it. Note: both the alias list and the CSV version use UNIX/Linux encoding […]
March 24th, 2025 at 20:21
… [Trackback]
[…] Information on that Topic: compdigitec.com/labs/2008/08/13/parsing-text-files-in-php-with-flatfiletools/ […]
March 26th, 2025 at 06:22
… [Trackback]
[…] Find More on on that Topic: compdigitec.com/labs/2008/08/13/parsing-text-files-in-php-with-flatfiletools/ […]
March 27th, 2025 at 21:57
… [Trackback]
[…] Read More on on that Topic: compdigitec.com/labs/2008/08/13/parsing-text-files-in-php-with-flatfiletools/ […]
March 31st, 2025 at 05:27
… [Trackback]
[…] Find More here on that Topic: compdigitec.com/labs/2008/08/13/parsing-text-files-in-php-with-flatfiletools/ […]
April 10th, 2025 at 13:31
… [Trackback]
[…] Find More to that Topic: compdigitec.com/labs/2008/08/13/parsing-text-files-in-php-with-flatfiletools/ […]
April 13th, 2025 at 18:16
… [Trackback]
[…] Information to that Topic: compdigitec.com/labs/2008/08/13/parsing-text-files-in-php-with-flatfiletools/ […]