increment the result of PHP MySQL query by number

Question

I am currently using the following code in a WordPress site's functions.php file to display a petition signatory counter on the front-end of the website and it's working fine:

// Add shortcode for GravityForms Petition Form counter
function set_gf_petition_counter_num(){
    ?>
    <script>
    jQuery(document).ready(function(){
        jQuery('#gf_petition_signed_counter span').text('<?php
$summary = RGFormsModel::get_form_counts(1);
echo "".$summary['total']."";
?>');
    });
    </script> 

<?php
}
add_action( 'wp_footer', 'set_gf_petition_counter_num' );

The issue is that the form submissions are counting at zero because I've only just implemented this form after switching the site from Contact Form 7 to GravityForms.

There's already 127 entries from the old CF7 form and none of these are stored in the database.

It replaces the <span>0</span> in the body paragraph id="gf_petition_signed_counter" with the number returned by using get_form_counts(1) to check for the "entries" count in GravityForms (1 being the form ID).

How can I increment the number of GF subsmissions it returns by 127 so I have the true number of submissions?

Thanks. I had to enclose it in brackets, but it is working. Can you change the comment to an answer to I can accept it as correct. — Reece
– Reece, Commented Sep 25, 2017 at 3:30

Obsidian Age · Accepted Answer · 2017-09-25 03:42:58Z

1

You should just be able to increment the total directly after retrieving the number of forms:

$summary = RGFormsModel::get_form_counts(1);
$summary['total'] += 127;
echo "".$summary['total']."";

Hope this helps! :)

answered Sep 25, 2017 at 3:42

Obsidian Age

42.6k11 gold badges54 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Reece Over a year ago

I actually implemented by using echo "".($summary['total'] += 127)."";. Is there any downside to doing it this way instead of your suggestion?

Collectives™ on Stack Overflow

increment the result of PHP MySQL query by number

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related