sendoh07 Posted September 3, 2006 Share Posted September 3, 2006 Hi all. If I have to read from a text file, and do a query to display all usernames. How can I do it from reading a text file? Please note that as much as I would to use MySQL, I am not allowed to. For example, the text file "test.txt" contains the following:[code]M0001:jlee:James:Lee:23:Lakers Avenue 111/03 Country:123-345678M0002:tbogard:Terry:Bogard:23:Lakers Avenue 211/03 Country:124-333678etc.....[/code]The format is memberID:username:first name:last name:age:address:phoneIn normal mysql queries you would just have to do something like "SELECT username FROM Users" to display all the usernames. However, now that I am using just a text file, how can I do searching, insertion and deletion?Currently, I can only think of tokenizing those data and storing them into an array or linked-list. However, this approach is not that efficient.Can anyone point me in a right direction please? Thanks! Quote Link to comment Share on other sites More sharing options...
zq29 Posted September 4, 2006 Share Posted September 4, 2006 I would have thought you'd have to dump it all into an array and sort through it.[code]<?php//Display usernames$content = file("test.txt");foreach($content as $line) { $fields = explode(":",$line); echo $fields[1]."<br/>";}?>[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.