sudo apt-get update
sudo apt-get install apache2
sudo apt-get install php libapache2-mod-php php-mysql php-curl php-gd php-json php-zip php-mbstring
sudo systemctl restart apache2
sudo apt-get install mysql-server
Add Endpoint URL of the DB to the congig.php and also for the pages which need the DB Details
If the Database or Table name is changes please change it accordingly.
Example: Donate-blood.php, Find-donor.php, config.php, signup.php, index.php {login},
mysql -h mysqldb2022.cywy0av2gf7h.us-west-2.rds.amazonaws.com -u admin -p
Create database customers;
create table donors(id int AUTO_INCREMENT primary key, fname varchar(255) NOT NULL , lname varchar(255) NOT NULL , mobileno BIGINT UNIQUE, city varchar(255) NOT NULL, date date, dob date, bloodgroup varchar(255) NOT NULL);
DELETE FROM Customers;
show columns from donors;
CREATE TABLE users (
username varchar(80) NOT NULL,
name varchar(80) NOT NULL,
password varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO users (username, name, password) VALUES
('yssyogesh', 'Yogesh Singh', '12345'),
('bsonarika', 'Sonarika Bhadoria', '12345'),
('vishal', 'Vishal Sahu', '12345'),
('prashanth', 'Prashanth Katkam', '12345'),
('vijay', 'Vijay mourya', '12345');
INSERT INTO donors (fname, lname, mobileno, city, date, dob, bloodgroup) VALUES
('Srikanth', 'Koraveni', '9000736060', 'Pune', '2022-09-28', '1998-05-22', 'O_Positive'),
('Prashanth', 'Katkam', '7989919097', 'Mumbai', '2022-09-28', '1998-09-30', 'O_Positive'),
('Kranthi', 'Khaitha', '9876789871', 'Bangalore', '2022-09-16', '1996-07-02', 'B_Positive'),
('Srinivas', 'Thota', '9812789411', 'Mumbai', '2022-09-12', '1992-07-22', 'B_Positive'),
('Zaheer', 'Khan', '7788678987', 'Chennai', '2022-09-11', '1998-11-11', 'A_Positive');
#DB Endpoint needs to be added
vi donate-blood.php vi find-donor.php vi config.php vi search.php vi signup.php
INSERT INTO users (username, name, password) VALUES
('prashanth', 'Prashanth Katkam', '12345');
git clone URL
git clone --branch branchname URL
sudo git init
sudo git remote add origin "https://github.com/prashanthkatam/ltibloodbank.git"
sudo git remote add origin "https://github.com/prashanthkatam/test.git"
sudo git remote -v
sudo git add .
sudo git commit -m ""
git remote set-url origin https://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@github.com/prashanthkatam/ltibloodbank.git
git remote set-url origin https://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@github.com/prashanthkatam/test.git
sudo git push origin master
sudo git init
sudo git add .
sudo git commit -m ""
sudo git push origin master
<!doctype html>