1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / pattklvg / public_html / admin / pages / users1 / php /
Filename : getdata.php
back
<table id="example1" class="table table-bordered table-hover table-responsive">
    <thead>
    <tr>
        <th>ID</th>
        <th>First Name</th>
        <th>Last Name</th>
        <th>Email</th>
        <th>Institute</th>
        <th>Role</th>
        <th>Status</th>
        <th>Action</th>
    </tr>
    </thead>
    <tbody>
    <?php
    //include "../../../dist/resources/config.php";
    $conn = new mysqli("localhost", "pattklvg_site", "p@ssw0rd","pattklvg_new");
    $res = $conn->query("select * from users");
    while ($row = $res->fetch_assoc()) {
        $id = $row['id'];
        $ins_id = $row['ins_id'];
        $res1 = $conn->query("select * from institute where inst_id='$ins_id'");
        if ($res1->num_rows > 0) {
    while ($roww = $res1->fetch_assoc()) {
        $iname=$roww['name'];
        
    }
        }else{
          $iname="";  
        }
        ?>

        <tr>
            <td><?php echo $row['id']; ?></td>
            <td><?php echo $row['fname']; ?></td>
            <td><?php echo $row['lname']; ?></td>
            <td><?php echo $row['email']; ?></td>
            <td><?php echo $iname; ?></td>
            
            <td><?php echo $row['role']; ?></td>
            <td><?php echo $row['status']; ?></td>
            <td>
                <a class="btn btn-warning btn-sm" data-toggle="modal" data-target="#myModal<?php echo $row['id']; ?>"><span class="glyphicon glyphicon-pencil" aria-hidden="true"></span></a>
                <a class="btn btn-danger btn-sm"  onclick="deletedata('<?php echo $row['id']; ?>')" ><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></a></td>

            <!-- Modal -->
            <div class="modal fade" id="myModal<?php echo $row['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel<?php echo $row['id']; ?>" aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                            <h4 class="modal-title" id="myModalLabel<?php echo $row['id']; ?>">Edit Data</h4>
                        </div>
                        <div class="modal-body">

                            <form action="php/newdata.php" method="POST">
                                <div class="form-group">
                                    <label for="nm">First Name</label>
                                    <input type="text" class="form-control" id="nm<?php echo $row['id']; ?>" value="<?php echo $row['fname']; ?>">
                                </div>
                                <div class="form-group">
                                    <label for="nm">Last Name</label>
                                    <input type="text" class="form-control" id="lm<?php echo $row['id']; ?>" value="<?php echo $row['lname']; ?>">
                                </div>
                                <div class="form-group">
                                    <label for="gd">Email</label>
                                    <input type="text" class="form-control" id="em<?php echo $row['id']; ?>" value="<?php echo $row['email']; ?>">
                                </div>
                                <div class="form-group">
                                    <label for="mn">New Password</label>
                                    <input type="text" class="form-control" id="nps" >
                                    <input type="text" style="display:none;" class="form-control" id="ps<?php echo $row['id']; ?>" value="<?php echo $row['password']; ?>">
                                </div>
                                <div class="form-group">
                                    <label for="ad">Role</label>

                                    <select class="form-control"  id="rl<?php echo $row['id']; ?>" >
                                        <option selected value="<?php echo $row['role']; ?>"><?php echo $row['role']; ?></option>
                                        <option value="admin">Admin</option>
                                        <option value="institute">Institute</option>
                                    </select>
                                </div>
                                <div class="form-group">
                                    <label for="ins">Institute</label>
                                    <select class="form-control" id="ins" name="ins">
                                        <option selected value="<?php $row['ins_id'];?>"><?php echo $iname;?></option>
                                        <?php
                                        $queryusers = "SELECT * FROM `institute` ";
                                        $db = mysqli_query($conn, $queryusers);
                                        while ( $d=mysqli_fetch_assoc($db)) {
                                            echo "<option value='".$d['inst_id']."'>".$d['name']."</option>";
                                            
                                        }
                                        ?>
                                        </select>
                                        </div>
                                <div class="modal-footer">
                            <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                            <button type="submit"  class="btn btn-primary" data-dismiss="modal">Save changes</button>
                        </div>
                            </form>

                        </div>
                        
                    </div>
                </div>
            </div>

            </td>
        </tr>
        <?php
    }
    ?>
    </tbody>
</table>
<script>
    $(function () {
        $('#example1').DataTable({
            "paging": true,
            "lengthChange": true,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": true
        });
    });
    function deletedata(str){
        var id = str;
        var conf = confirm("Are you sure, do you really want to delete this User?");
        if (conf == true){
            $.ajax({
                type: "GET",
                url: "php/deletedata.php?id="+id
            }).done(function( data ) {
                $('#info').html(data);
                viewdata();
            });
        }
    }
</script>