Hi , I have problem with form , when I use javascript

[nia_st210]

Hello everyone ,

 

I have form and I am using action create2.php and everything is working when I want to send to my database information through the form ..

This are codes :

 

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

<p>email</p>
<input type="text" name="inputPayer_email" value="" />
<br/>
<p>Name</p>
<input type="text" name="inputFirst_name" value="" />
<br/>
<p>Last name</p>
<input type="text" name="inputLast_name" value="" />
<br/>
<p>Address 1</p>
<input type="text" name="inputAddress_street" value="" />
<br/>
<p>Address 2</p>
<input type="text" name="inputAddress_city"  value="" />
<br/>
<p>State</p>
<input type="text" name="inputAddress_state"  value="" />
<br/>
<p>Mobile number</p>
<input type="text" name="inputcmd" value="">
<br/>
<input type="submit" name="submit" value="submit" />

</form>

 

and create2.php code is

 

<?php  

$db_host = "mysqlxxx.host.com"; 
// Place the username for the MySQL database here 
$db_username = "nia";  
// Place the password for the MySQL database here 
$db_pass = "pass";  
// Place the name for the MySQL database here 
$db_name = "db"; 

// Run the actual connection here  
mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
mysql_select_db("$db_name") or die ("no database");              
?>

<?php  

$Payer_email = $_POST['inputPayer_email'];
$First_name = $_POST['inputFirst_name'];
$Last_name = $_POST['inputLast_name'];
$Address_street = $_POST['inputAddress_street'];
$Address_city = $_POST['inputAddress_city'];
$Address_state = $_POST['inputAddress_state'];
$cmd = $_POST['inputcmd'];

   
mysql_query("INSERT INTO `transactions` (

`payer_email` ,
`first_name` ,
`last_name` ,
`address_street` ,
`address_city` ,
`address_state` ,
`cmd` ,

)

VALUES  (NULL , '$Payer_email', '$First_name', '$Last_name', '$Address_street',
'$Address_city', '$Address_state', '$cmd')") or die(mysql_error());

//!!!!!!!!!!!!!!!!!!!!!!!!!    Email User the activation link    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$to = "$Payer_email";

    $from = "[email protected]";
    $subject = "Your order ..";
    //Begin HTML Email Message
    $message = "Hi $First_name,

   Thank you , bla bla .. 
   ";
   //end of message
$headers  = "From: $from\r\n";
    $headers .= "Content-type: text\r\n";

    mail($to, $subject, $message, $headers);

   $msgToUser = "Thank you .. 
   ";


   include_once 'hvala.php'; 

   exit();

    // Close else after duplication checks


header('Location: hvala.php'); 
?>

 

And this is redirecting me to hvala.php and sending e-mail for those who ordered something ..

 

But when I want to add javascript so I can validate my web form , sending information in database is not working . I named form with "m" and action is create2.php , javascript works but

my order form is not sending to my database anything .. Only blank fields in database .. I will give code with javascript , so if anyone see where is mistake , please write on thread .. Thank you in advance

 

<script type="text/javascript" language="javascript"> 
<!--
function validateMyForm ( ) { 
    var isValid = true;
    if ( document.m.inputPayer_email.value == "" ) { 
    alert ( "Insert email" ); 
    isValid = false;
    } else if ( document.m.inputPayer_email.value.length < 1 ) { 
            alert ( "Insert email" ); 
            isValid = false;
    } else if ( document.m.inputFirst_name.value == "" ) { 
            alert ( "First name" ); 
            isValid = false;
    } else if ( document.m.inputLast_name.value == "" ) { 
            alert ( "Last name" ); 
            isValid = false;
    } else if ( document.m.inputAddress_street.value == "" ) { 
            alert ( "Address" ); 
            isValid = false;
    } else if ( document.m.inputAddress_city.value == "" ) { 
            alert ( "Address" ); 
            isValid = false;
    } else if ( document.m.inputAddress_state.value == "" ) { 
            alert ( "State" ); 
            isValid = false;
    } else if ( document.m.inputcmd.value == "" ) { 
            alert ( "Mobile number" ); 
            isValid = false;
    } 
    return isValid;
}
//-->
</script>



<form name="m" action="create2.php"">

<p>email</p>
<input type="text" name="inputPayer_email" value="" />
<br/>
<p>Name</p>
<input type="text" name="inputFirst_name" value="" />
<br/>
<p>Last name</p>
<input type="text" name="inputLast_name" value="" />
<br/>
<p>Address 1</p>
<input type="text" name="inputAddress_street" value="" />
<br/>
<p>Address 2</p>
<input type="text" name="inputAddress_city"  value="" />
<br/>
<p>State</p>
<input type="text" name="inputAddress_state"  value="" />
<br/>
<p>Mobile number</p>
<input type="text" name="inputcmd" value="">
<br/>
<input name="button" type="submit" value="Submit Information" onclick="javascript:return validateMyForm();"/>

</form>

[xyph]

You want javascript to submit your form if all the checks are okay.

[nia_st210]

You want javascript to submit your form if all the checks are okay.

 

Yes .. If anyone can see where is my problem , please tell me .

Javascript is working and alerting when i don't write something in field ,

but form is not sending anything in my database except blank database field ..

 

Before when I am not using javascript to validate my form , it is sending information to database great , it works , but it

is not checked if fields are complete ..

[nia_st210]

I noticed now that I have "create.php"" mistake .

Thank you for trying to help.

I was tired .. Havent noticed mistake .

 

  Problem solved ))