Electricity bill payment management system in PHP MSQL

  1. Admin and user logins
  2. 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.
  3. The system calculates the electricity bill for every user and updates the information into their account every month.

Technology used

Front end

  1. HTML
  2. CSS
  3. Bootstrap
  4. JavaScript

Back end

  1. PHP
  2. 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


Leave a Reply

Your email address will not be published. Required fields are marked *