Switched Servers

raouleduke

I recently switched servers now it seems taht whenever I do this.

if($type == 'text'){
		   if($submit){ 
			$sql="UPDATE Thermo_King_temp SET $change='$test' WHERE id='$id'"; 
			$result=mysql_query($sql); 
			echo "Thank you information updated!";
			echo "<BODY onload='closeMe();'>";
			}else{
			$sql="SELECT $change as num FROM Thermo_King_temp WHERE id='$id'"; 
			$result=mysql_query($sql); 
			$myrow=mysql_fetch_array($result); 
			$value = $myrow['num']; 
			print "
			<form method='post' action=' $PHP_SELF?page=$page&id=$id&change=$change&type=text'>
			<input type=hidden name='temp_id' value='$id'>
      		<table align='left'>
                 <tr> 
                  <td width='300' height='25' class='smalltext'><font color='#000000' size='2' face='Verdana, Arial, Helvetica, sans-serif'>Insert your Temporary Comments</font></td>
                 </tr>
				 <tr>
				 <td width='300' height='25'><textarea name='test' cols='30' rows='5'>$value</textarea></td>
				 </tr>
				 <tr>
				 <td width='300' height='25'><input type='Submit' name='submit' value='Submit'></td>
                </tr>
              </table> 
             </form>";
			}
			}

Anyone got any ideas? I worked on my last server

etully

You don't say how it's behaving differently. I assume that it's not updating?

Are there any error messages?

The most common problem that people run into when they switch servers is that register_globals are turned off. Of course, it could be that the database doesn't exist, has a different name, or isn't yet configured to allow access from your script.

Have you done any troubleshooting? Does the script actually get the data posted? Do you actually get connected to the database?

devinemke

if you have not already you should turn on full [man]error_reporting[/man] and use [man]mysql_error[/man] to see what errors mySQL is spitting back.

raouleduke

the Globals are off, how do I turn them on.

etully

Before you turn them on, you should probably consider whether you really need them on. They are turned off by default to prevent potential security risks introduced by bad PHP programming.

You'd probably be better off just adding these lines to the top of the script:

$page = $REQUEST['page'];
$id = $REQUEST['id'];
$change = $REQUEST['change'];
$type = $REQUEST['type'];

That's the best way - the right way - to write your PHP scripts.

Or, you can defeat the whole point of turning Globals off by adding this to the top of your script:

foreach ($_REQUEST as $k=>$v) { $$k = $v; }

But, again, that defeats the whole point of turning Globals off as a security precaution.

Or, if you really really want Globals turned on, you can make the change in your php.ini file if you have access to it.

raouleduke

Yeh, I know about the bad programming, but I have alot of stuff in there that was written by another programmer. I am in the process of fixing it, but need to turn it on for now.

raouleduke

I am also having a problem with apostrophy's and quotes. I didn't have this problem before, is there something in the php.ini file that controls this.

etully

I'm not sure. Check magic quotes?

raouleduke

So should all of these be on then.

magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off

etully

I don't know. This is a question for the Install forum... I don't know much about installing or configuring PHP.

Weedpacket

One way to see what has changed in the configuration when moving from the old server to the new server is to look at the configuration settings on the old server and compare them to the configuration settings on the new server.