<?php
	
	//Update GS table with data from page 1
	//Get data from POST
	
	$qual = $_POST['qual'];
	$ql = $_POST['qlong'];
	$hci = $_POST['hci'];
	$hciwhen = $_POST['hciwhen'];
	$se = $_POST['se'];
	$sewhen = $_POST['sewhen'];
	$not = $_POST['notations'];
	$sw = $_POST['sw'];
	
    $con = new mysqli("mysql.cms.waikato.ac.nz", "jbowen", "my106710sql", "jbowen");
    
    
    $update = "insert into Students(Qual,QualLength,HCI,HCIWhen,SE,SEWhen,Notations,SWDev) values ('$qual', '$ql','$hci','$hciwhen','$se','$sewhen','$not','$sw')";
	$uresult = mysqli_query($con, $update);
	
	//$id = msqli_insert_id($con);
	$id = $con->insert_id;
    
    echo $id;
    
?>