[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2572
  • Last Modified:

Validate textbox value

HI ALL,

I have a textbox nd a submit button on my .aspx page.

Is there a way i can validate if the value entered in the textbox exist in a table?  I would like to do this before the user clicks on the submit button.

Thanks!!
0
joan2006
Asked:
joan2006
1 Solution
 
nathana21Commented:
add some code to your page...with the event onChange on the text box..make the code run a function on the page that:

opens the database
runs the following sql

select * from <Table> where <form field> = <table>.field
if record set is empty..
do something.

close recordset
close db
0
 
rlbalanCommented:
Good fit for an AJAX call.
onChange invoke an AJAX function to return true/ false from your DB. Then alert the user if it fails.
PS : The response will be as fast as your DB query here.. SO it better be a simple lookup in DB
0
 
dakydCommented:
Why not make it a drop down (<select>) instead?  You would populate that drop down with the existing values in your table.  That way, the validation is inherently done for you, since it's now impossible to enter a value that doesn't exist in the db.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
siva_sivaCommented:
I have done this one php you change this in ASP.NET

<?php
      include('connectdb.php');

      // After enter the value in the textbox called through Ajax
      if(isset($_REQUEST['value'])) {
            $value = $_REQUEST['value'];
            if($value != '') {
                  $valuequery  = "SELECT * FROM users where UserName = '$value'";
                  $valueresult = mysql_query($valuequery);
                  $valuerow = mysql_num_rows($valueresult);

                  // display the correct value for the value
                  if($valuerow > 0) {
                        echo "<input type=text name=test value='' onchange='check_database();'>";
                        echo "<br><font color=red><b>Value is in database</b></font>";
                  }
                  else {
                        echo "<input type=text name=test value='$value' onchange='check_database();'>";
                        echo "<br><font color=green><b>Value is not in database</b></font>";
                  }
            }
            exit;
      }
?>
<html>
<title>Validate</title>
<head>
      <!-- Ajax common script it is used in realnigerian copy from that -->
      <script src="scripts/prototype.js" type="text/javascript"></script>
      <script>
            function checkform() {
                  with(document.validateform){
                        if(test.value == '') {
                              alert('Please enter some value');
                              test.focus();
                              return false;
                        }
                  }
                  return false;
            }

            function check_database() {
                  // In which the textbox is display ("id value for the td textbox")
                  var target = 'textvalue';
                  var url = 'validate.php';
                  var params = 'value='+document.validateform.test.value;
                  new Ajax.Updater(target,url,{ parameters:params });
            }
      </script>
</head>
<body>
<form name="validateform" action="validate.php" method="post">
      <table>
            <tr>
                  <td id="textvalue"><input type="text" name="test" value="" onchange="check_database();"></td>
            </tr>
            <tr>
                  <td><input type="button" name="submit" value="Submit" onclick="return checkform();"></td>
            </tr>
      </table>
</form>
</body>
</html>
0
 
joan2006Author Commented:
Thanks guys but i used javascript, onkeypress and attribute.add functionality.  

Thanks again.
0
 
Vee_ModCommented:
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now