{$escaped_title}"; } $article = array( 'title' => 'Welcome', 'description' => 'Hello, web' ); $update_link = ''; $delete_link = ''; $author = ''; if( isset($_GET['id'])) { $filtered_id = mysqli_real_escape_string($conn, $_GET['id']); $sql = "SELECT * FROM topic LEFT JOIN author ON topic.author_id = author.id WHERE topic.id={$filtered_id}"; $result = mysqli_query($conn, $sql); $row = mysqli_fetch_array($result); $article['title'] = htmlspecialchars($row['title']); $article['description'] = htmlspecialchars($row['description']); $article['name'] = htmlspecialchars($row['name']); $update_link = 'update'; $delete_link = ' '; $author = "

by {$article['name']}

"; } ?> WEB

WEB

create

5-15-6.php