<?php
	$connect = mysqli_connect('127.0.0.1', 'root', '');

	if(!$connect) {
		echo 'Not connected to server';
	}

	if(!mysqli_select_db($connect, 'scanthiscar')) {
		echo 'Database not selected';
	}

	// dodaj ID
	$make = $_POST['car-make'];
	$model = $_POST['car-model'];
	$year = $_POST['car-year'];
	$price = $_POST['car-price'];
	$miles = $_POST['car-miles'];
	$petrol = $_POST['car-petrol'];
	$vin = $_POST['car-vin'];
	$link = $_POST['car-link'];
	$localization = $_POST['car-localization'];

	$sql = "INSERT INTO single_car (make, model, year, price, miles, petrol, vin, link, localization) VALUES ('$make', '$model', '$year', '$price', '$miles', '$petrol', '$vin', '$link', '$localization')";

	if (!mysqli_query($connect, $sql)) {
		echo 'Not inserted';
	}
	else {
		echo 'Inserted';
	}

	header('Location: ../index.php');
	exit;

?>