我使用下面的代码从数据库中的表中检索数据:
$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