Jump to content


Photo

validate input from form???


  • Please log in to reply
2 replies to this topic

#1 gk20

gk20
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 07 March 2006 - 11:29 AM

I have a form where I accept an email from the user. I enter their username and email into a table called validate, and then validate the email to see whether it ends in a certain domain. If it does then I submit all the user details into the user table. If not, then $problem=true; etc...
Whether or not the email validation evaluates to true, I delete the entry i just added to the validate table
Heres my code:

$username = $_POST['username'];
$Email = $_POST['Email'];
......
$validatename = $_POST['username'];
$validateemail = $_POST['Email'];
.....

$insertval = "INSERT INTO validate SET
validatename = '$username',
validateemail = '$Email' ";


$emailval = @mysql_query("select validateemail from validate
where validateemail like '%student.example.com'
OR validateemail like '%EXAMPLE.IE'
OR validateemail like '%STAFF.EXAMPLE.COM'");

if (mysql_num_rows($emailval) == 1)
{
$sql = "INSERT INTO user SET
fullname='$fullname',
username='$username',
password='$password',
Email='$Email',
DOB='$DOB',
phonenum='$phonenum' ";

// delete from validate table here and also if $problem = true;

}
else {
echo '<b>Invalid Email</b>';
$problem = true;
}

I also check whether or not the info was inserted into user table corectly etc...
but I get an error saying incorect argument passed to mysql_num_rows ?????? something like that??

Can anyone help?Its wrecking my head?

#2 zawadi

zawadi
  • Members
  • PipPip
  • Member
  • 25 posts
  • LocationChippenham UK

Posted 07 March 2006 - 12:43 PM

you cant use set in an insert statment, you need to write like this:

INSERT INTO user (
fullname,
username,
password,
Email,
DOB,
phonenum)
values(
'$fullname',
'$username',
'$password',
'$Email',
'$DOB',
'$phonenum')

That's the beauty of asymmetric warfare. You don't need a lot of money, or an army of people. You can do it from the comfort of your living room, with a beer in your hand.

#3 gk20

gk20
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 07 March 2006 - 01:29 PM

ya it was adding it to tables alright, but just not validating the email entered by the user. I wanted restricted access to certian domains. Anyway got it going in the meantime, thanks all the same




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users