<?php include('db_con.php'); ?>

<?php

function option_building_location()
{
	include('db_con.php');
	
	$get_bd_name ="select * from bd_locationtb";
	$run_bd_name = mysqli_query($con,$get_bd_name);
	while($row_bd_name = mysqli_fetch_array($run_bd_name))
	{
		$building_location = $row_bd_name['location_name'];
		echo"<option>$building_location</option>";
	}
	
	
}

?>
<?php


function option_building_name()
{
	include('db_con.php');
	
	$get_bd_name ="select * from main_buildingtb";
	$run_get_bd_name = mysqli_query($con,$get_bd_name);
	while($row_get_bd_name = mysqli_fetch_array($run_get_bd_name))
	{
		$building_name = $row_get_bd_name['building_name'];
		echo"<option>$building_name</option>";
	}
	
	
}

?>

<?php

function option_shop_name()
{ 
    include('db_con.php');
	
	$get_shop_name = "select * from shoptb ";
	$run_get_shop_name = mysqli_query($con,$get_shop_name);
	while($row_get_shop_name = mysqli_fetch_array($run_get_shop_name))
	{
	$name_shop = $row_get_shop_name['shop_name'];
    echo"<option>$name_shop</option>";	
	}
}
?>

<?php


function option_date_day()
{
	include('db_con.php');
	?>
<option selected disabled >Select day</option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
	
	
<?php } ?>

<?php
function option_date_month()
{
	include('db_con.php');
	?>
<option selected disabled >Select month</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
	
	
<?php } ?>

<?php
function option_date_year()
{
	include('db_con.php');
	?>
<option selected disabled >Select year</option>
<option>2022</option>
<option>2021</option>
<option>2020</option>
<option>2019</option>
<option>2018</option>
	
<?php } ?>

<?php
function complaint_notif()
{
	//include('db_con.php');
	//$insert_kvt ="insert into notiftb(complaint_id,user_cpr) values('$complaint_id','$user_cpr')";
	//$run_not = mysqli_query($con,$insert_kvt);
	/*
	$get_complaint_notif ="select * from notiftb ";
	$run_get_notif = mysqli_query($con,$get_complaint_notif);
	$check_get_notif = mysqli_num_rows($run_get_notif);
	echo"<div style='float:left;height:30px;line-height:30px;margin-top:10px;color:red;background:#FFF6F8;border-radius:5px;cursor:pointer;'>New$check_get_notif</div>";
*/
} ?>