mysql lc time names,PHP / MySQLi：将lc_time_names和DATE_FORMAT()设置为mysqli查询吗？

我使用下面的代码从数据库中的表中检索数据：

$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();

}

如您所见,同时我使用DATE_FORMAT()MySQL函数将日期从“生日”列格式化为更友好的显示.现在,我想以西班牙语显示月份的全名,所以我想在查询中插入SET lc_time_names =’es_ES’.

我该怎么做？？？我可以将SET lc_time_names添加到$check_sql变量中吗？

谢谢！！

解决方法:

$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();

}

标签：php,mysql,database,mysqli

来源： https://codeday.me/bug/20191009/1880437.html