Hi,
I;ve been working on this website in which each user can store certain information in text files. I decided to store the info in text files coz otherwise I would have to create a new table in a database for each user.
Anyway, my problem is this. I also wanna search through the text file for certain words, which i know how to do, only as there will be lots of users there will be lots and lots of text files, so i'd end up with something like
$search1 = file("../members/member1/info.txt");
$search2 = file("../members/member2/info.txt");
$search3 = file("../members/member3/info.txt");
$search4 = file("../members/member4/info.txt");
$search5 = file("../members/member5/info.txt");
$search6 = file("../members/member6/info.txt");
etc, for each members text file before searching them all, which of course is not acceptable. Would it be more acceptable to create a new table in a database for each users? I'm just worried that if i have lots of users then it will slow down my database and the running of the site. Or can anyone think of a better solution for searching all these text files?
Thanks
Ant