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

Shopify Discussion
1

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.
2

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

3

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

4

yes im using this package

5

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