Insert_Table_Category.php

<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head>
<body>
<?php
$mysqli = mysqli_connect("127.0.0.1","team07","team07","team07");
if (mysqli_connect_errno()) {
	printf("Connect failed: %s\n", mysqli_connect_error());
	exit();
} else {
	$sql = "INSERT Category(large_category, small_category) SELECT DISTINCT large_category, small_category FROM cloth_info";
	$res = mysqli_query($mysqli,$sql);

	if ($res === TRUE) {
		echo "category information successfully insert";
	} else {
	printf("Could not import data: %s\n", mysqli_error($mysqli));
	}
mysqli_close($mysqli);
}
?>
</body>
</html>