Search the Community
Showing results for tags 'edit page'.
Found 1 result
-
Hi All, I'm having a go at making an edit page and have come across a slight problem. I get this error on the edit page when the submit button is pressed: Notice: Undefined index: id this is the script that I have attempted: <?php # display all php errors error_reporting(-1); ini_set('display_errors', 1); # include dbConnection details include '../includes/dbconn.php'; # set form input fields $sql = 'SELECT id, name, email FROM author WHERE id = :id'; $query = $dbConnection->prepare($sql); $query->bindValue(':id', $_POST['id']); $query->execute(); $row = $query->fetch(); $name = $row['name']; $email = $row['email']; $id = $row['id']; # if the form has been posted if (isset($_GET['update_details'])) { $sql = 'UPDATE author SET name = :name, email = :email WHERE id = :id'; $query = $dbConnection->prepare($sql); $query->bindValue(':id', $id); $query->bindValue(':name', $_POST['name']); $query->bindValue(':email', $_POST['email']); $query->execute(); $message = 'Author details successfully updated'; header('Location: index.php?message=' . $message); } ?> the error makes reference to this line: $query->bindValue(':id', $_POST['id']); I can't see where I have gone wrong with it. Any tips on what I should be looking at?
