Another option wuld be to couple the text file with ODBC, and
then the text file can be treated as a relational database table,
e.g. a SELECT [...] would work fine on the text file.
-----Original Message-----
From: Neil Smith
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 9-8-03 11:55
Subject: [PHP-WIN] Subject: selecting data from file with php
I would do something like this, your mileage may vary. Lines starting
with
// are comments.
$addresscities=array();
// Make an empty array
$resultrows=file("address.txt");
// This creates an array of lines of the file, one element per line
foreach ($resultrows as $line) {
$row=explode("\t",$line);
// Chop up the row into 3 fields separated by the tab (\t) character
// You must use double quotes for PHP to read \t as a tab character
$addresscities[$row[2]]= $addresscities[$row[2]]+1;
// Add a count of one to the value in $addresscities[`cityname`]
// If an array element like that does not exist it will be created
// and one added to its initial value (effctoiely, zero), making a count
of 1.
}
// End looping though the result rows
ksort($addresscities);
// Sort the array keys (city names) alphabetically
You now have an array containing entries like :
$addresscities["dallas"] ........ 15
$addresscities["mexico"] ........ 1
or whatever. You can do pretty much what you want with that data.
In SQL you would import the file once as a CSV or similar format, then
do :
SELECT city, COUNT(city) AS address
GROUP BY city
ORDER BY city
to get a summary of people in each city. Much simpler, isn't it ? ;-)
I would definitely go with SQL for address data, you can get complex
breakdowns of data with almost no re-programming, and this sort of data
is
made for a database !
Cheers - Neil.
I do not accept mail from hotmail yahoo or other free accounts. Please
reply only on list.
All mail from these accounts *will* be bounced and the account
blacklisted.
Thankyou.
At 19:00 08/08/2003 +0000, you wrote:
>Message-ID: <[EMAIL PROTECTED]>
>Date: Fri, 8 Aug 2003 12:00:12 -0700 (PDT)
>From: Idur <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>MIME-Version: 1.0
>Content-Type: multipart/alternative;
boundary="0-779152822-1060369212=:59102"
>Subject: selecting data from file with php
>
>hi there,....
>
>i have file address.txt, it's content of address of customer, like this
;
>
>name age city
>jony 27 new york
>george 25 dallas
>mony 23 mexico
>edward 30 new york
>budy 22 dallas
>dennise 21 new york
>
>hox to count the field of city, so the result is, like this
>
>city count
>dallas 2
>new york 3
>mexico 1
>
>so i know how many user from a specific city, for the information i am
not
>using mysql. Is that to difficult to do it with out mysql...??
>Did php have the function to do selecting data like mysql....???
>
>thanx
========================================================
CaptionKit http://www.captionkit.com : Production tools
for accessible subtitled internet media, transcripts
and searchable video. Supports Real Player, Quicktime
and Windows Media Player.
VideoChat with friends online, get Freshly Toasted every
day at http://www.fresh-toast.net : NetMeeting solutions
for a connected world.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
