# Connect to the database pg_connect("") or die("Could not connect to database... " . pg_last_error($db) . "\n"); # Foreach username, lookup their application and try to report it to banner foreach ($usernames as $username) { echo "Looking up application for: {$username}..."; $result = pg_query("SELECT * from hms_application WHERE hms_student_id ILIKE '{$username}' AND term=" . CURR_TERM); if (!$result) { echo "\nAn error occured looking up appliction for {$username}: " . pg_last_error($db) . "\n"; exit; } if (sizeof($result) > 1) { echo "Multiple applications returned, skipping.\n"; continue; } if (sizeof($result) <= 0) { echo "No application found, skipping.\n"; continue; } # Get the application from the database $row = pg_fetch_assoc($result); # Actually try to report it to Banner $plan_meal = HMS_SOAP::get_plan_meal_codes($username, 'BLAH_DORM', $row['meal_option']); $banner_result = HMS_SOAP::report_application_received($username, CURR_TERM, $plan_meal['plan'], $plan_meal['meal']); if ($banner_result !== 0) { print_r($banner_result); echo "Banner error: {$banner_result}\n"; } else { echo "Reported.\n"; } } pg_close($db);