User Tools

Site Tools


testcount

Test dance count

  http://ottawaenglishdance.org/playford/p-dance/dancecounter.php
  <?php
  /* dancecounter.php */
   $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>\

“);

   mysql_close($dbcnx);
   ?>
testcount.txt · Last modified: 2014/07/18 15:52 (external edit)