Active and inactive users concept using php and Ajax - Mostlikers

09 February, 2015

Active and inactive users concept using php and Ajax

Today I have posted Active and inactive users script. This concept mostly using E-commerce website administrator access to check product available or not, delivery status, the user can block and activate like that similar concept related to this concept.

Active and inactive


Live demo             Download

Database

CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `address` varchar(100) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

Html

 'btn-success': 'btn-danger'  - Checking class
 'Active' : 'Inactive'  - Checking Active or inactive value
 data="<?php echo $user['id'];?>"  - User id to pass javascript valuetat
$db= Database connection.

<?php $db= new mysqli('localhost','root','','mostlikers'); ?>
<html>
<head></head>
  <body>
  <table border="1">
  <tr>
  <th>#</th>
  <th>name</th>
  <th>email</th>
  <th>Action</th>
  </tr>
  <?php $sql=$db->query("Select * from user");
        foreach ($sql as $key => $user) {
  ?>
  <tr>
  <td><?php echo $user['id'] ?></td>
  <td><?php echo $user['name']; ?></td>
  <td><?php echo $user['email']; ?></td>
  <td><i data="<?php echo $user['id'];?>" class="status_checks btn
  <?php echo ($user['status'])?
  'btn-success': 'btn-danger'?>"><?php echo ($user['status'])? 'Active' : 'Inactive'?>
 </i></td>
  </tr>
  <?php } ?>
  </table>
  </body>
</html>

Ajax

$(this).hasClass- Class suceess (Active) or (Inactive).
var msg - Status message.
<script src="//code.jquery.com/jquery-1.10.2.min.js"></script>
<script type="text/javascript">
$(document).on('click','.status_checks',function(){
      var status = ($(this).hasClass("btn-success")) ? '0' : '1';
      var msg = (status=='0')? 'Deactivate' : 'Activate';
      if(confirm("Are you sure to "+ msg)){
        var current_element = $(this);
        url = "ajax.php";
        $.ajax({
          type:"POST",
          url: url,
          data: {id:$(current_element).attr('data'),status:status},
          success: function(data)
          {   
            location.reload();
          }
        });
      }      
    });
</script>

Ajax.php

<?php $db= new mysqli('localhost','root','','mostlikers'); 
extract($_POST);
$user_id=$db->real_escape_string($id);
$status=$db->real_escape_string($status);
$sql=$db->query("UPDATE user SET status='$status' WHERE id='$id'");
echo 1;
?>

CSS

.btn-success {
   background-color: #65B688;
   border-color: #65B688;
   }
   .btn-danger {
   color: #fff;
   background-color: #d9534f;
   border-color: #d43f3a;
   }
   .btn {
   color: white;
   display: inline-block;
   margin-bottom: 0;
   font-weight: 400;
   text-align: center;
   vertical-align: middle;
   cursor: pointer;
   background-image: none;
   border: 1px solid transparent;
   white-space: nowrap;
   padding: 6px 12px;
   font-size: 14px;
   line-height: 1.42857143;
   border-radius: 4px;
   -webkit-user-select: none;
   -moz-user-select: none;
   -ms-user-select: none;
   user-select: none;
   }


Recent post
Labels: , , ,

9 comments:

  1. Qaysar25 August 2015 at 10:37

    Hello,

    Can you please advise how this concept be added to the below OOP code please.

    clickActive : function(thisIdentity) {
    "use strict";
    $(document).on('click', thisIdentity, function(e) {
    e.preventDefault();
    var thisObj = $(this);
    var thisUrl = thisObj.data('url');
    $.getJSON(thisUrl, function(data) {
    if (data && !data.error) {
    if (!adminObject.isEmpty(data.replace)) {
    thisObj.replaceWith(data.replace);

    }
    }
    });
    });
    },

    I want to add this class to my users list and cannot do this.

    Any help is much appreciated.

    ReplyDelete
  2. Unknown11 April 2017 at 04:48

    its works
    tnx for tutorial

    ReplyDelete
  3. Unknown1 April 2018 at 04:49

    the value in enum is 0 which means the record will be inactive or active. bit confused about it.

    ReplyDelete
    Replies
    1. Mostikers16 August 2021 at 09:41

      0 - Inactive 1- Active you can change according to your requirement.

      Delete
  4. Unknown31 January 2021 at 07:47

    Thanku
    That Was working

    ReplyDelete
  5. Plenty3 February 2021 at 21:39

    Excellent...Code working

    ReplyDelete
  6. Unknown15 July 2021 at 10:47

    Thanks it help me to add in my project

    ReplyDelete
  7. mehdi3 September 2021 at 18:13

    thank you Mostikers it help me in my project

    ReplyDelete

Subscribe to: Post Comments (Atom)