Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. <?php
  2. foreach ($dbDB->query($query) as $row) {
  3.  
  4. echo "<tr>";
  5. echo "<td>" . $row['Country'] . "</td>";
  6. echo "<td>" . $row['OrderNumber'] . "</td>";
  7. echo "<td>" . $row['Region'] . "</td>";
  8. echo "<td>" . $row['ShipDate'] . "</td>";
  9. echo "<td>" . $row['ProducedDate'] . "</td>";
  10.  
  11. echo "</tr>"; }
  12. ?>
  13.  
  14. <?php
  15. $ser="12.95.124.83";
  16. $db="reporting";
  17. $user="admin";
  18. $pass="password";
  19. $query = 'SELECT '.$_POST['SelectedColumns'].' FROM reporting.REPORT_ALL';
  20.  
  21. $dbDB = new PDO("odbc:Driver=ODBC Driver 13 for SQL Server;Server=10.99.244.81,1456;Database=DM_EMEA_BIZ;Port=1456", $user, $pass);
  22.  
  23. $row = $_POST["SelectedColumns"];
  24. $rows = explode(",",$row);
  25.  
  26. /*Here I have the another html code independent of this part */
  27.  
  28. foreach ($dbDB->query($query) as $dataRow) {
  29. echo "<table>";
  30. echo "<tr>";
  31.  
  32. foreach ($rows as $r ) {
  33. echo "<td>" . $dataRow[$r] . "</td>"; }
  34.  
  35. echo "</tr>";
  36. echo "</table>"; }
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement