hello all, after tried so much now posting here. i have two programs sql.php and form.jsp. i want to do insert values into mssql database from user input form. sql.php is able to insert the values into database. i have connected database using ODBC.form.jsp is able to give user input form where user can enter name.

when i submit the name it will successfully stored into the database. but if i submit the same name also it will get stored. i don't want store same name twice in the database.and it should notify the user that name already exist in the database. i can't change my database schema to unique constraint.
i need to accomplish throgh program. how to give this validation ?


$connect = odbc_connect('SerDB','sa', 'pwd');
      echo "server connected";
     $query=("INSERT INTO namemb(name) VALUES ('$_POST[name]')");
      $result = odbc_exec($connect, $query);


     <script type="text/javascript">
      function validateForm()

        var y=document.forms["myForm"]["name"].value;
      if (y==null || y=="")
    alert("Name must be filled out");
    return false;

     <form name="myForm" action="sql.php" onsubmit="return validateForm()"   
       Name:<input type="text" name="name">
         <input type="submit" value="Submit">
      <input type="button" onclick="window.close()" value="Cancel">


Have you solved? You need to build a callback script, where you check if the value is already stored or not. In order to speed up you can build an index related to that column. Bye.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.