Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <meta http-equiv="refresh" content="2; URL=sms_get_job.php">
- <link href="../css/default.css" rel="stylesheet" type="text/css">
- <body bgcolor=white>
- <table width="400" border="0" cellspacing="0" cellpadding="0">
- <?php
- $host = "sakura:/data/database/plx/plxsys.gdb";
- $username = "sysdba";
- $password = "masterkey";
- $dbh = ibase_connect ($host, $username, $password);
- $stmt = "SELECT * FROM CHK_DATE('now','now',0)";
- $sth = ibase_query ($dbh, $stmt);
- $row = ibase_fetch_object ($sth)
- ?>
- <tr>
- <td colspan="4">Last updated:<? print $row->NDT1 ?></td></tr>
- <tr align="center">
- <th colspan="4"> </th></tr>
- <tr align="center">
- <th colspan="4">SMS Outbound Gateway Queued Jobs</th></tr>
- <tr align="center">
- <th width="80">TAG</th>
- <th width="100">Queued</th>
- <th width="120">Purpose</th>
- <th width="80">Status</th>
- </tr>
- <?
- $stmt = 'SELECT * FROM SMSGW_LOADCNT';
- $sth = ibase_query ($dbh, $stmt);
- while ($row = ibase_fetch_object ($sth)) {
- ?>
- <tr align="center">
- <th align=left><? print $row->TAG ?></th>
- <td align=right><? print number_format($row->CNT) ?> </td>
- <td align=right><? print $row->PTR.' '.$row->DETAIL ?></td>
- <td align=center><? if ($row->STATUS == 0){ print 'OFF';} else { print 'ON';} ?></td>
- </tr>
- <?
- }
- ibase_close ($dbh);
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement