Re: Form width fieldset and different button types
In CakePHP 2.x, FormHelper::inputs doesn't make buttons. It makes input elements. If you want a button, try using FormHelper::submit for a submit button, or in this case FormHelper::button as in: echo $this-Form-button('Cancel upload', array('type' = 'reset', 'class' = 'btn btn-warning cancel') ); HTH! On Monday, May 18, 2015 at 1:48:35 PM UTC-4, Sam Clauw wrote: Hi there! I'm trying to use the jquery file uploader https://github.com/blueimp/jQuery-File-Upload/wiki in combination with CakePHP. The HTML form uses 3 different button types: - submit (button type=submitStart upload/submit) - reset (button type=resetStart upload/submit) - button (button type=buttonStart upload/submit) With CakePHP, I try to create those buttons via $this-Form-inputs, but I don't find out how I should sum up those different type of inputs. I tried the following, but it ends up that those buttons are becoming input fields instead: echo $this-Form-create('OutletPhoto', array( 'type' = 'file', 'novalidate' = true, // browser validatie 'inputDefaults' = array( 'label' = true, 'div' = 'form-group', 'class' = 'form-control' ), 'role' = 'form' )); echo $this-Form-inputs(array( 'legend' = false, 'name' = array( 'type' = 'file', 'multiple', 'label' = false, 'id' = 'file_upload', 'name' = 'file_upload', 'class' = false, 'before' = 'Pick photos', 'after' = '' ), 'Start upload' = array( 'type' = 'submit', 'label' = false, 'class' = 'btn btn-primary start' ), 'Cancel upload' = array( 'type' = 'reset', 'label' = false, 'class' = 'btn btn-warning cancel' ), 'Delete' = array( 'type' = 'button', 'label' = false, 'class' = 'btn btn-danger delete' ) )); echo $this-Form-end('Save'); Here's the HTML output of this code: div class=form-groupdiv class=submit*input class=btn btn-primary start type=submit value=Start upload*/div/div div class=form-group*input name=data[OutletPhoto][Cancel upload] class=btn btn-warning cancel type=reset id=OutletPhotoAnnuleerUpload* /div div class=form-groupbutton class=btn btn-danger delete type=submitDelete/button/div Anyone who can tell me why my Start upload and Cancel upload don't show up as a button? Thanks in advance! ;) -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: Site down after restart
If this happens, start checking logs. CakePHP logs errors to /tmp/, and your server access and error logs should also be reviewed. CakePHP depends on an operating system, a web server, and a database server. Each of these need to be up and running for Cake to do its thing. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: prevent uploaded file duplicate or double click in cake php?
First you need to identify what makes a file unique. Is it the contents of a row? a set of rows? a row ID? Second, you need to write code to query your existing database to see if your uploaded file has already been added (run a SELECT to see if the rows you are about to add have already been added). Adding rows to a database from an uploaded CSV file is not a typical CakePHP project. It can be done. Actually it's on my someday/maybe ToDo list. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: 2 tables wont display
It looks like your `posts` table doesn't have a `user_id` column. CakePHP convention wants it to have one so Cake can make the association Posts belongs to Users. On Friday, May 23, 2014 12:56:48 AM UTC-4, Andrew Townsley wrote: I am getting an error on a simple display of 2 tables as i am just learning it. I know sql but cakephp is awkward with sql/ Anyway I have *Error: * SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Post.user_id' in 'on clause' *SQL Query: * SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, `Post`.`created`, `Post`.`modified`, `User`.`two`, `User`.`three`, `User`.`id` FROM `jagguy`.`posts` AS `Post` LEFT JOIN `jagguy`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE 1 = 1 models ( I have 2 tables with 1 files with id in common class Post extends AppModel { /*var $name='User';*/ public $belongsTo = array('User'); } class User extends AppModel { public $hasMany = 'Post'; } class PostsController extends AppController { public function home2() { $everything= $this-Post-find('all', array('contain' = array('User'))); } view ?php foreach ($everything as $item): echo 'trtd'. $item['Post']['id']. '/td'; echo 'td'. $item['Post']['title'].'/td'; echo 'td'. $item['Post']['body'].'/td'; http://itfutures.edu.au?referer=email *P: (03) 9866 7737* *E: in...@itfutures.edu.au javascript:* *A: Suite 5 / Level 1 / 424 St Kilda Rd, Melbourne, 3004 https://www.google.com.au/url?sa=trct=jq=esrc=ssource=webcd=15cad=rjauact=8ved=0CKQBEPUXMA4url=http%3A%2F%2Fmaps.google.com.au%2Fmaps%3Fgl%3Dau%26hq%3Ditfutures%26daddr%3D1%2F424%2BSt%2BKilda%2BRd%2C%2BMelbourne%2BVIC%2B3004%26panel%3D1%26f%3Dd%26fb%3D1%26geocode%3DFdKovv0dMSWkCCnfp02hHWjWajGLbygrlMPvUw%26cid%3D6048267865728511883ei=hHUYU_abH8-okgXV7oGYDgusg=AFQjCNEBpgXrGRhNzMxOzPLHRVSQkdpXUQbvm=bv.62577051,d.dGI* *Connect with us: * http://plus.google.com/+itfutureseduau http://linkedin.com/company/it-futures http://youtube.com/user/itfutureseduau http://twitter.com/itfutures http://facebook.com/itfutures Please consider the environment before printing this email. This e-mail and any attachments to it (the Communication) is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of National Training and Solutions Provider Pty Ltd ABN 34 123 831 023, or any of its related entities. NTSP does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: 2 tables wont display
It looks like your `posts` table doesn't have a `user_id` column. CakePHP convention wants it to have one so Cake can make the association Posts belongs to Users. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: CakeDC's Users plugin action overriding
I think that the result you are expecting is simply to have the default plugin functionality? Suggestions: 1. First install and get it working out-of-the-box without any overriding. 2. After that, come back to what you've started (override UsersController as directed in the documentation) and also do this: 3. Copy your view files from \app\Plugin\Users\View\Users to \app\View\AppUsers 4. In you AppUsersController::add() method (which is empty) add the line return parent::add(); On Thursday, May 1, 2014 3:40:42 PM UTC-4, giolef...@gmail.com wrote: I have installed CakeDC's Users plugin and I have loaded all the required files in bootstrap.php, as shown below: CakePlugin::load('Users'); // Loads the Users pluginCakePlugin::load('Search'); // Loads the Search pluginCakePlugin::load('Utils'); // Loads the Utils pluginCakePlugin::load('Users', array('routes' = true)); I would like to override the add() action of the UsersController of the plugin, so I created the AppUsersController.php file in app/Controller, as instructed here:https://github.com/CakeDC/users#extending-the-controller Then I created an add() action inside the AppUsersController.php, with an empty body, but the original action was not overridden. What am I doing wrong? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: CakeDC's Users plugin action overriding
I think the result you seek is the default functionality? Suggestions: 1. First set it up exactly as directed in the box without overriding, and get it working. This makes you certain of correct installation, schema set-up, etc. 2. Next extend the controller as you have, with the following extra steps 3. Copy the view files from app\Plugin\Users\View\Users to \app\View\AppUsers 4. Add this line to your empty AppUsersController::model() method: return parent::add(); -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: CakeDC's Users plugin action overriding
I think the result you seek is the default functionality? Suggestions: 1. First set it up exactly as directed in the box without overriding, and get it working. This makes you certain of correct installation, schema set-up, etc. 2. Next extend the controller as you have, with the following extra steps 3. Copy the view files from app\Plugin\Users\View\Users to \app\View\AppUsers 4. Add this line to your empty AppUsersController::add() method: return parent::add(); -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups CakePHP group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
Re: Access to specific data cakephp 2.x
Hi Paulo: To answer your first question: give everyone access to every post by *not*checking to see who owns it in the Controller::index() and Controller::view() methods. Give only the post's writer the ability to edit/delete the post by checking first to see who owns it in the Controller::edit() and Controller::delete() methods. With the aforementioned WhoDidIt behavior we're talking about only one additional line of controller code plus one additional condition: $user = $this-Session-Read('Auth.User.id'); ...so in the Controller::delete() function (for example): function delete($id = null) { if (!$id) { $this-Session-setFlash(__('Invalid id for Post')); $this-redirect(array('action'='index')); } *$*user* = $this-Session-Read('Auth.User.id'); *// Only allow deletes from user's own records if (*$this-Post-field('created_by', array('id' = $id)) == $user* $this-Post-delete($id)) { $this-Session-setFlash(__('Post deleted')); } $this-Session-setFlash(__('Post was not deleted')); } To answer your second question: same idea. Check that the manager logged in has access to the controller function on that hotel *in the appropriate controller function*. -Rob On Monday, December 24, 2012 6:12:02 PM UTC-5, Paulo Braga wrote: Hi Rob. Thanks for your answer, the behavior is very interesting. I think I did not express myself well, I dont want just to set that a user has only access to the posts he created. I want also to configure for example: We have hotels around a country from the same organization, so in each city there's a manager, and I want a manager to manage just the hotels in his city. but this hotels can be created by another user(admin), is it possible? I did it with isAuthorized() method, but it requires a lot of code (ugly code)° :p Paulo On Monday, December 24, 2012 3:08:31 PM UTC+2, Rob M wrote: Hi Paulo: You are describing row-level access control, and I am doing that with CakePHP 2.0 using a modified version of Daniel Vecchiato's WhoDidIt Model Behavior ( https://github.com/danfreak/4cakephp/tree/master/models/behaviors). Then I check in the controller to see if the id in the table for the person who created the record matches the id of the person who is trying to modify it. - Rob On Sunday, December 23, 2012 4:01:28 PM UTC-5, Paulo Braga wrote: Hi people. I am using cakephp 2.x, and I am trying to build a system with group permissions, ok, I used Acl and Auth component without problem. Now I want to configure access to specific data. for example: we have a blog app, and we have users, posts, etc. an admin can do anything(no problems); a post is posted by a user. (some problems here); With acl I configured that admin group can do anything. and that user group can just do anything in posts(add, list, edit, delete). everything is working. But I dont want a user to edit,delete,list posts that were not created by him. I used to do it with the method isAuthorized(), but imagining a big app, I think it will be too hard to codify it. is there a clean way to do it??? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- 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. Visit this group at http://groups.google.com/group/cake-php?hl=en.
Re: Access to specific data cakephp 2.x
Hi Paulo: You are describing row-level access control, and I am doing that with CakePHP 2.0 using a modified version of Daniel Vecchiato's WhoDidIt Model Behavior (https://github.com/danfreak/4cakephp/tree/master/models/behaviors). Then I check in the controller to see if the id in the table for the person who created the record matches the id of the person who is trying to modify it. - Rob On Sunday, December 23, 2012 4:01:28 PM UTC-5, Paulo Braga wrote: Hi people. I am using cakephp 2.x, and I am trying to build a system with group permissions, ok, I used Acl and Auth component without problem. Now I want to configure access to specific data. for example: we have a blog app, and we have users, posts, etc. an admin can do anything(no problems); a post is posted by a user. (some problems here); With acl I configured that admin group can do anything. and that user group can just do anything in posts(add, list, edit, delete). everything is working. But I dont want a user to edit,delete,list posts that were not created by him. I used to do it with the method isAuthorized(), but imagining a big app, I think it will be too hard to codify it. is there a clean way to do it??? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- 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. Visit this group at http://groups.google.com/group/cake-php?hl=en.
Re: CakePHP 2.2 and Autocomplete Jquery
This code snippet needs refactoring in order to use JsHelper, but it works: controller code (Controllers/PeopleController.php): function autoComplete() { $this-autoRender = false; $search_string = trim($this-request-query['term']); if (!is_null($search_string) $search_string != '') { $people = $this-Person-find('all', array( 'conditions' = array ( 'OR' = array ( 'Person.first_name LIKE' = '%' . $search_string . '%', 'Person.last_name LIKE'= '%' . $search_string . '%', 'Person.family_info LIKE' = '%' . $search_string . '%', 'Person.comments LIKE' = '%' . $search_string . '%', 'Person.home_street LIKE' = '%' . $search_string . '%', 'Person.work_street_1 LIKE'= '%' . $search_string . '%', 'Person.work_street_2 LIKE'= '%' . $search_string . '%' ) ), 'fields' = array( 'Person.first_name', 'Person.last_name', 'Person.active', 'Person.requested_do_not_call', 'Person.home_street', 'Person.home_city', 'Person.home_state', 'Person.home_zip', 'Person.work_street_1', 'Person.work_street_2', 'Person.work_city', 'Person.work_state', 'Person.work_zip', 'Person.id', 'Person.home_phone', 'Person.mobile_phone', 'Person.tty', 'Person.video_phone', 'Person.email' ), 'order' = array( 'Person.active DESC', 'Person.last_name ASC', 'Person.first_name ASC' ), 'recursive' = 0 ) ); $i=0; foreach($people as $person){ $response[$i]['id'] = $person['Person']['id']; $response[$i]['label'] = $person['Person']['last_name'] . ', ' . $person['Person']['first_name']; $response[$i]['value'] = $person['Person']['last_name'] . ', ' . $person['Person']['first_name']; $i++; } echo json_encode($response); } } view code (Views/People/search.ctp): ?php echo $this-Html-script('https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js', array('inline' = false)); echo $this-Html-script('https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.21/jquery-ui.js', array('inline' = false)); echo $this-Html-script('autocomplete/jquery.ui.autocomplete.html.js', array('inline' = false)); ob_start(); ? $(document).ready(function(){ $(#PersonQ).autocomplete({ source: ../people/autoComplete.json, minLength: 2 }); $(input:submit).button(); $(#PersonQ).autocomplete({ select: function(event, ui) { selected_id = ui.item.id; $('#PersonSearchForm').append('input id=PersonId type=hidden name=data[Person][id] value=' + selected_id + ' /'); $('#PersonSearchForm').submit(); } }); $(#PersonQ).autocomplete({ open: function(event, ui) { $('#PersonId').remove(); } }); }); ?php $jscript = ob_get_contents(); ob_end_clean(); echo $this-Html-scriptBlock($jscript, array('inline' = false)); ? On Tuesday, November 20, 2012 5:34:56 AM UTC-5, franscelstain wrote: if anyone can give an example? Pada Senin, 12 November 2012 11:01:40 UTC+7, franscelstain menulis: Is there someone who can help me make jquery autocomplete using CakePHP 2.2 -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- 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. Visit this group at http://groups.google.com/group/cake-php?hl=en.
Re: Bad Request URL not found - after an JQuery change event
A. To debug, I'd insert the line: console.log(load + _this.find('option:selected').val()); just above your $.ajax() call. Then watch your Javascript console when running the page to see what URL is being submitted and try submitting it manually. - Rob On Friday, November 16, 2012 1:53:13 AM UTC-5, Benjamin Such wrote: Hey guys, I am really stuck with that problem. I have a JQuery Dialog which contains a selectbox. When I change the option inside this selectbox, another selectbox shows up with options generated from an .ajax() event. Anyway... everything works fine, but when I submit the form CakePHP says: 404 Bad Request - URL was not found, but it DOES EXISTS 100%. I tested it several times to be sure, but another thing is: When submit the form WITHOUT selecting any option from the first selectbox the form is submitted correctly. I dont know what to post really but here is my Javascript: $('select[data-onchange=true]').live(change, function() { var _this = $(this); var element = $('select[data-onchange-trigger=' + _this.attr(id) + ']:first'); if (typeof element == object) { if (_this.attr(data-onchange-load)) { var options = element.prop(options); var load = _this.attr(data-onchange-load); $.ajax({ dataType: json, url: load + _this.find('option:selected').val(), beforeSend: function() { $('.ajax-loader').show(); element.find('option').remove(); element.parent().hide(); }, success: function(data) { $.each(data, function(index, _data) { if (typeof _data == object) { $.each(_data, function(index, _data) { options[options.length] = new Option(_ data.name, _data.id); }); } }); element.parent().show(); }, complete: function() { $('.ajax-loader').hide(); } }); } } }); The error occurs only when I submit the form after I change the option on the selectbox. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- 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. Visit this group at http://groups.google.com/group/cake-php?hl=en.
Re: 1.3-2.1 migration: aco problem
After hours of trying to sniff out the problem, it came down to a model I'd foolishly created in App/Models (Model/Aco.php). Once deleted, this worked. My thanks to caggia https://groups.google.com/forum/?fromgroups#!searchin/cake-php/caggia/cake-php/j0wgXoj4Ma0/iFA92tzUdiUJfor helping me find my error. - RM On Sunday, May 27, 2012 8:13:31 AM UTC-4, Rob M wrote: Attempting to migrate my app from 1.3 to 2.1; using xampp. I'm running into an error in the console when I use AclExtras to recover aco ('recover aro' produces no error). The same error is encountered when attempting 'aco_sync'. Would you perhaps recognize the stack trace and suggest where to look for solutions? Text follows: C:\xampp\htdocs\testpeople\people*cake AclExtras.AclExtras recover aro* Welcome to CakePHP v2.1.3 Console --- App : people Path: C:\xampp\htdocs\testpeople\people\ --- Tree has been recovered, or tree did not need recovery. C:\xampp\htdocs\testpeople\people*cake AclExtras.AclExtras recover aco* Welcome to CakePHP v2.1.3 Console --- App : people Path: C:\xampp\htdocs\testpeople\people\ --- Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'recover' at line 1 #0 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(437): PDOStatement-execute(Array) #1 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(403): DboSource-_execute('recover', Array) #2 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(647): DboSource-execute('recover', Array, Array) #3 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(589): DboSource-fetchAll('recover', Array, Array) #4 C:\xampp\htdocs\cakephp\lib\Cake\Model\Model.php(775): DboSource-query('recover', Array, Object(Aco)) #5 C:\xampp\htdocs\testpeople\people\Plugin\AclExtras\Console\Command\AclExtrasShell.php(300): Model-__call('recover', Array) #6 C:\xampp\htdocs\testpeople\people\Plugin\AclExtras\Console\Command\AclExtrasShell.php(300): Aco-recover() #7 C:\xampp\htdocs\cakephp\lib\Cake\Console\Shell.php(386): AclExtrasShell-recover() #8 C:\xampp\htdocs\cakephp\lib\Cake\Console\ShellDispatcher.php(177): Shell-runCommand('recover', Array) #9 C:\xampp\htdocs\cakephp\lib\Cake\Console\ShellDispatcher.php(69): ShellDispatcher-dispatch() #10 C:\xampp\htdocs\cakephp\lib\Cake\Console\cake.php(41): ShellDispatcher::run(Array) #11 {main} 42000 -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Saving a long list of hasMany Through associasions
It sounds like a HABTM table is precisely what you need. Please elaborate on your requirement 'cannot do HABTM due to storing meta info'. - Rob On Friday, May 25, 2012 9:09:59 PM UTC-4, Benjamin Allison wrote: I have two models: Users and Surveys. In my Users index view, each User row has two select lists that are populated with the names of all the available Surveys. The idea is to allow someone to assign two Surveys to each user, right from the Index page. The associations take place via a hasMany Through association: the intermediary model is called SurveyAssignments (I can't do HABTM because I'm storing meta info). What I'm struggling with is that I can't figure out how to save all those associations, from one page, or how to account for each user's specifica association state: some users will have association records, some will not. Some will need associations created, others changed or removed. I would like to avoid large complicated nests of if statements! How can I account for multiple records one on page, and handle all of their unique association states without getting overly bloated or complex? Any ideas? -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
1.3-2.1 migration: aco problem
Attempting to migrate my app from 1.3 to 2.1; using xampp. I'm running into an error in the console when I use AclExtras to recover aco ('recover aro' produces no error). The same error is encountered when attempting 'aco_sync'. Would you perhaps recognize the stack trace and suggest where to look for solutions? Text follows: C:\xampp\htdocs\testpeople\people*cake AclExtras.AclExtras recover aro* Welcome to CakePHP v2.1.3 Console --- App : people Path: C:\xampp\htdocs\testpeople\people\ --- Tree has been recovered, or tree did not need recovery. C:\xampp\htdocs\testpeople\people*cake AclExtras.AclExtras recover aco* Welcome to CakePHP v2.1.3 Console --- App : people Path: C:\xampp\htdocs\testpeople\people\ --- Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'recover' at line 1 #0 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(437): PDOStatement-execute(Array) #1 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(403): DboSource-_execute('recover', Array) #2 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(647): DboSource-execute('recover', Array, Array) #3 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(589): DboSource-fetchAll('recover', Array, Array) #4 C:\xampp\htdocs\cakephp\lib\Cake\Model\Model.php(775): DboSource-query('recover', Array, Object(Aco)) #5 C:\xampp\htdocs\testpeople\people\Plugin\AclExtras\Console\Command\AclExtrasShell.php(300): Model-__call('recover', Array) #6 C:\xampp\htdocs\testpeople\people\Plugin\AclExtras\Console\Command\AclExtrasShell.php(300): Aco-recover() #7 C:\xampp\htdocs\cakephp\lib\Cake\Console\Shell.php(386): AclExtrasShell-recover() #8 C:\xampp\htdocs\cakephp\lib\Cake\Console\ShellDispatcher.php(177): Shell-runCommand('recover', Array) #9 C:\xampp\htdocs\cakephp\lib\Cake\Console\ShellDispatcher.php(69): ShellDispatcher-dispatch() #10 C:\xampp\htdocs\cakephp\lib\Cake\Console\cake.php(41): ShellDispatcher::run(Array) #11 {main} 42000 -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php