array( "Back to policies" => "policy-main.php", "Back to members" => "policy-member-main.php?policy_id=".$_REQUEST['policy_id'], ), )); # Display change screen if ($_POST['frmaction'] == "change") { # Check a policy member was selected if (isset($_POST['policy_member_id'])) { # Prepare statement $stmt = $db->prepare("SELECT ID, Source, Destination, Comment, Disabled FROM ${DB_TABLE_PREFIX}policy_members WHERE ID = ?"); $res = $stmt->execute(array($_POST['policy_member_id'])); $row = $stmt->fetchObject(); $stmt->closeCursor(); ?>

Update Policy Member

Old Value New Value
Source source ?>
Destination destination ?>
Comment comment ?>
Disabled disabled ? 'yes' : 'no' ?>

No policy selected

Policy Update Results

quote($_POST['policy_member_source'])); } if (isset($_POST['policy_member_destination']) && $_POST['policy_member_destination'] != "") { array_push($updates,"Destination = ".$db->quote($_POST['policy_member_destination'])); } if (!empty($_POST['policy_member_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['policy_member_comment'])); } if (isset($_POST['policy_member_disabled']) && $_POST['policy_member_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['policy_member_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}policy_members SET $updateStr WHERE ID = ".$db->quote($_POST['policy_member_id'])); if ($res) { ?>
Policy member updated
Error updating policy member!
errorInfo()) ?>
No policy member updates
No policy member data available
Invalid invocation