help: php breaks on upgrade (?)

[cgmoller]

Hi,
I am building a new server and migrating scripts from an existing server. The details are:

Old server
Redhat 7.3
PHP 4.1.2-7.3.6
PostgreSQL 7.2.3
Apache 1.3.27

New Server
Redhat 9.0
PHP 4.2.2-17.2
PostgreSQL 7.3.2
Apache 2.0.40

Both are standard rpm installs from redhat cds.

I have migrated the databases to the new box and I sftp'd the php scripts to the new box.

Everything works except the scripts as they are written. It seems I can not pass variables into the query. For example:

This works:
$query = "select * from hardware_profile order by hostname asc";

This does not:
$query = "select * from hardware_profile order by $sortkey asc";

Has there been a change in php that I am missing? Any help would be appreciated.

After some more experimentation - it appears that the variables are not being passed from the "selections" page which is in html format. Possibly this is an Apache issue.

[Pig]

do you have register globals turned on? Try something like this:

if( isset($field_name) ) { echo("registered globals is on"); }
if( isset($_POST['field_name']) ) { echo("If all you see is this line, this registered globals is off."); }

[cgmoller]

I tried your suggestion and found register_globals to be off.
I also found the security issues associated with enabling them so I solved the problem like this:

$node = $_REQUEST['node'];

Everything now works.

Thanks for your help.

Cameron

[Pig]

I agree. I definitely recommend having it off. I was just checking because that what the symptoms sounded like.