<?php
$dbhost = 'localhost';
$dbuser = 'hanze';
$dbpass = '******';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'hanze';
mysql_select_db($dbname);
?>

Then
<?php
include 'connection.php';
insert mysql