For LARGE datasets, CSV or tab-delimited transfers are probably going to be easiest to suck in to the DB. Another option is to just use pg_dump, if you want whole tables. Otherwise, honestly, I'd suggest you just export your data to RSS or XML and let the user choose how to open it up. Even CSV export is better than PHP arrays, since they can open the stuff up in Excel if they want to. On Wed, August 16, 2006 6:00 pm, Michelle Konzack wrote: > 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) > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
