modify value returned by SELECT with MySQL / PHP

Question

I want do such as this:

$username0 = $_POST["nkn"];
$username1 = strtoupper($username0);
$query = "SELECT username FROM users WHERE strtoupper(username) = '".$username1."'";

What's the right way to do this? Thanks.

See http://stackoverflow.com/questions/60174/how-to-prevent-sql-injection-in-php — Blackhole, Jun 21 '13 at 13:13
use a case insensitive collation where you don't need any index killing functions. — juergen d, Jun 21 '13 at 13:13

score 2 · Accepted Answer · answered Jun 21 '13 at 13:15

2

Use the below code:

$query = "SELECT username FROM users WHERE UPPER(username) = '".$username1."'";

In mysql the is the function UPPER() to convert the string in upper case.

answered Jun 21 '13 at 13:15

Code Lღver

1 Answers1