Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- foreach ($dbDB->query($query) as $row) {
- echo "<tr>";
- echo "<td>" . $row['Country'] . "</td>";
- echo "<td>" . $row['OrderNumber'] . "</td>";
- echo "<td>" . $row['Region'] . "</td>";
- echo "<td>" . $row['ShipDate'] . "</td>";
- echo "<td>" . $row['ProducedDate'] . "</td>";
- echo "</tr>"; }
- ?>
- <?php
- $ser="12.95.124.83";
- $db="reporting";
- $user="admin";
- $pass="password";
- $query = 'SELECT '.$_POST['SelectedColumns'].' FROM reporting.REPORT_ALL';
- $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);
- $row = $_POST["SelectedColumns"];
- $rows = explode(",",$row);
- /*Here I have the another html code independent of this part */
- foreach ($dbDB->query($query) as $dataRow) {
- echo "<table>";
- echo "<tr>";
- foreach ($rows as $r ) {
- echo "<td>" . $dataRow[$r] . "</td>"; }
- echo "</tr>";
- echo "</table>"; }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement