<?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);
}
?>
<div class="col-md-12">
<div class="card">
<div class="card-body">
<h4 style="margin-bottom:25px;">Currency Master</h4>
<form class="forms-sample" method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-md-3">
<div class="form-group">
<label for="exampleInputPassword4">Currency Name</label>
<input type="hidden" class="form-control" name="id" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['id'];}?>">
<input type="text" class="form-control" name="name" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['name'];}?>">
<p>Ex. Like USD, EURO Etc.</p>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="exampleInputPassword4">Currency Amount</label>
<input type="text" class="form-control" name="amount" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['value'];}?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="exampleInputPassword4">Currency Symbol</label>
<textarea class="form-control" name="currency_symbol" cols="1" required><?php if(isset($_GET['edit_id'])) {echo $sqlData['currency_symbol'];}?></textarea>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label for="exampleInputPassword4">Currency Title</label>
<textarea class="form-control" name="title" cols="1" required><?php if(isset($_GET['edit_id'])) {echo $sqlData['title'];}?></textarea>
</div>
</div>
</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>
</div>
</div>
<div class="col-md-12">
<div class="card">
<div class="card-body">
<h4 class="card-title">Currency List</h4>
<div class="table-responsive">
<table class="table table-striped">
<thead>
<tr>
<th>Sr. No.</th>
<th>Name</th>
<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>
<td><?php echo $i++;?></td>
<td><?php echo $sqlCityData['name'];?></td>
<td><?php echo $sqlCityData['value'];?></td>
<td><?php echo $sqlCityData['title'];?></td>
<td><a href="home.php?pages=currencyMaster&edit_id=<?php echo $sqlCityData['id'];?>">Edit</a></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>