Objectives

Students will be able to:

  • use PHP to place the results of an SQL query onto a webpage

Full Stack Web Developer

They can design the Front End of the webpage/site - this is what the user sees when a webpage is downloaded from a web server. Technologies such as:

  • HTML
  • CSS
  • Javascript

are required to be a Front-End Developer.

They can also design the Back End of the webpage/site. This is what the user doesn't see. This is where calculations happen, database tasks are completed, passwords are processed.

Back-End Developers need skills in server-side technologies such as:

  • SQL
  • PHP
  • Node.js
  • Python
  • Java

So, Full Stack Developers have both Front-End and Back-End skills! They can do everything.

As you can imagine, they are saught after!

Address

460-0026

Aichi

Nagoya

Naka Ward

2-17-13

CRUD

 

CREATE

Let's look at how to CREATE a new record using form data and insert it into a database.

Note, we don't need a webpage to create a new record, we just need SQL.

But what if I don't understand SQL? Or I don't have access to a server?

A webpage with a form is useful for anyone who wants to interact with a database.

Project Assets

In htdocs find your social data folder.

You should already have assets from the previous unit. Download the latest asset and store it in your folder.

Video Task

Follow the video.

Worksheet

Complete the worksheet.

C.R.U.D.

essential vocabulary

database querycriteriaimport evidence table integer screenshot record text ascending field double descending data type Yes/No

SUBSCRIBE

Join my mailing list to receive updates on the latest blog posts and other things.