RE: Dynamic data from user file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sean,
Not sure if this helps, but when I developed an in house app for my company
I have to migrate from very messy access db to mysql and I still have to
import once a week from the old db as other people still use it.
I just setup an array with oldtable and newtable then oldfield, newfield
etc. then parse through that array with a loop that inserts the new value
line for line and it works fine for me.
There is possibly a better way of going about it, but this works for me.
Cheers
Simon
 
-----Original Message-----
From: John Patrick [mailto:waprd@comcast.net] 
Sent: 9 October 2002 00:15
To: php-db@lists.php.net
Subject:  Dynamic data from user file


Greetings:
    I currently am using the fgetcsv function to read in fields from a
user-defined file.  The delimited file is read and displayed just fine.

    Firstly, what I'm trying to accomplish:  The MySQL database has a table
with about 30 fields.  The user-defined file may contain only some of these
fields and in no particular order.  I'm trying to achieve a way for the user
to specify what each field is so the insert into MySQL is done correctly.
(An analogy would be a custom import.

    The problem I'm having is finding the best way to go about this.  I've
been able to read in the data via fgetcsv and dynamically displaying a drop
down box above each field with all possible choices but am unable to create
a way to link the two for each field successfully.  Been looking for
solutions as well as trial and error to no avail. Any suggestions? -Sean.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux