Re: Office document upload to website (and inserting in MySQL if possible)

From: Shawn Wilson (shawn_at_glassgiant.com)
Date: 03/09/04


Date: Tue, 09 Mar 2004 09:46:01 -0400


"Pugi!" wrote:
>
> I would like to upload office-document (doc, xls, ...) using a form to a
> website (apache, php, mysql) in a specific directory and if possible insert
> it into a table (MySQL-db). Is this possible. If yes, how ? You don't have
> to explain it in detail, a link to a website or online manual or example is
> fine.

Handling file uploads:
http://ca2.php.net/features.file-upload

To get the whole think into a database, you'd use the file and mysql commands,
but the general consensus seems to be don't save binary files in the database
unless you have a really good reason. Could you just keep the file in a non-web
accessable folder and use something like readfile(), possibly in conjunction
with some kind of authentication system?

Regards,
Shawn

-- 
Shawn Wilson
shawn@glassgiant.com
http://www.glassgiant.com


Relevant Pages

  • Re: Requery subforms that dont have a Master/Child relationship
    ... I don't need the forms on the Website. ... I plan a desktop database in Access ... For the Website, use PHP and MySQL. ... I have joined these other tables to tblMain in separate ...
    (microsoft.public.access.formscoding)
  • Re: Executing PHP files on remote web server
    ... We have a commercial web host servicing our external clients, but we don't want to move the entire app and database to the web host because a lot of the data is sensitive. ... By loading the non-sensitive data into the web host's MySQL tables, our external clients can see their reports on the web. ... our web host put a firewall on the MySQL database so we can't insert data into the remote tables directly from the PHP pages running on our own web server. ...
    (comp.lang.php)
  • Database Comparison?
    ... after using it that php is built more than anything to easily sit on ... talking to a mysql database and spitting out html to ... use these things better I've made a rudimentary gui designer and some ...
    (comp.lang.php)
  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... that it will work with an MSAccess MDB file. ... PHP Programmer Guy. ... Except you've just "solved" his issue with a database redesign. ... from MySQL to Access in the first place. ...
    (comp.lang.php)
  • Re: help me
    ... field automatically assign its self a value of the next auto inc number ... I have a mysql database and i have it displaying whats currently there ... using php, the problem is that I cannot insert into the database ...
    (comp.lang.php)