How to insert data in a mysql database using a html form

<form id="form1" name="form1" method="post" action="includes/facilityProjectIndex.php">
<label for="name_of_facility">Name Of Facility</label><input type="text" name="name_of_facility" id="name_of_facility" />
<br class="clear" /> 
<label for="location">Location</label><input type="text" name="location" id="location" />
<br class="clear" /> 
<label for="responsible_organisation">Responsible Organisation</label><input type="text" name="responsible_organisation" id="responsible_organisation" />
<br class="clear" /> 
<input type="submit" name="Submit" id="Submit" value="Submit" />
<br class="clear" /> 
</form>

<?php //Facility index file that sends data from the form to the database 
	

include 'connection.php';
	
	// Assigning Variables
	$name = $_POST['name_of_facility'];
	$location = $_POST['location'];
	$responorg = $_POST['responsible_organisation'];	
	
	// Variable that executes request to send data to database 
	$sql = "INSERT INTO facilities (name_of_facility,location,responsible_organisation)
			VALUES('$name','$location','$responorg')";
	
	// Statement stating whether the execution is successful 
	if (!mysqli_query ($link,$sql)){
		die ('Error: ' . mysqli_error($link));
	} 
	else 
		echo ('Entry successfully submitted');
?>