Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host = 'localhost';
- $db_user = 'root';
- $db_pass = '';
- $db_name = 'Proyecto';
- $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
- if (!$conn) {
- die ('Failed to connect to MySQL: ' . mysqli_connect_error());
- }
- $sql = 'SELECT * FROM tecnica1';
- $sql1 = 'SELECT * FROM empadronamiento';
- $sql2 = 'SELECT * FROM inspeccion';
- $sql3 = 'SELECT * FROM SistemaInfGeografica';
- $sql4 = 'SELECT * FROM tecnica2';
- $query = mysqli_query($conn, $sql);
- $query1 = mysqli_query($conn, $sql1);
- $query2 = mysqli_query($conn, $sql2);
- $query3 = mysqli_query($conn, $sql3);
- $query4 = mysqli_query($conn, $sql4);
- if (!$query) {
- die ('SQL Error: ' . mysqli_error($conn));
- }
- while ($row = mysqli_fetch_array($query))
- {
- echo '<tr>
- <td class="tg-r8b1" style="text-align:center;">'.$row['Mes'].'</td>
- <td style="text-align:center;">'.$row['M'].'</td>
- <td style="text-align:center;">'.$row['MH'].'</td>
- <td style="text-align:center;">'.$row['DJ'].'</td>
- <td style="text-align:center;">'.$row['R'].'</td>
- <td style="text-align:center;">'.$row['PO'].'</td>
- <td style="text-align:center;">'.$row['POTNM'].'</td>
- ';}
- while ($row = mysqli_fetch_array($query1))
- {
- echo
- '
- <td style="text-align:center;">'.$row['CargaTotal'].'</td>
- <td style="text-align:center;">'.$row['DescargaTotal'].'</td>
- <td style="text-align:center;">'.$row['DescargaDSIG'].'</td>
- ';}
- while ($row = mysqli_fetch_array($query2))
- {
- echo
- '
- <td style="text-align:center;">'.$row['CargaTotal'].'</td>
- <td style="text-align:center;">'.$row['DescargaTotal'].'</td>
- <td style="text-align:center;">'.$row['DescargaDSIG'].'</td>
- ';}
- while ($row = mysqli_fetch_array($query3))
- {
- echo
- '
- <td style="text-align:center;">'.$row['FCGrabadas'].'</td>
- <td style="text-align:center;">'.$row['FCGrabVuelos'].'</td>
- ';}
- while ($row = mysqli_fetch_array($query4))
- {
- echo
- '
- <td style="text-align:center;">'.$row['FCConformadas'].'</td>
- </tr>';}
- ?>
Add Comment
Please, Sign In to add comment