Install the required dependencies
npm install
Set up MySQL if you have not done so
Start the local MySQL server and establish local connection
Create database
your_databaseNavigate to folder
backend, then import the 3 .csv filesusers,transactionsandloanstoyour_databaseEdit the Node.js server file to
your_user,your_passwordandyour_databaseconstdb=mysql.createConnection({host: 'localhost',user: 'your_user',password: 'your_password',database: 'your_database'});constpool=mysql.createPool({host: 'localhost',user: 'your_user',password: 'your_password',database: 'your_database'});
Start the Node.js server file
node mysql.js
Start the app
npx expo start
- Number: +65 12345678
- Verification Code: 654321
- Username: iancheah
- Password: wordpass
- Number: +65 12121212
- Verification Code: 123456
- Username: yunhong
- Password: securepass