X
26494

Ticket #26494 Public

SQL

  • Hi

    I have tried your script eventon-iframe.php and it’s working as described in your documentation.

    However, the integration inside an external website is not optimal with this solution.

    Is it possible to know a basic SQL query to fetch (by example) the last event name and date in the DB ? It’s only a reading query. Or at least some documentations (maybe I miss something) or previous tickets regarding the same kind of request ?

    Thanks a lot for šŸ™‚

    BY: acecomputer - Feb 2,2017 AT 1:49AM - 3 years ago
    • By: infotainerdave Feb 2,2017 AT 2:17AM - Posted 3 years ago - #26495

      Thank you for your messages, I am going to assign this ticket to Ashan and he will be able to take it from here and find you a solution. Please allow some time for him to get back to you, we greatly appreciate your patience and thank you for being a eventon customer!

    • By: Ashan Perera Feb 2,2017 AT 5:57PM - Posted 3 years ago - #26621

      I wouldnt recommend accessing the database from an external site. We do have a new solution called eventon APIĀ http://www.myeventon.com/addons/event-api/ this allow you to show calendar on external site or get a JSON data string of the events that can be used in any way you want to generate display of events.

    • By: acecomputer Feb 3,2017 AT 2:00AM - Posted 3 years ago - #26657

      The script will beĀ hosted as the same location than the eventon-iframe.php (same website; not external website) and accessed through an iframe too, but we just need very basic informations (event name, date, location).

    • By: Ashan Perera Feb 6,2017 AT 6:15PM - Posted 3 years ago - #27016

      Ok so I think the best way would be to use wordpress functions using wp_query or wpdb to access database. We dont have a documentation on running custom db queries but you can call event custom posts types ajde_events using normal wordpress queries

      http://www.myeventon.com/documentation/event-post-meta-variables/

You must login to reply to this ticket

HelpDesk

Welcome to EventON helpdesk.

EventON is the #1 Best selling event calendar plugin for WordPress websites in envato marketplace.

Checkout EventON