Sometime you may need to delete records from a table several times and also add new ones in between. This will create non sequential values for your auto increment field. You can avoid that by resetting the value of the auto-incrementing field by running the following two quires right after deleting records.
new_id = (SELECT MAX(id) FROM your_table_name)+1
ALTER TABLE your_table_name AUTO_INCREMENT = new_id
If you try to submit a form to different controller than the one you are on, all validation error messages and flash messages will be lost while the second controller redirects you back to the current one. To solve this problem, I modified this component from CakePHP bakery and made it compatible with CakePHP 2.x. I hope you find it useful. It will keep your request data and error validation messages intact while redirecting between two controllers.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
<?php App::uses('Component', 'Controller'); class PersistentComponent extends Component { var $components = array('Session'); var $Controller = null; function initialize(&$controller, $settings = array()) { $this->Controller = & $controller; } function beforeRender(&$controller) { $persistentData = $this->Session->read('PersistentData'); if($persistentData) { foreach($persistentData as $key=>$value) { if(isset($value['errors'])) ClassRegistry::init($key)->validationErrors = $value['errors']; if(isset($value['data'])) $controller->request->data[$key] = $value['data']; $this->Session->delete('PersistentData.'. $key); } } } function beforeRedirect(&$controller, $url, $status=null, $exit=true) { foreach ($controller->uses as $modelName) { if(count($controller->$modelName->validationErrors)) { $this->Session->write('PersistentData.' . $modelName . '.errors', $controller->$modelName->validationErrors); } if(isset($controller->request->data[$modelName])) $this->Session->write('PersistentData.' . $modelName . '.data', $controller->request->data[$modelName]); } } } ?> |
Let’s say you are coding the user management part of your CakePHP app, and you wanted to introduce a feature that will allow you to delete multiple users at once. Here is one way you can achieve that:
|
1 |
<?php echo $this->Form->checkbox('cid.', array('hiddenField' => false, 'value'=>$user['User']['id'])); ?> |
Notice the dot at the end of the checkbox’s fieldName parameter “cid.”
The above code will create the following HTML code:
|
1 |
<input type="checkbox" name="data[User][cid][]" value="1" id="UserCid"> |
The extra square bracket at the end of the name field was created by the dot appended above in the php code. That’s something I had to find out after a bit of searching.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
public function admin_delete() { if (!$this->request->is('post')) { throw new MethodNotAllowedException(); } $cid = $this->request->data['User']['cid']; if(count($cid)) { $cids = implode(",", $cid); $conditions = "User.id IN ($cids)"; if($this->User->deleteAll($conditions)){ $this->Session->setFlash(count($cid) . __(' Records deleted'), 'success'); }else{ $error_message = parent::error_messages($this->User->validationErrors); $this->Session->setFlash($error_message, 'error'); } }else{ $this->Session->setFlash(__('Please select the records you want to delete first and try again'), 'notice'); } $this->redirect($this->referer()); } |
I had trouble running a cron script using the following command after switching server for one of our websites.
|
1 |
Wget http://www.example.com/my_cron_script.php?q=param |
The website was hosted on a shared hosting at hostgator and it was working fine for long time. But after switching server to VPS, I started to get 403 errors whenever the cron script runs. After some research, I found out that mod_security is the one that is causing the trouble and there are three things you can do to solve the problem.
I think the best solution in terms of security is probably converting your script into curl but I chose option #3.
Here is what you need to add to white list your domain:
|
1 |
SecRule SERVER_NAME "example.com" phase:1,nolog,allow,ctl:ruleEngine=off |
You can add the line anywhere in mod_security’s configuration file. I added mine simply at the top.