สอบถามวิธีบันทึกค่า array ลงฐานข้อมูลครับ ลองมาเยอะแล้วก็ยังบันทึกได้แค่ค่าแรกค่าเดียว

<?php
session_start();
include '../include/condb.php';

for($i=0;$i<count($_POST["txtMedName"]);$i++){

$sql = "INSERT INTO Medical (Name, UOM, Price, MedicalTypeID, SupplierID, CreateDateTime, CreateByUser)"
        . "VALUES ('".$_POST["txtMedName"][$i]."',"
        ." '".$_POST["txtUOM"][$i]."',"
        ." '".$_POST["txtPrice"][$i]."',"
        ." '".$_POST["txtMedType"][$i]."',"
        ." '".$_POST["txtSupplier"][$i]."',"
        ." NOW(),"
        ." '$_SESSION[Username]')";

if ($conn->query($sql) === TRUE) {
    header( "location:  ../stock.php" );
 	exit(0);
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

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

<?php
session_start();
include'include/condb.php';
foreach($_POST['txtMedName'] as $key=>$val){
	$sql = "INSERT INTO Medical (Name, UOM, Price, MedicalTypeID, SupplierID, CreateDateTime, CreateByUser)"
	        . "VALUES ('".$_POST["txtMedName"][$key]."',"
	        ." '".$_POST["txtUOM"][$key]."',"
	        ." '".$_POST["txtPrice"][$key]."',"
	        ." '".$_POST["txtMedType"][$key]."',"
	        ." '".$_POST["txtSupplier"][$key]."',"
	        ." NOW(),"
	        ." '$_SESSION[Username]')";

	if ($conn->query($sql) === TRUE) {
		echo 'save success';
	    //header( "location:  ../stock.php" );
	 	exit(0);
	} else {
	    echo "Error: " . $sql . "<br>" . $conn->error;
	}

}
$conn->close();
?>