upload a csv into a database

[Craig Keightley]

I have had a quick look on the net for the above but have found a load of
impressive scripts, all of whic are too over complicated for what i need to
do:

I have a csv file of number plateswith fixed column headings that i want to
be able to upload via a web interface.
Once loaded, i want it to insert the values into a database.

CSV data:

Registration number New style (Y/N) Price Matches
xx123 N 14995.00 match name
the database structure is of similar format

How do i acheive this?

Any help would be grateful
Craig

[Chris Hope]

Craig Keightley wrote:

I have had a quick look on the net for the above but have found a load
of impressive scripts, all of whic are too over complicated for what i
need to do:

I have a csv file of number plateswith fixed column headings that i
want to
be able to upload via a web interface.
Once loaded, i want it to insert the values into a database.

CSV data:

Registration number New style (Y/N) Price Matches
xx123 N 14995.00 match name
the database structure is of similar format

How do i acheive this?

You can use phpMyAdmin (http://phpmyadmin.sourceforge.net) which is a
web based interface to the database. When you view a table's properties
there's an "Insert data from a textfile into table" option at the
bottom of the page which lets you specify all sort of parameters about
the file you are to import.

From the command line there's the mysqlimport utility.

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Sacs]

Craig Keightley wrote:

I have had a quick look on the net for the above but have found a load of
impressive scripts, all of whic are too over complicated for what i need to
do:

I have a csv file of number plateswith fixed column headings that i want to
be able to upload via a web interface.
Once loaded, i want it to insert the values into a database.

CSV data:

Registration number New style (Y/N) Price Matches
xx123 N 14995.00 match name
the database structure is of similar format

How do i acheive this?

Any help would be grateful
Craig

Upload the file, fopen it then use fgetcsv to read through the file line
by line and create an array of all the columns. Insert those into the
database. et voila.

http://www.php.net/manual/en/function.fgetcsv.php

Sacs

[Craig Keightley]

Thanks but I know about phpMyAdmin and use it on a daily basis. This will be
for a client of mine (needs to be idiot proof) who will upload there own csv
files

Thanks anyway though

Craig
"Chris Hope" <bl*******@electrictoolbox.com> wrote in message
news:11**************@216.128.74.129...

Craig Keightley wrote:

I have had a quick look on the net for the above but have found a load
of impressive scripts, all of whic are too over complicated for what i
need to do:

I have a csv file of number plateswith fixed column headings that i
want to
be able to upload via a web interface.
Once loaded, i want it to insert the values into a database.

CSV data:

Registration number New style (Y/N) Price Matches
xx123 N 14995.00 match name
the database structure is of similar format

How do i acheive this?

You can use phpMyAdmin (http://phpmyadmin.sourceforge.net) which is a
web based interface to the database. When you view a table's properties
there's an "Insert data from a textfile into table" option at the
bottom of the page which lets you specify all sort of parameters about
the file you are to import.

From the command line there's the mysqlimport utility.

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[R. Rajesh Jeba Anbiah]

"Craig Keightley" <do**@spam.me> wrote in message news:<41***********************@news-text.dial.pipex.com>...

I have had a quick look on the net for the above but have found a load of
impressive scripts, all of whic are too over complicated for what i need to
do:

I have a csv file of number plateswith fixed column headings that i want to
be able to upload via a web interface.
Once loaded, i want it to insert the values into a database.

CSV data:

Registration number New style (Y/N) Price Matches
xx123 N 14995.00 match name

LOAD DATA INFILE <http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html>
Look at comment #4964

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com

[Craig Keightley]

Thats a great way. I knew from looking at the code generated by phpmy admin,
it was along these lines but this works great

Thanks to all

craig
"R. Rajesh Jeba Anbiah" <ng**********@rediffmail.com> wrote in message
news:ab**************************@posting.google.c om...

"Craig Keightley" <do**@spam.me> wrote in message
news:<41***********************@news-text.dial.pipex.com>...

I have had a quick look on the net for the above but have found a load of
impressive scripts, all of whic are too over complicated for what i need
to
do:

I have a csv file of number plateswith fixed column headings that i want
to
be able to upload via a web interface.
Once loaded, i want it to insert the values into a database.

CSV data:

Registration number New style (Y/N) Price Matches
xx123 N 14995.00 match name

LOAD DATA INFILE <http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html>
Look at comment #4964

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com