Order Importer - Notification Page

<?php

 

if($_GET["OrderIDString"] != "")

{

 //get posted OrderID's into a variable

 $OrderIDStrings = $_POST["OrderIDString"];

 

 //connect to database

 $db_connection = new COM("ADODB.Connection");        

 $db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("SageDemoData.mdb") ." ;DefaultDir=". realpath(".");

 $db_connection->open($db_connstr);

 

 //Execute the update SQL

 $db_connection->execute("UPDATE Orders SET ExportedToSage=1 WHERE OrderID IN($OrderIDStrings)");

 

 //disconnect from database

 $db_connection->Close();

}

 

?>