Changing $_GET data on the fly

nanolimit

Hello phpbuilders!
Hoping this is the right place to post :S

I'll type into my search for "little bobby tables" which will send me to mysite.com/site.php?=little bobby tables

Which is fine(ish... I can still get the data)

before the form submits I want to check the value of the form against my sql database and replace what im looking for

i.e.
little bobby tables = index 100
so when the form submits it'll send off:
mysite.com/site.php?=100
instead

Done some googling but cant really find anything, about as much as I could see was I need to use javascript/ some odd ball php to manipulate it though onSubmit but even then im still completely lost

bradgrafelman

Well obvoiusly you have some way of changing "little bobby tables" into id # 100, so why not just include that bit of processing into site.php?

nanolimit

bradgrafelman;10943424 wrote:
Well obvoiusly you have some way of changing "little bobby tables" into id # 100, so why not just include that bit of processing into site.php?

I have. but that wasnt the question.
The question was how do I change the value sent BEFORE it gets to site.php

When I click send I want to it check the value being sent BEFORE it gets to site.php so the url shows as an INT instead of a string

bradgrafelman

nanolimit;10943426 wrote:
I have. but that wasnt the question.

I realize that, but I also realize that the best answer to a question can be another question. Why does it matter whether there's a number or a string in the URL?

nanolimit

bradgrafelman;10943428 wrote:
I realize that, but I also realize that the best answer to a question can be another question. Why does it matter whether there's a number or a string in the URL?

All the data is based on ID numbers and not their corrosponding names, go for general use it would be easier to display int rather then string to people to understand which item their on.

Should I just make a process page first to find the id of the item and forward it into site.php?

bradgrafelman

I still don't see why there's any reason to convert the string to an ID before redirecting, but.. shrug

Using an intermediate processing page would probably be the easiest solution. You could also use AJAX to send the query to a script that returns the id number (or some sort of value to indicate an error, e.g. no record was found). You could then have the Javascript code redirect the user using the ID number.