Running total of a field value

The plugin doesn’t have a way of doing this built in. You can query the database directly to get your number, though in practice that means you’d probably need to create a shortcode in order to insert the value into your content.

I can provide the details if you’re interested in doing a little coding.

I’m definitely willing to give it a shot! I’m more of a front-end guy so I’m not much on PHP, but I’ve tinkered a lot and can handle some of the basic stuff. I’ve added a shortcode before and made custom templates and widgets. I don’t wanna waste your time but I appreciate any assistance I can get, even if it’s “here are the highlights, look this stuff up.”

OK, this will get you started. Create a new file in your plugins directory called running_total.php

Paste this into that file:

<?php
/*
 * Plugin Name: Running Total from Participants Database
 * Version: 0.1
 * Description: returns the numeric total of a column in the participants database table
 * Author: xnau webdesign
 */

// define the shortcode
add_shortcode('total_pledges', 'r_t_get_total');

function r_t_get_total() {

  // this is the name of the column to get the tally from
  $r_t_column = 'pledge';

  global $wpdb;

  $sql =  'SELECT SUM(p.' . $r_t_column . ')  FROM ' . Participants_Db::$participants_table . ' p';

  return $wpdb->get_var($sql);

}
?>

Save it and go to the plugins page in your WP admin. Activate the plugin.

Now, you just need to place the shortcode where you want that total to show up: [total_pledges]

Looking at the code, it should be easy to figure out how to alter to your needs.

Awesome, thank you!

xnau – Sorry for the simple question. But I would like to subtotal a column by adding a WHERE statement. Could you show how you would setup a WHERE statement in the above code? thank you.

Justin,

A “WHERE” statement is used to select which records are selected based on some criteria. This usually goes after the database table is named in the database query…but your question isn’t specific enough for me to go into much detail. Are you familiar with MySQL? What are you trying to do?

Hi Xnau, one question i have.

Is is possible to add a value to each form input field, so at the end, it summs it all up and says the result? Like for exams and then i can see if someone passed or not?

Regards

Toni

Toni,

I assume you mean within one record, as opposed to summing from all records, as in the example above?

I don’t have time to spell it all out, but you would start by adding a dummy field to give you a place to put the sum. Then, in your template, inside the fields loop, you would perform a MySQL query similar to the one above that gives your dummy field the sum of the scores for that field.

I have a tutorial on creating custom templates that will give you the basics here: https://xnau.com/pdb-templates/

hi i added the plug-in running_total.php and the codes nothing happen on the page no display at all [total_pledges]

Hi i would like to ask if it is possible to display on page the total numbers of participants on at page or widgets, your plugins is perfect and thanks to this plugin for WordPress, i love it.thanks and looking for your fast response