Restricting enry .

[habbardone]

In sql there is a field type that has no length - sorry I ve forgotten the name of it - It is usually used for storing stuff over 255 characters long.

How can I use PHP to limit this to say 500 characters or to read it the field from my table., cut it down to 500 chars and then update it again ?

I just want to stop some idiot from dumping twenty pages of garbage into my textbox.

I protect it with js at present but any one can turn that off - so I want to check it with PHP

Thnks for any help

How can I make sure my data field - sorry I've forg

[drew010]

you could do something like

if (strlen($_POST['text']) > 500) {
  $_POST['text'] = substr($_POST['text'], 0, 499);
}

[habbardone]

Yes it is the text type field in mysql that I am using which seems to have unlimited size.

Thanks for your help.

[drew010]

yeah a text field will hold 2¹⁶ bytes, or roughly 65k, much larger than 500 chars.