Keeping pdf files in a folder and than download them via link

See more:

PHP

MySQL

PDF

database

file-system

, +

Hello everyone,

I have a website. I am developing it to develop myself.

My Database conists of 3 tables. 1 is for the content.
I seperated a column for the pdf file directory(type is varchar). ie (files/pdffiles/example.pdf)

The problem is that;how can i add the true file directory and point the exact pdf.

and how can i download it to my computer by clicking the link?

Here is my code;

 <section class="accordionMod">
    <div class= "yardimbaslik">
    <h2 title = "U ve Ü harfiyle başlayan yardım konuları"> <span>U-Ü</span></h2>
    </div>
    <?php
   $sql =mysql_query("SELECT * FROM problemler WHERE baslik LIKE 'U%' or baslik LIKE 'Ü%' ORDER BY baslik ASC") or die("SORGU HATASI");
    while ($row = mysql_fetch_array($sql)) {
        $baslik = $row['baslik'];
        $icerik = $row['icerik'];
        $youtube_link = $row['youtube_link'];
        $pdf_link = $row['pdf_link'];
        $download_link = $row['download_link'];
        $oy_orani = $row ['oy_orani'];
   ?>
     <div>
        <h3 class="accordion-toggle"><?echo $baslik?></h3>
        <section class="accordion-inner">
            
                <div class ="sosyal_buton">

                        <a href=<?php echo $download_link ?>><img src = "themes/images/indir.png"></a><a href=<?php echo $pdf_link.'.pdf'?>><img src = "themes/images/pdf.png"></a><a href=<?php echo $youtube_link ?>><img src = "themes/images/youtube.png"></a>
                </br>
                <br/>
                </div>
            <div class = "icerik_alt">
                <p><?php echo $icerik?></p>
            </div>

    </div>  
    <?php
}
?>
</section>