Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id fisrt last
- 1 juan a
- 2 pedro b
- 3 diago c
- $conn = sqlsrv_connect( $server, $connectionInfo );
- //mi conecion a BD esta esta en sql server sqlsrv
- $query = "SELECT * FROM testC ORDER BY id DESC";
- $result = sqlsrv_query($conn, $query);
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
- <script src="jquery.tabledit.min.js"></script>
- //las librerias , tengo ya en mi carpeta el documento con jquery
- <table id="editable_table" class="table table-bordered table-striped">
- <thead>
- <tr>
- <th>ID</th>
- <th>First Name</th>
- <th>Last Name</th>
- </tr>
- </thead>
- <tbody>
- <?php
- while($row = sqlsrv_fetch_array($result)){
- echo '
- <tr>
- <td>'.$row["id"].'</td>
- <td>'.$row["fisrt"].'</td>
- <td>'.$row["last"].'</td>
- </tr>
- ';
- }?>
- </tbody>
- </table>
- //la tabla anote mal first y puse fisrt pero lo e dejado asi por cuestiones de
- //ser una tabla test
- <script>
- $(document).ready(function(){
- $('#editable_table').Tabledit({
- url:'action.php',
- columns:{
- identifier:[0, "id"],
- editable:[[1, 'fisrt'], [2, 'last']]
- },
- restoreButton:false,
- onSuccess:function(data, textStatus, jqXHR)
- {
- if(data.action == 'edit')
- {
- $('#'+data.id).remove();
- }
- }
- });
- });
- </script>
- $conn = sqlsrv_connect( $server, $connectionInfo );
- $input = filter_input_array(INPUT_POST);
- $query = "SELECT * FROM testC WHERE fisrt=? AND last=?";
- $parameters = [$_POST["fisrt"], $_POST["last"]];
- $result = sqlsrv_query($conn, $query, $parameters);
- if($input["action"] === 'edit')
- {
- $query_edit = "UPDATE testC
- SET fisrt = '$first_name',
- last = '$last_name'
- WHERE id = '$input["id"]'";
- sqlsrv_query($conn, $query);
- }
- if($input["action"] === 'delete')
- {
- //$query = "DELETE FROM testC WHERE id = '".$input["id"]."'";sqlsrv_query($conn, $query);
- $query_edit = "UPDATE testC SET
- fisrt = '$first_name',
- last = '$last_name'
- WHERE id = '$input["id"]'";
- sqlsrv_query($conn, $query_edit);
- }
- echo json_encode($input);
- ?>
Add Comment
Please, Sign In to add comment