mysqli.php

			$username = $_POST["uname"];
    	$password = $_POST["pword"];
	
			$con = mysqli_connect("localhost", "student", "", "ryan04");
			
			//check connection
			if (mysqli_connect_errno()) {
				echo "Failed to connect to MySQL: " . mysqli_connect_error();
			} else {
				
				echo "connected <br />";
					
				$sql = "SELECT * FROM users WHERE name='$username'";
					
				$res = mysqli_query($con, $sql);
				$numrows = mysqli_num_rows($res);
					
				if ($numrows == 0) {
			
					$sql = "INSERT INTO users VALUES ('$username', '$password')";
			
					mysqli_query($con, $sql);
			
					$form .= "User successfully created.<br />";
					$form .= "<a href='login.php'>Click here to go to login</a>";
			
				} else {
			
					$form .= "<p>User already exists, please try another Username.</p>";
					$form .= displayForm();
			
				}
			
			}