Represent SQL Entry As PHP Page : <p>Can anyone here to solve my query.</p>

<ol>
<li>I want to manage many PDFs on base of php and mysql. So, i make a script to show list of books with their author name and size from mysql and i were also categorize them.  <strong><em>Now i want to show a detailed page (where download link, author name, size, screenshots, description will show) of each book, this detailed page will open when someone click on book name only.</em></strong></li>
</ol>

<p><strong>Script For List Of Books:</strong></p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
$server = "localhost";
$username = "root";
$password = "mysql";
$dbname = "db-gs";

// Create connection
$connect = mysqli_connect($server, $username, $password, $dbname);

// Check connection
if (!$connect) {
    die("Connection failed: " . mysqli_connect_error());
}

// Selection of data
$sql = "SELECT id, bname, aname, size, cat, lang FROM books";
$result = mysqli_query($connect, $sql);

if (mysqli_num_rows($result) &gt; 0) {
	echo "&lt;table&gt;&lt;tr&gt;&lt;th&gt;SNo:&lt;/th&gt;&lt;th&gt;Books&lt;/th&gt;&lt;th&gt;Size&lt;/th&gt;&lt;th&gt;Language&lt;/th&gt;&lt;/tr&gt;";
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "&lt;tr&gt;&lt;td&gt;".$row["id"]."&lt;/td&gt;&lt;td&gt;".$row["bname"]."&lt;/td&gt;&lt;td&gt;".$row["size"]."&lt;/td&gt;&lt;td&gt;".$row["lang"]."&lt;/td&gt;&lt;/tr&gt;";
		}
		echo "&lt;/table&gt;";
} else {
    echo "0 results";
}

mysqli_close($connect);
?&gt;</code></pre>
</div>
</div>
</p>
