Summary
- Tutorial demonstrates building an installable mobile CRM app without programming knowledge.
- Uses Google IDE "Antigravity" with integrated Gemini 3 Pro AI agent to generate a PHP + MySQL web app.
- AI creates project structure, database schema, backend API, frontend, and PWA support for mobile installation.
- Instructor shows local testing, database setup in phpMyAdmin, creating admin user, basic usage, and publishing to hosting for mobile install.
Action Items
- (now – Instructor) Create project folder and open it in Antigravity to start the AI agent.
- (now – Instructor) Submit prompt (provided in pinned comment) to Gemini 3 Pro to generate full app.
- (now – Instructor) Copy generated SQL schema into phpMyAdmin and run to create database tables.
- (now – Instructor) Update src/db.php with database connection info, then move credentials to .env for security.
- (now – Instructor) Run local PHP server (php -S 127.0.0.1:8080) to test the app.
- (now – Instructor) Use createadmin.php to create admin user ([email protected] / admin13) for login.
- (after testing – Instructor) Host the app to make it accessible online and installable as a PWA on mobile.
- (optional – Learner) Sign up for waiting list for "The New Era of Programming" training for deeper database, security, and hosting lessons.
Project Setup And Tools
- Key tools
- Antigravity IDE with Gemini 3 Pro agent.
- PHP for backend.
- MySQL for database (phpMyAdmin used to create DB).
- Browser for PWA installation (iPhone demonstrated).
- Project structure created by AI
- API folder
- assets folder
- src folder
- SQL schema file
- createadmin.php utility
- .env integration for credentials
- Security step
- Move DB credentials into .env to avoid hardcoding in source files.
Database And Server Steps
- Create database in phpMyAdmin (example name: IA_Finance_CRM).
- Paste and run AI-generated SQL schema to create all tables.
- Edit src/db.php:
- Host: 127.0.0.1 (local testing)
- DB name: IA_Finance_CRM (example)
- User: root
- Password: (empty for local)
- Start local server:
- Command: php -S 127.0.0.1:8080
- Use createadmin.php to auto-generate admin user:
App Features Demonstrated
- Authentication: login and admin user creation script.
- Financial CRM features:
- Dashboard with current balance, revenue, expenses.
- Add revenue entries with description, amount, category, date.
- Add expense entries with description, amount, category.
- Category defaults: sale, service, salary, investment, others (AI can add more on request).
- Profile and user management from admin interface.
- Placeholder configuration area for profile photo, name change, etc.
- PWA behavior:
- App appears and behaves like native app when added to home screen.
- Icon and manifest provided so mobile installation is seamless.
Decisions
- Chosen tech stack: PHP + MySQL (explicitly requested in prompt).
- Project generated and implemented by Gemini 3 Pro within Antigravity.
- Credentials relocated to .env for improved security before hosting.
- Created utility createadmin.php to simplify initial admin creation.
Open Questions
- Which hosting provider and deployment steps were used for the live hosting (specific provider not named)?
- What production-grade security measures (password policies, HTTPS setup, prepared statements) are implemented beyond moving credentials to .env?
- Is there an automated deployment workflow from Antigravity to hosting, or is manual upload required?
- What backup and migration strategy is recommended for the generated database schema in production?
Structured Details
| Item | Example / Value |
| IDE / Agent | Antigravity with Gemini 3 Pro |
| Backend Language | PHP |
| Database | MySQL (phpMyAdmin used) |
| Local Server Command | php -S 127.0.0.1:8080 |
| Example Database Name | IA_Finance_CRM |
| Admin User (created) | [email protected] |
| Admin Password (demo) | admin13 |
| Main Folders Generated | API, assets, src |
| Security Step | Move DB credentials to .env |
| Mobile Install Method | Add to Home Screen (iPhone share -> Add to Home Screen) |