We help IT Professionals succeed at work.
Get Started

how do I compare (validate) a form field text in php to a data type varchar filed in a mysql database?

ackrts
ackrts asked
on
475 Views
Last Modified: 2012-05-06
I have a simple form that users must "digitally sign" before continuing.  In my mysql database, they have a first name (fname) and a last name (lname) field.  

The form collects their ip address and the current time stamp.  It then asks them to "sign" by entering their first and last name.  Upon submit, I want the form to validate what the user entered for first and last name against their account in the database.  It must match exactly with fname and lname.  If it does not, the form should error.

Thanks in advance for any help!
Comment
Watch Question
Top Expert 2008
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE