1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / pattklvg / public_html / admin / pages / sankh_main / php /
Filename : getdata.php
back
<table id="example1" class="table table-bordered table-hover">
    <thead>
    <tr>
        <th>ID</th>
        <th>Name</th>
        <th>Panki Branch</th>
        <th>Temple</th>
        <th>Naivedh</th>
        <th>Action</th>
    </tr>
    </thead>
    <tbody>
    <?php
    include "../../../dist/resources/config.php";
    $res = $conn->query("select * from surname");
    while ($row = $res->fetch_assoc()) {
        ?>

        <tr>
            <td><?php echo $row['id']; ?></td>
            <td><?php echo $name = $row['name']; ?></td>
            <td><?php echo $branch = $row['branch']; ?></td>
            <td><?php echo $row['location']; ?></td>
            <td><?php echo $row['naivedh']; ?></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/updatedata.php" enctype="multipart/form-data" method="POST">
                                                            <div class="form-group">
                                                                <label for="nm">Name</label>
                                                                <input type="text" class="form-control" id="nm" name="nm" value="<?php echo $row['name']; ?>">
                                                            </div>
                                                            <div class="form-group">
                                                                <label for="br">Panki Branch</label>
                                                                <input type="text" class="form-control" name="br" id="br" value="<?php echo $row['branch']; ?>">                                                             
                                                            </div> 
                                                             <div class="form-group">
                                                                <label for="lc">Location/Temple/Madh</label>
                                                                <input type="text" class="form-control" id="lc" name="lc" value="<?php echo $row['location']; ?>">            
                                                            </div>
                                                             <div class="form-group">
                                                                <label for="gl">Google Map iframe Custom Size (1200x500px) </label>
                                                                <input type="text" class="form-control" id="gl" name="gl">
                                                            </div>
                                                            <div class="form-group">
                                                                <label for="photo">Image (370x250px)</label>
                                                                <input type="file" accept="image/*" class="form-control" name="photo">
                                                            </div>
                                                            <div class="form-group">
                                                                <label for="ni">Naivedh </label>
                                                                <input type="text" class="form-control" id="ni" name="ni" value="<?php echo $row['naivedh']; ?>">
                                                            </div>
                                                            <div class="form-group">
                                                                <label for="hs">History of Kuldevi</label>
                                                                <textarea class="textarea" id="editor1" name="hs" placeholder="Place some text here"
                                                                style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
                                                                <!--<textarea class="form-control textarea" rows="5" id="gd"></textarea>-->
                                                            </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 deletedata(str){
            var id = str;
            var conf = confirm("Are you sure, do you really want to Delete this Sankh?");
            if (conf == true){
                $.ajax({
                    type: "GET",
                    url: "php/deletedata.php?id="+id
                }).done(function( data ) {
                    $('#info').html(data);
                    viewdata();
                });
            }
        }
    $(function () {
        $('#example1').DataTable({
            "paging": true,
            "lengthChange": true,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": true
        });
    });
</script>