PHP:Unable to post variables from html form to mysql database

vikram_cvk · 09-29-2004, 02:14 PM

hello experts,

Trying to learn PHP on Fedora core 1 (PHP 4.3,MySQL,HTTPD).Unable to post data from html form to php file(connecting to mysql database and inserting into a table) .
This seemingly simple problem is making me go mad !!! I googled extensively and already tried the following

I enabled " register_globals = On " .... in /etc/php.ini and also took used _$POST syntax.

wot could be the problem .... is it the case that /etc/php.ini file is not being read .... how do i know whether this is the default location for php.ini?
Where can i find the PHPRC environment variable (the variable responsible for the php.ini default location)

Is the problem something else .....?

Plz help me out experts!!!!

Thx Adv

Regards,
Vikram.

Following is the code ...

form.html
---------
<HTML>
<HEAD>
<TITLE> email entry form </TITLE>
</HEAD>
<BODY>

<P>plz fil the form </P>

<FORM METHOD="POST" ACTON="form-handler.php">

NAME: <BR>
<INPUT TYPE=TEXT NAME="givename" SIZE=25> <BR>
AGE: <br>
<INPUT TYPE=TEXT NAME="givenaddress" SIZE=25> <BR>

<INPUT TYPE=SUBMIT>
</FORM>
</BODY>
</HTML>

form-handler.php
-----------------
<HTML>
<HEAD>
<TITLE> EMAIL FORM HANDLER </TITLE>
</HEAD>

<BODY>

<?
mysql_connect("localhost","root") or die("Failure on db connection");

mysql_select_db("mydb");

//$query = " insert into sample(name,address) values(_$POST['givename'],_$POST['givenaddress'])";

$query = " INSERT INTO sample SET
name = '_$POST[givename]',
address = '_$POST[givenaddress]' ";

$result = mysql_query($query) or die("Unable to record your info");
print("result:$result");
print("your info has been recorded");

?>

</body>
</html>

bulliver · 09-29-2004, 03:01 PM

Turn register globals back off. If you have register globals set then you can access your post variables using regular syntax ie: $foo_var but it is not secure or advised. Instead turn register globals off and access your vars thusly: $_POST['foo_var'] as you appear to be doing already.

There are also several typos in your code, I am not sure if that is the code you are running or just typos introduced when posting here but....

try this:

Code:

<?
mysql_connect("localhost","root") or die("Failure on db connection");
 
mysql_select_db("mydb"); 
 
$query = "INSERT INTO sample SET
    $name = $_POST['givename'],
    $address = $_POST['givenaddress']";
 
$result = mysql_query($query) or die("Unable to record your info");
print("result:$result");
print("your info has been recorded");
 
?>

As you can see...there are no quotes around the post variable, otherwise the literal value "$_POST['whatever']" will be used, or perhaps just an error.

I am also unsure of this line:

Code:

print("result:$result");

I don't think that php will interpolate this variable as Perl would. Try this:

Code:

print("result:" . $result);

Good luck.