Repository files navigation

AddPHP,Composer,MySQL,phpMyAdmin andPHP CRUD API to your local development environment.

You might be interested in a simpleSynchronization between local IndexedDB and MySQL Database.

1. InstallDocker andNode.js

2. Create a new app project:

   npm create vite

3. Add a PHP backend:

   npx add-php-backend

• Runnpm run backend to start the backend
• Open the PHP server athttp://localhost:8000
  • API endpoint athttp://localhost:8000/api.php
    • example:http://localhost:8000/api.php/records/tasks
• Open phpMyAdmin athttp://localhost:8080
  • Login with usernameroot and passwordroot
• Use the PHP CRUD API in frontend with/api.php

• no dependency will be added to the repository
• you havefull control of all source files for fine tuning
• runningnpx add-php-backend will download the package in a cache folder
• the package main script willcreate some files in the project folder if not exist:
  • docker/ folder with the Dockerfiles
  • public/api.php initialization of the PHP CRUD API
  • public/credentials.template.php to be renamed tocredentials.php for production
  • composer.json to configure Composer
  • docker-composer.yml to configure the container setup
  • schema.sql contains the database schema and updates to it
  • testdata.sql contains test data only for development
• the package main script willmodify some files in your project folder:
  • add abackend script to thepackage.json file and prepend it todev
  • add a proxy server config for PHP files to the Vite config file
  • addvendor/ andcredentials.php to the.gitignore file

Report bugs in theissues list.

1. Apply changes to the code
2. Runnpm run demo to build and start thedemo-app
3. Apply changes to theREADME.md file and screenshots
4. Commit changes with an issue (closure) reference
5. Runnpm version patch | minor | major and push changes
6. Let the workflow manage the release to GitHub and NPM