Php variable to be shown in a separate HTML file than the php one

Question

In a html page, I would like to appear, for example, the following text:

Amount: 50

where

Amount - is a fixed word
50 - is a sum of the values from a table column.

I have the php script (let's call it "Script.php") where I calculate the sum:

$query_ = mysqli_query($link, "SELECT SUM(table_column) AS amount FROM table"); 
$row = mysqli_fetch_assoc($query_); 
$sum = $row['amount'];

echo "<font color='red', size='5'>$sum";

Currently the html code looks like this:

<ul>
    <li>Some info: &nbsp;some info</li>
    <li>Amount: ??? </li>
</ul>

What should I put instead of "???" in order to obtain what I want? Thanks.

UPDATE: the php code and the html code are in two different files.

@Machavity: My question is not the same as the one considered to you as duplicated by me. As I have mentioned, the php code and the html code are in two different files. Please revise your "marked as duplicate" or refer to another question which I have duplicated. Thanks.

Answer 1

You can do it like this:

<ul>
   <li>Some info: &nbsp;some info</li>
   <li>Amount: <?= $sum ?> </li>
</ul>

UPDATE:

At the top of your view file, add this:

<?php require_once 'Script.php' ?>

And then put this code:

<ul>
   <li>Some info: &nbsp;some info</li>
   <li>Amount: <?= $sum ?> </li>
</ul>

I put the require_once code at the top, because it is better to leave your presentation code as clean and readable as possible. The <?= is valid and also makes the code cleaner and shorter. When adding side code that doesn't do anything to the presentation (don't adds something on the screen), you are redundantly messing the code. That could make your code more difficult to understand in the future (if you continue messing it).

Answer 2

Here is what I think will do.

<ul>
    <li>Some info: &nbsp;some info</li>
    <li>Amount: <?php echo $sum ?></li>
</ul>

Answer 3

<ul>
    <li>Some info: &nbsp;some info</li>
    <li>Amount: <?php include 'Script.php'; ?> </li>
</ul>

Note that your echo should also do a </font> to prevent the rest of the page from turning red.

You must rename your HTML file to .php to be able to do this. But if you do that, you might as well use PHP properly. Remove the echo from Script.php and then you can do:

<?php include 'Script.php'; ?>
<ul>
    <li>Some info: &nbsp;some info</li>
    <li>Amount: <font color="red" size="5"><?php echo $sum; ?></font> </li>
</ul>

Answer 4

There's the short tag version of your code, which is now completely acceptable to use despite antiquated recommendations otherwise:

<tr><td> <input type="hidden" name="type" value="<?= $var ?>" ></td></tr>

which (prior to PHP 5.4) requires short tags be enabled in your php configuration. It functions exactly as the code you typed; these lines are literally identical in their internal implementation:

php <?= $var1, $var2 ?> <?php echo $var1, $var2 ?>

Answer 5

I would advice you to use a template system like Twig to separate your logic from your templates. That makes it much easier to understand. I know that when you start with PHP it's not the easiest thing but you can learn very good with such tasks.

In your case you can simply echo your variable like this:

<ul>
    <li>Some info: &nbsp;some info</li>
    <li>Amount: <?php echo $sum ?></li>
</ul>