Show the scholarships available for the Spring of 2016

 Display the scholarship id, the name of the organization, and the scholarship amount for scholarships available for the Spring of 2016 when the page loads

 Order the results by the amount of the scholarship in descending order (highest amounts first), and by the organization in ascending order (a-z)

 Show the number of scholarships available on the page

 Display the results in a visually attractive layout web page using the HTML and CSS of your choice and make sure that the view/source looks good

Objectives:

 Connect to a MySQL database from the web page

 Display data on the web page from a table using an SQL query

Procedure:

 You will use the “scholarships” table from the college database (provided if you need it)

 You use the host – localhost (or use your own values)

 You will use the user name – root (or use your own values)

 You will have no password (or use your own values)

 You will construct the correct SQL query (develop and test your SQL in phpMyAdmin first)

 You will use either the mysqli object oriented extension or PDO

 You will create the code to connect to the database, execute the SQL query, and display the results in the web page using PHP

 You will place the connection information in an “include” statement and reference it appropriately

 

1CIS 219 Final Project - Instructor Teresa PelkieCIS 219 Final Project – 100 pointsAssignment:Show the scholarships available for the Spring of 2016Display the scholarship id, the name of the organization, and the scholarship amount forscholarships available for the Spring of 2016 when the page loadsOrder the results by the amount of the scholarship in descending order (highestamounts first), and by the organization in ascending order (a-z)Show the number of scholarships available on the pageDisplay the results in a visually attractive layout web page using the HTML and CSS ofyour choice and make sure that the view/source looks goodObjectives:Connect to a MySQL database from the web pageDisplay data on the web page from a table using an SQL queryProcedure:You will use the“scholarships”table from thecollegedatabase (provided if you need it)You use the host –localhost(or use your own values)You will use the user name –root(or use your own values)You will haveno password(or use your own values)You will construct the correctSQLquery (develop and test your SQL in phpMyAdmin first)You will use either themysqliobject oriented extension orPDOYou will create the code to connect to the database, execute the SQL query, and display the results in the webpage using PHPYou will place the connection information in an “include” statement and reference it appropriatelyHow to submit the AssignmentYou will submit the.phpfiles and any other needed files (CSS, images, etc)You will use this format for the file name:firstname-lastname-final-project.php(unless you use a web host, then use your own file names and send me the URL and the code)You will name your include fileconnect.phpor something similar

11 Scholarships Available for Spring 2016Scholarship IDOrganization Offering ScholarshipScholarship AmountS12MKL Memorial Scholoarship$1,000.00S01Chancellor's Scholarship$800.00S06Academic Senate Scholorship$750.00S18Kaiser Permanente Medical Scholarship$750.00S11Asian Pacific Islander American StudiesScholarshi$600.00S02Classified Senate Scholarship$600.00S15Board of Trustees Scholarship$500.00S08Chemical Engineers Association$500.00S03San Diego Business Council Award$500.00S10San Diego County Veterinary Medicine$500.00S21San Diego Track Club$300.00The below form is optional for extra creditChoose a semesterChoose a yearsubmit

- phpMyAdmin SQL Dump-- version 4.5.1-- http://www.phpmyadmin.net---- Host: 127.0.0.1-- Generation Time: Nov 22, 2016 at 02:22 AM-- Server version: 10.1.13-MariaDB-- PHP Version: 5.6.21SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */;---- Database: `college`---- ------------------------------------------------------------ Table structure for table `scholarships`--CREATE TABLE `scholarships` (`scholarship_id` varchar(10) NOT NULL,`organization` varchar(50) NOT NULL,`amount` decimal(7,2) UNSIGNED NOT NULL,`semester` enum('Fall','Spring') NOT NULL,`year` year(4) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `scholarships`--INSERT INTO `scholarships` (`scholarship_id`, `organization`, `amount`,`semester`, `year`) VALUES('S01', 'Chancellor''s Scholarship', '800.00', 'Spring', 2016),('S02', 'Classified Senate Scholarship', '600.00', 'Spring', 2016),('S03', 'San Diego Business Council Award', '500.00', 'Spring', 2016),('S04', 'California State Business Council Award', '300.00', 'Fall', 2015),('S05', 'Honor SocietyAward', '500.00', 'Fall', 2015),('S06', 'Academic Senate Scholorship', '750.00', 'Spring', 2016),('S07', 'Alfonso Perez Memorial Scholarship', '1000.00', 'Fall', 2015),('S08', 'Chemical EngineersAssociation', '500.00', 'Spring', 2016),('S09', 'Allen Rogert Memorial Scholarship', '1000.00', 'Fall', 2015),('S10', 'San Diego County Veterinary Medicine', '500.00', 'Spring', 2016),('S11', 'Asian Pacific Islander American Studies Scholarshi', '600.00','Spring', 2016),('S12', 'MKL Memorial Scholoarship', '1000.00', 'Spring', 2016),('S13', 'California Coast Credit Union', '500.00', 'Fall', 2015),('S14', 'Associated Students Leadership Award', '750.00', 'Fall', 2015),('S15', 'Board of Trustees Scholarship', '500.00', 'Spring', 2016),('S16', 'Iranian-American Scholarship', '800.00', 'Fall', 2015),('S17', 'President''s Award for Academic Excellence', '750.00', 'Fall', 2015),('S18', 'Kaiser Permanente Medical Scholarship', '750.00', 'Spring', 2016),('S19', 'Languages Department Scholarship', '250.00', 'Fall', 2015),('S20', 'Veterans Award'