<?php
	if($_GET['benzinac'] == 'da'){
		echo "Auto je benzinac";
	} else {
		echo "Auto nije benzinac";
	}
	echo "<br>";
	echo "<table border = 1><tr>";
	echo "<td><a href = 'http://www.automobili.hr/stats.php?model=" . $_GET['id']. "'>" . $_GET['id'] . "</a></td>";
	echo "<td>" . $GET_['producer'] . "</td>";
	echo "</tr></table>";
?>


<?php
	mysql_connect("localhost", "root", "vertrigo");
	mysql_select_db("hello_world");
	$queri1 = "SELECT Ammun't FROM korisnik WHERE Username = " . $_GET['user'];
	$queri2 = "SELECT Price, Stock FROM proizvodi WHERE Id = " . $_GET['item'];
	$rez1 = mysql_query(queri1);
	$rez2 = mysql_query(queri2);
	$row1 = mysql_fetch_array($rez1, MYSQL_NUM);
	$row2 = mysql_fetch_array($rez2, MYSQL_NUM);

	if ((row1[0] < $_GET['number'] * row2[0]) || (row2[1] < $_GET['number'])){
		echo "Transakcija je neuspješna";
	} else {
		$queri1 = "UPDATE korisnik SET Ammun't = " . row1[0] - $_GET['number'] * row2[0] . "WHERE Username = " . $_GET['user'];
		$queri2 = "UPDATE proizvodi SET Stock = " . row2[1] - $_GET['number'] . "WHERE Id = " . $_GET['item'];
		$rez1 = mysql_query(queri1);
		$rez2 = mysql_query(queri2);
		echo "Transakcija je uspješna";
	}

	mysql_close();
?>