This PHP web application is a simple budget management system designed to track expenses and incomes. It utilizes a MySQL database to store information and provides a user-friendly interface for data entry and visualization.
-
Database Structure:
- The application's information system is based on several tables in a relationship, including
accounting
,categories
,payments
, andtransactions
.
- The application's information system is based on several tables in a relationship, including
-
HTML Forms:
- HTML forms are provided for entering data, allowing users to add new transactions with details such as date, amount, description, category, and payment method.
-
Data Storage:
- User-entered data is stored in the corresponding tables in the MySQL database.
-
Queries and Display:
- The application supports queries on several tables in a relationship, displaying results in tables or graphs.
- Set up a MySQL database and import the provided SQL schema (
database/maarif_alizade.sql
). - Update the config file(s) with your database credentials.
- Host the application on a PHP-enabled server.
- Access the application through a web browser.
- Use the provided HTML forms to enter new transactions.
- View and analyze your financial data through the transaction display or graphical representation.
-
Frontend:
- HTML, CSS
- JavaScript
- jQuery UI, Bootstrap
-
Backend:
- PHP
-
Database:
- MySQL
Contributions are welcome! Feel free to open issues or pull requests for improvements.