Executing Sql Server Stored Procedure

Question

My PHP skills are rusty. I am trying to execute a stored procedure with the following code

<?php

    $server = “SQLINSTANCE”;
    $options = array(  "UID" => “uname”,  "PWD" => “password,  "Database" => "HomeSensors");
    $conn = sqlsrv_connect($server, $options);
    if ($conn === false) 
    die("<pre>".print_r(sqlsrv_errors(), true));

    echo "Successfully connected!<br/>";

    $stmt = mssql_init('addSensorData', $conn);


    mssql_bind($stmt, '@Pool',    90,  SQLINT1,     false,  false,  3);
    mssql_bind($stmt, '@Temp',    80,  SQLINT1,     false,  false,  3);

    $proc_result = mssql_execute($stmt);

    if( $proc_result === false) {

        die( print_r( sqlsrv_errors(), true) );
    }

    mssql_free_statement($stmt);


    ?>

When I execute the following, the server response is:

Successfully connected!

But nothing is executed and I don't see any errors. What am I doing wrong?

sqlsrv_connect is from Microsoft SQL Server Driver for PHP (SQLSRV); mssql_execute seems to be from another PHP extension, which seems to be deprecated ("This extension is not available anymore on Windows with PHP 5.3 or later.") — Vladimir Baranov
– Vladimir Baranov, Commented Sep 19, 2015 at 13:34

RomanPerekhrest · Accepted Answer · 2015-09-20 17:33:34Z

1

+50

Use mssql_connect at first.
What kind of result does your procedure have to return(one or many result sets)?
Also try mssql_query instead of mssql_init function.
Approximate approach:

$result = mssql_query("addSensorData Var1, Var2, Var3...");
$arr = mssql_fetch_row($result);

answered Sep 20, 2015 at 17:33

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Executing Sql Server Stored Procedure

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