peletelitan wrote:Hello, I am using Xampp for my DBMS.
No you aren't. :p The XAMPP project is basically nothing more than a bundle of a few different software packages (e.g. Apache, PHP, MySQL, phpMyAdmin)
peletelitan wrote: Do I physically put the pdf files in the database table? (if so, how do I do this?)
I personally wouldn't, simply because I think that the filesystem should be left to do what it does best (manage files) and let a DBMS such as MySQL do what it does best (index information and maintain relations).
If you wanted to, however, you can indeed store raw binary information in a MySQL column - see the MySQL manual page for the BLOB column type.
peletelitan wrote:do I generate a link of existing files in the website root? (Again, how?)
You could either do that (see the PHP manual page for [man]glob/man to search for all PDF files in a given directory), or you could store the metadata for each PDF document (e.g. title, filename and/or file path, last upload/modified/etc. date, etc. etc.) and instead query the DB for a list of files and related information. One downside to the latter method is the issue of keeping the DB and filesystem in sync.
peletelitan wrote: I would really like to know how to have the pdf file come directly out of the database table
Any particular reason(s) why?
EDIT: sigh second time this morning Nog's beaten me to it. Maybe we should coordinate our replies from now on? :p
