shopify apps: how to install mysql in shopify react and php app and get table data from mysql table

nihal · ‎03-10-2024

Hey guys, im working on a shopify app with react and php template, in default sqllite came with the installation but i want to install mysql and get data from a table from my database.

1) how to install mysql instead of sqlite?
2) how to create connection and get data from table in php controller.

product_options · ‎03-11-2024

Are you using this template https://github.com/Shopify/shopify-app-template-php/.

Or any other, please specify, then can suggest the required changes to be make to connect with MySql instead sqlite

Product Options Add unlimited product options using an easy-to-use drag-and-drop form builder

nihal · ‎03-16-2024

yes im using this package

BrainStation23 · ‎03-12-2024

Hello,

You can use this package instead of SQLite one https://www.npmjs.com/package/@link-hooks/shopify-app-session-storage-mysql

Configure the configuration accordingly for MYSQL

Brain Station 23 PLC (Mail: js.sbu@brainstation-23.com)
- Was your question answered? Mark it as an Accepted Solution
- Did the solution not address your concern? We kindly request that share or mail your store URL with us this will enable us to collaborate more closely.
- Explore our Shopify public apps

nihal · ‎03-16-2024

ok, after using this package, how can i use this to add, update records in db ?