Untitled

<?php include 'header.php';?>
<body>
<?php
$epasts = $_SESSION["epasts"];
?>
	<div class="content">
		<div>
		<table class="table-hover table-striped">
								<tr>
									<td height="50"></td>
									<td><span style="font-weight:bold">Modelis</span></td>
									<td><span style="font-weight:bold">Krāsa</span></td>
									<td><span style="font-weight:bold">Daudzums</span></td>
									<td><span style="font-weight:bold">Cena</span></td>
								</tr>
		<?php
		$connect = mysqli_connect('localhost', 'root', 'PASSWORD', 'db_edniloshop');
		$query = "SELECT `t`.`krasa`, `t`.`cena`, `t`.`bilde`, `g`.`grozaID` AS `grozaID`,`g`.`epasts` AS `epasts`, `t`.`modelis`,`gt`.`daudzums` , `t`.`viedtalrunaID`FROM `grozi` `g`
		JOIN `groziem_ir_telefoni` `gt` ON `g`.`grozaID` = `gt`.`grozaID`
		JOIN `telefoni` `t` ON `gt`.`viedtalrunaID` = `t`.`viedtalrunaID`
		WHERE (`g`.`irApmaksats` = 'F')
		AND `g`.`epasts` ='$epasts'";
		$result = mysqli_query($connect, $query);
		$summa = 0;

		if ($result):
			if(mysqli_num_rows($result)>0):
				while($smartphone = mysqli_fetch_assoc($result)):
				?>

								<tr>
									<td><img src="<?php echo $smartphone['bilde']; ?>" class="img" height="50" width="50"/></td>
									<td><?php echo $smartphone['modelis']; ?></td>
									<td><?php echo $smartphone['krasa']; ?></td>
									<td><?php echo $smartphone['daudzums']; ?> .gab</td>
									<td><?php echo $smartphone['cena']*$smartphone['daudzums'];
									$summa = $summa+$smartphone['cena']*$smartphone['daudzums'];?> EUR</td>
								</tr>
				<?php
				endwhile;
			endif;
		endif;
		$selectOption = "";
		?>
								<tr>
									<td></td>
									<td></td>
									<td></td>
									<td style="text-align:right;">Kopā:</td>
									<td height="50"><span style="font-weight:bold"><?php echo $summa;?> EUR</span></td>
								</tr>
		<table>
		<form method="post" action="paldies.php?adrese=<?php echo $selectOption; ?>">
			<h4>Lūdzu izvēlaties, kur vēlaties saņemt pirkumu</h4>
			<?php
				$connect = mysqli_connect('localhost', 'root', 'PASSWORD', 'db_edniloshop');
				$query = "SELECT * FROM pakautomati";
				$result = mysqli_query($connect, $query);
				?>

				<select name="adreseID">
				<?php
				if ($result):
					if(mysqli_num_rows($result)>0):
						while ($row = mysqli_fetch_assoc($result)):
							$adrese = $row['adrese'];
							?>
							<option value="<?php echo $adrese ?>"> <?php echo $adrese ?></option>
							<?php
							$selectOption = $_POST["adreseID"];
						endwhile;
					endif;
				endif;

				if (isset($_POST["adreseID"])):
					$selectOption = $_POST["adreseID"];
					echo $selectOption;
				endif;
				?>
				</select>
			<input style="display:block; margin:auto; margin-top:20px; width:200px;" type="submit" name="uniqid" style="margin: 20px;" id="pirktPoga" class="btn btn-success " value="Pirkt" onclick="paldies.php?adrese=<?php echo $selectOption; ?>" />
		</form>
		<?php
		?>
		</div>
	</div>

</body>
</html>