|P is for Practical|
unpacking - html re-encoding?by Mac (Acolyte)
|on Jul 18, 2001 at 10:13 UTC||Need Help??|
Mac has asked for the wisdom of the Perl Monks concerning the following question:
Probably a simple question but, I have a form where a user can place a job item, for example. Details of this job are stored in a mysql database. If you can imagine, the user submits a job containing:
he can't wait so he ran...
it would do an insert such as..
insert into jobs values ('he can't wait so he ran'); which is definatly not desierable.
How can you convert special characters into HTML format
he said, "I'LL be back"
Is there an easier way round this? Like parse html (what is parsehtml - what does it do)? also, more simple stuff... I want to check if a date matches a certian format (mysql problem again) so I want to check if $date =~ /0000-00-00/ where $date can be like 2000-05-23 (CCYY-MM-DD)
please email me, email@example.com as I'm new to this site and probably won't be able to find my way bacdk here...