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(); }
?> |