Guest User

Untitled

a guest
Nov 5th, 2018
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.92 KB | None | 0 0
  1. <?php
  2. $db_host = 'localhost';
  3. $db_user = 'root';
  4. $db_pass = '';
  5. $db_name = 'Proyecto';
  6.  
  7. $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
  8. if (!$conn) {
  9. die ('Failed to connect to MySQL: ' . mysqli_connect_error());
  10. }
  11.  
  12. $sql = 'SELECT * FROM tecnica1';
  13. $sql1 = 'SELECT * FROM empadronamiento';
  14. $sql2 = 'SELECT * FROM inspeccion';
  15. $sql3 = 'SELECT * FROM SistemaInfGeografica';
  16. $sql4 = 'SELECT * FROM tecnica2';
  17.  
  18. $query = mysqli_query($conn, $sql);
  19. $query1 = mysqli_query($conn, $sql1);
  20. $query2 = mysqli_query($conn, $sql2);
  21. $query3 = mysqli_query($conn, $sql3);
  22. $query4 = mysqli_query($conn, $sql4);
  23.  
  24. if (!$query) {
  25. die ('SQL Error: ' . mysqli_error($conn));
  26. }
  27.  
  28. while ($row = mysqli_fetch_array($query))
  29. {
  30. echo '<tr>
  31. <td class="tg-r8b1" style="text-align:center;">'.$row['Mes'].'</td>
  32. <td style="text-align:center;">'.$row['M'].'</td>
  33. <td style="text-align:center;">'.$row['MH'].'</td>
  34. <td style="text-align:center;">'.$row['DJ'].'</td>
  35. <td style="text-align:center;">'.$row['R'].'</td>
  36. <td style="text-align:center;">'.$row['PO'].'</td>
  37. <td style="text-align:center;">'.$row['POTNM'].'</td>
  38. ';}
  39.  
  40. while ($row = mysqli_fetch_array($query1))
  41. {
  42. echo
  43. '
  44. <td style="text-align:center;">'.$row['CargaTotal'].'</td>
  45. <td style="text-align:center;">'.$row['DescargaTotal'].'</td>
  46. <td style="text-align:center;">'.$row['DescargaDSIG'].'</td>
  47. ';}
  48.  
  49. while ($row = mysqli_fetch_array($query2))
  50. {
  51. echo
  52. '
  53. <td style="text-align:center;">'.$row['CargaTotal'].'</td>
  54. <td style="text-align:center;">'.$row['DescargaTotal'].'</td>
  55. <td style="text-align:center;">'.$row['DescargaDSIG'].'</td>
  56. ';}
  57.  
  58. while ($row = mysqli_fetch_array($query3))
  59. {
  60. echo
  61. '
  62. <td style="text-align:center;">'.$row['FCGrabadas'].'</td>
  63. <td style="text-align:center;">'.$row['FCGrabVuelos'].'</td>
  64. ';}
  65.  
  66. while ($row = mysqli_fetch_array($query4))
  67. {
  68. echo
  69. '
  70. <td style="text-align:center;">'.$row['FCConformadas'].'</td>
  71.  
  72. </tr>';}
  73. ?>
Add Comment
Please, Sign In to add comment