data fetching and ahref issues

Asked Apr 24 '19 at 07:18

Active Apr 24 '19 at 09:10

Viewed 18 times

I am fetching blob data (pdf) from my database but when i execute the code blank page is displayed. Maybe ahref tag is not working properly or the code has some issues or some syntax error please guide i am new to php.

<html>
    <head>
        <title>Download File From MySQL</title>
    </head>
    <body>
        <?php
            $con=mysqli_connect("localhost","root","","mydb");
            $query = "SELECT id, name FROM upload";
            $result = mysqli_query($con,$query) or die('Error, query failed');
            if(mysqli_num_rows($result) == 0) {
                echo "Database is empty <br>";
            } else {
                while(list($id, $name) = mysqli_fetch_array($result)) {
        ?>
                    <a href='download.php?id=<?php=$id;?>'><?php=$name;?></a> <br>
        <?php 
                }
            }
        ?>
    </body>
</html>

edited Apr 24 '19 at 09:10

Jaydip kharvad

1,064
7
13

asked Apr 24 '19 at 07:18

Rajendra Talekar

the code above looks OK so assuming that it is and it generates some links ( with an ID in the querystring ) then the problematic code is within `download.php` I'd suggest – Professor Abronsius Apr 24 '19 at 07:21
But when i run this code it shows blank screen no record is being fetch from table – Rajendra Talekar Apr 24 '19 at 07:32

data fetching and ahref issues

0 Answers0