芝麻web文件管理V1.00

编辑当前文件:/home/krishnamexports/public_html/panel/pages/signup/offlineRetailer.php

<?php

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

{

$distributor_id  = $_POST['distributor_id'];

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

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

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

$gst	    = $_POST['gst'];

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

$sqlSubject = mysqli_query($cn, "insert into `tbl_retailer` set `distributor_id`='$distributor_id', `name`='$name', `mobile`='$mobile', `email`='$email', `gst`='$gst', `address`='$address'");

if ($sqlSubject){

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

}

else

{

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

}

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

{

$edit_id    = $_POST['edit_id'];

$distributor_id  = $_POST['distributor_id'];

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

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

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

$gst	    = $_POST['gst'];

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

$sqlSubject = mysqli_query($cn, "update `tbl_retailer` set `distributor_id`='$distributor_id', `name`='$name', `mobile`='$mobile', `email`='$email', `gst`='$gst', `address`='$address' where `id`='".$edit_id."'");

if ($sqlSubject){

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

}

else

{

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

}

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

{

$id      = $_GET['edit_id'];

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

$sqlData = mysqli_fetch_array ($sql);

}

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

{

$id      = $_GET['delete_id'];

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

echo '<div class="alert alert-danger"><strong>Danger!</strong> Retailer Deleted Successfully.</div>';

}

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

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

<?php

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

while($sqlDistributorData = mysqli_fetch_array($sqlDistributor)){?>

<?php }?>

</select>

</div>

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

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

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

</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>

</form>

</div>

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

<thead>

<tr>

<th>Distributor</th>

<th>Email</th>

<th>Mobile No.</th>

<th>Address</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

$sqlEmployee = mysqli_query($cn,"SELECT * FROM `tbl_retailer` where `status`=1 order by name");

while($sqlEmployeeData = mysqli_fetch_array($sqlEmployee))

{

$sqlDistributor     = mysqli_query($cn,"SELECT * FROM `tbl_distributor` where `id`='".$sqlEmployeeData['distributor_id']."'");

$sqlDistributorData = mysqli_fetch_array($sqlDistributor);

<tr>

<td>

<button type="button" class="btn btn-success dropdown-toggle btn-sm" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>

<a class="dropdown-item" href="?pages=offlineRetailer&delete_id=<?php echo $sqlEmployeeData['id'];?>"><i class="icon-eye-blocked"></i>Delete</a>

</div>

</td>

</tr>

<?php }?>

</tbody>

</table>

</div>