Can we pass variable in href instead of link?

See more:

SQL

PHP

database

href

website

, +

Hi, I have stored the URL of pdf in MySQL database. Based on the search criteria the url of pdf will be fetched from the database which means everytime the url will be different. So the url should be passed as parameter to 'href' of .Also I don't want t show the url on the webpage itself. Some text or report name will be there and when user will click on that, it will go to that that url of pdf.
Can someone please tell me how I can pass the variable to href instead of passing the url?

Here $report_url is defined in other php file and it stores the url fetched from database. And "$report_result" stores the name of the report. So after clicking on this name it should go to that url stored in "$report_url".



How can we do this?

What I have tried:

$result=mysqli_query($db,$sql);
$count=mysqli_num_rows($result);

if($count==0)
{
array_push($errors,"No report found for given criteria");
}
else
{
while($row = mysqli_fetch_array($result))
{
$rname=$row['report_pdf_url'];
$pdf=$row['pdf_name'];

$report_result .='

'.$pdf.'

';
$report_url=$rname;
}
-----------------------------

<a href=$report_url><?php print("$report_result"); ?>