newbie:form problem
| From: | Sudheer Palaparambil | Date: | Tue, 07 Oct 2003 12:02:37 +0000 |
| Subject: | newbie:form problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-165289@lists.php.net to get a copy of this message | ||
Hi,
Is this is the way to write a form which insert data into a mysql DB ?
Please note where I am keeping the mysql code.
The problem with this code is that whenever I am issues a refresh,
a row is inserted into the DB with previous field values! Even when
the form field is empty.
Pls help.
<html>
<SCRIPT LANGUAGE="JavaScript1.2">
function verifyIt(form)
{
var sName = form.first_name.value, sEMID = form.e_mail.value;
if ( sName == "" )
{
......
return false;
}
<?
$sFName = $_POST['first_name'];
$sLName = $_POST['last_name'];
$sEMail = $_POST['e_mail'];
$sComments = $_POST['comments'];
mysql_connect( "localhost", "usr", "pwd" ) or die( "Failure" );
mysql_select_db( "sessions" );
$query = "INSERT INTO users( fname, lname, email, comments )
VALUES ( '$sFName', '$sLName', '$sEMail', '$sComments' )";$result = mysql_query( $query ) or die ( "Unable to insert user.." ); mysql_close( "sessions" ); ?> return true; } </SCRIPT> <form method="post" name="form" action="<? echo $editFormAction; ?>" onsubmit="return verifyIt(this);"> <table width="80%" border="0" cellspacing="1" cellpadding="0"> ..... ..... </table> </form> </body> </html> Thank you Sudheer _________________________________________________________________ The heat is on! Catch the latest action. http://server1.msn.co.in/sp03/formula2003/ Speed along with F1!