Manager

Back Back Up Advanced Editor

<?php

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

{

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

$sort_order = $_POST['sort_order'];

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

if(mysqli_num_rows($sql)>0)

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> Polish already exists.</div>';

}

else

{

$sqlSubject = mysqli_query ($cn, "insert into `tbl_polish` set `name`='$name', sort_order='$sort_order'");

if ($sqlSubject){

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

}

else

{

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

}

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

{

$id   	    = $_POST['id'];

$name		= $_POST['name'];

$sort_order	= $_POST['sort_order'];

$sqlSubject = mysqli_query ($cn,"update `tbl_polish` SET `name`='$name', `sort_order`='$sort_order' where `id`='$id'");

if($sqlSubject)

{

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

}

else

{

echo '<div class="alert alert-success"><strong>Warning!</strong> Polish Updated try again.</div>';

}

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

{

$id      = $_GET['edit_id'];

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

$sqlData = mysqli_fetch_array ($sql);

}

<h4 class="card-title">Polish</h4>

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

</div>

<label for="exampleInputName1">Sort Order</label>

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

</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">Polish List</h4>

<thead>

<tr>

<th width="10%">Sort Order</th>

<th width="10%">Action</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

$sqlEmployee = mysqli_query($cn, "select * from `tbl_polish` order by `sort_order`");

while($sqlEmployeeData = mysqli_fetch_array($sqlEmployee)){?>

<tr>

</tr>

<?php }?>

</tbody>

</table>

</div>