Uppercase

[Anon]

Greetings

I simply need data entered in a text field (LastName) to be converted into uppercase before it is entered into MySQL.

I'm not to skilled in strings and everything I've tried just doesn't do it.

Thanks.

[ivoxz]

string strtoupper ( string string)
so it would be

$my_var = "Welcome to my house";
$my_var = strtoupper($mayvar);

the variable is now all upper

[Anon]

Still can't get it to work.

This is the abridged version of the form I enter the data into:

<?

echo "<FORM ACTION=\"$Relative/add.php\" METHOD=\"POST\">";

fontSize("-1","red","Arial","First Name:*<br>");
echo "<input type=\"text\" name=\"FirstName\" size=\"40\"><p>";

fontSize("-1","red","Arial","Middle Name:<br>");
echo "<input type=\"text\" name=\"MiddleName\" size=\"40\"><p>";

fontSize("-1","red","Arial","Last Name:*<br>");
echo "<input type=\"text\" name=\"LastName\" size=\"40\"><p>";

echo "</td><td><INPUT TYPE=\"SUBMIT\" VALUE=\"Add Details Now\"></td></tr></table></FORM>";

commonFooter($Relative,$UID);

?>

And this is the form the info gets posted to:

add.php

mysql_connect("$DBHost","$DBUser","$DBPass");
mysql ("$DBName","INSERT INTO Data VALUES (
'$FirstName','$MiddleName','$LastName'));

I need to be spoon feed on this one as it's the last thing I have to do for the entire site.

Thanks

[Anon]

Before you do the MySQL stuff, add the line

$LastName=strtoupper($LastName);

[trooper]

Rob

If you just want the first character of the lastname to be in caps then do the following

$lastname = addslashes(strtolower($lastname));
$lastname = ucfirst($lastname);

the reason i have put $lastname = strtolower addslashes(($lastname)) is because you cannot guarantee that the user has not put something like JohNsTon as the last name. By converting the string to lower then doing a ucfirst on it you are guarenteed to get Johnston as the string that will go into the database.

The addslashes will automatically put a '\' before and ' that is in a string. So O'shea will become O\'shea. If you don't escape the ' then the database will stop at O'.

You have to try and account for all sorts of silly things that the user could do :-)

HTH

Gary Mailer

[Anon]

It worked. Thank you one and all.