Unable to insert data into database using php script

Question

I am using Sql server 2012 procedure to execute using php and the result should be store into table on sql server only. I am facing this issue, I can fetch the data from php code but when i insert that data into table only one value is inserted.I can see different values on my screen when i run php script.but back to data base only first value is inserted. I am not getting where i am going wrong. please help me with this. Thanks in advance.

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 into 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')".'<br>'; 
                            $res = sqlsrv_query($conn,$query);
                            echo $res;
                            echo $query;
            }

this is php script output

enter image description here

remove .'<br>' from $query variable

Chetan Ameta
– Chetan Ameta

2016-01-20 05:35:33 +00:00
Commented Jan 20, 2016 at 5:35 — Chetan Ameta
– Chetan Ameta, Commented Jan 20, 2016 at 5:35

Gerald Schneider · Accepted Answer · 2016-01-20 11:12:41Z

1

Remove the .'<br>' from your query. It's a HTML line break, SQL can't handle it.

You can always use sqlsrv_errors() to check for errors if a query doesn't work as intended:

$res = sqlsrv_query($conn,$query);
if ( $res === false ) {
  echo "Error in SQL query:";
  var_dump( sqlsrv_errors() );
}

edited Jan 20, 2016 at 11:12

answered Jan 20, 2016 at 5:36

Gerald Schneider

17.8k10 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to insert data into database using php script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related