Forcing a form field to send upper case values to database

Hi Jerry

Test :

<?php echo strtoupper(strtolower(@$_REQUEST['state'])); ?>

Djulia

Hi Jerrry,

What you need to do is to transform the variable before adding it to the database, that way the value that it displays in the form doesn't matter.

Before your query to update that database, try this:

$_REQUEST['state']=strtoupper($_REQUEST['state']);

This will take the value of the field "state" from the form, put it to all uppercase, then assign it to $_REQUEST['state']; This value can now be submitted normally to the database.

If you want to just put the first letter to upper case, use this instead:

$_REQUEST['state']=ucfirst($_REQUEST['state']);

Hope this helps.

Thanks Jason,

I guess I was transforming the text after adding it to the database not before, which would much more sense.

It's always so simple when you know how.

I think it's about time you electioneered to remove the "in training" from your signature.

Best,

Jerry Kornbluth

Hi Jason,

I'm sure that the code is OK and I'm missing something, but when I insert
<?php $_REQUEST['state'] = strtoupper($_REQUEST['state']); ?>
into

<tr>
<td class="body-text-bold">State</td>
<td><input type="text" name="state" value="<?php echo htmlspecialchars(@$_REQUEST['state']); ?>" MAXLENGTH="2" size="50" /></td>
</tr>

Like this:

<tr>
<td class="body-text-bold">State<?php $_REQUEST['state'] = strtoupper($_REQUEST['state']); ?></td>
<td><input type="text" name="state" value="<?php echo htmlspecialchars(@$_REQUEST['state']); ?>" MAXLENGTH="2" size="50" /></td>
</tr>

I get this error:

Notice: Undefined index: state in /hsphere/local/home/apbcweb/artistsofpalmbeachcounty.org/member_signup7.php on line 212 /code]

Thanks,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php