Re: A little help needed on determining my model relation ships please
ok here is how you should do that create you category table first then create your product table in the product table just include category_id then you can do product belongs to category or cake bake it it will ask you what model associations let me know how you did On Jun 4, 6:45 am, Beedge cake...@hbit.ie wrote: Hi all, about to start on my first cake project. A straight forward e- commerce site. I am not used to having to visualise my database relationships so I was hoping for a little help. A product belongs in a category A product can be in many categories A Category has Sub categories Is this just a HABTM relationship between products and categories? I will be using tree behavior for my categories. Any comments on this or helpers? I would love to find a tutorial that covered this, but all I can really find is blog tutorials! Thanks in advance Kev --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Auth Session question
it worked thanks
On Jun 2, 10:37 am, brian bally.z...@gmail.com wrote:
On Mon, Jun 1, 2009 at 1:20 PM, cake_baker muni...@hotmail.com wrote:
ok here is the full the details
i'm using a star rating plugin that need user.id in the Session
define('RATING_SESSION_USER_ID', 'User.id');
This defines the session key? You can get Auth's session info using
$this-Session-read('Auth.User.id') so, in this case, 'Auth.User.id'
should work for your define().
I've never used the plugin, so if this doesn't work, maybe you should
re-send your query with Star rating somewhere in the subject line.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Belongs to Hasmany
hey i'm working on comment box so need help
var $belongsTo = array(
'User' = array(
'className' = 'User',
'foreignKey' = 'user_id',
'conditions' = '',
'fields' = '',
'order' = ''
),
'Recipe' = array(
'className' = 'Recipe',
'foreignKey' = 'recipe_id',
'conditions' = '',
'fields' = '',
'order' = ''
)
);
what i wannna do is have user login before using the comment then
and comment on the recipe they are viewing
so what you guys think
function add() {
if (!empty($this-data)) {
$this-Comment-create();
if ($this-Comment-save($this-data)) {
$this-Session-setFlash(__('The Comment has
been saved', true));
$this-redirect(array('action'='index'));
} else {
$this-Session-setFlash(__('The Comment could
not be saved.
Please, try again.', true));
}
}
$this-set(compact('users', 'recipes'));
}
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: A good helper for cake 1.2 for Datepicker?
here is the links maybe help you http://nik.chankov.net/2007/09/13/advanced-datepicker-helper-for-cakephp/ On Jun 3, 7:03 am, Dr.Dran franco.tampi...@gmail.com wrote: Hi! Does anyone know if there is a good tutorial or helper to have the datepicker function implemented in cake? I see in the backery but the tutorial is for cake 1.1 Best Regards Franco Tampieri --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Auth Session question
How you write user.id a Session with auth i did this but dosent work
Login
!$user = $this-Auth-user();
$this-Session-write('User.id', $user['User']['id']);
logout
$this-Session-del('User.id');
Thank you
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Auth Session question
ok here is the full the details
i'm using a star rating plugin that need user.id in the Session
define('RATING_SESSION_USER_ID', 'User.id');
so i need the user.id to written in the Session unless you know an
other solution
it wont work with out this
On Jun 1, 9:12 am, brian bally.z...@gmail.com wrote:
If you're using Auth you don't need to store the User ID in the
session. Just grab it with $this-Auth-user('id') whenever you need
it.
On Mon, Jun 1, 2009 at 9:55 AM, cake_baker muni...@hotmail.com wrote:
How you write user.id a Session with auth i did this but dosent work
Login
!$user = $this-Auth-user();
$this-Session-write('User.id', $user['User']['id']);
logout
$this-Session-del('User.id');
Thank you
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Star Rating Help
Your are Right Henrique Machado i searched the whole google i couldnt find any good one. well this is the problem i'm new to cake this is what i did to this code i create the database table then MVC then linked the java files and css what i dont know is how to the database instert /selects ajax calls in cakephp is this something you put in model or controller never done it before this is the link to the file http://www.masugadesign.com/the-lab/scripts/unobtrusive-ajax-star-rating-bar/ if some one wanna help me with that i think there is alot of people looking for star rating for cakephp . there is alot of star rating helpers for Ruby on Rails all other framework but not cakephp thank you all --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Star Rating Help
hey guys i searched the whole google i coudnt find any star rating
helper for cakephp i found two they are oudated
i found a star rating called ajaxstarrater_v122 its php and it stores
it in database and i have no idea how to implement it to cakephp if
some help here thank you in advance
these are some code give u ideas
this is the databse file
?php
/*
Page: _config-rating.php
Created:Aug 2006
Last Mod: Mar 18 2007
Holds info for connecting to the db, and some other vars
-
ryan masuga, masugadesign.com
r...@masugadesign.com
Licensed under a Creative Commons Attribution 3.0 License.
http://creativecommons.org/licenses/by/3.0/
See readme.txt for full credit details.
- */
//Connect to your rating database
$rating_dbhost= 'localhost';
$rating_dbuser= 'root';
$rating_dbpass= 'root';
$rating_dbname= 'rating';
$rating_tableName = 'ratings';
$rating_path_db = ''; // the path to your db.php file (not used
yet!)
$rating_path_rpc = ''; // the path to your rpc.php file (not
used yet!)
$rating_unitwidth = 30; // the width (in pixels) of each rating
unit (star, etc.)
// if you changed your graphic to be 50 pixels wide, you should
change the value above
$rating_conn = mysql_connect($rating_dbhost, $rating_dbuser,
$rating_dbpass) or die ('Error connecting to mysql');
//mysql_select_db($rating_dbname);
?
this _drawrating.php
?php
/*
Page: _drawrating.php
Created:Aug 2006
Last Mod: Mar 18 2007
The function that draws the rating bar.
-
ryan masuga, masugadesign.com
r...@masugadesign.com
Licensed under a Creative Commons Attribution 3.0 License.
http://creativecommons.org/licenses/by/3.0/
See readme.txt for full credit details.
- */
function rating_bar($id,$units='',$static='') {
require('_config-rating.php'); // get the db connection info
//set some variables
$ip = $_SERVER['REMOTE_ADDR'];
if (!$units) {$units = 10;}
if (!$static) {$static = FALSE;}
// get votes, values, ips for the current rating bar
$query=mysql_query(SELECT total_votes, total_value, used_ips FROM
$rating_dbname.$rating_tableName WHERE id='$id' )or die( Error:
.mysql_error());
// insert the id in the DB if it doesn't exist already
// see:
http://www.masugadesign.com/the-lab/scripts/unobtrusive-ajax-star-rating-bar/#comment-121
if (mysql_num_rows($query) == 0) {
$sql = INSERT INTO $rating_dbname.$rating_tableName
(`id`,`total_votes`, `total_value`, `used_ips`) VALUES ('$id', '0',
'0', '');
$result = mysql_query($sql);
}
$numbers=mysql_fetch_assoc($query);
if ($numbers['total_votes'] 1) {
$count = 0;
} else {
$count=$numbers['total_votes']; //how many votes total
}
$current_rating=$numbers['total_value']; //total number of rating
added together and stored
$tense=($count==1) ? vote : votes; //plural form votes/vote
// determine whether the user has voted, so we know how to draw the ul/
li
$voted=mysql_num_rows(mysql_query(SELECT used_ips FROM $rating_dbname.
$rating_tableName WHERE used_ips LIKE '%.$ip.%' AND id='.$id.'
));
// now draw the rating bar
$rating_width = @number_format($current_rating/$count,2)*
$rating_unitwidth;
$rating1 = @number_format($current_rating/$count,1);
$rating2 = @number_format($current_rating/$count,2);
if ($static == 'static') {
$static_rater = array();
$static_rater[] .= \n.'div class=ratingblock';
$static_rater[] .= 'div id=unit_long'.$id.'';
$static_rater[] .= 'ul id=unit_ul'.$id.' class=unit-rating
style=width:'.$rating_unitwidth*$units.'px;';
$static_rater[] .= 'li class=current-rating style=width:'.
$rating_width.'px;Currently '.$rating2.'/'.$units.'/li';
$static_rater[] .= '/ul';
$static_rater[] .= 'p class=static'.$id.'. Rating: strong
'.
$rating1.'/strong/'.$units.' ('.$count.' '.$tense.' cast) emThis
is \'static\'./em/p';
$static_rater[] .= '/div';
$static_rater[] .= '/div'.\n\n;
return join(\n, $static_rater);
} else {
$rater ='';
$rater.='div class=ratingblock';
$rater.='div id=unit_long'.$id.'';
$rater.=' ul id=unit_ul'.$id.' class=unit-rating
style=width:'.$rating_unitwidth*$units.'px;';
$rater.=' li class=current-rating style=width:'.
$rating_width.'px;Currently '.$rating2.'/'.$units.'/li';
for ($ncount = 1; $ncount = $units; $ncount++) { // loop from 1
to the number of units
if(!$voted) { // if the user hasn't yet voted, draw the
voting stars
$rater.='lia href=db.php?j='.$ncount.'q='.
$id.'t='.$ip.'c='.$units.' title='.$ncount.' out of
