Playford's Progeny

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=====  Test dance count  =====

<code>
  http://ottawaenglishdance.org/playford/p-dance/dancecounter.php</code>


<code>
  <?php
  /* dancecounter.php */</code>
   
   
<code>
   $wgDBserver         = "localhost";
   $wgDBname           = "playford";
   $wgDBuser           = "playford";
   $wgDBpassword       = "pw4playford";
   $wgDBport           = "5432";
   $wgDBprefix         = "pf";
   $dbcnx = @mysql_connect($wgDBserver, $wgDBuser, $wgDBpassword) or die (mysql_error());
   @mysql_select_db($wgDBname);
   if (!$dbcnx)
     {
       die("Could not connect to $wgDBserver: " . mysql_error());
   }
      mysql_select_db("my_db", $dbcnx);
   $result = mysql_query("SELECT *  FROM `pfpage` WHERE `page_title` LIKE  '%INS:%'");
   $numdance = 0;
   while($row = mysql_fetch_array($result))
   {
   /*
    echo $row[['page_title']];
    echo "<br />";
   */
    $numdance++;
    }
   echo ("# = $numdance<BR>\</code>
");     
   
<code>
   mysql_close($dbcnx);
   ?></code>