validating data in php form

Question

0.00/5 (No votes)

See more:

Hi I want to validate fields of a php form by Ajax but I have to get the type of that field by mysql because i store the data in mysql. So I should validate my data with java after I get the type of the field (from mysql) or I can send them to Mysql to be validated by Mysql or I should validate my data with php?
Which one is better, faster, more reliable and more secure?
Thanks to whom helped but actually I want to validate any kind of type even the protoype, I mean maybe in future they change the type of a column I don't want to go through the whole codes including client_side code to change the rule of validation for my field.
I want something more intelligent.
Thanks in advance.

Posted 17-Mar-15 20:25pm

Saeed.A

Updated 18-Mar-15 15:00pm

v3

Add a Solution

Comments

Mohibur Rashid 18-Mar-15 3:09am

java? are you using java on your client site?

Saeed.A 18-Mar-15 21:06pm

I mean javascript.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2015-03-18T05:59:00

As a general rule it is best to validate your data (and do anything else you can) on the client side. This will eliminate possible delays in the server round-trip.

This isn't always possible, such as when the data needs to be validated against that in a database - in which case AJAX is likely a better choice than a <form> as it doesn't scrub the data fields on the client side.

Since it's on the client side, you normally use javaScript for this. Your "submit" button (or whatever you use) should go through the validation function which, if the validation passes, can formName.submit()the data or call AJAX.

Peter Leow · Answer 2 · 2015-03-18T06:52:00

0. You should have known of the database schema, i.e. tables, fields, data types, and their relationships before you start coding.
1. Perform the necessary client-side validation using JavaScript for conditions such as required entry, min length, data type, etc. that will eliminate round trip to server if any of the inputs are found to be invalid. Refer: JavaScript Form Validation[^]
2. Next, do the necessary security related validation on the server-side such as account authentication, cleansing of user inputs, etc. See PHP 5 Form Validation[^]. However, you still have to perform validations on those inputs that passes the client-side validation on the server side as client-side script is clear source and opened to hacking.
3. Finally, on the database part, many measures can be put in place to ensure data integrity, such as primary key, referential integrity, and user-defined rules.
All of them work together to make sure that the application is secure and reliable.

validating data in php form

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0