Fix my HTML code for Website Development.
sonly
requirements.zipRequirements/AddToMailList.txt
"; echo "Thank you for Joining Our Mailing List!
"; echo "This is the information you entered:
"; echo " "; echo "| Name: | $fullname |
| Age: | $age |
| Email: |
| Major: | $major |
| Degree: | $degree |
__MACOSX/Requirements/._AddToMailList.txt
Requirements/HTML Files/.DS_Store
__MACOSX/Requirements/HTML Files/._.DS_Store
Requirements/HTML Files/AddToRegister.php
Thank You for Joining our Mailing List!
SELECT * FROM `DB 11` WHERE 1 Thank you MessageDear $firstname : Thank you for joining our mailing list. The management
"; echo "$html_string"; ?> //end of PHP block__MACOSX/Requirements/HTML Files/._AddToRegister.php
Requirements/HTML Files/assets/.DS_Store
__MACOSX/Requirements/HTML Files/assets/._.DS_Store
Requirements/HTML Files/assets/big contact.jpg
__MACOSX/Requirements/HTML Files/assets/._big contact.jpg
Requirements/HTML Files/assets/big shop.jpeg
__MACOSX/Requirements/HTML Files/assets/._big shop.jpeg
Requirements/HTML Files/assets/big tour.jpg
__MACOSX/Requirements/HTML Files/assets/._big tour.jpg
Requirements/HTML Files/assets/dadhat.jpg
__MACOSX/Requirements/HTML Files/assets/._dadhat.jpg
Requirements/HTML Files/assets/djhanzel.png
__MACOSX/Requirements/HTML Files/assets/._djhanzel.png
Requirements/HTML Files/assets/gerald.jpeg
__MACOSX/Requirements/HTML Files/assets/._gerald.jpeg
Requirements/HTML Files/assets/home.png
__MACOSX/Requirements/HTML Files/assets/._home.png
Requirements/HTML Files/assets/madeonshirt.jpg
__MACOSX/Requirements/HTML Files/assets/._madeonshirt.jpg
Requirements/HTML Files/assets/social.jpg
__MACOSX/Requirements/HTML Files/assets/._social.jpg
Requirements/HTML Files/assets/socialmediabanner.png
__MACOSX/Requirements/HTML Files/assets/._socialmediabanner.png
Requirements/HTML Files/assets/trafficlights.jpg
__MACOSX/Requirements/HTML Files/assets/._trafficlights.jpg
Requirements/HTML Files/assets/yellowclawshirt.jpg
__MACOSX/Requirements/HTML Files/assets/._yellowclawshirt.jpg
__MACOSX/Requirements/HTML Files/._assets
Requirements/HTML Files/Contact.html
CONTACT US
Ask us anything!
| Home | Shop | Tour | Social Media | Contact Us |
PHONE: 901-674-9012
E-Mail: [email protected]
Address: 912 Jefferson St. Memphis, TN 38104
Join our mailing list to be updated with all news, merchandise, tours, etc.
Name:
Telephone:
Email Address:
Date:
I am over 13 years old:
I agree to join this mailing list:
How did you get here?:
Facebook
Instagram
Twitter
Blog
Other
HOME |
SHOP |
TOUR |
SOCIAL |
CONTACT US
__MACOSX/Requirements/HTML Files/._Contact.html
Requirements/HTML Files/Home.html
DJ Rice God Official Website
Welcome Home!
| Home | Shop | Tour | Social Media | Contact Us |
Social Media
Online Store
Music
Contact Us
Join our mailing list to be updated with all news, merchandise, tours, etc.
Name:
Telephone:
Email Address:
Date:
I am over 13 years old:
I agree to join this mailing list:
How did you get here?:
Facebook
Instagram
Twitter
Blog
Other
HOME |
SHOP |
TOUR |
SOCIAL |
CONTACT US
__MACOSX/Requirements/HTML Files/._Home.html
__MACOSX/Requirements/HTML Files/._index.html
Requirements/HTML Files/Shop.html
DJ Rice God Online Store
New Merchandise Coming Soon
| Home | Shop | Tour | Social Media | Contact Us |
| Top Seller | Just Released | Top Rated | Deal of the Day |
|---|---|---|---|
|
|
|
|
|
HOME |
SHOP |
TOUR |
SOCIAL |
CONTACT US
__MACOSX/Requirements/HTML Files/._Shop.html
Requirements/HTML Files/Social.html
Social Media
Follow them all!
| Home | Shop | Tour | Social Media | Contact Us |
HOME |
SHOP |
TOUR |
SOCIAL |
CONTACT US
__MACOSX/Requirements/HTML Files/._Social.html
Requirements/HTML Files/stylerules.css
/* CSS style rules that define page structure */ header { background-color: white; font:italic small-caps normal 20px/150% arial, helvetica, sans-serif;} nav {text-align: center; background-color: white;} th,td{padding: 10px; border: 1px solid black;} td{c} table {border: 1px solid red; border-collapse: separate;border-spacing: 10px; margin: 0 auto;} th,td{padding: 10px; border: 1px solid black;} td{text-align: center;} table {border: 1px soild red ; border-collapse: separate;border-spacing: 10px; margin: 0 auto;} h1 {background-color:text-align: center; font: italic small-caps normal 50px arial, verdana, sans-serif;} h2 {font: italic small-caps normal 40px courier new; text-align: center;} p {font: 20px Lucida Sans; text-align: left;} p2 {background-color:text-align: center; font: italic small-caps normal 30px arial, verdana, sans-serif;} footer {background-color:text-align: center; font: italic small-caps normal 20px arial, verdana, sans-serif;} #container { max-width: 960px; margin: 0 auto; background-color: white;} #left { float: left; width: 20%; background-color: white; } #main { float: right; width:100%; background-color: white; } footer {text-align: center; clear: both; background-color: white; } .centertext { text-align: center; } #photos{margin: 0 auto;} #list{margin:0 auto;} #list td{ padding:10px; background-color:yellow; border:3px solid red; border-top-right-radius:50px; border-top-left-radius: 50px; text-align:center-right; } #photos td{ text-align:center; border:1px solid black; }
__MACOSX/Requirements/HTML Files/._stylerules.css
Requirements/HTML Files/Tour.html
DJ Rice God Tour Schedule
The Life of Rice Tour 2016
| Home | Shop | Tour | Social Media | Contact Us |
September 28, 2016 Atlanta, GA
October 17, 2016 St. Louis, MO
October 23, 2016 Kansas City, MO
October 24, 2016 Memphis, MO
HOME |
SHOP |
TOUR |
SOCIAL |
CONTACT US
__MACOSX/Requirements/HTML Files/._Tour.html
__MACOSX/Requirements/._HTML Files
Requirements/HW #10.pdf
MIS 4760 / 7435
Web Site Design and Development
Homework DB#10
In this assignment, we are going to create a PHP file that generates dynamic content.
1. Move your web site files into the htdocs folder if you have not done so already.
2. Locate the file that contains your user-data-entry form and open it in your text editor.
3. Modify the <form> element tag: Assign a PHP file name (such as: AddToMailList.php) to the form tag’s action value:
Example:
<form id="mailList" action="AddToMailList.php" method="post">
4. Resave the html file.
5. Create a new file with the name you assigned to the action attribute (e.g., AddToMailList.php).
Make sure the filename has the extension .php and the file is saved in the htdocs folder.
6. Add the PHP code to the file so that it sends the form data to the PHP processor as $_POST
variables and then generates a “thank you” message that refers to the form-user by name.
7. Test it out. Try filling out your own form and make sure the “thank you” message appears in a
browser window after you submit the form. Please refer to the example below.
Note: To test your PHP code, you must start your web services, then start a browser and enter
the URL of your html file that contains the form element (e.g. contactus.html):
\localhost\contactus.html
Fill out your form and click “submit”. Once ‘submit’ is clicked, the browser will send the form
data (as “post” variables) to the web server along with the “signal’ to run the PHP file.
8. Zip the folder that contains the web site files (including this new .php file) and upload the
zipped folder to the dropbox by the due date.
******************************AddToMailList.php **********************
<!DOCTYPE html>
<html> <head> <meta charset="utf-8" >
<title>Thank You for Joining our Mailing List</title>
</head>
<body>
<?php
// Create PHP variables and assign incoming POST variables to PHP variables
$fullname = $_POST['fullname'];
$age = $_POST['age'];
$email = $_POST['email'];
$major = $_POST['major'];
$degree = $_POST['degree'];
// Create a thank you message using PHP variables in HTML elements.
$html_string = "<h3>Thank you Message</h3><p>Dear $fullname :<br><br> Thank
you for joining our mailing list. We can provide $major majors seeking
$degree degrees with useful information. <br><br>The management</p>";
echo "$html_string";
?> //end of PHP block
</body> </html>
__MACOSX/Requirements/._HW #10.pdf
Requirements/HW #11.pdf
MIS 4760 / 7435
Web Site Design and Development
Homework DB#11
In this assignment, you are going to create a database and then add a table to it using MySQL. You will
also add PHP code to your PHP file that will open the database and write the form content to the table in
the database.
Here are the steps:
1. Create a database in MySQL. (hint: Direct the browser to: localhost\phpmyadmin )
2. Create a table in that database. You will need as many columns as you have input boxes in your form.
3. Add the PHP code to the php file that will open a connection to mySQL, select the database, “escape”
the POST variable values, create an SQL statement to insert the “escaped” values into the table,
execute the SQL statement, and close the connection. See the example below. Replace highlighted
words with your own database, table, and variable names.
4. Test it out. Use the form to enter values and then check the database to see if the values were added as
a new record in the table.
5. Zip the folder that contains the web site files (including the .php file) and upload the zipped folder
to the dropbox by the due date.
******** AddToMailList.php – add your code on to end of your existing <php> script ***********
$dbconnect = mysqli_connect("localhost", "root", "")
or die("Unable to connect to MySQL");
$selected = mysqli_select_db($dbconnect, "YOUR DATABASE")
or die("Could not open database");
$esc_fullname = mysqli_real_escape_string($dbconnect, $_POST['fullname']);
$esc_age = mysqli_real_escape_string($dbconnect, $_POST['age']);
$esc_email = mysqli_real_escape_string($dbconnect, $_POST['email']);
$esc_major = mysqli_real_escape_string($dbconnect, $_POST['major']);
$esc_degree = mysqli_real_escape_string($dbconnect, $_POST['degree']);
$sql="INSERT INTO YOUR TABLE VALUES ('$esc_fullname', '$esc_age', '$esc_email',
'$esc_major', '$esc_degree')";
mysqli_query($dbconnect, $sql);
mysqli_close($dbconnect);
?> //end of PHP block
</body>
</html>
__MACOSX/Requirements/._HW #11.pdf
Requirements/Requirements.txt
I need my website to correctly respond to a mail list joining submission that requires the AddtoMailList php file according to HW #10 & #11. Also, it needs to correspond to all of the following details in the Website Completion excel files.
__MACOSX/Requirements/._Requirements.txt
Requirements/WebsiteCompletionChecksheet.xlsx
Sheet1
| MIS 4760 | |
| Checklist for site completion | |
| YES/NO | HW #3 |
| 5 HTML files with required page layout elements (div container, header, nav, div left, div main, footer) | |
| 1 style sheet with required style rules for page layout elements | |
| meta tags for keywords, description and author on each HTML page in the <head> element | |
| Unique titles on each HTML page in the <title> element | |
| HW #4 | |
| color rules removed from style sheet | |
| placeholder text removed from HTML pages | |
| level 1 heading <h1> on each HTML page in <header> element | |
| minimum of 6 paragraphs in main div or left div | |
| minumum of 1 list in main div or left div | |
| minimum of 1 inline element in main div or left div | |
| element-based style rules for <p> and <h1> elements in style sheet | |
| HW #5 | |
| Text-based menu with functional links to all five html pages in the <footer> element | |
| One link to an external web page | |
| Five regular-size images and one thumbnail image in assets folder | |
| Functional links to images in html files | |
| Thumbnail image is a link to a larger image that opens In separate window | |
| HW #6 | |
| One table element such as a price list on any one page | |
| One table designed to be a menu in each page's <nav> element and links are functional | |
| IDs assigned to each table | |
| ID-based style rules for each <table> element and its <td> elements in stylesheet | |
| HW #7 | |
| A <form> element that contains at least one of each of these input elements and each element is assigned a unique ID and a name: | |
| text element | |
| tel element | |
| email element | |
| date element | |
| A set of radio buttons | |
| A set of check boxes | |
| A select element with options | |
| A “submit” and a “reset” button. | |
| <form id="mailList" action=" " method="post"> | |
| HW #8 | |
| functional jQuery validation code for at least three input elements | |
| HW #9 | |
| screen shot of XAMPP control panel | |
| HW #10 | |
| Functional PHP script that captures form field data and generates an HTML page using form field data. | |
| HW #11 | |
| Functional PHP code that opens a connection to a mySQL DB, writes YOUR form field values to the DB, closes the DB. |
