Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script src="http://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
- <script data-cfasync="false" src="app_new.js"></script>
- <!DOCTYPE html>
- <html>
- <head>
- <style>
- #customers {
- font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
- border-collapse: collapse;
- width: 100%;
- }
- #customers td, #customers th {
- border: 1px solid #ddd;
- padding: 8px;
- }
- #customers tr:nth-child(even){background-color: #f2f2f2;}
- #customers tr:hover {background-color: #ddd;}
- #customers th {
- padding-top: 12px;
- padding-bottom: 12px;
- text-align: left;
- background-color: #4CAF50;
- color: white;
- }
- </style>
- </head>
- <?php
- if (!mssql_num_rows($query)) {
- echo 'No records found';
- } else {
- ?>
- <body>
- <table id="customers">
- <tr>
- <th>Order Number</th>
- <th>Name</th>
- <th>Delivery Instructions</th>
- <th>Ship Date</th>
- <th>Taker</th>
- <th>Customer Part Number</th>
- </tr>
- <?php
- while ($row = mssql_fetch_array($query)) {
- echo'<tr>';
- echo'<td>'. $row['order_no'].'</td>';
- echo'<td>'. $row['name'].'</td>';
- echo'<td>'. $row['delivery_instructions'].'</td>';
- echo'<td>'. $row['shipdate'].'</td>';
- echo'<td>'. $row['taker'].'</td>';
- echo'<td>'. $row['customer_part_number'].'</td>';
- echo'<tr>';
- }
- ?>
- </table>
- </body>
- </html>
- <script>
- $(window).on('beforeunload', function(){
- $(window).scrollTop(0);
- });
- </script>
- <?php
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement