Is there a better way to pass information to another page?

Grant_Cooper

I have this querry I'm passing to another web page. But is there a better way to do this? Is there something in mysql that I can do like a tempory table to do the querry. I don't know what to do.

I'm using a $_REQUEST[page]; to ge the information from one page to load the next.

bardrinks/default.php?page=3600&limit=100&Form_complete=query&sql=SELECT%20DISTINCT%20*%20FROM%20recipe%20WHERE%20((strengthID%20NOT%20LIKE%20'1')%20and%20(glassID%20!=%20'12')%20and%20(difficultyID%20=%20'2'))%20ORDER%20BY%20name

Thanks in advance.

leatherback

Hi,

You could just parse the variables, or you could consider using sessions / coockies? I am not sure about making temp. tables. I believe it is possible, but you need at some point to remove these. I suppose you will need to setup a check for that, most likely to be stored in a session. Which brings you back to using sessions.

TheIceman5

Originally posted by Grant Cooper

bardrinks/default.php?page=3600&limit=100&Form_complete=query&sql=SELECT%20DISTINCT%20*%20FROM%20recipe%20WHERE%20((strengthID%20NOT%20LIKE%20'1')%20and%20(glassID%20!=%20'12')%20and%20(difficultyID%20=%20'2'))%20ORDER%20BY%20name

Thanks in advance.

this will stand out and say "PLEASE EXPLOIT ME" to anyone with even the slightest php knowledge and before you know it your script and database is getting fuked over by someone.

Grant_Cooper

Sessions, I guess this would be the best way. Is this the common way of doing it? I'm using a hpyer link to another page. How am I suppose to use sessions for that?

leatherback

hi,

Depending on the amout of info you try to pass this is or isnot the way to go.

I use passing var's in forms and urls myself, unless it is really critical information..

It is a trick using sessions, so please have a look at the manual, and do a search on this forum. There are a lot of thread about it.

In short: On each page you start a session before 'doing' any other coding, and you register the variables you want to use later on.
Then in the next pages you can call the variables from the session array.