You can directly link your widget to MySQL database, allowing for real-time data fetching, analysis, and manipulation.
Follow these steps to connect your widget with MySQL:
- Open the Common Ninja editor and navigate to the Integrations tab. Within the Data section, locate and select the MySQL option.
- In your MySQL settings window, paste your MySQL credentials such as host, user, password, and database
-
After inputting your credentials details, click the "Connect Widget" button to continue the integration process.
-
Once connected, a new set of options will appear:
- Use the Table section to choose the needed table from your MySQL database.
-
Use the Data Mapper section to select the specific data elements from your database to incorporate into your widget.
That's it! By following these steps, you can integrate data from the MySQL database into your Common Ninja widgets.