Guest User

Untitled

a guest
Aug 21st, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.42 KB | None | 0 0
  1. id fisrt last
  2. 1 juan a
  3. 2 pedro b
  4. 3 diago c
  5.  
  6. $conn = sqlsrv_connect( $server, $connectionInfo );
  7. //mi conecion a BD esta esta en sql server sqlsrv
  8.  
  9. $query = "SELECT * FROM testC ORDER BY id DESC";
  10. $result = sqlsrv_query($conn, $query);
  11.  
  12. <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  13. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  14. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  15. <script src="jquery.tabledit.min.js"></script>
  16. //las librerias , tengo ya en mi carpeta el documento con jquery
  17.  
  18. <table id="editable_table" class="table table-bordered table-striped">
  19. <thead>
  20. <tr>
  21. <th>ID</th>
  22. <th>First Name</th>
  23. <th>Last Name</th>
  24. </tr>
  25. </thead>
  26. <tbody>
  27. <?php
  28.  
  29. while($row = sqlsrv_fetch_array($result)){
  30. echo '
  31. <tr>
  32. <td>'.$row["id"].'</td>
  33. <td>'.$row["fisrt"].'</td>
  34. <td>'.$row["last"].'</td>
  35. </tr>
  36. ';
  37. }?>
  38. </tbody>
  39. </table>
  40. //la tabla anote mal first y puse fisrt pero lo e dejado asi por cuestiones de
  41. //ser una tabla test
  42.  
  43. <script>
  44. $(document).ready(function(){
  45. $('#editable_table').Tabledit({
  46. url:'action.php',
  47. columns:{
  48. identifier:[0, "id"],
  49. editable:[[1, 'fisrt'], [2, 'last']]
  50. },
  51. restoreButton:false,
  52. onSuccess:function(data, textStatus, jqXHR)
  53. {
  54. if(data.action == 'edit')
  55. {
  56. $('#'+data.id).remove();
  57. }
  58. }
  59. });
  60.  
  61. });
  62. </script>
  63.  
  64. $conn = sqlsrv_connect( $server, $connectionInfo );
  65.  
  66. $input = filter_input_array(INPUT_POST);
  67.  
  68. $query = "SELECT * FROM testC WHERE fisrt=? AND last=?";
  69. $parameters = [$_POST["fisrt"], $_POST["last"]];
  70. $result = sqlsrv_query($conn, $query, $parameters);
  71.  
  72.  
  73. if($input["action"] === 'edit')
  74. {
  75. $query_edit = "UPDATE testC
  76. SET fisrt = '$first_name',
  77. last = '$last_name'
  78. WHERE id = '$input["id"]'";
  79.  
  80. sqlsrv_query($conn, $query);
  81.  
  82. }
  83. if($input["action"] === 'delete')
  84. {
  85. //$query = "DELETE FROM testC WHERE id = '".$input["id"]."'";sqlsrv_query($conn, $query);
  86. $query_edit = "UPDATE testC SET
  87. fisrt = '$first_name',
  88. last = '$last_name'
  89. WHERE id = '$input["id"]'";
  90.  
  91. sqlsrv_query($conn, $query_edit);
  92.  
  93.  
  94. }
  95.  
  96. echo json_encode($input);
  97.  
  98. ?>
Add Comment
Please, Sign In to add comment