Speaking of moot points, it's "moot" not "mute" On Feb 11, 3:09 am, Sam Sherlock <[email protected]> wrote: > FWIW the suggestions made by Ryan & Jeremy are better than using the Model > Query method > as you lose out on the cake auto magic with the method > > $this->Video->doIncrement($id); > vs > $this->Video->query('UPDATE fociki_videos' . ' SET views = views + > 1' . ' WHERE id = ' . $video['Video']['id']); > > this point might be mute in this case but its worth knowing; > any how the first option is > > a) less code > b) clearer > c) does not tie your app to using a table name with prefix > > - S > > On 11 February 2011 04:55, [email protected] <[email protected]> wrote: > > > Thank You Jeremy, > > I got another approch to it... > > here is what works in my case: > > > $this->Video->query('UPDATE fociki_videos' . ' SET views = views + > > 1' . ' WHERE id = ' . $video['Video']['id']); > > > Thank You for Your Help guys,... > > I love you with all my heart... LoL > > > I'm sorry to bother you with all these questions,... I learn on the > > way,... With little or no knowllege of CAKE and PHP I have gone so > > far... Check me out if you what,... and hire me for your next project > > help... LOL Just kidding guys, don't take it siriously... > > > Thank you All !! > > chris > > > On Feb 10, 8:39 pm, Jeremy Burns | Class Outfit > > <[email protected]> wrote: > > > Sounds like you need to have a line of code in the controller's view > > method that calls a simple model function: > > > > $this->Model->increment($id); > > > > In the model: > > > > function increment($id) { > > > $this->updateAll(array('Model.view_count' => > > 'Model.view_count+1'), array('Model.id' => $id)); > > > > } > > > > Or you could just call it directly from the view method in the > > controller: > > > > $this->Model->updateAll(array('Model.view_count' => > > 'Model.view_count+1'), array('Model.id' => $id)); > > > > This way, whenever the view method is called (in other words, each time > > the page is rendered) you increment the view_count field by one. > > > > Jeremy Burns > > > Class Outfit > > > > [email protected]http://www.classoutfit.com > > > > On 11 Feb 2011, at 03:31, [email protected] wrote: > > > > > Hi Jeremy, > > > > What I'm looking for is to set the data,... say to set field views in > > > > Video table increment by 1 every time page accessed. To set data,... > > > > NOT to retrive. > > > > > Thanks > > > > chris > > > > > On Feb 10, 1:11 pm, Jeremy Burns | Class Outfit > > > > <[email protected]> wrote: > > > >> RTFM.http://book.cakephp.org/ > > > > >> Jeremy Burns > > > >> Class Outfit > > > > >> [email protected]http://www.classoutfit.com > > > > >> On 10 Feb 2011, at 20:57, [email protected] wrote: > > > > >>> Hi Mike, > > > >>> Yes, I know that I have to read from table,... > > > >>> But I don't know how... LOL > > > >>> the code... anyone can help...? > > > > >>> Thanks > > > >>> chris > > > > >>> On Feb 10, 11:59 am, mike karthauser <[email protected]> > > wrote: > > > >>>> On 10 Feb 2011, at 17:30, "[email protected]" <[email protected]> > > wrote: > > > > >>>>> Hi All, > > > >>>>> How u All Doinnn...?! > > > > >>>>> Can anyone teach me how to setup views,... so when page is > > > >>>>> accessed ... it will set field views="increment numbers" like Video > > > >>>>> views=906, Group views=489, etc.. like how many time page has been > > > >>>>> accessed. > > > > >>>> You won't be doing any counts in the view, rather updating the count > > when the action is called and passing that value to the view. > > > > >>>> All you'll need to do is to get a count value from your table and > > then resave it after you have added 1. You may also want to do this as an > > ajax call in JavaScript when you have played say half of the video as then > > it won't be affected if bots hit the page or people refresh loads > > > > >>>>> Thanks > > > >>>>> chris > > > > >>>>> -- > > > >>>>> Our newest site for the community: CakePHP Video Tutorialshttp:// > > tv.cakephp.org > > > >>>>> Check out the new CakePHP Questions > > sitehttp://ask.cakephp.organdhelpotherswith their CakePHP related > > questions. > > > > >>>>> To unsubscribe from this group, send email to > > > >>>>> [email protected] For more options, visit this > > group athttp://groups.google.com/group/cake-php > > > > >>> -- > > > >>> Our newest site for the community: CakePHP Video Tutorialshttp:// > > tv.cakephp.org > > > >>> Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp > > others with their CakePHP related questions. > > > > >>> To unsubscribe from this group, send email to > > > >>> [email protected] For more options, visit this > > group athttp://groups.google.com/group/cake-php > > > > > -- > > > > Our newest site for the community: CakePHP Video Tutorialshttp:// > > tv.cakephp.org > > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > > [email protected] For more options, visit this > > group athttp://groups.google.com/group/cake-php > > > -- > > Our newest site for the community: CakePHP Video Tutorials > >http://tv.cakephp.org > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > > [email protected] For more options, visit this group > > athttp://groups.google.com/group/cake-php
-- 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
