CODEWITHSUNDEEP
phpsql-server
Ani
Ani

Reputation: 11

Insert query with sqlsrv

When i try to insert a value in my database it returns me no error but it inserts me nothing, on sql server it works perfectly.

<?php
$serverName = "12.15.88.81";
$connectionInfo = array( "Database"=>"Dcs", "UID"=>"sa", "PWD"=>"123456");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
    die( print_r( sqlsrv_errors(), true ));

}
if ( sqlsrv_begin_transaction( $conn ) === false ) {
     die( print_r( sqlsrv_errors(), true ));
}
$sql = "INSERT INTO [dbo].[Dcs_name] (ID,NAME) VALUES (?,?)";
$params = array('11','Ani');
$stmt = sqlsrv_query( $conn, $sql, $params);



$stmt = sqlsrv_query( $conn, $sql, $params);

if( $stmt === false ) {
    if( ($errors = sqlsrv_errors() ) != null) {
        foreach( $errors as $error ) {
            echo "SQLSTATE: ".$error[ 'SQLSTATE']."<br />";
            echo "code: ".$error[ 'code']."<br />";
            echo "message: ".$error[ 'message']."<br />";
        }
    }
}

?>

Upvotes: 0

Views: 907

Answers (1)

Ani
Ani

Reputation: 11

you're right I added commit and it works thank you so much.

if( $stmt ) {
     sqlsrv_commit( $conn );
     echo "Transaction committed.<br />";
} else {
     sqlsrv_rollback( $conn );
     echo "Transaction rolled back.<br />";
}

Upvotes: 1

Related Questions