Contact
Hello nurhodelta_17,
please could i have your contact?
Thanks
CREATE TABLE `user` ( `userid` INT(11) NOT NULL AUTO_INCREMENT, `firstname` VARCHAR(30) NOT NULL, `lastname` VARCHAR(30) NOT NULL, PRIMARY KEY(`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
<?php //MySQLi Procedural if (!$conn) { } ?>
<?php include('conn.php'); ?> <!DOCTYPE html> <html lang = "en"> <head> <meta charset = "UTF-8" name = "viewport" content = "width-device=width, initial-scale=1" /> <link rel = "stylesheet" type = "text/css" href = "css/bootstrap.css" /> <title>PHP CRUD Operation using AJAX/JQuery</title> </head> <body> <div style="height:30px;"></div> <div class = "row"> <div class = "col-md-3"> </div> <div class = "col-md-6 well"> <div class="row"> <div class="col-lg-12"> <center><h2 class = "text-primary">PHP - CRUD Operation using AJAX/JQuery</h2></center> <hr> <div> <form class = "form-inline"> <div class = "form-group"> <label>Firstname:</label> <input type = "text" id = "firstname" class = "form-control"> </div> <div class = "form-group"> <label>Lastname:</label> <input type = "text" id = "lastname" class = "form-control"> </div> <div class = "form-group"> <button type = "button" id="addnew" class = "btn btn-primary"><span class = "glyphicon glyphicon-plus"></span> Add</button> </div> </form> </div> </div> </div><br> <div class="row"> <div id="userTable"></div> </div> </div> </div> </body> <script src = "js/jquery-3.1.1.js"></script> <script src = "js/bootstrap.js"></script> <script type = "text/javascript"> $(document).ready(function(){ showUser(); //Add New $(document).on('click', '#addnew', function(){ if ($('#firstname').val()=="" || $('#lastname').val()==""){ alert('Please input data first'); } else{ $firstname=$('#firstname').val(); $lastname=$('#lastname').val(); $.ajax({ type: "POST", url: "addnew.php", data: { firstname: $firstname, lastname: $lastname, add: 1, }, success: function(){ showUser(); } }); } }); //Delete $(document).on('click', '.delete', function(){ $id=$(this).val(); $.ajax({ type: "POST", url: "delete.php", data: { id: $id, del: 1, }, success: function(){ showUser(); } }); }); //Update $(document).on('click', '.updateuser', function(){ $uid=$(this).val(); $('#edit'+$uid).modal('hide'); $('body').removeClass('modal-open'); $('.modal-backdrop').remove(); $ufirstname=$('#ufirstname'+$uid).val(); $ulastname=$('#ulastname'+$uid).val(); $.ajax({ type: "POST", url: "update.php", data: { id: $uid, firstname: $ufirstname, lastname: $ulastname, edit: 1, }, success: function(){ showUser(); } }); }); }); //Showing our Table function showUser(){ $.ajax({ url: 'show_user.php', type: 'POST', async: false, data:{ show: 1 }, success: function(response){ $('#userTable').html(response); } }); } </script> </html>
<?php include('conn.php'); ?> <table class = "table table-bordered alert-warning table-hover"> <thead> <th>Firstname</th> <th>Lastname</th> <th>Action</th> </thead> <tbody> <?php ?> <tr> <td><?php echo $urow['firstname']; ?></td> <td><?php echo $urow['lastname']; ?></td> <td><button class="btn btn-success" data-toggle="modal" data-target="#edit<?php echo $urow['userid']; ?>"><span class = "glyphicon glyphicon-pencil"></span> Edit</button> | <button class="btn btn-danger delete" value="<?php echo $urow['userid']; ?>"><span class = "glyphicon glyphicon-trash"></span> Delete</button> <?php include('edit_modal.php'); ?> </td> </tr> <?php } ?> </tbody> </table> <?php } ?>
<?php include('conn.php'); $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; } ?>
<div class="modal fade" id="edit<?php echo $urow['userid']; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <?php ?> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class = "modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <center><h3 class = "text-success modal-title">Update Member</h3></center> </div> <form class="form-inline"> <div class="modal-body"> Firstname: <input type="text" value="<?php echo $nrow['firstname']; ?>" id="ufirstname<?php echo $urow['userid']; ?>" class="form-control"> Lastname: <input type="text" value="<?php echo $nrow['lastname']; ?>" id="ulastname<?php echo $urow['userid']; ?>" class="form-control"> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal"><span class = "glyphicon glyphicon-remove"></span> Cancel</button> | <button type="button" class="updateuser btn btn-success" value="<?php echo $urow['userid']; ?>"><span class = "glyphicon glyphicon-floppy-disk"></span> Save</button> </div> </form> </div> </div> </div>
<?php include('conn.php'); $id=$_POST['id']; $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; mysqli_query($conn,"update `user` set firstname='$firstname', lastname='$lastname' where userid='$id'"); } ?>
<?php include('conn.php'); $id=$_POST['id']; } ?>
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.