Guest User

Untitled

a guest
Jul 5th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. <?php
  2. <html lang="pt-br">
  3. <head>
  4. <meta charset="utf-8">
  5. <title>titulo</title>
  6. <link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
  7. <script src="https://code.jquery.com/jquery-3.3.1.js"></script>
  8. <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
  9. <script type="text/javascript" language="javascript">
  10. $(document).ready(function() {
  11. $('#listar-usuario').DataTable({
  12. "processing": true,
  13. "serverSide": true,
  14. "ajax": {
  15. "url": "proc_pesq_user.php",
  16. "type": "POST"
  17. }
  18. });
  19. } );
  20. </script>
  21.  
  22. <?php
  23. header("Content-Type: text/html; charset=UTF-8",true);
  24. $servername = "localhost";
  25. $username = "root";
  26. $password = "010203";
  27. $dbname = "banco";
  28. $conn = mysqli_connect($servername, $username, $password, $dbname);
  29. $conn->set_charset("utf8");
  30.  
  31. $result_user = "SELECT idservidor, nome, celular FROM servidor";
  32. $resultado_user =mysqli_query($conn, $result_user);
  33. $qnt_linhas = mysqli_num_rows($resultado_user);
  34.  
  35. $result_usuarios = "SELECT idservidor, nome, celular FROM servidor WHERE 1=1";
  36. if( !empty($requestData['search']['value']) ) { // se houver um parâmetro de
  37.  
  38. $result_usuarios.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']."
  39.  
  40. $dados = array();
  41. while( $row_usuarios =mysqli_fetch_array($resultado_usuarios) ) {
  42. $dado = array();
  43. $dado[] = $row_usuarios["idservidor"];
  44. $dado[] = $row_usuarios["nome"];
  45. $dado[] = $row_usuarios["celular"];
  46. $dados[] = $dado;
  47. }
  48.  
  49. $json_data = array(
  50. "draw" => intval( $requestData['draw'] ),//para cada requisição é enviado um
Add Comment
Please, Sign In to add comment