Add PHP, Composer, MySQL, phpMyAdmin and PHP CRUD API to your local development environment.
You might be interested in a simple Synchronization between local IndexedDB and MySQL Database.
-
Create a new app project:
npm create vite
-
Add a PHP backend:
npx add-php-backend
- Run
npm run backendto start the backend - Open the PHP server at http://localhost:8000
- API endpoint at http://localhost:8000/api.php
- Open phpMyAdmin at http://localhost:8080
- Login with username
rootand passwordroot
- Login with username
- Use the PHP CRUD API in frontend with
/api.php
- no dependency will be added to the repository
- you have full control of all source files for fine tuning
- running
npx add-php-backendwill download the package in a cache folder - the package main script will create some files in the project folder if not exist:
docker/folder with the Dockerfilespublic/api.phpinitialization of the PHP CRUD APIpublic/credentials.template.phpto be renamed tocredentials.phpfor productioncomposer.jsonto configure Composerdocker-composer.ymlto configure the container setupschema.sqlcontains the database schema and updates to ittestdata.sqlcontains test data only for development
- the package main script will modify some files in your project folder:
- add a
backendscript to thepackage.jsonfile and prepend it todev - add a proxy server config for PHP files to the Vite config file
- add
vendor/andcredentials.phpto the.gitignorefile
- add a
Report bugs in the issues list.
- Apply changes to the code
- Run
npm run demoto build and start thedemo-app - Apply changes to the
README.mdfile and screenshots - Commit changes with an issue (closure) reference
- Run
npm version patch | minor | majorand push changes - Let the workflow manage the release to GitHub and NPM