i want to know how to count when someone click to download some file..

important notice.. i don't store my files in database..i store it into
webroot/files

and i use meioupload to upload files


CREATE TABLE IF NOT EXISTS `downloads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(50) NOT NULL,
  `title` varchar(70) NOT NULL,
  `type` varchar(150) NOT NULL,
  `filesize` int(11) unsigned NOT NULL,
  `counts` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;


{{{

downloads_controller.php


<?php
class DownloadsController extends AppController {
     var $helpers = array ( "Html", "Ajax", "Javascript" ,"Number");
     var $name = 'Downloads';
     var $paginate = array('limit' => 3, 'page' => 1, 'order' =>
                                array('Download.id'=>'desc'));

    function index() {
        $this->set('downloads', $this->paginate());
    }
}
?>

downloads/index.ctp


<?php
    $i = 0;
    foreach ($downloads as $download):
        $class = null;
        if ($i++ % 2 == 0) {
            $class = ' class="altrow"';
        }
    ?>
    <tr<?php echo $class;?>>
        <td>

 <?php
 $title = $download['Download']['title'];
$filename = '/files/'.$download['Download']['filename'];
 echo $this->Html->link($title, $filename,array('escape' => false));

?>

</td>

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to