'Capitalizing' a form-field inserted by DA

Hi,

I'm using DA to insert a new user record into MySQL table.
I have the form configured so each word typed into each field is 'capitalized' using 'text-transform:capitalize', however the insert process does not keep that 'capitalized' format and inserts all in lowercase.

Here are the two fields i wish to insert as 'capitalize'

GetSQLValueString($_POST['fname'], "text"),

GetSQLValueString($_POST['lName2'], "text"),

Any ideas please?

Thank you.
Paul

Originally Said By: paul.casbourne361959

  Hi,

I'm using DA to insert a new user record into MySQL table.
I have the form configured so each word typed into each field is 'capitalized' using 'text-transform:capitalize', however the insert process does not keep that 'capitalized' format and inserts all in lowercase.

Here are the two fields i wish to insert as 'capitalize'

php:

GetSQLValueString($_POST['fname'], "text"),

GetSQLValueString($_POST['lName2'], "text"),

Any ideas please?

Thank you.
Paul  

Your changing the style of the displayed text -- that isn't changing the actual data. Look up the PHP functions 'ucfirst' or 'ucwords'. . .

I should have added that i've seen some examples of ucwords, which is what I believe i should be using, but what is not clear to me is where/how to use it.

For example

GetSQLValueString ucwords(($_POST['fname'], "text")),
and
GetSQLValueString ($_POST[ucwords('fname')], "text"),
and
GetSQLValueString ($_POST(ucwords(['fname'])), "text"),

Seems obvious to me, but do not work.

I believe the code you are editing here is a part of the Dreamweaver recordset, not the data assist insert.


in the data assist insert behavior, when you bind a column to a form value, it will show code similar to this in the value section:

<?php echo((isset($_POST["textfield"]))?$_POST["textfield"]:"") ?>

you would want to edit that code to use the ucwords() function:

<?php echo((isset($_POST["textfield"]))?ucwords($_POST["textfield"]):"") ?>

Thanks Jason,

I have reverted back to DA to allow the above modification.
(not sure why i used DW in the first place!)

MySQL now populating with capitalized words.
Pefect.