I am creating a form processor. When the form is submitted, then information is stored into a MySQL database. I am using the php function htmlspecialchars whenever I submit the form information into the database (in case someone's name is O'Reilly or something, the apostraphe will not mess with the MySQL syntax).
Originally, the problem was just that in MySQL there is a 255 character limit per cell. When htmlspecialchars converts the text, there are four times as many characters stored into the cell. This is fine, except I have a textarea titled "information" where people can type paragraphs of information.
If possible, I would like to find an alternative so that people can type more than 255 characters in the textarea.
This is a link to the form ([url]www.mlowery.net/se/contact2.php)[/URL]
This is a link to a .txt version of the php script ([url]http://mlowery.net/se/contact_processor.txt)[/URL]
Originally, the problem was just that in MySQL there is a 255 character limit per cell. When htmlspecialchars converts the text, there are four times as many characters stored into the cell. This is fine, except I have a textarea titled "information" where people can type paragraphs of information.
If possible, I would like to find an alternative so that people can type more than 255 characters in the textarea.
This is a link to the form ([url]www.mlowery.net/se/contact2.php)[/URL]
This is a link to a .txt version of the php script ([url]http://mlowery.net/se/contact_processor.txt)[/URL]
Thanks a lot CareBear, it worked. For some reason, through the dozens of MySQL tutorials that I've read, I never figured out what each of the column typed did.