mysql lc time names,PHP / MySQLi：SET lc_time_names和DATE_FORMAT（）成一个mysqli查询？-CSDN博客

该博客讲述了如何在PHP中通过MySQL查询设置locale为'es_ES'，以便将日期以西班牙语的全名显示。作者展示了一段代码，首先设置locale，然后执行查询来获取个人数据，包括格式化后的出生日期。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I use the next code to retrieve data from a table in the database:

$check_sql = 'SELECT personID, name, DATE_FORMAT(persons.birthdate, "%d de %M, %Y"), birthplace, countryID FROM persons WHERE personID = ?';

if ($stmt->prepare($check_sql)) {

$stmt->bind_param('i', $pid);

$stmt->bind_result($personDB, $name, $birthdate, $birthplace, $countryID);

$stmt->execute();

$stmt->fetch();

}

Like you can see, at the same time I format the date from the 'birthdate' column to a more friendly display using the DATE_FORMAT() MySQL function. Now, I want to display the month full names in Spanish, so I want to insert SET lc_time_names = 'es_ES' into the query..

How can I do it??? Can I add SET lc_time_names to the $check_sql variable??

Thanks!!

解决方案

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

$mysqli->query("SET lc_time_names = 'es_ES'");

$check_sql = 'SELECT personID, name, DATE_FORMAT(persons.birthdate, "%d de %M, %Y"), birthplace, countryID FROM persons WHERE personID = ?';

if ($stmt = $mysqli->prepare($check_sql)) {

$stmt->bind_param('i', $pid);

$stmt->bind_result($personDB, $name, $birthdate, $birthplace, $countryID);

$stmt->execute();

$stmt->fetch();

}