How to 'index.php?=test' ??

jangoux

Hi,

I am writing a news site using PHP and MySQL. I am having no problems writing the queries for the news, but there's one thing that i have no clue how to do.

On the frontpage, there'll be the headlines and when you click on it, it would send you to another page, with further information regarding the news. On this frontpage, i do all the Db connecting, querying, etc. But what should i do keep everything i queried, so i can get the news related to the link i clicked ? I mean...I read somewhere that i could do what i want using sort of a 'index.php=?1048' where 1048 is the cod of the new. But i don't have a clue how such a thing works or how to write that. Can anyone help me ?

btw, i think i can do that with sessions, using an array, but wouldnt it be much more trouble ?

Thanks,
Ivan Jangoux

LordShryku

Passing it through the URL is your best bet here. You'll just be using the GET superglobal. So you setup your links like page.php?newsid=1048. They click it, and on news.php, you can reference that variable as $_GET['newsid'].

http://www.php.net/manual/en/reserved.variables.php#reserved.variables.get

jangoux

But how will it pass out all the variables that i need ( the ones that result from the mysql_fetch_array thinggie) ? Should i use as 'newsid' the variable that i used for the mysql fetch array, so it will pass all the info inside the array ?

yelvington

No.

If you want to preserve large quantities of data across multiple pages, DO NOT send it back and forth between server and client.

Use sessions. That's what they're for.

http://us2.php.net/session

jangoux

The problem with using sessions is that on the template page, i would have to use fixed variables to load whatever i needed. Up to that, it would work wonderfully with sessions. But the problem is that i would need to assign each array found using the mysqlfetch thinggie to a different variable, using a loop....Let me exemplify : i would use a loop to write 'n' news from the database, and each new would have an array assigned to a $variable...each loop would append a number to the variable, like $variable0, $variable1, etc.

For this reason alone, sessions wouldnt work...at least inside my head.

So i need to understand how that parsing thing works exactly, 'cus i didn't really understood from what i've read on the php documentation.

This is what i understood :

page.php?newsid=1048

That will assign the value '1048' to a $_GET[newsid] variable ? Is it that ?

Thanks,
Ivan

dalecosp

Originally posted by jangoux
This is what i understood :
page.php?newsid=1048
That will assign the value '1048' to a $_GET[newsid] variable ? Is it that ?

Thanks,
Ivan [/B]

That is correct. More properly, array indices should be single quoted: i.e. $_GET['newsid'] ...

I think you should reconsider your design, though. Wouldn't it work best to have page.php do its own DB work for each individual story? "Headlines.php" could grab headlines for each of several stories; "page.php" should grab all the data for the story ID that is passed to it and display it to the browser....

jangoux

But that's exactly what i have in mind. The index will pick the headlines and the Id from the Database, and then page.php will pick the right data using the id given by the index page (included on the link to page.php). I think i made it look a little more confusion than it really is, with all my explaining about why it would be troublesome to use sessions.