Select Page

FooEvents - Output number of canceled tickets

How to get certain values from the WordPress database via SQL query in a PHP function.

In this article, I will use a code example to show you how to output the number of canceled FooEvents tickets via an SQL query of the WordPress database.

This article was last updated on April, 26 2023.

info
Written by Saskia Teichmann
on April 26, 2023
Sending
User Review
0 (0 votes)
Comments Rating 0 (0 reviews)
Code Snippets - WordPress - FooEvents

When using third-party plugins, I repeatedly come across problems which, in the opinion of my customers, "should actually be solved by default in the respective premium plugin".

The plugin "FooEvents" is no exception. It is an event plugin that enables the management of events and ticket sales via WooCommerce.

I have programmed a dashboard widget for one of my customers that is displayed in the WordPress admin area directly after login and clearly lists all upcoming events together with the number of registered participants, a button for direct download of the participant list as a csv file and also canceled ticket numbers. It also prominently displays for each event as soon as all available tickets have been sold. In the case of this customer, a waiting list functionality is then activated. Whether the waiting list has been activated is clearly displayed in the dashboard widget.

Below I have listed the code component that outputs the number of canceled FooEvents tickets. This may be useful for someone out there:

Do you have questions about the code? Questions about the FooEvents plugin or other comments? Then please use the comment function at the end of this article.

Best regards
Saskia Teichmann (formerly Lund)

<span class="castledown-font">Saskia Teichmann</span>

Saskia Teichmann

A WordPress full stack web developer from Germany who likes to create beautiful websites and sophisticated web projects.

In her free time, Saskia enjoys hiking with her family in the Tramuntana mountains on Mallorca, walking in the Herrenhausen Gardens in Hanover or swimming in the sea.

Submit a project requestServing coffee

2 Comments

  1. Lars Hansen

    I have exactly the same problem, have installed FooEvents, and lack the ability to extract a participant list of the upcoming events, but Foo doesn't really have anything to offer. Their CSV export can't really help any good.
    It's a bit strange that they don't have such a module 🙁
    Greetings from Bornholm

    Reply
    • Saskia Teichmann

      Hey Lars,
      Thanks for your comment! I can definitely help with that, but since it takes a bit more effort, I'd need you to book me as a developer. If you're up for it, we can sort out the details and get it done.

      Let me know!

      Cheers,
      Saskia

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Sending