将数据以大写格式存储到mysql中

Question

如何用大写字母存储我的数据？

查询

$personal_date_birth = checkDateY($personal_date_birth);

mysql_query("UPDATE personal_data SET personal_full_name = '".mysql_real_escape_string($personal_full_name)."', personal_title = '".mysql_real_escape_string($personal_title)."', personal_date_birth ='".mysql_real_escape_string($personal_date_birth)."', personal_marital_status = '".mysql_real_escape_string($personal_marital_status)."', personal_nationality = '".mysql_real_escape_string($personal_nationality)."', personal_race = '".mysql_real_escape_string($personal_race)."', personal_religion = '".mysql_real_escape_string($personal_religion)."', personal_gender = '".mysql_real_escape_string($personal_gender)."', personal_country_birth = '".mysql_real_escape_string($personal_country_birth)."', personal_bumiputra_status = '".mysql_real_escape_string($personal_bumiputra_status)."' WHERE LAS_login_id = '".mysql_real_escape_string($LAS_login_id)."'")

Answer 1

使用strtoupper()函数

试试看

$personal_date_birth = checkDateY($personal_date_birth); 
mysql_query("UPDATE personal_data SET 
personal_full_name='".mysql_real_escape_string(strtoupper($personal_full_name))."',
personal_title = '".mysql_real_escape_string(strtoupper($personal_title))."',
personal_date_birth ='".mysql_real_escape_string(strtoupper($personal_date_birth))."',
personal_marital_status = '".mysql_real_escape_string($personal_marital_status)."',
personal_nationality = '".mysql_real_escape_string(strtoupper($personal_nationality))."',
personal_race = '".mysql_real_escape_string(strtoupper($personal_race))."',
personal_religion = '".mysql_real_escape_string(strtoupper($personal_religion))."',
personal_gender = '".mysql_real_escape_string(strtoupper($personal_gender))."',
personal_country_birth = '".mysql_real_escape_string(strtoupper($personal_country_birth))."',
personal_bumiputra_status = '".mysql_real_escape_string(strtoupper($personal_bumiputra_status))."' 
WHERE LAS_login_id = '".mysql_real_escape_string($LAS_login_id)."'")

Answer 2

你应该像Ankur说的那样，在php中完成它。但是您也可以在MySQL中使用上级(‘string’)；

Answer 3

使用"strtoupper()“函数，将文本放入您想要的括号中作为大写。