admin/introductionstatus.php

   1 <?php\r
   2 \r
   3         include_once('config.php');\r
   4         include_once('linkbar.php');\r
   5                 \r
   6 function content()\r
   7 {\r
   8         global $dblocation;\r
   9         \r
  10         $db=new PDO('sqlite:'.$dblocation);\r
  11         $st=$db->prepare("SELECT tblLocalIdentity.Name, COUNT(Inserted) FROM tblLocalIdentity LEFT JOIN tblIdentityIntroductionInserts ON tblLocalIdentity.LocalIdentityID=tblIdentityIntroductionInserts.LocalIdentityID WHERE (Inserted='true' OR Inserted IS NULL) GROUP BY tblLocalIdentity.LocalIdentityID;");\r
  12         $st->execute();\r
  13         \r
  14         ?>\r
  15         <h2>Introduction Status</h2>\r
  16         <table>\r
  17                 <tr>\r
  18                         <th>Identity</th>\r
  19                         <th>Successful introduction inserts</th>\r
  20                 </tr>\r
  21                 <?php\r
  22                 while($record=$st->fetch())\r
  23                 {\r
  24                         ?>\r
  25                 <tr>\r
  26                         <td>\r
  27                                 <?php print $record[0]; ?>\r
  28                         </td>\r
  29                         <td>\r
  30                                 <?php print $record[1]; ?>\r
  31                         </td>\r
  32                 </tr>\r
  33                         <?php   \r
  34                 }\r
  35                 ?>\r
  36         </table>\r
  37         <?php\r
  38 }\r
  39         \r
  40         include_once('template.php');\r
  41 \r
  42 ?>