MySQL Forums
Forum List  »  Newbie

Need help ASAP with data uploading...
Posted by: Josh Ziman
Date: April 15, 2005 08:05PM

I just finished my first site using php/mysql and now its time to upload the data. This is the email I sent to the author of PHP MySQL for Dummies asking for help, but she has no experience with phpMyAdmin so she couldnt help. What about yall?

**********************************************
Hi, I am a web designer, now learning PHP. I just
finished up a site using PHP but now I'm trying to
figure out how to get all this data into the database.
Right now I'm simply working with two columns,
loginName and password. The tablename is Member. There
a bit over 100 rows of data so upload seems to be the
only reasonable way to input the data. For testing
purposes I have a text file that reads...

JoshZiman<tab>josh123

(JoshZiman being in the loginName and josh123 as the
password)

Your book, PHP MySQL for Dummies, says to use the SQL
query:

LOAD DATA LOCAL INFILE "pets" INTO TABLE Pet;

My text file is named test.txt and table name is
Member
What would the query be? I have tried a million things
to replace "pets" like test.txt ,
C:\WINDOWS\Profiles\Josh\My Documents\test.txt nothing
is working.


There is also the link on the phpMyAdmin that reads
"Insert data from a textfile into table" I click it
and get a form that looks like attachment1. Please
tell me how I am filling it out wrong because after I
submit, the data that is submitted ends up having
"JoshZiman josh123" in the loginName field.


Any ideas for either method?

Thanks in advance, Josh Ziman
**********************************

Options: ReplyQuote


Subject
Written By
Posted
Need help ASAP with data uploading...
April 15, 2005 08:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.