Querying text database

NYSiRacer

How do I query a text file and return the whole row when a matching record is found?
This is what I have in the text file:

aaa|bbb|ccc
ddd|eee|fff
ggg|hhh|iii

If I search for ddd, I want it to return everything that's in that row, which are ddd, eee, fff (| is used to split the data that's in the row using preg_split())

Thank you.

intenz

Let's say you have this in foo.txt

aaa|bbb|ccc 
ddd|eee|fff 
ggg|hhh|iii

Then this is a function I made for you

function SearchInFile($strNeedle,$strFile)
{
	$file = file($strFile);
	for($i = 0; $i < count($file); $i++)
	{
		$parts = explode('|',$file[$i]);
		if(in_array($strNeedle,$parts))
		{
			return $parts[0] . ', ' . $parts[1] . ' and ' . $parts[2];
		}
	}
}

How you use this function:

echo SearchInFile('ggg','foo.txt');

Output should be:

ggg, hhh and iii

NYSiRacer

Great code, thank you very much, but I don't understand it though... I'd rather learn how to do it than just copy & paste... Would you care to explain the codes? Thanks.

intenz

Put this in foo.txt

aaa|bbb|ccc 
ddd|eee|fff 
ggg|hhh|iii

Put this in function.php

<?
function SearchInFile($strNeedle,$strFile)
{
    $file = file($strFile); # Put all lines in file into an array
    for($i = 0; $i < count($file); $i++) # Loop through all lines
    {
        $parts = explode('|',$file[$i]); # Split lines by |
        if(in_array($strNeedle,$parts)) # If the "needle" is in the file then...
        {
            return $parts[0] . ', ' . $parts[1] . ' and ' . $parts[2]; # Return the 3 items in the array
        }
    }
}
?>

Put this in output.php

<?
include('function.php'); # Include the file with the function (function.php)
echo SearchInFile('ggg','foo.txt'); # Try the function we made earlier
?>

Output should be

ggg, hhh and iii

When you've done all of this you run output.php through your webserver, e.g. http://localhost/output.php

michael

strstr or stristr would be faster.

NYSiRacer

I'm sorry Michael, but strstr won't do because if I were to search something that's in the middle of a row, it won't return the whole row...

The function SearchInFile only returns the first match that it finds, is there a way to make it return multiple rows like the mysql command: select * from $table where data = bbb which returns all rows that has bbb in the data field?

For example:
aaa|bbb|ccc|row0
ddd|bbb|eee|row1
Returns row 0 & 1

Thank you

michael

$parts = explode('|',$file[$i]); # Split lines by |
if(in_array($strNeedle,$parts)) # If the "needle" is in the file then...
{

Do stristr before you explode. It'll work.