<?php
	$servername = "127.0.0.1";
	$username = "root";
	$password = "";
	$dbname = "kontr";

	// Create connection
	$conn = new mysqli($servername, $username, $password, $dbname);
	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);

	}

	// sql to create table
	$sql = "CREATE TABLE IF NOT EXISTS books (
		isbn INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
		title VARCHAR(30),
		published_year date,
		genre VARCHAR(50),
		author VARCHAR(50)
	)";

	if ($conn->query($sql)) {
		//echo "Table books created successfully";
	} else {
		//echo "Error creating table: " . $conn->error;
	}

	if(isset($_GET['add'])){

	}

	if(isset($_GET['search'])){

	}

	if(isset($_GET['change'])){

	}

	if(isset($_GET['sort'])){

	}

$conn->close();

?>
<h2>Add book</h2>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>">
	<label for="t" >Title</label>
	<input id="t" type="text" name="title"></input>
	<label for="p" >Pulished Year</label>
	<input id="p" type="date" name="published_year"></input>
	<label for="g" >Genre</label>
	<input id="g" type="text" name="genre"></input>
	<label for="a" >Author</label>
	<input id="a" type="text" name="author"></input>
	<button type="submit" name="add">add</button>
</form>
<h2>Get book by Genre</h2>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>">
	<label for="gs">Genre</label>
	<input id="gs" type="text" name="genre"></input>
	<button type="submit" name="search">search</button>
</form>
<h2>Change book Title</h2>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>">
	<label for="i" >ISDN</label>
	<input id="i" type="number" name="isdn"></input>
	<label for="ti" >Title</label>
	<input id="ti" type="text" name="title"></input>
	<button type="submit" name="change">change</button>
</form>
<h2>Sort book by Author</h2>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>">
	<button type="submit" name="sort">sort</button>
</form>