<?php
include('header.php');
echo '<h1>download</h1>';
$sql=mysql_fetch_array(mysql_query("select * from addbook where id='$_GET[id]'"));
$views=$sql['views']+1;
mysql_query("update addbook set views='$views' where id='$_GET[id]'");
$row=mysql_fetch_array(mysql_query("select * from categorie where id='$sql[categorie_id]'"));
echo '<hr>';
echo '<br>';
echo 'title : '.$sql['book_title'];
echo '<br>';
echo 'categorie : '.$row['title'];
echo '<br>';
echo 'author name : '.$sql['author_name'];
echo '<br>';
echo 'date of add : '.$sql['date_of_add'];
echo '<br>';
echo 'views = '.$sql['views'];
echo '<br>';
echo '<a href="booksfiles/'.$sql['book'].'">download from her</a>';
include('disconnect.php');
?>