
<div class="page-content">




<?php
include("common/sitemap.php");
?>                            <div class="container-fluid">
                                


<div data-widget-group="group1">

<div class="row">
		<div class="col-md-12">
			<div class="alert alert-info mb-xl">
				<h3>Add City</h3>
<div class="form-group"><form action="action-pages/add-city-action.php" method="post">
					<div class="col-sm-3">
					
					<script type="text/javascript" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
<script type="text/javascript">
$(document).ready(function(e) {
 
  
    $('#country').change(function(e){
		  $.post('common/insert.php',{country:$(this).val()},function(data){
			
			   $('#state').html(data);
			  });
		});
		
     $('#sem').change(function(e){
		  $.post('module/insert.php',{subject:$(this).val()},function(data){
		  		
			   $('#subject').html(data);
			  });
		});		
});
</script>

				
						<select name="country" id="country" class="form-control" required>
						<option value="">SELECT COUNTRY</option>
						<?php 
						$GetCountryType = mysql_query("SELECT * FROM `sgvu_country` ORDER BY `sgvu_country`.`country` ASC");
						while($GetCountryType1 = mysql_fetch_assoc($GetCountryType))
						{
						?>
						<option value="<?php echo $GetCountryType1['country_id']; ?>"><?php echo $GetCountryType1['country']; ?></option>
						<?php } ?>
						</select>
					</div>
					<div class="col-sm-3">
						<select name="state" id="state" class="form-control" required>
						<option value="">SELECT COUNTRY</option>
						</select>
					</div>
					<div class="col-sm-3">
						<input type="text" class="form-control" name="city"/>
					</div>

					
						

					<div class="col-sm-2">
<button class="btn-primary btn" type="submit">Submit</button>					</div></form>
<br />


				</div>			</div>
		</div>
	</div>

	
	
	<div class="row">
	
	
		<div class="col-md-9">
			<div class="panel panel-default">
				<div class="panel-heading">
					<h2>States List</h2>
					<div class="panel-ctrls"></div>
				</div>
				<div class="panel-body no-padding">
					<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
						<thead>
							<tr>
								<th width="3%" height="28">S.No.</th>
								<th width="27%">City</th>
								<th width="27%">State</th>
								<th width="26%">Country</th>
								<th width="17%">Action</th>
							</tr>
						</thead>
						<tbody>
							
						<?php
						$GetCityDe = mysql_query("SELECT * FROM `city` ORDER BY `city`.`city_id` DESC");
						while($GetCityDe1 = mysql_fetch_assoc($GetCityDe))
						{
						$s =$_REQUEST['v'];

						$u = $s+0;

						?>
							
						<tr>
								<td width="3%" height="28" align="center"><?php echo $_REQUEST['v'] = $u+1; ?></td>
								<td width="27%" height="28" align=""><?php echo $GetCityDe1['cityname']; ?></td>
								<td width="27%"><?php 
								$GetState = mysql_query("SELECT * FROM `state` WHERE `ids` = '$GetCityDe1[state_id]'");
								$GetState1 =  mysql_fetch_assoc($GetState);
								echo $GetState1['state'];
								?></td>
								<td width="26%"><?php 
								$GetCount = mysql_query("SELECT * FROM `sgvu_country` WHERE `country_id` = '$GetState1[country]'");
								$GetCount1 = mysql_fetch_assoc($GetCount);
								echo $GetCount1['country'];
								?></td>
								<td width="17%" align="center">Edit Delete</td>
						  </tr>
						<?php
						}
						?>	   
						
							
						</tbody>
					</table>
				</div>
				<div class="panel-footer"></div>
			</div>
		</div>
	</div>
	
	
	

	
	
	
	
	
</div>
                            </div> <!-- .container-fluid -->
                        </div>
						
						<script type="text/javascript" src="assets/js/jquery-1.10.2.min.js"></script> 							<!-- Load jQuery -->
<script type="text/javascript" src="assets/js/jqueryui-1.10.3.min.js"></script> 							<!-- Load jQueryUI -->
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script> 								<!-- Load Bootstrap -->
<script type="text/javascript" src="assets/js/enquire.min.js"></script> 									<!-- Load Enquire -->

<script type="text/javascript" src="assets/plugins/velocityjs/velocity.min.js"></script>					<!-- Load Velocity for Animated Content -->
<script type="text/javascript" src="assets/plugins/velocityjs/velocity.ui.min.js"></script>

<script type="text/javascript" src="assets/plugins/wijets/wijets.js"></script>     						<!-- Wijet -->

<script type="text/javascript" src="assets/plugins/codeprettifier/prettify.js"></script> 				<!-- Code Prettifier  -->
<script type="text/javascript" src="assets/plugins/bootstrap-switch/bootstrap-switch.js"></script> 		<!-- Swith/Toggle Button -->

<script type="text/javascript" src="assets/plugins/bootstrap-tabdrop/js/bootstrap-tabdrop.js"></script>  <!-- Bootstrap Tabdrop -->

<script type="text/javascript" src="assets/plugins/iCheck/icheck.min.js"></script>     					<!-- iCheck -->

<script type="text/javascript" src="assets/plugins/nanoScroller/js/jquery.nanoscroller.min.js"></script> <!-- nano scroller -->

<script type="text/javascript" src="assets/js/application.js"></script>
<script type="text/javascript" src="assets/demo/demo.js"></script>
<script type="text/javascript" src="assets/demo/demo-switcher.js"></script>

<script type="text/javascript" src="assets/plugins/datatables/jquery.dataTables.js"></script>
<script type="text/javascript" src="assets/plugins/datatables/dataTables.bootstrap.js"></script>
<script type="text/javascript" src="assets/demo/demo-datatables.js"></script>
