Make a PHP echo a link

Question

I am trying to echo the title out as a link, so when it is clicked it will redirect the user to the post.

<?php
$sql = "SELECT title, category FROM posts ORDER BY id DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
foreach($posts as $post)

while ($list = mysql_fetch_assoc($result)) {
   echo "<h2><a href='post.php?post='.$post->id.>"$list['title']"</a></h2>";
   echo "<p>".$list['category']."</p>";
}  ?>

Use error reporting. http://stackoverflow.com/questions/845021/how-to-get-useful-error-messages-in-php — chris85, Jul 25 '15 at 18:51

M0rtiis · Accepted Answer · 2015-07-25T18:52:57.630

0

just try to replace your code with this

<?php
$sql = "SELECT * FROM posts ORDER BY id DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
while ($post = mysql_fetch_assoc($result)) {
   echo '<h2><a href="post.php?post=' . $post[id] . '">' . htmlspecialchars($post['title']) . '</a></h2>';
   echo '<p>' . htmlspecialchars($post['category']) . '</p>';
}  ?>

edited Jul 25 '15 at 18:52

answered Jul 25 '15 at 18:38

M0rtiis

3,676
1
15
22

This worked thank you, however the foreach dosen't work :/ – mattmill98 Jul 25 '15 at 18:42
so `foreach($posts as $post)` what is `$posts` here? its not defined in your code – M0rtiis Jul 25 '15 at 18:45
Ive added this to the code although its not working, ive messed it up alot 'fetchAll(PDO::FETCH_CLASS); foreach($posts as $post) ; ?>' – mattmill98 Jul 25 '15 at 18:51
Perfect thanks so much:) – mattmill98 Jul 25 '15 at 18:55

score 0 · Answer 2 · answered Jul 25 '15 at 18:39

0

echo "<h2><a href='post.php?post='.$post->id.>"$list['title']"</a></h2>";

try it like this:

 echo "<h2><a href='post.php?post=" . $post->id . "'>". $list["title"] . "</a></h2>";

answered Jul 25 '15 at 18:39

fsn

549
3
11

Make a PHP echo a link

' . $list['title'] . '

2 Answers2