What do I tell my host?

rizzo65

I'm in the process of switching hosts (virtual server) and I'm unable to successfully run my current working shoutboard on my new host.

I've tried testing other basic form submittion type scripts where a user types info into a form which is passed on to a php file which then writes to the mysql table and the info is printed back to the users browser.

All these types of scripts fail on my new host. I am able to create the table but cannot write to it through a form submitted by a browser.

The only difference besides the obvious is that my new host runs their mysql server on a separate machine so I have to change localhost to the sql server ip number within the script.

I mailed my host but I don't think they have a clue. What do I tell them to do? Access privileges? They are running php4.2.2/mysql 3.23.39

Thanks,
rizzo65

tekky

in your scripts are you using $GET $POST $SERVER $COOKIE $SESSION $GLOBAL or are you relying on register globals being turned on to just use $varname $etc $etc2 to access those variables?

rizzo65

Hi and thanks for the reply. I think I understand what you're saying but I'm just starting out with scripting.

If I'm relying on register globals being turned on and they're not would this work? Here's an example of a simple script which fails on me and won't write to the database. It simply returns the form without the input values:

<?
$DBhost = "mysql ip here";
$DBuser = "user here";
$DBpass = "password here";
$DBName = "dbname here";
$table = "information";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$sqlquery = "INSERT INTO $table
VALUES('$id','$name','$email','$opinion')";

$results = mysql_query($sqlquery);

mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Name : $name<p>E-Mail : $email<p>Opinion :
$opinion</blockquote></td></tr></table>
</center></BODY></HTML>";
?>

Thanks,
rizzo65

tekky

no it wouldnt....

with reg globals off, you need to use the super globals $POST $GET $SESSION $COOKIE $_GLOBAL etc etc.... to get submitted/stored data from a previous form

ie. in POST... use $POST['varname'] get... use $GET['varname']

same applies to cookies/sessions/globals ohh and $_SERVER exists also...

rizzo65

O.K. Thanks. That explains a lot.

Question. I'm not sure how to change my script to work. How should it look?

Would $_POST be ('$id','$name','$email','$opinion')"; the values input into the form?

Thanks,
rizzo65

LordShryku

Take a look at the manual. Anything coming from a form using method="post", would be $POST[]. If it was method="get", then your vars would be in $GET[].