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

Question

how can I store my data in uppercase letter?

query

$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

Use strtoupper() function

Just Try this

$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)."'")