Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.38 KB | None | 0 0
  1.  
  2. <html>
  3. <meta http-equiv="refresh" content="2; URL=sms_get_job.php">
  4. <link href="../css/default.css" rel="stylesheet" type="text/css">
  5.  
  6. <body bgcolor=white>
  7. <table width="400" border="0" cellspacing="0" cellpadding="0">
  8. <?php
  9. $host = "sakura:/data/database/plx/plxsys.gdb";
  10. $username = "sysdba";
  11. $password = "masterkey";
  12.  
  13. $dbh = ibase_connect ($host, $username, $password);
  14. $stmt = "SELECT * FROM CHK_DATE('now','now',0)";
  15. $sth = ibase_query ($dbh, $stmt);
  16. $row = ibase_fetch_object ($sth)
  17. ?>
  18. <tr>
  19. <td colspan="4">Last updated:<? print $row->NDT1 ?></td></tr>
  20. <tr align="center">
  21. <th colspan="4">&nbsp;</th></tr>
  22. <tr align="center">
  23. <th colspan="4">SMS Outbound Gateway Queued Jobs</th></tr>
  24. <tr align="center">
  25. <th width="80">TAG</th>
  26. <th width="100">Queued</th>
  27. <th width="120">Purpose</th>
  28. <th width="80">Status</th>
  29. </tr>
  30. <?
  31. $stmt = 'SELECT * FROM SMSGW_LOADCNT';
  32. $sth = ibase_query ($dbh, $stmt);
  33.  
  34. while ($row = ibase_fetch_object ($sth)) {
  35. ?>
  36. <tr align="center">
  37. <th align=left><? print $row->TAG ?></th>
  38. <td align=right><? print number_format($row->CNT) ?>&nbsp;&nbsp;&nbsp;&nbsp;</td>
  39. <td align=right><? print $row->PTR.' '.$row->DETAIL ?></td>
  40. <td align=center><? if ($row->STATUS == 0){ print 'OFF';} else { print 'ON';} ?></td>
  41. </tr>
  42. <?
  43. }
  44. ibase_close ($dbh);
  45. ?>
  46. </table>
  47. </body>
  48. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement