sql server - php script enters duplicate data in database -

-

i have php script runs stored procedure sql server , enters data in table present in database. when run php script enters duplicate date same data present in database. need rid of these duplicate data. stored procedure gives me correct output php script troubling me

     while ($obj = sqlsrv_fetch_array( $stmt, sqlsrv_fetch_assoc  )) {       if($obj['bank_name']!= $obj['bank_name_old'])             {                    $obj['company_code'];              $obj['account_code'];             $obj['bank_name'];              $obj['bank_name_old'];             $obj['field_name']='bank name';               if($obj['field_name']='bank name')             {                    $old=$obj['bank_name_old'];                      $new=$obj['bank_name'];              }                     $query="insert vns_db.dbo.client_details_log (company_code,client_id,field_name,original_value,new_value) values ('".$obj['company_code']."',                             '".$obj['account_code']."','".$obj['field_name']."','$old','$new')";                                 $res = sqlsrv_query($conn,$query);                             //$obj['modified_fields']=$obj['field_name'].'|'.addslashes('$old').'|'.addslashes('$new');                          //  echo $query;             }            if($obj['bank_acno'] != $obj['bank_acno_old'])             {                      $obj['company_code'];                       $obj['account_code'];                      $obj['bank_acno'];                       $obj['bank_acno_old'];                      $obj['field_name']='bank account number';                          if($obj['field_name']='bank account number')             {                        $old=$obj['bank_acno_old'];                      $new=$obj['bank_acno'];                      }                      $query="insert vns_db.dbo.client_details_log (company_code,client_id,field_name,original_value,new_value) values ('".$obj['company_code']."',                             '".$obj['account_code']."','".$obj['field_name']."','$old','$new')";                              $res = sqlsrv_query($conn,$query);                             //$obj['modified_fields']=$obj['field_name'].'|'.addslashes('$old').'|'.addslashes('$new');                             //echo $query;              }

there possibility of execution of both if conditions in loop:

if($obj['bank_name']!= $obj['bank_name_old'])

and

if($obj['bank_acno'] != $obj['bank_acno_old'])

this might run insertion 2 times tryout :)


Comments

Post a Comment

Popular posts from this blog

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

-
Image
i created own android project , cut , pasted code exercise: http://androidexample.com/show_phone_contacts_in_autocomplete_suggestions_-_android_example%20/index.php?view=article_discription&aid=106&aaid=128# when build project no errors or warnings. when run project window error: annoyingly, can't make window smaller, can't click of buttons. cick 'x' @ top, close it. here's project structure: where getting 'autocompletemain' from? (note small c) class named autocompletemain. help. and have activity included in android manifest, in case you're wondering: <?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.androidexample.autocompleteedittext" android:versioncode="1" android:versionname="1.0" > <uses-permission android:name="android.permission.read_phone_state...
Read more

Making Empty C++ Project: General exception (Exception from HRESULT:0x80131500) Visual Studio Community 2015 -

-
i'm trying make new c++ empty project in visual studio community 2015. however, hit okay, tells me 1 or more errors have occured, , general exception (exception hresult:0x80131500). i've been trying online other results, none have helped far , wondering if here knew how fix it. i've tried re installing , tried windows ultimate 2013 , i'd still unable make empty project. in case stopped working when i've tried switch solution "debug" "release" configuration. after vs started fail load projects or create new ones message have mentioned (exception hresult:0x80131500). what did trying create new c# project on have got more clear , useful message, saying vs 2015 can not open following file: c\programfiles(x86)\msbuild\14.0\bin\microsoft.common.currentversion.targets when have checked file have found corrupted in weird way - size of file same original 80% of file garbage. after have downloaded original file microsoft reference so...
Read more

How to fix java warning for "The value of the local variable is not used " -

-
how avoid java warning says the value of local variable not used for variable declared private ? you have multiple choices: remove field. unused, shouldn't there. comment out field, e.g. using // todo temporary hiding of warning until write code using field. suppress warning using @suppresswarnings("unused") . disable warning in ide settings. eclipse, in window > preferences java > compiler > error/warnings unnecessary code > unused private member select option ignore for #3 , #4, though, although can, why want to?
Read more