0

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 ?


sql.php

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

form.jsp

<html>
    <head>
     <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;
      }
     }
    </script>
     </head>

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

       </html>

Edited by Narue: Added code tags

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by cereal
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.