- Admin and user logins
- User can view their electricity bill and make payment before month end. If user fails to pay the bill before month end, it then calculates fine for each subsequent day.
- The system calculates the electricity bill for every user and updates the information into their account every month.
Technology used
Front end
- HTML
- CSS
- Bootstrap
- JavaScript
Back end
- PHP
- MySQL
How to run Online electricity bill payment management system in PHP MSQL in Cpanel
Download source code using the link below After and extract the zipped file ,find the folder named electra.sql in this folder you will also get the file named electra.sql
Create a new database and user, give it privilege and import the file named electra.sql to create all the tables
After importing all the tables you can now run the project in your favourite browser ,create an account and experience the system!
Download the zipped file
Extract the file
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)
How to run Online electricity bill payment management system in PHP MSQL in localhost
Open PHPMyAdmin (http://localhost/phpmyadmin)
Create a database with any name
Import electra.sql file (given inside the zip package in SQL file folder)
Download and make the following changes in `database.php`
‘connections’ => [
‘sqlite’ => [
‘driver’ => ‘sqlite’,
‘database’ => env(‘DB_DATABASE’, database_path(‘database.sqlite’)),
‘prefix’ => ”,
],
‘mysql’ => [
‘driver’ => ‘mysql’,
‘host’ => env(‘DB_HOST’, ‘127.0.0.1’),
‘port’ => env(‘DB_PORT’, ‘3306’),
‘database’ => env(‘DB_DATABASE’, ‘techadvisor’),
‘username’ => env(‘DB_USERNAME’, ‘techadvisor3’),
‘password’ => env(‘DB_PASSWORD’, ‘12345’),
‘unix_socket’ => env(‘DB_SOCKET’, ”),
‘charset’ => ‘utf8mb4’,
‘collation’ => ‘utf8mb4_unicode_ci’,
‘prefix’ => ”,
‘strict’ => true,
‘engine’ => null,
],
‘pgsql’ => [
‘driver’ => ‘pgsql’,
‘host’ => env(‘DB_HOST’, ‘127.0.0.1’),
‘port’ => env(‘DB_PORT’, ‘5432’),
‘database’ => env(‘DB_DATABASE’, ‘techadvisor’),
‘username’ => env(‘DB_USERNAME’, ‘techadviser4’),
‘password’ => env(‘DB_PASSWORD’, ”),
‘charset’ => ‘utf8’,
‘prefix’ => ”,
‘schema’ => ‘public’,
‘sslmode’ => ‘prefer’,
],
‘sqlsrv’ => [
‘driver’ => ‘sqlsrv’,
‘host’ => env(‘DB_HOST’, ‘localhost’),
‘port’ => env(‘DB_PORT’, ‘1433’),
‘database’ => env(‘DB_DATABASE’, ‘techadvisor3’),
‘username’ => env(‘DB_USERNAME’, ‘techadvisor6’),
‘password’ => env(‘DB_PASSWORD’, ”),
‘charset’ => ‘utf8’,
‘prefix’ => ”,
],
],
DOWNLOAD DOCUMENT
DOWNLOAD FILES