pdf path

mungpatta

I built a site for a library. with books as a pdf files. The pdfs are stored on the root floder to prevent people from downloading the entire library.
i like to store file path on mySQL and echo file form there can any one help me with path i tryed but it did not work
Src="http://abc/images/the_eagle.pdf"width="275" />

dagon

if they are stored outside of the web root then you can't access them directly via http; that's why i assumed you did it to protect direct linking. so to link to the files you have to do so via a web script.

mungpatta

thax for ur replay back

no books are store in web root i dont mind if any one access them directly i just dont know much about PHP so not sure how to display them

dagon

then your not really protecting them, anyway the url would just be
http://site/file

mungpatta

i did try that way but it just show the path when i echo it and the book

dagon

mungpatta;10976728 wrote:
i did try that way but it just show the path when i echo it and the book

don't really understand, what's the full code your using and what's the result?

mungpatta

<?php

$link = mysql_connect('********', '****', '*********');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db(urduworld);

if(isset($GET['id'])){
$id = $GET['id'];
} else {
$id=1;
}

$books_sql = "SELECT * FROM books WHERE id=$id";
$books_query = mysql_query($books_sql) or die(mysql_error());
$rsbooks = mysql_fetch_assoc($books_query);

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $rsbooks['name']; ?></title>
<link rel="stylesheet" type="text/css" href="css_layout/styles.css" />
</head>

i am trying to display PDF book on web page

dagon

browser don't understand pdf format, you need to link to the pdf and let the client's machine handle it how it will.

mungpatta

can u plz point me how i can do that plz i am working on it for last 2 days i am really stuck thax for all your help Dagon

dagon

<a href="<?php echo $rsbooks[url']; ?>" >click to read</a>