I'm writing something like a "e-diary" (for schools, education project) in PHP. I have a problem with database records.
Notice: Undefined variable: name in C:\xampp\htdocs\projects\edziennik\panel.php on line 44
Notice: Undefined variable: surname in C:\xampp\htdocs\projects\edziennik\panel.php on line 44
My code:
if (!empty($_POST['name']) or !empty($_POST['surname'])){
require('inc/database.php');
$query = $db->prepare("SELECT * FROM `studentindex`");
$query->execute();
$result = $query->fetchAll();
echo '<table class="table table-striped table-hover ">
<thead>
<tr>
<th>#</th>
<th>Imię</th>
<th>Nazwisko</th>
<th>Klasa</th>
</tr>
</thead><tbody>';
$row = array();
foreach ($result as $row){
if ($row['name'] == $name or $row['surname'] == $surname){
echo ' <tr>
<td>'.$row['id'].'</td>
<td>'.$row['name'].'</td>
<td>'.$row['surname'].'</td>
<td>'.$row['class'].'</td>
</tr>';
}
Exact problem is in foreach, where the if giving that error, in other PHP versions everything was OK (with MySQL). I'm using PDO actually, in database.php is only connection that works fine.
Edit
I have error Notice: Undefined index: id in C:\xampp\htdocs\projects\edziennik\panel.php on line 48 now.
These lines:
echo '<tr>
<td>'.$row['id'].'</td> // line 48
<td>'.$row['name'].'</td>
<td>'.$row['surname'].'</td>
<td>'.$row['class'].'</td>
</tr>';
微信扫一扫