Re: [PHP] Validate CSV file With Table in Database!!
Sorry - pressed send w/out writing anything. Topic followed up direct with problem owner. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA There are 2 ways to handle women and I know neither. -- 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]
Re: [PHP] 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% > 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 ""; > echo "Upload this file: "; > echo ""; > echo ""; > } > ?> > > > > "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]
Re: [PHP] Validate CSV file With Table in Database!!
This is the code i came up with! But it is not 100% "") { 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 ""; echo "Upload this file: "; echo ""; echo ""; } ?> "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. -- 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]
Re: [PHP] Validate CSV file With Table in Database!!
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. -- 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]
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? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Birds are trapped by their feet, people by their tongues. -- 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]