i need to make this plz will give a thumbs up if done good the goal of what i ha

Question

i need to make this plz will give a thumbs up if done good the goal of what i have to make is in the picutre. the link for the stated code is below:

https://drive.google.com/file/d/1b7_GMqFKMZwMPWFBEjqhrFdn4kow5rSx/view?usp=sharing

Goal The goal of this project is to design an image sharing app /site using all the concepts, languages, and technologies learned throughout the class. This task will be structured in a series of milestones, as follows: o Milestone 1: user authentication o Milestone 2: session management o Milestone 3: basic photo uploader o Milestone 4: improved photo uploader o Milestone 5: additional features o Milestone 6: preparation of the final app Recommended Procedure 1. Make sure you have your lamp.cse.fau.edu server space set up. Please note that you must have a server setup for your PHP code to work. Milestone 1: user authentication 2. Create a table ('USERS' for storing user information (see example 12.3 in Nixon's book). It should contain 2 fields per record, namely: userid and password. The password should be stored in encrypted form (after "salting" and hashing) (see example 12.4 in Nixon's book). Implement the functionality that allows a user to login (by entering their userid and password and matching against the data stored in the USERS table in the database). See example 26.7 in Nixon's book for the basic functionality (ignore the visual aspects, please!). After successful login, display a page that shows a simple 'Success' message Implement the functionality that allows a user to sign up (by entering their intended userid and password): if the userid is no longer available, display an error message; otherwise, add the new userid and associated (encrypted) password to the 'USERS' table in the database and display a simple Success' message. (Optionally, you might want to enforce password rules, such as minimum length, etc.) 3. 4. 5. Improve the visual aspects of your login/signup page and make it Bootstrap-based. See examples at ist.github.c Minaise 874 e htt Create a page that looks like you want your future 'wall' to look. Don't forget to include a Logout' button in the page 6.

Explanation / Answer

Answer:

Creating Tables:

For first Table:

--Here table name is used as Table1

create table Table1(TutorID INT NOT NULL,CertDate DATE,Status VARCHAR(20),PRIMARY KEY(TutorID));

For Second Table (Student)

create table Student(StudentID INT NOT NULL,Read DECIMAL(5,2),PRIMARY KEY(StudentID));

For Third Table (Match_History)

create table Match_Hist(MatchID INT NOT NULL AUTO_INCREMENT,TutorID INT,StudentID INT,StartDate DATE,EndDate DATE,PRIMARY KEY(MatchID),FOREIGN KEY (TutorID) REFERENCES Table1(TutorID),FOREIGN KEY (StudentID) REFERENCES Student(StudentID));

=>If you need autoincrement IDs for the tables Tutor1 and student, use the query before inserting

alter table Tutor1 AUTO_INCREMENT=100;

alter table Student AUTO_INCREMENT=3000;

Insert Data Into Tables

For firsttable

Insert into Table1((TutorID,CertDate,Status) values(100,'1/05/2015');

for second table

Insert into Student(StudentID,Read) values (3000,2.3);

For THird Table

Insert into Match_Hist(TutorID,StudentID,StartDate,EndDate) values (100,3000,'1/10/2015',NULL);

SQL Statements

1.Number of table1s have status of Tem Stop

Select count(TutorID) from Table1 where Status='Tem Stop';

2. List of active tables

Select TutorID from Table1 where Status='Active';

3. Table1s who took certification in january

Select TutorID from Table1 where MONTH(CertDate)=1

4. Student who has highest Read Score

Select StudentID from Student where Read=(select max(Read) from Student);

5. Average Read Score

Select AVG(Read) from Student;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.