regeister_globals and MySQL

fmaestas

Hello,
I need to start the process of modifying all my php pages so they work correctly with register_globals = Off.

I've read and read but just don't get where to use $Post, $GET, etc in my pages.

I have a table of contents page that has several links like so:
<a href="supervisors_data.php?recnum=100">Supervisor 100</a>

On my template page I match the recnum with the id:
$result = mysql_query( "SELECT * FROM db_Supervisors WHERE id=$recnum" );

And it should then display based on that match:
printf("%s ", mysql_result($result,id,"supervisor_name"));
printf("%s ", mysql_result($result,id,"supervisor_dept"));
...etc.

Where does the $_POST go... on the first page or both. Been messing with this for about a week and just having no luck. Just need a push in the right direction. Guess I'm just not 'grokking' this whole concept.

Thanks in advance.
Frank M.

DeltaRho2K

I have a table of contents page that has several links like so:
<a href="supervisors_data.php?recnum=100">Supervisor 100</a>

On my template page I match the recnum with the id:
$result = mysql_query( "SELECT * FROM db_Supervisors WHERE id=$recnum" );

And it should then display based on that match:
printf("%s ", mysql_result($result,id,"supervisor_name"));
printf("%s ", mysql_result($result,id,"supervisor_dept"));
...etc.

Where does the $_POST go... on the first page or both. Been messing with this for about a week and just having no luck. Just need a push in the right direction. Guess I'm just not 'grokking' this whole concept.

based on what you have here, you would use $GET and not $POST, because your variable is passed as part of the URL. so in the file supervisors_data.php you would use something like:

$recnum = $_GET['recnum'];
$result = mysql_query( "SELECT * FROM db_Supervisors WHERE id='$recnum'" );

You could also do something like:

// Based on your example, this would produce:
// $recnum = 100
extract($_GET);

$result = mysql_query( "SELECT * FROM db_Supervisors WHERE id='$recnum'" );

If you are submitting a FORM, and using the POST method, then these examples would be applied in the same manner except you would substitue $POST for $GET. The difference is that POST is not passed through the URL, and would not be visible.

There's a bit more to all of this, but this should get you started.