dougong7850
2015-11-13 16:06
浏览 52
已采纳

获取MySQL记录时PHP未定义变量错误

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>';
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

  • douju7765 2015-11-13 16:09
    最佳回答

    if (!empty($_POST['name']) or !empty($_POST['surname'])){

    You have to add variables and assign values:

    $name = $_POST['name'];
    $surname = $_POST['surname'];
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题