Manager

Back Back Up Advanced Editor

<?php

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

{

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

$amount = $_POST['amount'];

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

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

$sqlSubject      = mysqli_query ($cn, "insert into `tbl_currency` set `name`='".$name."', `value`='".$amount."', `title`='".$title."', `currency_symbol`='".$currency_symbol."'");

if ($sqlSubject)

{

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

}

else

{

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

}

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

{

$id     = $_POST['id'];

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

$amount = $_POST['amount'];

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

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

$sqlSubject      = mysqli_query ($cn,"update `tbl_currency` set `name`='".$name."', `value`='".$amount."', `title`='".$title."', `currency_symbol`='".$currency_symbol."' where `id`='$id'");

if($sqlSubject)

{

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

}

else

{

echo '<div class="alert alert-success"><strong>Warrning!</strong> Currency Not Updated. Try again.</div>';

}

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

{

$id      = $_GET['edit_id'];

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

$sqlData = mysqli_fetch_array ($sql);

}

<h4 style="margin-bottom:25px;">Currency Master</h4>

<label for="exampleInputPassword4">Currency Name</label>

</div>

<label for="exampleInputPassword4">Currency Amount</label>

</div>

<label for="exampleInputPassword4">Currency Symbol</label>

</div>

<label for="exampleInputPassword4">Currency Title</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">Currency List</h4>

<thead>

<tr>

<th>Amount</th>

<th>Title</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

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

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

<tr>

</tr>

<?php } ?>

</tbody>

</table>

</div>