Web development

Cerrado Publicado hace 6 años Pagado a la entrega
Cerrado Pagado a la entrega

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.';

?>

Instalación de blogs Diseño gráfico PHP Diseño de sitios web

Nº del proyecto: #15852738

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 6 años

3 freelancers están ofertando un promedio de $27 por este trabajo

Majidsayyed

Hello, I am experienced and professional Web Developer. I am a Codeigniter, WordPress and Php expert having extensive experience 5+ years. Complete team to manage entire project. Thanks Majid.

$25 USD en 1 día
(8 comentarios)
4.6
arshthewriter

HI, I am enthusiastically writing in response to your advertisement for the position of a Web Designer/developer. I have 5 years of functional experience in development. I am highly skilled with Wordpress/PhP/CorePhP/ Más

$30 USD en 1 día
(45 comentarios)
4.5