form help

BobW123

I am trying to validate a form when it is submitted.

The user is entering a membership number on a form then a query is being run to see if the member number exists in a mysql database can someone please help me out with an example of a description of this this is can be achieved

Thanks everyone

WindomEarle

function check_number ($num)
{
mysql_connect($variables);
mysql_select_db($variable); //connecting to mySQL

$check = mysql_query("SELECT * FROM $table WHERE user_number = '$num'") or die(mysql_error());
$result = mysql_num_rows($check); 

if ($result == 0) return FALSE; else return TRUE;
}


if (!check_number($number)) echo "This user number doesnt exist";
else echo "OK";

🙂

laserlight

On those lines, you would probably connect to your database outside the function.

with a little more explanation,

<?php
function check_number($num) {
	//validate $num
	if (is_numeric($num)) {
		//tablename is the name of the members table
		//member_id is the name of the field containing unique member numbers
		$query = mysql_query("SELECT * FROM tablename WHERE member_id='$num'");
		//check that there is a match
		if (mysql_num_rows($query) == 1) {
			return true;
		}
		else {
			return false;
		}
	}
	else {
		return false;
	}
}
?>

BobW123

where should i call the function? would it be in the button tags, and in the onClick? because the onSubmit never seems to do anything

laserlight

Well, this isnt JS, so what you would do is call the function on the page the form is directed to.