Passing CSS formatted data to a PHPMyAdmin database

[anton2511]

I have applied text-transform to a data entry form to ensure consistency. I want certain characters to be uppercase regardless of whether the user enters them that way. However when I submit the data to my database it appears as it was entered i.e. if the user didn't capitalise the characters in question they appear in the lowercase, even though on the data entry form they are in uppercase. Has anybody any suggestions as to how I can rectify this issue?

[bernie1227]

You could use the mysql function UPPER()?
http://www.sqlinfo.net/mysql/mysql_function_upper_lower.php

Or alternatively you could use the php function strtoupper() before submitting it.

[traq]

Do you mean CSS text-transform? That doesn't affect the actual text at all (only how the browser displays it). You'd need to apply those changes to the text itself before saving it to your database.