On Thu, 13 Sep 2001 17:27, Coenraad Steenkamp wrote:
> 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" <[EMAIL PROTECTED]> wrote in message
> 01091317241109.14360@www">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" <[EMAIL PROTECTED]>
> > > Newsgroups: php.general
> > > To: "Coenraad Steenkamp" <[EMAIL PROTECTED]>;
> > > <[EMAIL PROTECTED]>
> > > 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.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
A cat will go "quack" - if you squeeze it hard enough.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
