Auction item hit counter

[bwilson]

Would it be difficult to add a hit counter for each auction item?

Would it be as simple as adding a "count" field to the products table and then adding some code to the view_product.html file?

I'm new to php/mySql.

Bob

[shannah]

Yup.. that's pretty much all it would take.

The code in view_product.html might look something like:

Code: Select all

{php}
$app =& Dataface_Application::getInstance();
$product =& $app->getRecord();
if ( $product ){
    mysql_query("update products set `count` = `count`+1 where product_id='".addslashes($record->val('product_id'))."'", df_db());
}
{/php}


assuming that you added a field named 'count' to the products table.

Note that this won't work properly if you are using the dataface output cache (which is disabled by default).