form to database

[edlundcl]

hi again, i was trying to figure this out last night but didn't get very far so i'm gonna try again. does any one know of a good online article or tutorial on how to have information from a form submitted to a mysql database?

here's the code i'm trying to use. but when i try to submit the form i get the error : "FORBIDDEN: You don't have permission to access /test/< on this server.

anyone have any idea why?

<?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
?>

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

<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>

[jasonmills58]

well, i'm kinda new, so i'm no expert, but i'm pretty sure these blank spots are where you're user name and password for server access go:

$db = mysql_connect("localhost", "", "");

my access script looks like this:

$user = "cpoint";
$pass = "*****";
$database = "counterpoint";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
	$dberror = "Couldn't connect to MySQL server.";
	return false;
}
if ( ! mysql_select_db( $database, $link ) ) {
	$dberror = mysql_error();
	return false;
}

except I use a real password in the $pass field - just blanked it out for safety here....

[leatherback]

Hi,

Here goes..

JasonMills, is absolutely right about the pass/user.. But since you are working on your local machine (I suppose!?), you may not have set a usernam/password, so that is not giving you the error.

Keep in mind:

• Variables passed by a form are NOT directly available to the script, unless you have register_globals set to "on". Since this feature was set to a defaul "of", starting php 4...?.. you might have that problem (In any case: Assume that is one problem). So you have to get the variables first:

$message = $_POST[message];

Then, you are trying to submitthe form. Since you are working on getting the form working, don't jump to far in one go: replace
<form method="post" action="<?php echo $PHP_SELF?>">
with a real pagename, such as

<form method="post" action="thisscript.php">

(I am assuming that is what is giving you the headache)

This whole section:

while (list($name, $value) = each($HTTP_POST_VARS)){ 
echo "Thank You! Infomation entered.\n"; 

can be replaced with:

if($result)
  {
  echo "Thank You! Infomation entered.<br>";
  }

Think tyhat should help you.

[edlundcl]

thanks for the suggestions. a couple of notes:

register_globals is set to ON in my php.ini. i actually tried changing it to OFF to see if that would make a difference but it didn't so i changed it back..

also i tried putting a reg. page name for :

<form method="post" action="test.php">

and when i hit submit, it actually goes to that page, but nothing is ever added to the database in sql..

ack.

[leatherback]

Hi,

Eventually you will be working ona server which doesnot have the globals switched to on (I know.. It happened to me..) and trus me.. It is no joke have to re-write your code then!
So.. Write as if it was switched of.. It serves you better in the long run.

OK. Enough advice on coding. Let's solve your problem.

Have you made the modifications I suggested? Then, also change:

$result = mysql_query($sql);

into:

$result = mysql_query($sql) or die("An error occured when inserting:" .mysql_error());

Please do this, try to run it, and paste the code you are using.

(PLEASE between [ p h p ]... [ / p h p ] brackets, lose the spaces, and you will get the nicely coloror code)

Also, post the output the page gives you. After that I think we have the answer to your problem.
I am off to the shop right now, but I will have a look in 45 min or so.

J.

[edlundcl]

actually now when i changed that action to a local page i have set up , it's saying : method not allowed : the requested method POST is not allowed for the URL....

it was odd thoguh because the first couple of times i tried it , it went to the page but nothing went to the database....

php drives me crazy.

[edlundcl]

ok i think i've made all the suggested changes. here's my code:

<body>
<?php

if ($submit){
    // process form
    $db = mysql_connect("localhost", "root", "");
    mysql_select_db("test2", $db);
    $sql = "INSERT INTO message (message) values ('$message')";
    $result = mysql_query($sql) or die("An error occured when inserting:" .mysql_error());

if ($result)
{
    echo "Thank You!  Information entered. <br>";
}
else {
?>


<form method="post" action="lastime.php">


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

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

 <?
}//end else


</body>
</html>

and now i'm getting this error message:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, admin@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

---

Apache/1.3.23 Server at localhost Port 80

thanks for your help by the way. so far you've been the most receptive to my probs and i really appreciate it. i'm at my wits end w/ this thing.

[edlundcl]

is this the internal server error that i'm getting?:

[Sat Jan 03 02:39:56 2004] [error] [client 127.0.0.1] Premature end of script headers: c:/apache/php/php.exe
[Sat Jan 03 02:47:26 2004] [error] [client 127.0.0.1] Premature end of script headers: c:/apache/php/php.exe
[Sat Jan 03 02:48:02 2004] [error] [client 127.0.0.1] Premature end of script headers: c:/apache/php/php.exe
[Sat Jan 03 02:52:13 2004] [error] [client 127.0.0.1] Premature end of script headers: c:/apache/php/php.exe

[leatherback]

Hi,

Some typos (Corrected below):
- Missing closing curly bracket for the if submit
- Missing PHP close tag at end of script

But I must say.. I find it a strange error.. But maybe that is the result of non-closing php tags?

<body> 
<?php 

if ($submit){ 
    // process form 
    $db = mysql_connect("localhost", "root", ""); 
    mysql_select_db("test2", $db); 
    $sql = "INSERT INTO message (message) values ('$message')"; 
    $result = mysql_query($sql) or die("An error occured when inserting:" .mysql_error()); 

if ($result) 
{ 
    echo "Thank You!  Information entered. <br>"; 
} 
}
    else { 
    ?> 


<form method="post" action="lastime.php"> 


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

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

 <? 
}//end else 
?>

</body> 
</html> 

[edlundcl]

ok yeah i changed those 2 little typos but i am still getting the same error.

/me throws hands in air..
i give up.

thanks for you your help though, i greatly apprciate it. I'm glad it's a funky problem and not something simple, cause i'm starting to feel like i'm too stupid to learn this stuff.

[leatherback]

Hi,

Try tossing thie error mentioned, and perhaps the thread, to the installing board.. I have the feeling it me be the result of php compiler problems / server settings, but I have no clue of those.. I got mine running, made a backup of a clean install, and hope I never have to change it! ;-)

Some of the guys there spot quitcks like this and solve them like it is nothing.

Sorry ;-(

J.

[edlundcl]

thanks for the suggestion, i'll try that.