dreglo

I found a script that I'm trying to use as a work-around for what I REALLY want. It's a "simple" (not for me) hit counter based on mysql. The creator of the script did give instructions on how to install it but I know I'm doing something wrong ( seeing as I know NOTHING about PHP or mysql), Here is the script: <?php ///////////////////// DSCRIPTS PRESENTS ///////////////////////////////////// // // // This script has been downloaded from http://dscripts.awardspace.com // // --------------------------------------------------------------------- // // // // Script Name: MySQL Hit Counter // // Written on: 5 January 2007 // // Written by: Burhan Uddin // // // // Browse: http://dscripts.awardspace.com for more free scripts. // // // ///////////////////////////////////////////////////////////////////////////// $page = $_GET['page']; // Exits script if page id isn't supplied if(!$page) { echo 'document.write(\'Invalid Page ID\')'; exit(); } // MySQL Informations. Change it to yours $host = 'localhost'; // Host Name $user = 'root'; // User Name $pass = 'admin'; // Password $db = 'test'; // Database Name //--------------------------------------------- // Don't edit below /* This query is required to be executed using phpMyAdmin to create a table for storing data CREATE TABLE `mysql_couter_logs` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` TEXT NOT NULL , `hits` INT NOT NULL DEFAULT '0' ) */ // Connection to database $db = mysql_connect($host, $user, $pass) or die ( 'Failed to connect with database!' ); mysql_select_db($db) or die ("Can't select database!"); $query= "SELECT id, hits FROM `mysql_couter_logs` WHERE page = '$page'"; $result = mysql_query($query) or die ("document.write('Error in getting hit counts!')"); while ($data = mysql_fetch_array($result)) { $id = $data[id]; $count = $data[hits]; } $count = $count+1; echo 'document.write(\''.$count.'\');'; $query = "UPDATE mysql_couter_logs SET hits = '$count' WHERE page = '$page'"; $result = mysql_query($query) or die ("document.write('Error in storing hit counts!')"); ?> Here is the Javascript to show the number on the selected page: <SCRIPT LANGUAGE="Javascript" SRC="counter.php?page=pagename"><!--//--></SCRIPT> I also set up the database table as instructed in phpmyadmin. All this and no results so I know it's me. Here is the URL of the page where I want the number to appear (in the box that has "For restaurant use only" in it, under the header "Certificate #" http://metrodetroitrestaurantguide.com/index.php?option=com_content&view=article&id=11:cert-template&catid=15:gc Any help or guidance would be greatly appreciated.

I found a script that I'm trying to use as a work-around for what I REALLY want. It's a "simple" (not for me) hit counter based on mysql. The creator of the script did give instructions on how to install it but I know I'm doing something wrong ( seeing as I know NOTHING about PHP or mysql), Here is the script: <?php ///////////////////// DSCRIPTS PRESENTS ///////////////////////////////////// // // // This script has been downloaded from http://dscripts.awardspace.com // // --------------------------------------------------------------------- // // // // Script Name: MySQL Hit Counter // // Written on: 5 January 2007 // // Written by: Burhan Uddin // // // // Browse: http://dscripts.awardspace.com for more free scripts. // // // ///////////////////////////////////////////////////////////////////////////// $page = $_GET['page']; // Exits script if page id isn't supplied if(!$page) { echo 'document.write(\'Invalid Page ID\')'; exit(); } // MySQL Informations. Change it to yours $host = 'localhost'; // Host Name $user = 'root'; // User Name $pass = 'admin'; // Password $db = 'test'; // Database Name //--------------------------------------------- // Don't edit below /* This query is required to be executed using phpMyAdmin to create a table for storing data CREATE TABLE `mysql_couter_logs` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` TEXT NOT NULL , `hits` INT NOT NULL DEFAULT '0' ) */ // Connection to database $db = mysql_connect($host, $user, $pass) or die ( 'Failed to connect with database!' ); mysql_select_db($db) or die ("Can't select database!"); $query= "SELECT id, hits FROM `mysql_couter_logs` WHERE page = '$page'"; $result = mysql_query($query) or die ("document.write('Error in getting hit counts!')"); while ($data = mysql_fetch_array($result)) { $id = $data[id]; $count = $data[hits]; } $count = $count+1; echo 'document.write(\''.$count.'\');'; $query = "UPDATE mysql_couter_logs SET hits = '$count' WHERE page = '$page'"; $result = mysql_query($query) or die ("document.write('Error in storing hit counts!')"); ?> Here is the Javascript to show the number on the selected page: <SCRIPT LANGUAGE="Javascript" SRC="counter.php?page=pagename"><!--//--></SCRIPT> I also set up the database table as instructed in phpmyadmin. All this and no results so I know it's me. Here is the URL of the page where I want the number to appear (in the box that has "For restaurant use only" in it, under the header "Certificate #" http://metrodetroitrestaurantguide.com/index.php?option=com_content&view=article&id=11:cert-template&catid=15:gc Any help or guidance would be greatly appreciated.