File "stone.php"

Full Path: /home/krishnamexports/public_html/panel/pages/product/stone.php
File size: 4.48 KB
MIME-type: text/x-php; charset=us-ascii
Charset: utf-8

<?php 		  

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

{

	$name	    = $_POST['name'];

	$sort_order = $_POST['sort_order'];			

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

	if(mysqli_num_rows($sql)>0)

	{

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

	}

	else

	{

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

		if ($sqlSubject){

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

		}

		else

		{

			echo '<div class="alert alert-danger"><strong>Danger!</strong> Stone 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_stone` SET `name`='$name', `sort_order`='$sort_order' where `id`='$id'");

	if($sqlSubject)

	{

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

	}

	else

	{

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

	}

}



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

{

	$id      = $_GET['edit_id'];

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

	$sqlData = mysqli_fetch_array ($sql); 

}	



?>

<div class="card">

	<div class="card-body">              

        <h4 class="card-title">Stone</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="exampleInputName1">Name</label> 

                        <input type="hidden" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['id'];}?>" name="id">                               

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

                    </div>

                </div>                            

            

                <div class="col-md-3">

                    <div class="form-group">

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

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

<br><br>

        

		

<div class="col-lg-12 grid-margin stretch-card">

    <div class="card">

        <div class="card-body">

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

            <div class="table-responsive">

                <table class="table table-striped" id="example">

                    <thead>

                        <tr>

                            <th width="5%">S.No.</th>

                            <th width="75%">Name</th>

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

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

                        </tr>

                    </thead>

                    <tbody>

						<?php

                        $i = 1;						  

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

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

                        <tr>

                            <td><?php echo $i++;?></td>							  

                            <td><?php echo $sqlEmployeeData['name'];?></td>

                            <td><?php echo $sqlEmployeeData['sort_order'];?></td>

                            <td><a href="home.php?pages=stone&edit_id=<?php echo $sqlEmployeeData['id'];?>">Edit</a></td>

                        </tr>

                        <?php }?>                              

                    </tbody>

                </table>

            </div>

        </div>

    </div>

</div>