Downloading of PgSQL data for use local (crappy subject line)
| From: | Michelle Konzack | Date: | Wed, 16 Aug 2006 23:00:42 +0000 |
| Subject: | Downloading of PgSQL data for use local (crappy subject line) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-240860@lists.php.net to get a copy of this message | ||
Hello,
I have: 1) PostgreSQL 7.4/8.1
2) PHP5
3) Apache 1.3
The client have 1) A web browser
2) PHP4/5
3) PostgreSQL X.XX
The clients can surf my website/database and collect data for
Off-Line working, exactly, I want, that they can download a
file containing the requested data and importing it into there
local database using a http://localhost/ Intranet Interface.
Since $USER is generaly not a Geek/Nerd/Freek or something like
this all must be done easyly...
Now my question:
What is the best format to transfer such data?
I was thinking, that I create from each $ROW selected from the
Database a PHP.include which contain the data in a array
array[serno]="....";
array[foo]="...";
array[bar]="...";
which then can be imported and read from a PHP script.
Additonaly I want to encrypt (the $USER must upload his/her public
GPG key) this file because some of the "stupid" $USER can lost one
(should not, but it allredy happen).
Any suggestions?
Greetings
Michelle Konzack
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)