I am trying to call a stored procedure named RunRefresh. There are no paramaters.
When I run exec RunRefresh, a table is refreshed. Nothing is displayed or changed on the php page.
I have tried:
<?php
include('php/SessionSetup.php');
if(isset($_POST['submit']))
{
sqlsrv_execute( $conn, runrefresh);
echo "Done!";
} else {
// display the form
?>
<form action="" method="post">
<input type="submit" name="submit" value="DO IT!">
</form>
<?php
}
?>
-------------------------------------------------------------------------------------------------------------------
The procedure does not appear to run.
the include('php/SessionSetup.php');
contains the statement
include('queries/ConnIris.php');
-------------------------------------------------------------------------------------------------------------------
ConnIris is
$serverName = "(local)";
$connectionInfo = array("UID" => "username", "PWD" => "xxx", "Database"=>"MyDb");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
-------------------------------------------------------------------------------------------------------------------
I am using IIS (if that makes a difference)