Я редактирую этот код, чтобы отображать mesaje, когда select имеет значение null, и я получаю эту ошибку:
Parse error: syntax error, unexpected 'else' (T_ELSE) in /nginx/user/reports.php on line 235 Это код:
$stmt = $mysqli->prepare("SELECT date, impressions, balance, username FROM reports WHERE username = '$username' and date between '$firstDay' AND '$lastDay'"); $stmt->execute(); $stmt->store_result(); $rows = $stmt->num_rows; mysqli_stmt_bind_result($stmt,$date,$impressions,$balance,$username); if ($rows > 0){ while (mysqli_stmt_fetch($stmt)) { $ecpm_t3 = $balance*1000; $ecpm3 = $ecpm_t3/$impressions; $rate = number_format((float)$ecpm3, 2, '.', ''); echo"<tr> <td class=\"nn\" style=\"text-align:center;\" align=center>$date</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$impressions</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$$rate</td> <td class=\"nn\" style=\"text-align:center;\" align=center nowrap>$$balance</td> </tr>"; } else { echo"<tr> <td colspan=\"4\" class=\"nn\" style=\"text-align:center;\" align=center>Not rows</td> </tr>"; } }
И строка 235:
} else {
Как я могу решить эту ошибку? Что такое плохо ?
Рабочий пример (фиксированный и отформатированный):
$stmt = $mysqli->prepare("SELECT date, impressions, balance, username FROM reports WHERE username = '$username' and date between '$firstDay' AND '$lastDay'"); $stmt->execute(); $stmt->store_result(); $rows = $stmt->num_rows; mysqli_stmt_bind_result($stmt, $date, $impressions, $balance, $username); if ($rows > 0) { while (mysqli_stmt_fetch($stmt)) { $ecpm_t3 = $balance * 1000; $ecpm3 = $ecpm_t3 / $impressions; $rate = number_format((float)$ecpm3, 2, '.', ''); echo "<tr> <td class=\"nn\" style=\"text-align:center;\" align=center>$date</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$impressions</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$$rate</td> <td class=\"nn\" style=\"text-align:center;\" align=center nowrap>$$balance</td> </tr>"; } } else { echo "<tr> <td colspan=\"4\" class=\"nn\" style=\"text-align:center;\" align=center>Not rows</td> </tr>"; }
Попробуй это
<?php $stmt = $mysqli->prepare("SELECT date, impressions, balance, username FROM reports WHERE username = '$username' and date between '$firstDay' AND '$lastDay'"); $stmt->execute(); $stmt->store_result(); $rows = $stmt->num_rows; mysqli_stmt_bind_result($stmt,$date,$impressions,$balance,$username); if ($rows > 0){ while (mysqli_stmt_fetch($stmt)) { $ecpm_t3 = $balance*1000; $ecpm3 = $ecpm_t3/$impressions; $rate = number_format((float)$ecpm3, 2, '.', ''); echo"<tr> <td class=\"nn\" style=\"text-align:center;\" align=center>$date</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$impressions</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$$rate</td> <td class=\"nn\" style=\"text-align:center;\" align=center nowrap>$$balance</td> </tr>"; }} else { echo"<tr> <td colspan=\"4\" class=\"nn\" style=\"text-align:center;\" align=center>Not rows</td> </tr>"; } ?>