1#@!#!123s

: / home / vitalityhealth / www / testaa / superadmin /
Filename : add-business.php
back
<?php 
include 'cn.php';
session_start();
if(isset($_SESSION['username'])) {



if(isset($_POST['submit']))
{
//   print_r($_POST);
//   die();
 
    date_default_timezone_set('Asia/Kolkata');
$curdate= date('d-m-Y H:i');

 $filename1 = $_FILES['file1']['name'];
    
     // Upload file
     move_uploaded_file($_FILES['file1']['tmp_name'],'business/'.$filename1);

  
 
  
    $dec= $_POST['editor'];
      
 $sql = "INSERT INTO `business`(`name`, `category`, `tag`, `image`, `address`, `website`, `facebook`, `instagram`, `whatsapp`, `number`, `email`, `verified`, `city`) VALUES 
('".$_POST['name']."','".$_POST['category']."','".$_POST['tag']."','".$filename1."','".$_POST['address']."','".$_POST['website']."','".$_POST['facebook']."','".$_POST['instagram']."','".$_POST['whatsapp']."','".$_POST['number']."','".$_POST['email']."','".$_POST['verified']."','".$_POST['city']."') ";
$result = $con->query($sql);



if($result){ 
echo  "<script type='text/javascript'>alert(\"Add Successfully\")
 location.href='business.php';
  </script>";}
  else
      { echo  "<script type='text/javascript'>alert(\"not added\")
 location.href='business.php';
  </script>";
          
      }      

}
?>
<!doctype html><html class="fixed dark" data-style-switcher-options="{'backgroundColor': 'dark'}">
	<head>
		<!-- Basic -->
		<meta charset="UTF-8">
		<title>Mether</title>
		
		
		<!-- Mobile Metas -->
		<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
		<!-- Web Fonts  -->		<link href="css?family=Poppins:300,400,500,600,700,800|Shadows+Into+Light" rel="stylesheet" type="text/css">
		<!-- Vendor CSS -->
		<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.css">		<link rel="stylesheet" href="vendor/animate/animate.compat.css">		<link rel="stylesheet" href="vendor/font-awesome/css/all.min.css">		<link rel="stylesheet" href="vendor/boxicons/css/boxicons.min.css">		<link rel="stylesheet" href="vendor/magnific-popup/magnific-popup.css">		<link rel="stylesheet" href="vendor/bootstrap-datepicker/css/bootstrap-datepicker3.css">
		<!-- Specific Page Vendor CSS -->

		<!-- Theme CSS -->
		<link rel="stylesheet" href="css/theme.css">
		<!-- Theme Custom CSS -->
		<link rel="stylesheet" href="css/custom.css">
		<!-- Head Libs -->
		<script src="vendor/modernizr/modernizr.js"></script>
		<script src="master/style-switcher/style.switcher.localstorage.js"></script>
	</head>
	<body>
		<section class="body">
			<!-- start: header -->
				<?php include("header.php"); ?>
			<!-- end: header -->
			<div class="inner-wrapper">
				<!-- start: sidebar -->
					<?php include("leftnav.php"); ?>
				<!-- end: sidebar -->
				<section role="main" class="content-body card-margin">
					<header class="page-header">
						<h2>Add Business</h2>
						<div class="right-wrapper text-end">
							<ol class="breadcrumbs">
								<li>
									<a href="index.php">
										<i class="bx bx-home-alt"></i>
									</a>
								</li>
								<li><span>Add Business</span></li>
								
							</ol>
							<a class="sidebar-right-toggle" data-open="sidebar-right"><i class="fas fa-chevron-left"></i></a>
						</div>
					</header>
					<!-- start: page -->
					
					<div class="row">
					
						<div class="col-lg-12">
							<section class="card">
								<header class="card-header">
									<div class="card-actions">
										<a href="#" class="card-action card-action-toggle" data-card-toggle=""></a>
										
									</div>
									<h2 class="card-title">Add Business</h2>
									
								</header>
								<form action="" method="post" enctype="multipart/form-data">
								<div class="card-body">
									<div class="row form-group pb-3">
										<div class="col-lg-4">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Name</label>
												<input type="text" class="form-control" name="name" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-4">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Category</label>
												<select name="category" class="form-control">
 <?php
include("superadmin/cn.php");
        $sql1 ="SELECT * FROM `category`";
        $run1 =mysqli_query($con,$sql1);
      
        while($row1 = $run1->fetch_assoc()) {
            
        
        ?>   												    
  <option value="<?php echo $row1['name']; ?>   "><?php echo $row1['name']; ?>   </option>
  <?php } ?>

</select>
											</div>
										</div>
										
										<div class="col-lg-4">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Tags</label>
												<select name="tag" class="form-control">
 <?php
include("superadmin/cn.php");
        $sql2 ="SELECT * FROM `tags`";
        $run2 =mysqli_query($con,$sql2);
      
        while($row2 = $run2->fetch_assoc()) {
            
        
        ?>   												    
  <option value="<?php echo $row2['name']; ?>   "><?php echo $row2['name']; ?>   </option>
  <?php } ?>

</select>
											</div>
										</div>
										<div class="col-lg-4">
											<div class="form-group">
											<label class="col-form-label" for="formGroupExampleInput">Image</label>
												<input type="file"  class="form-control" name="file1" id="file1" >
											</div>
										</div>
										<div class="col-lg-8">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Address</label>
												<input type="text" class="form-control" name="address" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Facebook URL</label>
												<input type="text" class="form-control" name="facebook" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Website URL</label>
												<input type="text" class="form-control" name="website" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Instagram URL</label>
												<input type="text" class="form-control" name="instagram" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Whatsapp</label>
												<input type="text" class="form-control" name="whatsapp" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Phone</label>
												<input type="text" class="form-control" name="number" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Email</label>
												<input type="email" class="form-control" name="email" placeholder="" required>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">City</label>
												<select name="city" class="form-control">
	<option >Select City</option>
											<?php

        $sql ="SELECT * FROM `city`";
        $run =mysqli_query($con,$sql);
        $i=1;
        while($row = $run->fetch_assoc()) {
            
        
        ?>                                     	    
  <option value="<?php echo $row['name']; ?>"><?php echo $row['name']; ?></option>
<?php } ?>
  
</select>
											</div>
										</div>
										<div class="col-lg-3">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Verified</label>
												<select name="verified" class="form-control">
  <option value="Yes">Yes</option>
  <option value="No">No</option>
  
</select>
											</div>
										</div>
										
									</div>
									
								</div>
							<footer class="card-footer text-end">
								    <center>
									<button class="mb-1 mt-1 me-1 btn btn-success" name="submit">Submit</button></center>
								</footer>
								</form>
							</section>
						</div>
					</div>
					
					<!-- end: page -->
				</section>
			</div>
			<?php include("rightnav.php"); ?>
		</section>
		<!-- Vendor -->
		<script src="vendor/jquery/jquery.js"></script>		<script src="vendor/jquery-browser-mobile/jquery.browser.mobile.js"></script>		<script src="vendor/jquery-cookie/jquery.cookie.js"></script>			<script src="vendor/popper/umd/popper.min.js"></script>		<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>		<script src="vendor/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>		<script src="vendor/common/common.js"></script>		<script src="vendor/nanoscroller/nanoscroller.js"></script>		<script src="vendor/magnific-popup/jquery.magnific-popup.js"></script>		<script src="vendor/jquery-placeholder/jquery.placeholder.js"></script>
		<!-- Specific Page Vendor -->

		<!-- Theme Base, Components and Settings -->
		<script src="js/theme.js"></script>
		<!-- Theme Custom -->
		<script src="js/custom.js"></script>
		<!-- Theme Initialization Files -->
		<script src="js/theme.init.js"></script>
		<!-- Analytics to Track Preview Website -->
	
	</body>
</html>
<?php
}
else {
  header("location:login.php");
}
?>