Re: Validate CSV file With Table in Database!!
| From: | Coenraad Steenkamp | Date: | Thu, 13 Sep 2001 07:57:15 +0000 |
| Subject: | Re: Validate CSV file With Table in Database!! | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67157@lists.php.net to get a copy of this message | ||
This is the code i came up with! But it is not 100%
<?php
if (isset($Submit)) {
// File is uploaded
if ($uFile <> "") {
if (!copy($uFile, $move_to_dir."/".$uFile_name)) {
echo "No File Uploaded";
}
$curr = fopen($move_to_dir."/".$uFile_name, "r");
while ($currar = fgetcsv($curr, 1000, ",")) {
$CurrCode = $currar[0];
$Currency = $currar[1];
$From1 = $currar[2];
$To1 = $currar[3];
$ROEX = $currar[4];
$sqlcurr="SELECT * FROM CurrencyNetwork WHERE CNCurr =
'$Currency'";
$result = mysql_query($sqlcurr,$db_con);
if (mysql_fetch_array($result)) {
//Do Nothing
} else {
$sql="INSERT INTO CurrencyNetwork
(CNCode,CNCurr,CNAdBy,CNDtAd,CNROEX)
values ('$CurrCode', '$Currency', '$From1',
'$To1',
'$ROEX')";
mysql_query($sql,$db_con);
}
}
mysql_close($db_con);
}
}
else
{
// No file uploaded, show the form
echo "<div align='center'>";
echo "Upload this file: <input name='uFile' type='file'>";
echo "<input type='submit' name='Submit'
value='Upload'>";
echo "</div>";
}
?>
"David Robley" <huntsman@www.nisu.flinders.edu.au> wrote in message
news:01091317241109.14360@www...
> On Thu, 13 Sep 2001 16:52, you wrote:
> > There is a very good reason !
> > The csv file contains world currency's
> > The system is updated with the changed currency's only !
> > The Master field contains all country currency's , this makes it
> > difficult because if i drop the master table and upload the csv there
> > will only be a few currency's!
> >
> > Thanks
> > Coenraad Steenkamp
> >
> >
> > ----- Original Message -----
> > From: "David Robley" <huntsman@www.nisu.flinders.edu.au>
> > Newsgroups: php.general
> > To: "Coenraad Steenkamp" <coenraad@webserv.co.za>;
> > <php-general@lists.php.net>
> > Sent: Thursday, September 13, 2001 9:18 AM
> > Subject: Re: [PHP] Validate CSV file With Table in Database!!
> >
> > > On Thu, 13 Sep 2001 16:37, Coenraad Steenkamp wrote:
> > > > I need to compare a csv file to a table in the database but only
> > > > one field in the database with
> > > > one field in the CSV file! Comparing only one field will make it
> > > > much easier! When there is any change in the Database compared to
> > > > the CSV file , the database must then be updated or if there are no
> > > > such a field it must be added to the table!
> > > >
> > > > I am new in php Please help!
> > >
> > > That seems an awful lot of work, if you know that the csv is at least
> > > as up to date, if not more so, than the actual table. You might as
> > > well just drop the table and import the contents of the csv.
> > >
> > > Unless there's a good reason not to that you haven't mentioned?
>
> OK. So it sounds like you need to do something like:
>
> for each csv file line
> select record where table_key = csvfield_key
> if record found
> if table_other_value != csv_other_value
> update table with csv_value
> end if
> else (record not found)
> insert new record
> end if
> end for
>
> where the key might be perhaps the country name and the other value is
> the current currency.
>
> Am I on the right track? Does that help you any?
>
> --
> David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
> CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
>
> I am functioning within established parameters.