我正在使用以下查询,并希望查询结果显示在单引号内,例如“10AM”。
$sql2 = mysqli_query($con, "SELECT concat('''', appointment_time ,''''), concat('''', appointment_end_time ,'''') FROM Appointments WHERE appointment_with LIKE 'Sarah'");
if (!$sql2) {
die('Invalid query: ' . mysqli_error());
}
while ($row2 = mysqli_fetch_assoc($sql2)) {
$time = array($row2['appointment_time']. "," ." " . $row2['appointment_end_time']);
$appointment = [];
foreach ($time as $appointment){
echo $appointment;
}
当我在 phpmyadmin 中运行代码但在我的 php 代码中运行代码时,这工作正常,因为我收到以下消息。
注意:未定义索引:/Applications/MAMP/htdocs/booking-system/index.php 第 140 行中的约会时间
注意:未定义索引:/Applications/MAMP/htdocs/booking-system/index.php 中第 140 行的约会结束时间,
为什么会这样?
你需要在你的 SQL 中给你的字段一个别名......
$sql2 = mysqli_query($con, "SELECT concat('''', appointment_time ,'''') as appointment_time,
concat('''', appointment_end_time ,'''') as appointment_end_time
FROM Appointments
WHERE appointment_with LIKE 'Sarah'");
至于主循环,您似乎构建了一个数组以再次打印出来,您可以将该代码简化为...
while ($row2 = mysqli_fetch_assoc($sql2)) {
echo $row2['appointment_time']. ", " .
$row2['appointment_end_time'];
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句