Forum Moderators: open

Message Too Old, No Replies

PHP and MySQL

         

tonynoriega

3:30 pm on May 4, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I have a server that uses PHP 5.1.6 and MySQL 5.0.27.

I am going to create a simple dbase with 20 fields, that my agents are going to enter data for leads. simple. ive done this before on a simple scale.

What they want for the future is to be able to create a PDF document, for instance, and have it upload to the SQL server for storage.

Then i will create a web form, to query this information and display, for instance, the PDF document.

Is that going to require more than just some PHP to do all of this....

I am not sure what is involved into document storage.

thansk

jatar_k

3:36 pm on May 4, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I wouldn't actually store the document itself in the database. I think it is better to store the file in a directory and just store the path to the file in the database.

drooh

4:55 am on May 5, 2007 (gmt 0)

10+ Year Member



are you set on having the document stored in the db?

alternatively you could have a form that uploaded the doc to a specified folder and at the same time a SQL query that marked the location (url) of that upload. make sense?

then you would probably need a php generated page that would list out the doc name and the link/path to it.