in editing how can i make my php code works. below are my codings. when i click the edit post link, it should pass to authenticate2.php first to key in username and password then if successful it will go to edit.php to grab the title and content that i want to edit. THere i can edit the post then when i click UPDATE button it should update the new edit post i did and will display in index.php. for delete button when i click the edit post link it will show the title and content message then when i click delete it will delete the post in the index.php.

heres my coding:

require('connect.php');

// UPDATE quote if author, content and id are present in POST. if ($_POST && isset($_POST['title']) && isset($_POST['content']) && isset($_POST['id'])) { // Sanitize user input to escape HTML entities and filter out dangerous characters. $title = filter_input(INPUT_POST, 'title', FILTER_SANITIZE_FULL_SPECIAL_CHARS); $content = filter_input(INPUT_POST, 'content', FILTER_SANITIZE_FULL_SPECIAL_CHARS); $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); // Build the parameterized SQL query and bind to the above sanitized values. $query = "UPDATE blogs SET title = :title, content = :content WHERE id = :id"; $statement = $db->prepare($query); $statement->bindValue(':title', $title); $statement->bindValue(':content', $content); $statement->bindValue(':id', $id, PDO::PARAM_INT); // Execute the INSERT. $statement->execute((array(':title' => $title, ':content' => $content, ':id' => $id))); // Redirect after update. header("Location: index.php?id={$id}"); exit; } else if (isset($_GET['id'])) { // Retrieve quote to be edited, if id GET parameter is in URL. // Sanitize the id. Like above but this time from INPUT_GET. $id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT); // Build the parametrized SQL query using the filtered id. $query = "SELECT * FROM blogs WHERE id = :id"; $statement = $db->prepare($query); $statement->bindValue(':id', $id, PDO::PARAM_INT); // Execute the SELECT and fetch the single row returned. $statement->execute(); $blogs = $statement->fetch(); } else { $id = false; // False if we are not UPDATING or SELECTING. } ?>

Welcome to My Blog

Title

Content

Home

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaa January 30,2023,2:50pmedit CA January 30,2023,1:39 am - edit Canadacanada This post was updated through the test monster post January 29,2023,2:53 am - edit bruh This is the epitome of gaming! January 28,2023,9:24 pm - edit yeet yeet yeet yeeet yeet hello January 27, 2023, 3:46 pm - edit Lo45245