Manager

Back Back Up Advanced Editor

<?php

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

{

$name	 		= mysqli_real_escape_string($cn,$_POST['name']);

$company_name	= mysqli_real_escape_string($cn,$_POST['company_name']);

$mobile 		= mysqli_real_escape_string($cn,$_POST['mobile']);

$email	 		= mysqli_real_escape_string($cn,$_POST['email']);

$designation_id	= mysqli_real_escape_string($cn,$_POST['designation_id']);

$state_id       = $_POST['state_id'];

$city_id 		= $_POST['city_id'];

$pincode        = $_POST['pincode'];

$gst	 		= $_POST['gst'];

$address = mysqli_real_escape_string($cn,$_POST['address']);

$sql     = mysqli_query($cn, "select * from `tbl_employee` where mobile='$mobile'");

if(mysqli_num_rows($sql)==0)

{

$sqlSubject = mysqli_query($cn, "insert into `tbl_employee` set `name`='$name', `company_name`='$company_name', `mobile`='$mobile', `email`='$email', `designation_id`='$designation_id', `state_id`='$state_id', `city_id`='$city_id', `pincode`='".$pincode."', `gst`='$gst', `address`='$address'");

if ($sqlSubject){

echo '<div class="alert alert-success"><strong>Success!</strong> Distributor Added Successfully.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> Distributor Not Added. Try Again.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> This  Mobile Already Registred.</div>';

}

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

{

$edit_id 		= $_POST['edit_id'];

$name	 		= mysqli_real_escape_string($cn,$_POST['name']);

$company_name	= mysqli_real_escape_string($cn,$_POST['company_name']);

$email	 		= mysqli_real_escape_string($cn,$_POST['email']);

$mobile 		= mysqli_real_escape_string($cn,$_POST['mobile']);

$designation_id	= mysqli_real_escape_string($cn,$_POST['designation_id']);

$state_id       = $_POST['state_id'];

$city_id 		= $_POST['city_id'];

$pincode        = $_POST['pincode'];

$gst	 		= $_POST['gst'];

$address 		= mysqli_real_escape_string($cn,$_POST['address']);

$sqlSubject = mysqli_query($cn, "update `tbl_employee` set `name`='$name', `company_name`='$company_name', `mobile`='$mobile', `email`='$email', `designation_id`='$designation_id', `state_id`='$state_id', `city_id`='$city_id', `pincode`='".$pincode."', `gst`='$gst', `address`='$address' where `id`='".$edit_id."'");

if ($sqlSubject){

echo '<div class="alert alert-success"><strong>Success!</strong> Distributor Added Successfully.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> Distributor Not Added. Try Again.</div>';

}

if(isset($_GET['edit_id']))

{

$id      = $_GET['edit_id'];

$sql     = mysqli_query($cn, "select * from tbl_employee where id='$id'");

$sqlData = mysqli_fetch_array ($sql);

}

if(isset($_GET['delete_id']))

{

$id      = $_GET['delete_id'];

$sql     = mysqli_query($cn, "update `tbl_employee` SET `status`=0 where id='$id'");

}

<label for="exampleInputCity1">Desination </label>

<option value="">Select Designation</option>

<?php

$sqlCategory = mysqli_query($cn, "select * from `tbl_designation` where `status`=1 and id IN(2,3,4)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<input type="text" class="form-control" name="name" value="<?php if(isset($_GET['edit_id'])) { echo $sqlData['name'];}?>" placeholder="Name" required>

</div>

<label for="exampleInputCity1">Company Name</label>

<input type="text" class="form-control" name="company_name" value="<?php if(isset($_GET['edit_id'])) { echo $sqlData['company_name'];}?>" placeholder="Company Name" required>

</div>

<label for="exampleInputCity1">Mobile No.</label>

<input type="text" class="form-control" name="mobile" value="<?php if(isset($_GET['edit_id'])) { echo $sqlData['mobile'];}?>" placeholder="Mobile" required>

</div>

<label for="exampleInputCity1">Email</label>

<input type="text" class="form-control" name="email" value="<?php if(isset($_GET['edit_id'])) { echo $sqlData['email'];}?>" placeholder="Email" required>

</div>

<label for="exampleInputCity1">State </label>

<option value="">Select State</option>

<?php

$sqlState = mysqli_query($cn, "select * from `tbl_state` order by `name`");

while($sqlStateData = mysqli_fetch_array($sqlState)){?>

<?php }?>

</select>

</div>

<option value="">Select City</option>

<?php

if(isset($_GET['edit_id'])){

$sqlCity = mysqli_query($cn,"select * from `tbl_city` order by `name`");

while($sqlCityData = mysqli_fetch_array($sqlCity)){?>

<?php }}?>

</select>

</div>

<label for="exampleInputCity1">Pincode </label>

<input type="text" class="form-control" name="pincode" value="<?php if(isset($_GET['edit_id'])) { echo $sqlData['pincode'];}?>" placeholder="pincode">

</div>

<input type="text" class="form-control" name="gst" value="<?php if(isset($_GET['edit_id'])) { echo $sqlData['gst'];}?>" placeholder="GST">

</div>

<label for="exampleInputCity1">Address</label>

</div>

<button type="submit" class="btn btn-success mr-2" name="<?php if(isset($_GET['edit_id'])) {echo "edit";}else{ echo "add";}?>">SUBMIT</button>

<a href="home.php?pages=uploadDistributor" class="btn btn-success mr-2" style="color:#FFF;float:right;"><i class="mdi mdi-file-excel"></i> UPLOAD EXCEL</a>

</form>

</div>

<h4 class="card-title">Dealer / Distributor / Retailer List</h4>

<thead>

<tr>

<th>Category</th>

<th>Person Name</th>

<th>State</th>

<th>Mobile No.</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

$sqlEmployee = mysqli_query($cn,"SELECT * FROM `tbl_employee` where `status`=1 and `designation_id` IN(2,3,4)order by name");

while($sqlEmployeeData = mysqli_fetch_array($sqlEmployee))

{

$sqlDesignation     = mysqli_query($cn,"select `name` from `tbl_designation` where `id`='".$sqlEmployeeData['designation_id']."'");

$sqlDesignationData = mysqli_fetch_array($sqlDesignation);

<tr>

<td>

<a href="home.php?pages=distributorRegistation&edit_id=<?php echo $sqlEmployeeData['id'];?>" class="btn btn-outline-success btn-sm">Edit</a>

<a href="home.php?pages=distributorRegistation&delete_id=<?php echo $sqlEmployeeData['id'];?>" class="btn btn-outline-danger btn-sm" onclick="return deleteConfirm();">Delete</a>

</td>

</tr>

<?php }?>

</tbody>

</table>

</div>