0

I come to see you because I have a problem in PHP, I'm a novice, I try to recover the ID but I can't get this error : "Notice: Undefined index: id in C:\xampp\htdocs\Dossier\Stage\admin\index.php on line 49"

Can you help me, please? Thank you.

<?php
   require 'database.php';
   $db = Database::connect();
   $statement = $db->query("SELECT people.name, people.society, people.email, people.city, people.direct_line, people.internal_number, people.phone_number, people.abbreviated_number,  people.service, business_service.name  AS service FROM people LEFT JOIN business_service ON people.service = business_service.id ORDER BY people.id DESC");
   while($item = $statement->fetch()) {
      echo '<tr>';
         echo '<td>' . $item['name'] . '</td>';
         echo '<td>' . $item['society'] . '</td>';
         echo '<td>' . $item['email'] . '</td>';
         echo '<td>' . $item['city'] . '</td>';
         echo '<td>' . $item['direct_line'] . '</td>';
         echo '<td>' . $item['internal_number'] . '</td>';
         echo '<td>' . $item['phone_number'] . '</td>';
         echo '<td>' . $item['abbreviated_number'] . '</td>';
         echo '<td>' . $item['service'] . '</td>';
         echo '<td width=300>';
            echo '<a class="btn btn-default" href="view.php?id=' . $item['id'] . '"><span class="glyphicon glyphicon-eye-open"></span> Voir</a>';
            echo '  ';
            echo '<a class="btn btn-primary" href="update.php?id=' . $item['id'] . '"><span class="glyphicon glyphicon-pencil"></span> Modifier</a>';
            echo '  ';
            echo '<a class="btn btn-danger" href="delete.php?id=' . $item['id'] . '"><span class="glyphicon glyphicon-remove"></span> Supp</a>';
         echo '</td>';
      echo '</tr>';
   }
?>

Kiwi
  • 7
  • 3
  • 1
    Does this answer your question? ["Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset" using PHP](https://stackoverflow.com/questions/4261133/notice-undefined-variable-notice-undefined-index-and-notice-undefined) – El_Vanja Mar 26 '20 at 17:19
  • I had looked at it before posting my question but I still don't understand why. – Kiwi Mar 26 '20 at 17:24
  • You're not selecting the id in SQL. – El_Vanja Mar 26 '20 at 17:27
  • I'm stupid. Thank you very much. – Kiwi Mar 26 '20 at 17:30

0 Answers0