How to check validate function value is true and then insert the values to database

[ghjk]

I'm having php page with validation. This is the code.

<script language="javascript" src="../javascripts/validate.js"></script>
<script type="text/javascript">
    function valForm(){
        if(!valid_required(document.add.FullName.value))
        {
        add.FullName.style.background = 'Yellow';
        alert("First name is required field.")
        return false
        }
    }
</script>
$array = array('FullName'=>'FullName','DoB'=>'date1');
 
       foreach ($array as $key => $val)
    $$key = $_POST[$val];
 
    if(isset($_POST['Submit'])){
 
    $pgsql = "insert into \"xxx\" ( \"Name\" , \"DateofBirth\"  )
VALUES ('$FullName', '$DoB');"; 
 
$result = pg_query($dbconn , $pgsql);
    if (!$result) {
         die("Error in SQL query: " . pg_last_error());
     }
    echo "Data successfully inserted!";
       }
}
<form action="Add.php" method="post" name="add"  onSubmit="return valForm()" >
                  <tr>
                    <td height="24" colspan="3" ><!--DWLayoutEmptyCell-->&nbsp;</td>
                </tr>
                  <tr>
                    <td height="24" >Full Name*</td>
                    <td colspan="2"><input type="text" name="FullName"  size="40"/></td>
                  </tr>
                  <tr>
                    <td>Date of Birth*</td></tr>
<input name="Submit" value="Submit" id="Submit" src="../common/images/Submit.jpg" type="image"  alt="add" height="30"  width="73" onclick="Validator();"/>
 

I want to adda values after validation is completed. In my code when I click submit button it tries to insert values and didnt get any error message. How can I check if function is true then insert value(execute insert query) ?

[dlite922]

what do you mean you want to add values after validation is completed?

You need some PHP MySQL Form tutorials. Get that working, then modify it to suit your needs.



Dan