<?php
// Database
$servername = "";
$username = "";
$password = "";
$dbname = "";

/*
// Write to DB
$form = $_POST;
$teamname = $form['teamname'];
$player1 = $form['player1'];
$player2 = $form['player2'];
$player3 = $form['player3'];
$player4 = $form['player4'];
$player5 = $form['player5'];
$sub1 = $form['sub1'];
$sub2 = $form['sub2'];
$leadersteamid = $form['leadersteamid'];
$teamlogo = $form['teamlogo'];
*/

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// SQL to create table
$sql = "CREATE TABLE Tournament1 (
	id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	teamname VARCHAR(20) NOT NULL,
	teamlogo VARCHAR(30) NOT NULL,
	player1 VARCHAR(30) NOT NULL,
	player2 VARCHAR(30) NOT NULL,
	player3 VARCHAR(30) NOT NULL,
	player4 VARCHAR(30) NOT NULL,
	player5 VARCHAR(30) NOT NULL,
	sub1 VARCHAR(30) NOT NULL,
	sub2 VARCHAR(30) NOT NULL,
	reg_date TIMESTAMP
	)";

if ($conn->query($sql) === TRUE) {
	echo "Table Tournament1 successfully";
} else {
	echo "Error creating table: " . $conn->error;
}

$conn->close();
?>