how to insert and retrieve a 20mb pdf file from mysql database?
arunpatyal1987 0 Newbie Poster
andydeans 0 Junior Poster
if this is a web app, i would personally store the pdf in a seperate folder and only the document name in the database. i am sure this would be the way without it being web based also.
is it web based?
arunpatyal1987 0 Newbie Poster
yes this is a web app using php,mysql
but i am simply designing a database by phpadmin
mwasif 10 Posting Whiz
andydeans's suggestion is really good.
yes this is a web app using php,mysql
but i am simply designing a database by phpadmin
Are you trying to develop a test site/database?
andydeans 0 Junior Poster
If it is using php/mysql then for definate you want to store the files in a seperate folder on your server. (Possible password protect this directory) then in mysql, create a docs table, store the filename in here and add a docid PK AI just in ase you get the same filename twice.
if you want to store in the database check this out:
http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/uploading-files-to-mysql-database.aspx
if you do not want to store in the database then check this this other thread out:
arunpatyal1987 0 Newbie Poster
Thank u andy.
it's workin.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.