Changes and Additions to php/MySQL Website

Description

Files for this site can be accessed here: https://www.dropbox.com/scl/fo/8fa7t552q4nwdrdpbowuo/AOhFEx2eWHs7YML67fNpOuM?rlkey=p7ws7066jiya5zxsq18ta1mai&dl=0
The Review PageGo to https://prep-test.net/test/login.php (I will call this the “new site”) and log in as Mary Doe. Click the Review button in the navbar. Click the Algebra item under Quantitative. Now go to insightprep.net I will call this the “live site”) and log in again as Mary Doe. Click the Algebra item again. The layout and functions of this page in prep-test.net/test need to be the same as they are in insightprep.net/preptest except that there should be no Discuss with William button. That includes the position and format of the three panels, the Next button, the Dismiss button, and the Remaining Explanations number in the navbar. Currently, the Dismiss button in both the live site and the new site doesn’t work, so that functionality needs to be restored in both sites. The Heading above panel 1 should be removed.
The Questions PageClick the Home button and select Quantitative and Prep Now. Note that the Percent Missed value in the navbar is 50%. That is because each time a student starts a session, the first question that appears is one that 50% of my students missed. Click the Not Sure answer and Submit. Now you see the explanation for the question you just answered. Then click the Next Question button in the navbar and note that the Percent Missed for this question is very close or equal to 50%. Because your Not Sure answer to the previous question wasn’t correct, this current question should have a percent missed value that is the greatest value of the set of questions having percent missed of less than 5 percentage points below that value of the previous question. For example, if the previous question had a percent missed of 50% and it was answered incorrectly, the next question should have a percent missed of the greatest value less than 45%. Likewise, if a question is answered correctly, the next question should have a percent missed that is the least value greater than 4 percentage points higher than the last question.
The new site should also display “previously missed questions”, i.e. questions that the current student answered more than 7 days before the current session, along with new questions. This is not happening and needs to be done.
The panels should be populated with the data in the corresponding panel fields in the Questions table. If a panel field contains only a “q”, the question and answer choices are displayed with radio buttons. If a panel field contains a “1”, the graphic associated with the question is displayed. All of that is working as intended. However, the panel layout on the questions page should be panels 6, 7 and 8 from left to right and panel 9 laying over panels 6 and 7. Only panels containing data should have a white background. The position of the panels is not now correct and needs to be corrected as stated. For example, the position of the panels in a Data Insights (Integrated Reasoning) question is not correct.
The Explanations PageClick the Not Sure button on a questions page and Submit. The panels should be populated with the data in the corresponding Panelx fields in the Questions table. The panel layout on the explanations page should be panels 1, 2 and 3 from left to right and panel 4 laying over panels 1 and 2. Only panels containing data should have a white background. The position of the panels is not now correct and needs to be corrected as stated.
Mobile DevicesAll pages should be optimized for other devices.