include 'config.php';

function connectDb() {
	global $db;
	$conn = mysqli_connect(
                    $db['host'],
                    $db['user'],
                    $db['pass'],
                    $db['name'],
                    $db['port']
                    );
	if(!$conn) {
		die('Hiba! A kapcsolódás sikertelen: ' .
		mysqli_connect_error());
	}
	return $conn;
}

function closeDb($conn) {
	mysqli_close($conn);
}

function createTable($conn) {
	$sql = <<<EOT
		create table if not exists test01 (
		title varchar(150),
		bodytext text,
		created varchar(100)
	)
EOT;	
	return mysqli_query($conn, $sql);
}

function getDatas($conn) {
	$sql = 'select * from test01';
	$res = mysqli_query($conn, $sql);
	$datas = array();
	while($row = mysqli_fetch_assoc($res)) {
		array_push($datas, array($row['id'], $row['vmi']));
	}
	return $datas;
}