Data Validation

[sanand158]

I am trying to set up a data validation routine. I have a FORM which consists ten rows, each with two columns called code and description,i.e.

<form>
CODE: <user input> DESC: <auto generated>
CODE: <user input> DESC: <auto generated>
etc, 10 times
</form>

The first column is for the user to enter a code.

I would like to complete the second (description) column by passing the code to mysql, check if it exists and if it does to show the description in the second column.

My problem is that I want to carry out this validation before the user presses the submit button. An Onchange event would probably trigger the validation. Within this Onchange event I would like to get the result of the query and insert the details in the second column, allowing the user to proceed to the next row.

The aim is that everytime a user completes the code column and exits the field, the code is validated and the description inserted.

Any ideas?

Thank you for any help.

[[deleted]]

PHP is server side, so you can't use it without submitting data to the server. And you don't want to use onchange for that, because that is triggered with every keystroke in the field. (typing "1234" will trigger the onchange 4 times)

Simply put, you can only use PHP to verify the data once the user has entered them all and pressed submit.

[Anon]

Use the "onBlur()" or "lostFocus()" to trigger a javascript function which opens a tiny minimized popup window and do your query in this window. In the pop-up, say something like:

window.opener.formname.fieldname.value = '<?php echo $value-from-database; ?>';
window.opener.focus();
window.close();

/ Ronnie