pretraga.php

<?php

if(isset($_POST['pretraga']))

	$pretraga = $_POST['pretraga'];
	$opcija = $_POST['opcija'];

	$connect = mysqli_connect("localhost", "root", "", "ispit1");
	$query = '';

	if($opcija == '1')
	{
		$query = 'SELECT * FROM ZAPOSLENI WHERE RADNO_MESTP = ' . $pretraga;
	}

	if($opcija == '2')
	{
		$query = 'SELECT * FROM ZAPOSLENI WHERE PLATA > ' . $pretraga;
	}

	if($opcija == '3')
	{
		$query = 'SELECT * FROM ZAPOSLENI WHERE PLATA < ' . $pretraga;
	}

	$result = mysqli_query($connect, $query);

	if($result && mysqli_num_rows($result) > 0)
	{

		?>

		<table>

		<?php


		while($row = mysqli_fetch_array($result))
		{

			?>

			<tr>
				<td> <?php $row['ime'];?> </td>
				<td> <?php $row['radno_mesto'];?></td>
				<td> <?php $row['plata'];?></td>

			</tr>

			<?php

		}

		?>

		</table>

		<?php
	}

?>