[cathyMember]

Is there any way of resetting a single field in all items in a pod to a set value (eg zero) or to false (for a boolean field)? ie a global change? I have a membership database that I would like to reset with the change in financial year (30 June).

I could go into the database itself, but I would prefer to do it in pods if possible.

[chris.pilkoMember]

You can do this with a Pods API call.

I have some routines like this that I use for maintenance. I have Pod pages that do not show up in my site listings. I give these pages long, random strings for page names, and then use code like this on them:

PHP

<?php global $current_user, $user_ID , $user_level; get_currentuserinfo(); //Get the information about the current user. if (current_user_can('manage_options')): //is admin echo &quot;<p>Hi Chris</p>n&quot;; $api = new PodAPI(); $Record = new Pod('my_pod'); $Record->findRecords('id ASC', -1); while ($Record->fetchRecord()) { //Your action code goes between these $old_data = $Record->get_field('my_data'); $new_data = $old_data + 1; //Your action code goes between these $params = array('datatype' => 'my_pod', 'tbl_row_id' => $Record->get_field('id'), 'columns' => array('my_data' => $new_value)); $params = pods_sanitize($params); $api->save_pod_item($params); echo &quot;<p>Changed &quot;. $Record->get_field('name') . &quot;.my_data from &quot; . $old_data .&quot; to &quot; . $Record->get_field('my_data') .&quot;</p>n&quot;; // break; //Remove comment to test with just one row to see how this works. } else: ?> <h2>Sorry</h2> <p>You don't have the privileges required to use this resource</h2> <?php endif; ?>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

<?php global $current_user, $user_ID , $user_level; get_currentuserinfo();     //Get the information about the current user. if (current_user_can('manage_options')): //is admin    echo &quot;<p>Hi Chris</p>n&quot;;      $api = new PodAPI();    $Record = new Pod('my_pod');    $Record->findRecords('id ASC', -1);    while ($Record->fetchRecord()) {             //Your action code goes between these             $old_data = $Record->get_field('my_data');             $new_data =  $old_data + 1;             //Your action code goes between these             $params = array('datatype' => 'my_pod', 'tbl_row_id' => $Record->get_field('id'), 'columns' => array('my_data' => $new_value));             $params = pods_sanitize($params);             $api->save_pod_item($params);             echo &quot;<p>Changed &quot;. $Record->get_field('name') . &quot;.my_data from &quot; . $old_data .&quot; to &quot; . $Record->get_field('my_data') .&quot;</p>n&quot;;             // break; //Remove comment to test with just one row to see how this works.     }   else: ?>      <h2>Sorry</h2>      <p>You don't have the privileges required to use this resource</h2>   <?php endif; ?>

For something like this where I am reseting a variable once per year, I would probably add a check for the proper value in a changing GET value in the URL, just to make sure I didn’t call this page by accident when going through my history.

[cathyMember]

Thanks. Will give this a go tonight.

[cathyMember]

It’s all fine, but it seems to give me a new record with only the changed value in it (all the other fields are either the default or empty).

It comes down to this:
<pre> $params = array(‘datatype’ => ‘my_pod’, ‘tbl_row_id’ => $id, ‘columns’ => array(‘my_data’ => $new_value));
$params = pods_sanitize($params);
$api->save_pod_item($params);
</pre>

How do I overwrite the value in one field and not touch the others, and not create a new record in the process?

(OK – yes I did get sidetracked on my day job for a month)

[chris.pilkoMember]

Fat finger on my part. You need to specify the id to overwrite data instead of creating a new record.

Change $id to $Record->get_field(‘id’).

[cathyMember]

Worked a treat. Thanks so very much.

[Author]

Posts