![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Website Design
- or -
Post a project like this3318
$500
- Posted:
- Proposals: 11
- Remote
- #789885
- Awarded
★Top PPH Service Provider! Shopify, WordPress, WooCommerce, Magento, & eCommerce Expert!
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Responsive Website | | Flash | Logo Designing | Wordpress | Magento | PHP | MySql | ASP.net | MsSql | Jquery | Ajax | CSS | HTML5 | AWS
Magento|WordPress |Shopify|PHP|Zend|Laravel|Android|iOS|GUI Designing|SEO|React Native|Node.js|Angular.js
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
894988867059613795388779550406143891959734601750836855200475960311
![Activecraft](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/7dc3fe53d78ababb45f30f73b4b53724_70x70.png)
![Naeem A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/c840c149daec85f75fc1f5d3401be21f_70x70.jpg)
![Mitash Digital Pty Ltd](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/46a7d8f464bf5e84e02dc77e9c6a961e_70x70.jpg)
![Anuradha S.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/302d76cce61c37cc10b5f2be60c4d094_70x70.jpg)
![Haresh D.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/55d3bf0988f962e1886f65c300efec85_70x70.jpg)
Description
Experience Level: Expert
Estimated project duration: less than 1 week
General information for the website: Education
Database management system (DBMS): MySQL
Kind of development: New website from scratch
Description of requirements/features: I need an Expression Web website containing two pages connected to a MySQL database.
1. LOGIN PAGE
A page for students to enter their StudentID and Password and have those validated against the Students table in the database described below so that they can view the pages I am showing at that time.
2. MySQL DATABASE
A. This needs the same tables and queries that are contained in the Access database supplied with this project description. That Access database is to be replaced by the MySql database online that will be created in this project, and then I will create an ODBC connection to it from another Access database on my computer.
3. QUESTION PAGE
A. DetailsView or similar control containing a bound item linked to the Questions field in the Questionsqry. I need to know how to write the text for this field in the database such that it can contain multiple paragraphs separated by a blank line.
B. On pages where the Passage ID field in the current record is not null, show the Passage field on the left side of the page and the Question field on the right side of the page. On pages where the Graphic field is not null in the current record, show the Graphic above the Question.
C. Radio Button List containing 6 choices such that the text for the first 5 choices are populated by the AnswerA, AnswerB, AnswerC, AnswerD and AnswerE fields in the Questionsqry. The sixth choice is always “Not Sure”. The values for each choice are 1 through 6. The student’s selection must post back to the StudentAnswers table and contain the value of the selection, the QuestionID in the Questionsqry for the question being answered, the StudentID at login, and the DateTime.
4. EXPLANATION PAGE
A. DetailsView or similar control containing a bound item linked to the Explanation field in the Explanationsqry and a bound item linked to the Principle field in the Explanationsqry. As with the Questions field on the Question page, I need to know how to write these in the database so that they can contain multiple paragraphs separated by blank lines.
B. On pages where the AnswerGraphic field in the current record is not null, show the AnswerGraphic above the Explanation.
C. Radio Button List containing 2 choices: “Got” and “Not” with values 1 and 2. The student’s selection must post back to the StudentAnswers table and contain the value of the selection, the QuestionID in the Explanationsqry for the question being explained, the StudentID at login, and the DateTime.
5. ADMIN PANEL
A. The contents of the PercentAnswered query giving me (i) the percent of students who have answered the current question and (ii) of the AnswerPercents query giving me the percent of students who chose each answer. This needs to be updated continuously while students are thinking about the current question so that I will know when to move to the next page.
B. Pager control that enables me to select whether to either (i) move to the Explanation page for the current question or (ii) skip to the next record for the Question page. If I move to the Explanation page, I need to be able to move through all records for the current question, and when all have been shown, I should then automatically move to the Question page for the next record. Both the Question page and the Explanation page must be continuously updated to the page I have selected in the Admin panel. Students will not have their own Pager controls.
6. VoiP. Controlled from Admin Panel with option for one-way and two-way communication.
Database management system (DBMS): MySQL
Kind of development: New website from scratch
Description of requirements/features: I need an Expression Web website containing two pages connected to a MySQL database.
1. LOGIN PAGE
A page for students to enter their StudentID and Password and have those validated against the Students table in the database described below so that they can view the pages I am showing at that time.
2. MySQL DATABASE
A. This needs the same tables and queries that are contained in the Access database supplied with this project description. That Access database is to be replaced by the MySql database online that will be created in this project, and then I will create an ODBC connection to it from another Access database on my computer.
3. QUESTION PAGE
A. DetailsView or similar control containing a bound item linked to the Questions field in the Questionsqry. I need to know how to write the text for this field in the database such that it can contain multiple paragraphs separated by a blank line.
B. On pages where the Passage ID field in the current record is not null, show the Passage field on the left side of the page and the Question field on the right side of the page. On pages where the Graphic field is not null in the current record, show the Graphic above the Question.
C. Radio Button List containing 6 choices such that the text for the first 5 choices are populated by the AnswerA, AnswerB, AnswerC, AnswerD and AnswerE fields in the Questionsqry. The sixth choice is always “Not Sure”. The values for each choice are 1 through 6. The student’s selection must post back to the StudentAnswers table and contain the value of the selection, the QuestionID in the Questionsqry for the question being answered, the StudentID at login, and the DateTime.
4. EXPLANATION PAGE
A. DetailsView or similar control containing a bound item linked to the Explanation field in the Explanationsqry and a bound item linked to the Principle field in the Explanationsqry. As with the Questions field on the Question page, I need to know how to write these in the database so that they can contain multiple paragraphs separated by blank lines.
B. On pages where the AnswerGraphic field in the current record is not null, show the AnswerGraphic above the Explanation.
C. Radio Button List containing 2 choices: “Got” and “Not” with values 1 and 2. The student’s selection must post back to the StudentAnswers table and contain the value of the selection, the QuestionID in the Explanationsqry for the question being explained, the StudentID at login, and the DateTime.
5. ADMIN PANEL
A. The contents of the PercentAnswered query giving me (i) the percent of students who have answered the current question and (ii) of the AnswerPercents query giving me the percent of students who chose each answer. This needs to be updated continuously while students are thinking about the current question so that I will know when to move to the next page.
B. Pager control that enables me to select whether to either (i) move to the Explanation page for the current question or (ii) skip to the next record for the Question page. If I move to the Explanation page, I need to be able to move through all records for the current question, and when all have been shown, I should then automatically move to the Question page for the next record. Both the Question page and the Explanation page must be continuously updated to the page I have selected in the Admin panel. Students will not have their own Pager controls.
6. VoiP. Controlled from Admin Panel with option for one-way and two-way communication.
![William B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/20f473e2af6feb66a8897a48f2bb8a0e_150x150.jpg)
William B.
100% (73)Projects Completed
39
Freelancers worked with
34
Projects awarded
73%
Last project
4 Jul 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies