please solve part-1 question no-2,3. you may use SQL,javascript,html,css,php

please solve part-2 question no 2 and 3. u may use HTML, javascript,php,mysql,css

code:

Survey Form

First Name: Last Name:

Did you attend MAC270 as a faculty member, student, exhibitor or industry professional?

Faculty Member Student Exhibitor Industry Professional

Was this your first MAC270 Course? Yes:
No:

On a 10 point scale, how valuable were the following events? (i.e. 1=not valualble, 10=extremely valuable)

Exhibit Hall 1 2 3 4 5 6 7 8 9 10

Technology Demostration Room 1 2 3 4 5 6 7 8 9 10

Apple Hands-On Lab 1 2 3 4 5 6 7 8 9 10

Avid Hands-On Lab 1 2 3 4 5 6 7 8 9 10

MAC Festival of Media 1 2 3 4 5 6 7 8 9 10

Academic Panel Sessions 1 2 3 4 5 6 7 8 9 10

Competitive Paper Sessions 1 2 3 4 5 6 7 8 9 10

I would say that the MAC270 Convention live up to my expectations (1=strongly disagree, 2=disagree, 3=unsure, 4=agree, 5=strongly agree)

1 2 3 4 5

---------------

code-2:

MAC270 Survey Administration

ADD a New Respondent

SEARCH a New Respondent

Respondent by Category

Student Respondents

Faculty Respondents

Industry Respondents

Complete List of Respondents

$connection = mysqli_connect("localhost", "root", "Walter1", "vp");

/*if(!$connection){

die("Database Connection Failed" . mysqli_error($connection));

*/

echo "Order by ID |

Order by Last Name |

Order by First Name |

Order by Category |

Order by First MAC270? |

Order by Exhibits |

Order by TDR |

Order by Apple |

Order by Avid |

Order by Festival |

Order by Academic |

Order by Papers |

Order by Expectations

";

if(empty($_GET["order"])) $order = "lastname";

else $order = $_GET["order"];

$sql = "SELECT * FROM survey ";

$result = mysqli_query($connection,$sql)

or die(mysqli_error($connection));

While ($respondent = mysqli_fetch_array($result)) {

$id = $respondent["id"];

$firstname = $respondent["firstname"];

$lastname = $respondent["lastname"];

$category = $respondent["category"];

$first = $respondent["first"];

$exhibits = $respondent["exhibits"];

$tdr = $respondent["tdr"];

$apple = $respondent["apple"];

$avid = $respondent["avid"];

$festival = $respondent["festival"];

$academic = $respondent["academic"];

$papers = $respondent["papers"];

$expectations = $respondent["expectations"];

echo "

ID

Last Name

First Name

Category

First MAC270

Exhibits

TDR

Apple

Avid

Festival

Academic Panels

Competitive Papers

Expectations

";

echo "

$id"; echo "

$lastname"; echo "

$firstname"; echo "

$category"; echo "

$first"; echo "

$exhibits"; echo "

$tdr"; echo "

$apple"; echo "

$avid"; echo "

$festival"; echo "

$academic"; echo "

$papers"; echo "

$expectations"; echo "

";

}

?>

echo "Total Number of Respondents:

".mysqli_num_rows($result);

?>

-------------------

code-3

$connection = mysqli_connect("localhost", "root", "walter1", "projects");

if(!$connection){

die("Database Connection Failed" . mysqli_error($connection));

}

$result = mysqli_query($connection, "select * from survey");

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

While ($respondent = mysqli_fetch_array($result)) {

$firstname = $respondent["firstname"];

$lastname = $respondent["lastname"];

$category = $respondent["category"];

$first = $respondent["first"];

$exhibits = $respondent["exhibits"];

$tdr = $respondent["tdr"];

$apple = $respondent["apple"];

$avid = $respondent["avid"];

$festival = $respondent["festival"];

$academic = $respondent["academic"];

$papers = $respondent["papers"];

$expectations = $respondent["expectations"];

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

}

?>

Last Name	First Name	Category	First MAC270?	Exhibits	TDR	Apple	Avid	Festival	Academic Panels	Papers	Expectations
$lastname	$firstname	$category	$first	$exhibits	$tdr	$apple	$avid	$festival	$academic	$papers	$expectations

MAC270 Survey Administration ADD a New Respondent SEARCH a New Respondent Respondent by Category Student Respondents Faculty Respondents Complete List of Respondents Last Name First Name rst bits TDR Festival DLT Walter faculty I exhibitor 1 11 Edit Delete Total Number of Respondents: 2 Part I Create a css file(s) that will make the Survey Form, Retrieval Form, and the Search Forms professional looking for the users. Part l Create a Search Form to Search by category and any two option that you prefer Create edit link or edit button to update any field (you may need to update the last name or first name or change expectation from 5 to 1 Create delete link or delete button to delete a single record from the database from the administration page. MAC270 Survey Administration ADD a New Respondent SEARCH a New Respondent Respondent by Category Student Respondents Faculty Respondents Complete List of Respondents Last Name First Name rst bits TDR Festival DLT Walter faculty I exhibitor 1 11 Edit Delete Total Number of Respondents: 2 Part I Create a css file(s) that will make the Survey Form, Retrieval Form, and the Search Forms professional looking for the users. Part l Create a Search Form to Search by category and any two option that you prefer Create edit link or edit button to update any field (you may need to update the last name or first name or change expectation from 5 to 1 Create delete link or delete button to delete a single record from the database from the administration page