Form Validation

[mark_c]

Hi All,

 

Is there any way to validate a text field in php to allow only values already in the Mysql table. If the user add new thing error message has to come up. 

 

I know drop down is the best. But I like to use text field.

[Sergey Popov]

Assuming your text field named my_form_field, you can validate like this:

 

$r=@mysql_query("select * from my_table where my_db_field='".addslashes($_REQUEST["my_form_field"])."'");
if(!@mysql_num_rows($r)){
  echo 'Value is not valid!';
}

[mark_c]

Hi Sergey,

 

Thank you for your help.

 

I'm new in php.

 

I'm attaching my file. Is it possible to add the codes to the file. Is going to be great help for me.

 

Text field is 'type'

 

Thanks,

Mark

[mark_c]

My working file

 

[attachment deleted by admin]

[mark_c]

Where I have to place this code.? Can anyone help me.

[mark_c]

Hi Sergey,

 

Thank you for the help... It's working fine

 

Mark