Passing PHP variables into html tags

[torsaur]

I have a php script that gets a string from my MySQL database and puts certain elements into variables.

PHP Code:

<?php
$connection = mysqli_connect('database','user','pw','the_sleeper');
$audiopath = mysqli_query($connection,"select * from the_sleeper");
$row = mysqli_fetch_array($audiopath);
$audio=$row['audiopath'];
$title= $row['title'];
?>

Now I want these two variables on to my main page. I want the audiopath to be passed to an audio embed tag and title to be passed into a heading tag. How can I do this?
Here is the link to the page I will be passing them to:http://www.j10thesleeper.net84.net/J...rhomepage.html
Thank you all for your time!

[tempz]

PHP Code:

<audio controls>
  <source src="<?php echo $audio; ?>" type="audio/mpeg"/>
</audio>

<h2> <?php echo $title; ?></h2>

Do you mean this?

[torsaur]

First I need to call the php file itself. I have the file stored so I want to link it in and have it run without putting the code itself directly on the html page.

[VIPStephan]

That’s not possible, you have to somehow insert PHP code into your current HTML page, otherwise the page wouldn’t know what to display.

[torsaur]

Isn't it a security concern to have my MySQL database, username, and password out there for everyone to see?

[tempz]

Originally Posted by torsaur

Isn't it a security concern to have my MySQL database, username, and password out there for everyone to see?

The file is .php it can't be read by going to the url www.example.com/connect.php

[torsaur]

Thank you all! I didn't realize that if you coded php directly onto a page it couldn't be seen through view source!

[tempz]

Originally Posted by torsaur

Thank you all! I didn't realize that if you coded php directly onto a page it couldn't be seen through view source!

You must make sure the extension is dot php else users can view php code because it will display as text.