php saves empty record in mysql

fitiux

Hi,

I'm a newbie =)
I have the following problem:

I have a simple html form validated with javascript to avoid empty fields... when form is ok I send an email and then save the info in a mysql table...
well, when I connected to my tables I see many records that are empty. ¿¿??
it's too weird for me, because I'm validating with javascript to avoid this.

someone have any idea???

thank you.

brandonschnell

check your html on the mementery.html file.

<p>First Name: <input type="text" name="first_name">
<br><p>Last Name: <input type="text" name="last_name">
<br>
<p>Email address <input type="text" name="email_address">

1) html can't have php variables

2) you needed to close the input tags

fitiux

Hi Again,

still I have same trouble...
look at this...

you know I have this structure to process form with php4

a file named "form.phtml" with an include("form.inc") sentence.
and when the form is submitted, the "save.php" file records the info in a mysql table.

form.phtml
is a page with colors, gif..and so on

  ....
 <body background="wallpaper.jpg">
   ...
   <?php include("form.inc"); ?>
   ...
</body>

form.inc
only haves the form.

<form name="fm" method="post" action="save.php" onsubmit="return isEmpty()">
<input type="text" name="email" value="">
<input type="text" name="city" value="">
...
...
<input type="submit" name="submit" value="Send">
</form>

the isEmpty() function is javascript code to validate blank fields..

save.php
record info into mysql table
<?
$DB_HOST="myhost";
$DB_USER="myuser";
$DB_PASS="mypass";
$DATABASE="mydb";

$db = mysql_connect ("$DB_HOST", "$DB_USER", "$DB_PASS") or die ("error");
mysql_select_db("$DATABASE",$db);

$sqlquery = "INSERT INTO contact(email,city) VALUES('$email','$city')";
$result = mysql_query ($sqlquery) or die ("error");
$db->close();
?>

the problem is that sometimes a blank record is saved into my mysql table...
and I don't know why.... exists one function isEmpty that validate blank fields...then only when all fields are filled
the form is submitted .... but sometime it happens that a blank row is saved in my table.

do you have any idea??
I have my pages in a server with php4, freeBSD 4.2.

thanks for your patience.. =)
if that reply is not readable..let me send you to your email.. ok?

regards from Chile.

Fitiux.