using filr.php?id=$number

Anon

Hello

i just have a quik qustion i hope someone can answer this because its driving me crazy trying to work it out.

i want to have like a flatfile database (with say 100 lines) and in the database, 'presume' i will be using "|" as the deliminator. (the seperator between the fields. (3 fields in total)

so my database would look like this.

ok, so now i have my text flatfile' db. i want to use a php script to execute certain lines of the db. presume in field2 of every line in teh db is a url (a different url) and i want to execute the url on line6' of the db. so my script would be something like this...

http://mysite.com/url.php?id=6

and after going to that url it would go through the db, and find $linedata[2] of $id=6

so now that you understand what im trying to do, what am i having problems with? well basically i dont have a clue where to start. if someone could give an example of what i would need to put in a php script to do this 'an example' or lead me to a webpage with information that could be useful id be grateful

ryza~

balsdorf

Make sure you do keep your file small, otherwise you will get into performance issues. That said, here is what I would do.

Assume:
$dbFile is the path to the file with the data.
$id is the row you want.

<?php

// read file into an array
$data = file($dbFile);

/
please note that file() creates a 0 based
array so line 1 will be element 0. To get
around this, we subtract 1 from $id
*/
$wantedLine = $id - 1;

// get the desired line
$lineData = $data[$wantedLine];

/
explode line on | so you can access
each column. Please note that explode
creates a 0 based array as well so col1
will be $lineData[0], col2 is $lineData[1]
etc, etc
*/
$lineData = explode("|", $lineData);

Hopefully this well help you. If you are going to do this on multiple pages, I suggest you write a class to handle this for you.
--Bryan

ryza_

woah.
man!

you have solved all my problems.

thanks.

regards
ryza

balsdorf

Glad I could help.

--Bryan