PHPize Online / SQLize Online  /  SQLtest Online

<?php ini_set('display_errors', 'On'); ini_set('default_charset', 'utf-8'); error_reporting(E_ALL); include 'connection.php'; $mockEvents = '[{"Author":1,"Title":"SkillBoost Bootcamp - PSE: Prisma Cloud Professional","Description":"Get ready to tackle your PSE: Prisma Cloud Professional exam in just 1 day with this SkillBoost Bootcamp. Earn 30 Tech Xpert points when you attend this session!","Start":"2025-06-21T07:00:00Z","End":"2025-07-04T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Incident & Response with Cortex","Description":"Learn how Cortex XDR can be used after an incident to rapidly recover from the attack. Earn 15 Tech Xpert points when you attend this session!","Start":"2025-06-21T07:00:00Z","End":"2025-06-21T08:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Prisma Cloud Assessment Walkthrough","Description":"Explore how to execute a Palo Alto Networks Prisma Cloud Assessment to assess your customers’ current cloud security environments. Earn 20 Tech Xpert points when you attend this session!","Start":"2025-06-20T07:00:00Z","End":"2025-06-20T09:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"SkillBoost Bootcamp – PSE: Software Firewall Professional","Description":"Get ready to tackle your PSE: Software Firewall Professional exam in just 1 day with this SkillBoost Bootcamp. Earn 30 Tech Xpert points when you attend this session!","Start":"2025-06-14T07:00:00Z","End":"2025-06-14T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"SkillBoost Bootcamp: PSE: Cortex Professional","Description":"Get ready to tackle your PSE: Cortex Professional exam in just 1 day with this SkillBoost Bootcamp. Earn 30 Tech Xpert points when you attend this session!","Start":"2025-06-08T07:00:00Z","End":"2025-06-08T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"#France - Prépa PSE Prisma Cloud - Workshop + CTF","Description":"Vous connaissez déjà très bien Palo Alto Networks et souhaitez préparer rapidement vos certifications avant vente alors n\\\\’hésitez pas à nous rejoindre à nos différents programme.","Start":"2025-05-25T07:00:00Z","End":"2025-05-25T14:00:00Z","Multiple_dates":0,"Button":"","URL":"https://westconcomstor.webex.com/webappng/sites/westconcomstor/webinar/webinarSeries/register/ea801dc6033e49b4945424cb7a893804","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"SkillBoost – PSE: Prisma Cloud Professional","Description":"Get ready to tackle your PSE: Prisma Cloud Professional exam in just 5 weeks with this SkillBoost track. Earn 50 Tech Xpert points when you attend at least 3 out of 5 sessions!","Start":"2025-05-15T07:00:00Z","End":"2025-06-13T08:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"DMEA 2025 - Connecting Digital Health","Description":"Die DMEA zählt zu Europa‘s wichtigsten Events für Digital Health. Hier treffen sich Expert:innen aus der digitalen Gesundheitswirtschaft in Berlin. Die DMEA bietet allen Akteuren neben einem umfassenden Marktüberblick vielfältige ...","Start":"2025-05-08T07:00:00Z","End":"2025-05-10T16:00:00Z","Multiple_dates":0,"Button":"Hier alle Infos","URL":"https://www.dmea.de/de/","Location":"Messe Berlin","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"NGFW Basics Crash Course","Description":"Take a crash-course on Palo Alto Networks NGFW and get a handle on the basics in just 1 week. Earn 50 Tech Xpert points when you attend at least 3 out of 5 sessions!","Start":"2025-05-07T06:00:00Z","End":"2025-05-07T07:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"#France - Prépa PSE Prisma Cloud - Overview","Description":"Vous connaissez déjà très bien Palo Alto Networks et souhaitez préparer rapidement vos certifications avant vente alors n\\\\’hésitez pas à nous rejoindre à nos différents programme.","Start":"2025-05-04T07:00:00Z","End":"2025-05-04T11:00:00Z","Multiple_dates":0,"Button":"","URL":"https://westconcomstor.webex.com/webappng/sites/westconcomstor/webinar/webinarSeries/register/ea801dc6033e49b4945424cb7a893804","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"SASE TITAN Session","Description":"Earn your Palo Alto Networks “SASE Titan Trainee” status with ease by following along this session. Earn 30 Tech Xpert points when you attend!","Start":"2025-05-01T07:00:00Z","End":"2025-05-01T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"#France - Prépa PSE Software Firewall - Workshop + CTF","Description":"Vous connaissez déjà très bien Palo Alto Networks et souhaitez préparer rapidement vos certifications avant vente alors n\\\\’hésitez pas à nous rejoindre à nos différents programme.","Start":"2025-04-28T07:00:00Z","End":"2025-04-28T14:00:00Z","Multiple_dates":0,"Button":"","URL":"https://westconcomstor.webex.com/webappng/sites/westconcomstor/webinar/webinarSeries/register/ea801dc6033e49b4945424cb7a893804","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"#France - PSE Software Firewall - Overview","Description":"Vous connaissez déjà très bien Palo Alto Networks et souhaitez préparer rapidement vos certifications avant vente alors n\\\\’hésitez pas à nous rejoindre à nos différents programme.","Start":"2025-04-21T07:00:00Z","End":"2025-04-21T11:00:00Z","Multiple_dates":0,"Button":"","URL":"https://westconcomstor.webex.com/webappng/sites/westconcomstor/webinar/webinarSeries/register/ea801dc6033e49b4945424cb7a893804","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Nokia SkillBoost: Network Infrastructure Security","Description":"Learn more about Nokia Network Infrastructure Security with detailed insights into Nokia\\\\’s solution for securing networks.","Start":"2025-04-20T08:00:00Z","End":"2025-04-20T09:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_nok_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"PartnerTag mit Infoblox & Westcon","Description":"Freuen Sie sich auf die Experten von Infoblox, eine Führung im Koster Seligenstadt, ein gemeinsames Dinner mit Weinverkostung und eine Menge guter Gespräche und neuer Informationen.","Start":"2025-04-18T10:00:00Z","End":"2025-04-18T19:00:00Z","Multiple_dates":0,"Button":"Details & Anmeldung","URL":"https://p.westconcomstor.com/de_inb_partnertag-mrz25.html","Location":"Kloster Seligenstadt","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"SkillBoost Bootcamp – PSE: SASE Professional","Description":"Get ready to tackle your PSE: SASE Professional exam in just 1 day with this SkillBoost Bootcamp. Earn 30 Tech Xpert points when you attend this session!","Start":"2025-04-18T08:00:00Z","End":"2025-04-18T11:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Zero Trust: The Critical Role of DNS","Description":"Explore the principles of Zero Trust, why it’s pivotal for modern networks and cybersecurity, and the essential role of DNS in a successful Zero Trust strategy. Earn 20 Tech Xpert points when you attend!","Start":"2025-04-06T08:00:00Z","End":"2025-04-06T09:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_eef_tech-xpert-sessions.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Prisma SASE Capture the Flag","Description":"Join us to get hands-on with Palo Alto Networks’ Prisma SASE in this competitive, gamified event. Earn 25 Tech Xpert points when you attend this session!","Start":"2025-04-05T08:00:00Z","End":"2025-04-05T10:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Vulnerability Management with Prisma Cloud: Best Practices","Description":"Join this short track series of live webinars featuring sales and technical contents. You will discover how the biggest innovations in Prisma Cloud can help secure customers\\\\\\\\\\\\’ Cloud and AI transformation.","Start":"2025-04-04T12:00:00Z","End":"2025-04-04T13:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://register.paloaltonetworks.com/vulnerabilitymanagementbestpra","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Prisma SASE 3D Lab Showcase","Description":"Join us as we showcase our Prisma SASE 3D Lab, so you know exactly how to navigate the environment and use it for your own enablement and customer demos. Earn 15 Tech Xpert points when you attend this session!","Start":"2025-03-20T09:00:00Z","End":"2025-03-20T10:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Z-Day - Partnerevent in Frankfurt Zscaler x Westcon","Description":"Beim Z-Day erwartet Sie eine Vielzahl wertvoller Informationen sowohl von Westcon als auch direkt vom Hersteller.\\\\n\\\\nDas Westcon-Team wird Ihnen einen Überlick zu den Support Angeboten von Westcon wie bspw. unsere 3D Labs oder Professional Services. \\\\n","Start":"2025-03-19T09:00:00Z","End":"2025-03-19T16:00:00Z","Multiple_dates":0,"Button":"Details & Anmeldung","URL":"https://p.westconcomstor.com/de_zsc_z-day-feb-2025.html","Location":"Zscaler Büro; Gerveniusstraße 17; 60322 Frankfurt am Main","Location_URL":"https://maps.app.goo.gl/Va4eWrCScPvE1BCp6","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"AI for Networking, enhanced by ecosystem partnerships","Description":"In this session we will give an overview of new partnerships in the manufacturing vertical and how their addition to existing infrastructure together with AI for Networking benefits, can create new business outcomes.","Start":"2025-03-19T09:00:00Z","End":"2025-03-19T09:00:00Z","Multiple_dates":0,"Button":"Register","URL":"https://arubanetworks.zoom.us/webinar/register/WN_CHKYFiSbQbK_QXcvY9VxaQ#/registration","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Alert Burndown Methodologies with Prisma Cloud","Description":"Join this short track series of live webinars featuring sales and technical contents. You will discover how the biggest innovations in Prisma Cloud can help secure customers\\\\\\\\\\\\’ Cloud and AI transformation.","Start":"2025-03-18T13:00:00Z","End":"2025-03-18T14:00:00Z","Multiple_dates":0,"Button":"REGISTER HERE","URL":"https://register.paloaltonetworks.com/alertburndownmethodologies","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Nokia SkillBoost: Data Center Networking Vision & Technology","Description":"Lear more about Nokia Data Center Networking vision and technology and how Nokia Data Center Networking fits in your technology stack. This is part of Nokia SkillBoot sessions for Tech Xpert.","Start":"2025-03-18T09:00:00Z","End":"2025-03-18T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_nok_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"#France - Prépa PSE SASE - Workshop + Capture the Flag","Description":"Vous connaissez déjà très bien Palo Alto Networks et souhaitez préparer rapidement vos certifications avant vente alors n\\\\’hésitez pas à nous rejoindre à nos différents programme.\\\\n","Start":"2025-03-14T08:00:00Z","End":"2025-03-14T15:00:00Z","Multiple_dates":0,"Button":"","URL":"https://westconcomstor.webex.com/webappng/sites/westconcomstor/webinar/webinarSeries/register/ea801dc6033e49b4945424cb7a893804","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Prisma Cloud Assessment Workshop","Description":"Explore how to execute a Palo Alto Networks Prisma Cloud Assessment to assess your customers’ current cloud security environments. Earn 20 Tech Xpert points when you attend this session!","Start":"2025-03-12T09:00:00Z","End":"2025-03-12T11:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"AI for Networking in Switching","Description":"In this session we will further explore how AI for Networking is used for our Switching solutions. As well as the growth in Wireless connectivity, we also see many more devices connected through wired connectivity.","Start":"2025-03-12T09:00:00Z","End":"2025-03-12T09:00:00Z","Multiple_dates":0,"Button":"Register","URL":"https://arubanetworks.zoom.us/webinar/register/WN_VnCSZm5QQ3aQRntc-B1wWg#/registration","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"SkillBoost – PSE: Software Firewall Professional","Description":"Get ready to tackle your PSE: Software Firewall Professional exam in just 5 weeks with this SkillBoost track. Earn 50 Tech Xpert points when you attend at least 3 out of 5 sessions!","Start":"2025-03-11T09:00:00Z","End":"2025-04-11T09:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Zscaler Get Skilled in 4 - Session 4","Description":"Westcon 3D Labs (ZIA and ZPA) (Virtual)\\\\n\\\\nYou will earn 20 TX points per full session attended","Start":"2025-03-07T09:00:00Z","End":"2025-03-07T12:00:00Z","Multiple_dates":0,"Button":"Register now","URL":"https://p.westconcomstor.com/emea_zsc_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"#France - Prépara PSE SASE - Overview","Description":"Vous connaissez déjà très bien Palo Alto Networks et souhaitez préparer rapidement vos certifications avant vente alors n\\\\’hésitez pas à nous rejoindre à nos différents programme.","Start":"2025-03-07T08:00:00Z","End":"2025-03-07T12:00:00Z","Multiple_dates":0,"Button":"","URL":"https://westconcomstor.webex.com/webappng/sites/westconcomstor/webinar/webinarSeries/register/ea801dc6033e49b4945424cb7a893804","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"SkillBoost Bootcamp – PSE: Hardware Firewall Professional","Description":"Get ready to tackle your PSE: Hardware Firewall Professional exam in just 1 day with this SkillBoost Bootcamp. Earn 30 Tech Xpert points when you attend this session!","Start":"2025-03-06T09:00:00Z","End":"2025-03-06T12:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Zscaler Get Skilled in 4 - Session 3","Description":"Zscaler Data Protection Solution (Virtual)\\\\nZscaler Risk Management Solution \\\\n\\\\nYou will earn 20 TX points per full session attended","Start":"2025-03-06T09:00:00Z","End":"2025-03-06T10:00:00Z","Multiple_dates":0,"Button":"Register now","URL":"https://p.westconcomstor.com/emea_zsc_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"AI in Cybersecurity","Description":"Dive into the transformative role of Artificial Intelligence in modern cybersecurity and explore how AI can accelerate and enhance DNS-based threat detection capabilities. Earn 20 Tech Xpert points when you attend!","Start":"2025-03-05T09:00:00Z","End":"2025-03-05T10:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_eef_tech-xpert-sessions.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Action Plans: Reduce Time To Fix Cloud Security Risks","Description":"Join this short track series of live webinars featuring sales and technical contents. You will discover how the biggest innovations in Prisma Cloud can help secure customers\\\\’ Cloud and AI transformation.","Start":"2025-03-04T09:00:00Z","End":"2025-03-04T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://register.paloaltonetworks.com/actionplansreducetimetofixclou","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Stratus SkillBoost: ztC Endurance Deep Dive","Description":"Join our Westcon Stratus SkillBoost session, detailed insights into ztC Endurance’s resilience and management capabilities. As a Tech Xpert member, you will get 15 TXP points for attending this session.","Start":"2025-03-04T10:00:00Z","End":"2025-03-04T11:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_str_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Zscaler Get Skilled in 4 - Session 2","Description":"Zscaler Zero Trust Networking Solution (Virtual)\\\\nZscaler Cyber Threat Protection Solution \\\\n\\\\nYou will earn 20 TX points per full session attended","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T10:00:00Z","Multiple_dates":0,"Button":"Register now","URL":"https://p.westconcomstor.com/emea_zsc_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Zscaler Get Skilled in 4 - Session 2","Description":"Zscaler Zero Trust Networking Solution (Virtual)\\\\nZscaler Cyber Threat Protection Solution \\\\n\\\\nYou will earn 20 TX points per full session attended","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T10:00:00Z","Multiple_dates":0,"Button":"Register now","URL":"https://p.westconcomstor.com/emea_zsc_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Accelerate through Cisco","Description":"We\\\\’ll cover how to get to Select with Cisco, give you an overview of Specialisations and how to make selling Cisco profitable.","Start":"2025-02-28T10:00:00Z","End":"2025-02-28T10:00:00Z","Multiple_dates":0,"Button":"Register here","URL":"https://comstoremea.webex.com/weblink/register/ra68dec7c5e72e8aa014aecef96bbdf48","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Cisco Secure Connect Deep Dive","Description":"Verdiep je kennis op Cisco Secure Connect met deze exclusieve training. Ontdek hoe deze unified SASE oplossing jouw digitale business kan verbeteren door gebruikers, apparaten en applicaties veilig en naadloos met elkaar te verbinden, waar je ook bent.","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T14:00:00Z","Multiple_dates":0,"Button":"Registreer je hier!","URL":"https://p.westconcomstor.com/nl_cis_security-360-trainingen.html","Location":"Needs something","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Zscaler Get Skilled in 4 - Session 1","Description":"Zscaler Zero Trust Cloud Architecture (Virtual)\\\\nTraffic Forwarding and Authentication\\\\n\\\\nYou will earn 20 TX points per full session attended","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T11:00:00Z","Multiple_dates":0,"Button":"Register now","URL":"https://p.westconcomstor.com/emea_zsc_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Zscaler Get Skilled in 4 - Session 1","Description":"Zscaler Zero Trust Cloud Architecture (Virtual)\\\\n\\\\nYou will earn 20 TX points per full session attended","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T11:00:00Z","Multiple_dates":0,"Button":"Register now","URL":"https://p.westconcomstor.com/emea_zsc_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Introduction to Nokia Network Infrastructure Portfolio","Description":"Together, Westcon-Comstor and Nokia provide the building blocks needed to unleash the full potential of network infrastructure. Join our webinar to learn more about the Network and Infrastructure portfolio of Nokia.","Start":"2025-02-28T10:00:00Z","End":"2025-02-28T11:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_nok_network-infrastructure-introduction-webinar.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Prisma Cloud AWS Xperience 3D Lab Showcase","Description":"Join us as we showcase our Prisma Cloud AWS Xperience 3D Lab, so you know exactly how to navigate the environment and use it for your own enablement and customer demos. Earn 15 Tech Xpert points when you attend this session!","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T10:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Fuel your pipeline with Q2 demand generation campaigns","Description":"Clare Buerge (EMEA Channel Marketing Manager) & Lora Neidhardt Maksic (EMEA SMB Marketing Lead) will take you through the HPE Aruba Networking campaigns available for you to run in Q2 (Feb-April).","Start":"2025-02-28T09:00:00Z","End":"2025-02-28T09:00:00Z","Multiple_dates":0,"Button":"Register","URL":"https://arubanetworks.zoom.us/webinar/register/WN_OKXNAR5nR5WxXXPYpF9FXg#/registration","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Dream Team Stammtisch: Extreme Networks & Palo Alto Networks","Description":"Wir laden Sie herzlich ein, mit uns in lockerer Atmosphäre über die neuesten Trends in IT Networking und Cyber Security zu sprechen. Extreme BOB Kit live erleben und testen – Extreme Fabric Connect inkl. Palo Alto Firewall Integration.","Start":"2025-02-28T16:00:00Z","End":"2025-02-28T21:00:00Z","Multiple_dates":0,"Button":"Hier anmelden","URL":"https://p.westconcomstor.com/DE_EXT_StammtischJan25.html","Location":"Leipzig","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Webinar CrowdStrike Cloud Security","Description":"Descubra como a CrowdStrike e a Westcon podem ajudar a sua organização a proteger os seus workloads, aplicações, e código na componente de Cloud.\\\\n\\\\nSessão Comunidade TechXpert: +15 TXP","Start":"2025-02-28T10:00:00Z","End":"2025-02-28T10:00:00Z","Multiple_dates":0,"Button":"Registe-se já!","URL":"https://westconemea.webex.com/weblink/register/rf98971252bd433a24c915a1605082191","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"F5 Bootcamp","Description":"\\\\nEntdecken Sie Multi-Cloud-Lösungen mit F5 Distributed Cloud (F5 XC): Effizient, sicher und flexibel. Spannende Sessions zu Grundlagen, Sicherheit, DNS-Management und Multi-Cloud-Konnektivität, ergänzt durch interaktive Labs zur direkten Anwendung.","Start":"2025-02-28T07:00:00Z","End":"2025-02-28T14:00:00Z","Multiple_dates":0,"Button":"HIER ANMELDEN!","URL":"https://p.westconcomstor.com/at_f5_bootcamp_jan25.html","Location":"Westcon Office Austria","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Unlocking Synergy: XSOAR and XSIAM in Cybersecurity","Description":"Join this webinar to discover how the integration of Cortex XSIAM into an existing Cortex XSOAR environment can unlock new possibilities and further propel your automation and orchestration efforts.","Start":"2025-02-23T13:00:00Z","End":"2025-02-23T14:00:00Z","Multiple_dates":0,"Button":"Details & Anmeldung","URL":"https://register.paloaltonetworks.com/xsoar-xsiam-session9","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Prisma Access Browser Workshop","Description":"Wir freuen uns, Sie zu einem besonderen Vor-Ort-Event einzuladen: dem Prisma Access Browser (PAB) Kompakt-Workshop, kombiniert mit einem entspannten Networking-Grill-Kurs!","Start":"2025-02-23T12:00:00Z","End":"2025-02-23T18:00:00Z","Multiple_dates":0,"Button":"Jetzt anmelden","URL":"https://p.westconcomstor.com/at_pan_pan-pab-workshop.html","Location":"Grill Heaven, SCS","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Nokia SkillBoost: Network Infrastructure Portfolio","Description":"Join the Nokia Network Infrastructure Portfolio update and learn how to meet customer requirements with trusted network performance and open network architectures. This is part of Nokia SkillBoost sessions for Tech Xpert.","Start":"2025-02-23T09:00:00Z","End":"2025-02-23T10:00:00Z","Multiple_dates":0,"Button":"","URL":"https://p.westconcomstor.com/emea_nok_skillboost.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Extreme Accreditation Workshop","Description":"Dieser Workshop bietet Ihnen die Möglichkeit, Ihre Verkaufsfähigkeiten zu optimieren und sich mit den neuesten Produkten und Lösungen vertraut zu machen.","Start":"2025-02-23T07:00:00Z","End":"2025-02-23T11:00:00Z","Multiple_dates":0,"Button":"GLEICH ANMELDEN!","URL":"https://p.westconcomstor.com/at_ext_accreditation-workshop.html","Location":"Westcon Office Austria","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Cisco Collaboration, Devices and Webex Calling [FY25Q2]","Description":"Needs description","Start":"2025-02-23T06:00:00Z","End":"2025-02-23T08:00:00Z","Multiple_dates":0,"Button":"Register for the Eve","URL":"https://p.westconcomstor.com/at_ext_accreditation-workshop.html","Location":"Comstor Office - Leap Center","Location_URL":"","Virtual":0,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"2025 Networking Technology Trends","Description":"• AI-Driven Network Management and Operations\\\\n• Wi-Fi 7 Wireless Convergence\\\\n• Sustainable Networking and Green ESG\\\\n• Edge-as-a-Service\\\\n• Post AI User Engagement","Start":"2025-02-22T15:00:00Z","End":"2025-02-22T16:00:00Z","Multiple_dates":0,"Button":"Register Here","URL":"https://events.commscope.com/commscope-virtual/2025-Networking-Technology-Trends-c14671f7e7ff7ce347f0c76c","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Marketing 101: Harness the power of Cisco Marketing Velocity","Description":"In this 101 session, Comstor\\\\’s Partner Marketing Manager UKI and Cisco will be doing a deep dive into the Cisco Marketing Velocity platforms updates.","Start":"2025-02-22T15:00:00Z","End":"2025-02-22T16:00:00Z","Multiple_dates":0,"Button":"Register here","URL":"https://comstoremea.webex.com/weblink/register/r3d6f1328cbfdad6b432b8187a1ad1f39","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Prisma Cloud AWS Xplore 3D Lab Showcase","Description":"Join us as we showcase our Prisma Cloud AWS Xplore 3D Lab, so you know exactly how to navigate the environment and use it for your own enablement and customer demos. Earn 15 Tech Xpert points when you attend this session!","Start":"2025-02-22T09:00:00Z","End":"2025-02-22T10:00:00Z","Multiple_dates":0,"Button":"REGISTER NOW","URL":"https://p.westconcomstor.com/emea_pan_ride-the-nextwave.html","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"AI for Networking in Wireless","Description":"As more devices and things are connecting to Wireless,keeping up with the volume, security and network maintenance becomes more challenging.By leveraging the power of AI we can help simplify deployment, client connectivity, performance,insights, security.","Start":"2025-02-22T09:00:00Z","End":"2025-02-22T09:00:00Z","Multiple_dates":0,"Button":"Register","URL":"https://arubanetworks.zoom.us/webinar/register/WN_C1wZ2PY_SSKREtYSBqVhGA#/registration","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Cybersecurity 360 Labs - Cisco Firepower (Advanced)","Description":"Get engineers up to speed on Cisco Firepower protection. Use the latest NGFW version (7,4,x) together with Cisco ISE policy &amp;Umbrella security solutions enabling companies to maximize their business security.","Start":"2025-02-21T13:00:00Z","End":"2025-02-21T14:00:00Z","Multiple_dates":0,"Button":"Register here","URL":"https://comstoremea.webex.com/weblink/register/r191258199fee6362386c160e8246ff88","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Prisma Cloud Security Assessment for Your Customers","Description":"Join this short track series of live webinars featuring sales and technical contents. You will discover how the biggest innovations in Prisma Cloud can help secure customers\\\\’ Cloud and AI transformation.","Start":"2025-02-21T13:00:00Z","End":"2025-02-21T14:00:00Z","Multiple_dates":0,"Button":"","URL":"https://register.paloaltonetworks.com/cloudsecurityassessmentforyour","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16,38]},{"Author":1,"Title":"Future Proofing the Workplace with Wi-Fi 7","Description":"Breaking News: What’s new and why it matters. Wi-Fi Evolution: Positioning Wi-Fi 7 and understanding its relationship with Wi-Fi 6 and 6E. Unlocking Opportunities: Discover the market potential and identify your unique opportunities. And more..","Start":"2025-02-21T10:00:00Z","End":"2025-02-21T11:00:00Z","Multiple_dates":0,"Button":"REGISTER","URL":"https://comstorbe.webex.com/webappng/sites/comstorbe/webinar/webinarSeries/register/34c25901dd5545949efc105e66456a98","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]},{"Author":1,"Title":"Cybersecurity 360 Training - Cisco Firepower (Advanced)","Description":"Get engineers up to speed on Cisco Firepower protection. Use the latest NGFW version (7,4,x) together with Cisco ISE policy &amp;Umbrella security solutions enabling companies to maximize their business security.","Start":"2025-02-21T10:00:00Z","End":"2025-02-21T11:00:00Z","Multiple_dates":0,"Button":"Register here","URL":"https://comstoremea.webex.com/weblink/register/rbcb397b6241d7fc1aa8c4748a2dff507","Location":"","Location_URL":"","Virtual":1,"Recurring":0,"On_Demand":0,"Created":"2025-01-18T01:42:26.058Z","Modified":"2025-01-18T01:42:26.058Z","vendors":[7],"countries":[35,10,12,27,28,31,16]}]'; /** * Helper function to return a response and exit. * * @param mixed $data * @param array|null $error * @param int $httpCode */ function respond($data, $error = null, $httpCode = 200) { global $mysqli; listAllTables($mysqli); if (isset($mysqli) && $mysqli) { $mysqli->close(); } http_response_code($httpCode); echo json_encode([ 'data' => $data, 'error' => $error ]); exit; } /** * Validates and sanitizes a field in the event input. * * @param array $input * @param string $key * @param bool $required * @param mixed $default * @return string|mixed */ function listAllTables($mysqli) { // Define the tables to display $tables = [ "Events", "Events_Vendors", "Events_Vendors_Tags", "Events_Countries", "Events_Countries_Tags" ]; // Loop through each table foreach ($tables as $table) { echo "Data in table: $table\n"; $query = "SELECT * FROM $table"; // Execute the query if ($result = $mysqli->query($query)) { // Fetch and display the column names $fields = $result->fetch_fields(); $fieldNames = []; foreach ($fields as $field) { $fieldNames[] = $field->name; } echo implode("\t", $fieldNames) . "\n"; // Fetch and display the rows while ($row = $result->fetch_assoc()) { echo implode("\t", $row) . "\n"; } $result->free(); // Free the result set } else { // Handle errors echo "Error querying table $table: " . $mysqli->error . "\n"; } echo str_repeat("-", 50) . "\n"; // Separator for tables } } function validateInput($input, $key, $required = true, $default = null) { if (!isset($input[$key])) { if ($required) { respond(null, ['code' => 400, 'message' => "$key is missing"]); } return $default; } // Basic sanitization return htmlspecialchars(trim($input[$key])); } // Get the entire request body as an array of events $eventsArray = json_decode($mockEvents, true); // Validate that we received an array if (!is_array($eventsArray)) { respond(null, ['code' => 400, 'message' => 'Invalid JSON payload or not an array of events']); } // Start transaction $mysqli->begin_transaction(); $newEventIds = []; try { foreach ($eventsArray as $index => $input) { // Validate event data (assuming no 'id' field is used for creation) $Author = validateInput($input, 'Author', true); $Title = validateInput($input, 'Title', true); $Description = validateInput($input, 'Description', true); $Start = validateInput($input, 'Start', true); $End = validateInput($input, 'End', true); $Button = validateInput($input, 'Button', false, ""); $URL = validateInput($input, 'URL', true); $Location = validateInput($input, 'Location', true); $Location_URL = validateInput($input, 'Location_URL', true); $Virtual = validateInput($input, 'Virtual', true); $MultipleDates = validateInput($input, 'Multiple_dates', false, 0); $Recurring = validateInput($input, 'Recurring', false, 0); $OnDemand = validateInput($input, 'On_Demand', false, 0); // Convert dates to MySQL format $Start = date('Y-m-d H:i:s', strtotime($Start)); $End = date('Y-m-d H:i:s', strtotime($End)); // Validate relationships $vendorIDs = $input['vendors'] ?? []; $countryIDs = $input['countries'] ?? []; // 1) Insert into `Events` $stmt = $mysqli->prepare(" INSERT INTO `Events` (`Author`, `Title`, `Description`, `Start`, `End`, `Button`, `URL`, `Location`, `Location_URL`, `Virtual`, `Multiple_dates`, `Recurring`, `On_Demand`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "); if (!$stmt) { throw new Exception($mysqli->error, 500); } $stmt->bind_param( "isssssssssiii", $Author, $Title, $Description, $Start, $End, $Button, $URL, $Location, $Location_URL, $Virtual, $MultipleDates, $Recurring, $OnDemand ); if (!$stmt->execute()) { throw new Exception($stmt->error, 500); } $newEventId = $stmt->insert_id; $stmt->close(); // 2) Insert into Events_Vendors_Tags if (!empty($vendorIDs)) { $stmt = $mysqli->prepare("INSERT INTO Events_Vendors_Tags (event_id, vendor_id) VALUES (?, ?)"); if (!$stmt) { throw new Exception($mysqli->error, 500); } foreach ($vendorIDs as $vendorID) { $stmt->bind_param("ii", $newEventId, $vendorID); if (!$stmt->execute()) { throw new Exception($stmt->error, 500); } } $stmt->close(); } // 3) Insert into Events_Countries_Tags if (!empty($countryIDs)) { $stmt = $mysqli->prepare("INSERT INTO Events_Countries_Tags (event_id, country_id) VALUES (?, ?)"); if (!$stmt) { throw new Exception($mysqli->error, 500); } foreach ($countryIDs as $countryID) { $stmt->bind_param("ii", $newEventId, $countryID); if (!$stmt->execute()) { throw new Exception($stmt->error, 500); } } $stmt->close(); } // Keep track of the newly inserted event ID $newEventIds[] = $newEventId; } // Commit if everything is OK $mysqli->commit(); // Return an array of created IDs respond($newEventIds, null, 200); } catch (Exception $e) { // Something went wrong, rollback all $mysqli->rollback(); respond( null, [ 'code' => $e->getCode() ?: 500, 'message' => $e->getMessage() ], 500 ); } ?>