add-users-to-courses.php

<?php
	require '../manager-session.php';
	require '../../db-config.php';
	require '../../distributor-config.php';

	// var_dump($_POST['course'])
	
	if(isset($_POST['course'])) {
		foreach($_POST['course'] as $course) {
			$selected = explode('-', $_POST['course']);
			$coursetitle = $selected[0];
			$username = $selected[1];
			
			$stmt = $conn->prepare("INSERT INTO users_on_courses (useroncourse, course) VALUES (?, ?)");
			$stmt->bind_param("ss", $username, $coursetitle);
			$stmt->execute();
		}
		
		header('location: ../add-users-to-courses.php?page=add-users-to-courses&status=success');
		exit();
	}

	else {
		header('location: ../add-users-to-courses.php?page=add-users-to-courses&status=error');
		exit();
	}

	$stmt->close();
	$conn->close();
?>