writing to database

edlundcl

ok i'm just trying to learn how to have the info submitted from a form written to an mySQL databse. i don't to make the user have to log on or anything in order to submit something to the form. i've pasted the code i'm using below. my problem is when i test it, i get the message: FORBIDEN: you don't have permission to access /> on this server. what am i missing?

<?php

if ($submit){
// process form
$db = mysql_connect("localhost", "", "");
mysql_select_db("test2", $db);
$sql = "INSERT INTO message (message) values ('$message')";
$result = mysql_query($sql);
while (list($name, $value) = each($HTTP_POST_VARS)){
echo "Thank You! Infomation entered.\n";
}
}else{
//display form
?>

 <textarea rows=10 cols=30 name="message">
 Please write your message here
 </textarea>          <br>

 <input type="submit" name="submit" value="submit">
 </form>

 <?php
 }//end if

</body>
</html>

TTT

i think proplem is with PHP_SELF. Try to set action as action="yourpage.php"

also you there is ";" missing after php_self.

why do you do like this
while (list($name, $value) = each($HTTP_POST_VARS)){
echo "Thank You! Infomation entered.\n";
} ??

it will print as many times "thank you..." as you have post_vars.

edlundcl

why do you do like this
while (list($name, $value) = each($HTTP_POST_VARS)){
echo "Thank You! Infomation entered.\n";
} ??

well mostly becuase i don't know what i'm doing. i'm trying to follow a tutorial. i'm less concerned about how many times it says thank you and more determined to get this form info written to a database.

I still don't have an answer the problem of why i'm getting the forbidden message. what causes that error message?

TTT

did you change that action ???

while prints all varible names and values from HTTP_POST_VARS array, but in this point you don't need that
while (list($name, $value) = each($HTTP_POST_VARS)){
print "the name of variable is: $name AND value is $value";

}

edlundcl

oh yeah i changed the action but that didn't help. no matter where i direct the action it gives me the same error.

TTT

k.... in php.ini, have you changed register_globals=on??

it doesn't work even if you rem action after submit??:

if ($submit){
// process form
/
$db = mysql_connect("localhost", "", "");
mysql_select_db("test2", $db);
$sql = "INSERT INTO message (message) values ('$message')";
$result = mysql_query($sql);
while (list($name, $value) = each($HTTP_POST_VARS)){
echo "Thank You! Infomation entered.\n";
/
echo "FORM HAS BEEN SUBMITED";

}

edlundcl

register_globals=on in my php.ini file.

"it doesn't work even if you rem action after submit??: "

i'm not quite sure what you mean by this. i chagned the

<form method="post" action="<?php echo $PHP_SELF?>">
to

but whichever place i have the action =, i get the same error message...

php is so stinkin hard.

TTT

i think that's not php problem, or maybe you don't have enoung right to submit.. 😕

what OS do you have?

edlundcl

i'm just on my laptop os win98. I'm just trying to learn Php on it. I'm not actually using it for anything online.

edlundcl

yeah i dont' really know what's going on. I didn't change anything, just kept trying and then started getting internal server errors. rebooted the pc. and now when i try to submit the form i get:
"Method Not Allowed. The request method POST is not allowed for the URL /test/testing.html

dangit. is that the same thing as being forbidden?

edlundcl

i gotta get outta here, i'll have to figure this out tomorrow. it seems like it should be a lot easier to figure out how to submit info from a form into a MySql database.

do you know of any good articles/ tutorials over this issue? i'm pullin my hair out over here and a large part of the problem is i can't seem to find much documentation on how to do this. thanks for your help

planetsim

register_globals = on is a big no no.

It is the most insecure part of PHP and should automatically be turned off without needing to be in the php.ini