a pretty similar question has just been asked a day before you posted this on ask.cakephp.org @ stackoverflow: http://stackoverflow.com/questions/8877842/how-to-count-the-number-of-user-downloads/ with probably the answer you are looking for
On 18 Jan., 15:37, ahmed fakher <[email protected]> wrote: > i want to know how to count when someone click to download some > file..please i need one example with answer ..cause i mam newbie > > important notice > .. i don't store my files in database..i store it into webroot/files > and i use meioupload to upload files > i see this tut but i don't understand how to use it > > 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
