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