I am now using kirby for a project with a custom widget panel that reads user details and displaying them to a table. The widget panel should also allow users to export the data through csv, excel and sql format. Is there a plugin or anything from kirby that can export database files?
Thanks for the response! I already read those and use it on integrating mysql on my kirby project. My problem was on downloading / exporting the database on different filetypes(csv,xlx,sql) just trying my luck if there is something from kirby that can help me simplify things.
I can generate the CSV file when the user clicks the ‘export’ button, but I don’t know how to force the browser to download it. Ideally, I’d like to not even generate the file - just send it directly to the browser, and let it download it to a file in the user’s computer. I tried just sending the data, and it ended up as raw text in a new browser tab…
Thank you for all your help guys! Finally got the sql one using mysqldump. As for the CSV one, it was got out of the plan since the sql format is what needed the most. Thanks for all your help!