PHP concatenation with html

Question

I'm trying to concatenate some href with my fetched value form my DB. But I got lost in '' . "" \

I'm sure I'm missing something small but I just can't see it.

while ($row = $result->fetch_assoc()) {
                    echo "<tr>";
                    echo."<td>" . $row["interest"] . "</td>"
                        ."<td>"."<a href=\"http://localhost/page/files/".$row["filename"]\"/>" . $row["filename"] . " </a></td>"
                        ."<td>" . $row["reg_date"] . "</td>";
                }

Replace $row["filename"]\"/>" with $row["filename"] . "\"/>" — Andrej
– Andrej, Commented Sep 11, 2016 at 21:08

Kervon Ryan · Accepted Answer · 2016-09-13 18:02:31Z

2

I suggest you use single quotes instead of double quotes for your html values as this can confuse things.

You also had a lot of mistakes. I wont go into detail but compare your code to this and you should see them.

I fixed the code for you.

while ($row = $result->fetch_assoc()) {
                    $returnedHTMl = "<tr>";
                    $returnedHTMl .= "<td>" . $row["interest"] . "</td>"
                    $returnedHTMl .= "<td><a href='http://localhost/page/files/".$row["filename"]."'>" . $row["filename"] . " </a></td>"
                    $returnedHTMl .= "<td>" . $row["reg_date"] . "</td>"; 

                    echo $returnedHTML
}

@tpojka is also correct you should assign variables but I kept it similar to your code as I am not aware as to your reasons for doing it this way.

edited Sep 13, 2016 at 18:02

answered Sep 11, 2016 at 21:11

Kervon Ryan

6841 gold badge10 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tpojka · Accepted Answer · 2016-09-11 21:06:55Z

1

Until you get your mind back, check this example - assign variables to values:

while ($row = $result->fetch_assoc()) {
    $interest = $row["interest"];
    $filename = $row["filename"];
    $reg_date = $row["reg_date"];
    echo "<tr><td>$interest</td><td><a href=\"http://localhost/page/files/$filename\"/>$filename</a></td><td>$reg_date</td>";
}

answered Sep 11, 2016 at 21:06

Tpojka

7,0812 gold badges32 silver badges41 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:15:03Z

0

I believe you want to do something like this,

echo "<a href='".$link_address."'>Link</a>";

check this for more insight

add-php-variable-inside-echo-statement-as-href-link-address

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Sep 11, 2016 at 21:05

Babajide Apata

6937 silver badges19 bronze badges

Comments

Sylwit · Accepted Answer · 2016-09-13 18:09:28Z

0

When you have a lot of concatenation like this you can use the HEREDOC syntax which is a lot more readable

http://php.net/manual/fr/language.types.string.php#language.types.string.syntax.heredoc

$out <<<EOT
<tr>
<td> {$row["interest"]} </td>
<td><a href="http://localhost/page/files/{$row["filename"]}"> {$row["filename"]} </a></td>
<td> {$row["reg_date"]} </td> 
EOT;

echo $out;

answered Sep 13, 2016 at 18:09

Sylwit

1,6071 gold badge13 silver badges20 bronze badges

Collectives™ on Stack Overflow

PHP concatenation with html

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related