[sylunt1]

Hello.

I have been doing manual entry of items one at a time thru phpmyadmin and it's beginning to become tedious. What I want to do is this:

I have a huge list of items that I want to put into a table. For security reasons, I can not import the text file directly into mysql. Is there a way to do this with php? I pretty much know that it can be done, just how to do it is the question.

Thanks,
Chris

www.brew-monkey.com

[nd2]

the format of the text file whould help greatly.

[sylunt1]

Originally Posted by nd2

the format of the text file whould help greatly.

There are 3 fields...
id countryabv country

I can format it how ever but now its just a list

the ID field should be set to null correct - to get the auto increment to do its job. The other fields are just varchars. They are in an excel file at the moment.



ex:
null AS American Samoa


Thanks.

Chris

[tltran]

Originally Posted by sylunt1

There are 3 fields...
id countryabv country

I can format it how ever but now its just a list

the ID field should be set to null correct - to get the auto increment to do its job. The other fields are just varchars. They are in an excel file at the moment.



ex:
null AS American Samoa


Thanks.

Chris

Can you give us more details about your files,

Like

File 1 content:
1;Canada;America;
2;USA;America;
3;China;Asia;
4;France;Europe;

If so we can help you to create a script to read your text file and import your data into a database, otherwise we wont be able to help you.

[tltran]

suppose your data are store in a file with the following format

file1.txt
NULL;CA;Canada;
2;US;Units-States;

With php and mysql:
First make a simple connexion to your database..
Use the following function to to read a file and insert your data into database.

function importMyData($file_name) {

$t_file = file($file_name); // get data from the file
// for each line of the file do
for ($i=0; $i<count($t_file); $i++) {
$t_line = explode(";",$t_file[$i]);

$sql = "insert into (id, code, name)
values (".$t_line[0].",'". $t_line[1]."','". $t_line[2]."')";
mysql_query($sql,$cnx);
}
}