Inserting Array into MySQL

[Adamhumbug]

I have created an array that gets passed to php through ajax.

case 'createNewGame':
			exit(createNewGame($_POST['venue'], $_POST['gamedate'], $_POST['home'], $_POST['away'], $_POST['hts']));
		break;

hts is the array

i tried to insert this way

function createNewGame($venue, $gamedate, $home, $away, $homeSquad){

$qry = "INSERT INTO game_squad (game_id, player_id) VALUES (?,?)";
	$stmt = $conn->prepare($qry);
	
	for($i = 0; $i < count($homeSquad); $i++){
		$stmt->bind_param('ii', $gameID, $homeSquad[$i]);
		$stmt -> execute();
	}
}

there is more going on in here with the other variables.

When i console log the array before it is passed into php i can confirm i am getting an array:

Array [ "20", "21" ]

A point in the right direction here would be appreciated.

[Adamhumbug]

Turns out that i have solved this one myself also, the issue was that i was passing a string in the array and not integers.  When i changed the data type to 'is' rather than 'ii' the insert worked.