Jump to content

Run stored procedure to refresh tables


scamquist

Recommended Posts

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)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.