Re: Validate CSV file With Table in Database!!

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" <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. -- 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.