芝麻web文件管理V1.00

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

<?php

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

{

$pincode    		= $_POST['pincode'];

$state_id			= $_POST['state_id'];

$city_id			= $_POST['city_id'];

$sqlSubject=mysqli_query ($cn, "insert into `tbl_pincode` set pincode='$pincode',state_id='$state_id',city_id='$city_id'");

if ($sqlSubject){

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

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> City Page Not Exist.</div>';

}

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

{

$id  			    = $_POST['id'];

$pincode    		= $_POST['pincode'];

$state_id			= $_POST['state_id'];

$city_id			= $_POST['city_id'];

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

$sqlData = mysqli_fetch_array($sql);

$sqlSubject = mysqli_query ($cn,"update tbl_pincode SET pincode='$pincode',state_id='$state_id',city_id='$city_id' where `id`='$id'");

if($sqlSubject)

{

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

}

else

{

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

}

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

{

$id      = $_GET['edit_id'];

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

$sqlData = mysqli_fetch_array ($sql);

}

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

{

$id      = $_GET['delete_id'];

$sql     = mysqli_query($cn, "delete from tbl_pincode where id='$id'");

if($sql)

{

echo '<div class="alert alert-success"><strong>Success!</strong> City Page Deleted Successfully.</div>';

}

else

{

echo "error: " . $sql . "<br>" . mysqli_error($conn);

}

</div>

<h4 style="margin-bottom:25px;">Add Pincode</h4>

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

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

</div>

<label for="exampleInputPassword4">State Page</label>

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

<?php

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

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

<?php }?>

</select>

</div>

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

<?php

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

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

<?php }?>

</select>

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

<thead>

<tr>

<th>Pincode</th>

<th>State Page Name</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

$sqlPincode = mysqli_query($cn, "select * from `tbl_pincode`");

while($sqlPincodeData = mysqli_fetch_array($sqlPincode)){

$sqlState = mysqli_query($cn, "select * from `tbl_state` where id='".$sqlPincodeData['state_id']."'");

$sqlStateData = mysqli_fetch_array($sqlState);

$sqlCity = mysqli_query($cn, "select * from `tbl_city` where id='".$sqlPincodeData['city_id']."'");

$sqlCityData = mysqli_fetch_array($sqlCity);

<tr>

<td><a href="home.php?pages=pincode&edit_id=<?php echo $sqlPincodeData['id'];?>">Edit</a> | <a href="home.php?pages=pincode&delete_id=<?php echo $sqlPincodeData['id'];?>" onclick="return deleteConfirm();">Delete</a></td>

</tr>

<?php } ?>

</tbody>

</table>

</div>