Web development

What To Do ... Think of some 3-tier Web app (UI, server-side scripts, database) you would like to create. See the Project Examples page on the course website to help you get some ideas. Apply concepts and techniques from this course to design it. Use PHP and MySQL to implement it. A MySQL database called username_project has been created for you on the class web server. You can create tables, and populate data into the database for your Project. How to Turn in Your Project Upload your project to the class Web Server www.smccs85.com. Use folder "project" to submit your work. It should work with the MySQL Server running on www.smccs85.com. When is the project due? The project is due on the last day of the course, Sunday 12/10/17 by 11:59 pm. The Database for Your Project A database called username_project has been created on the MySQL database server on [login to view URL] for you to use for your project as follows: Your account has been granted all privileges on all tables in this database. You can create and populate tables for your project in this database. Your table names should use your last and first name as a prefix. For example, $query = "CREATE TABLE bigelow_john_users (userID int NOT NULL AUTO_INCREMENT,... )"; Accessing the MySQL Server Command Line Follow the instructions at [login to view URL] to access the MySQL Command Line on the class Web Server www.smccs85.com. Note: You can not create a database. A Database has been created for you for this project. Use the SQL command "show database;" to view which databases you have access to. Accessing the MySQL Server via PHP Please see the MySQL Basics page for information about using the MySQL Command Line. For access to the MySQL server on the class web server you will need to use a PHP script. For an example of how to connect to the MySQL Database Server and send a query, see the code below. The following is an example of a script for creating a table in the user data on the [login to view URL] MySQL Database Server on [login to view URL]: <?php //connect to the MySQL server as the user and select the username_project database $conn = mysqli_connect("localhost", "username", "password","username_project") or die(mysqli_error()); // query the database $result = mysqli_query($conn, 'DROP TABLE IF EXISTS tolkien_john_elves') or die(mysqli_error()); //create another query $query = 'CREATE TABLE tolkien_john_elves (id int NOT NULL AUTO_INCREMENT PRIMARY KEY)'; // send the query $result = mysqli_query($conn, $query) or die(mysqli_error()); // give user warm and fuzzy feeling echo 'All queries ran successfully.'; ?>