Creating the Customer table & Items Table
CREATE TABLE Items
(
ItemId int(10),
Items varchar(255)
);


CREATE TABLE Customer
(
CustomerID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255)
);
Inserting data into the Customer Table


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (1, 'Facer', 'Braxton', 'Hello Street')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (2, 'Jones', 'Sediq', 'Tim Street, TimTam')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (3, 'Peter', 'John', 'The World')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (4, 'Minutes', 'One', 'Maths room, New York')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (5, 'Helow', 'Den', '9 Martin street, heaven')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (6, 'Fr', ‘Sik', ‘Martin Morning')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (7, 'Jo', 'Pail', 'Box Street')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (8, 'Tim', 'Jon', 'My House')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (9, 'Seven', 'Minutes', 'DownTown')


INSERT INTO Customer (CustomerID, LastName, FirstName, Address)
VALUES (10, 'Hel', 'Nik', 'Some Street')


Inserting data into Items Table
INSERT INTO Items (ItemId, Items)
VALUES (1, ‘Fruit’)


INSERT INTO Items (ItemId, Items)
VALUES (2,  ‘Banana’)


INSERT INTO Items (ItemId, Items)
VALUES (3,  ‘Skirt’)


INSERT INTO Items (ItemId, Items)
VALUES (4,  ‘Undies’)


INSERT INTO Items (ItemId, Items)
VALUES (5,  ‘Bag’)


INSERT INTO Items (ItemId, Items)
VALUES (6,  ‘Hat’)


INSERT INTO Items (ItemId, Items)
VALUES (7,  ‘Leggings’)


INSERT INTO Items (ItemId, Items)
VALUES (8,  ‘Xbox’)


INSERT INTO Items (ItemId, Items)
VALUES (9,  ‘Mouse’)


INSERT INTO Items (ItemId, Items)
VALUES (10,  ‘Keyboard’)


Updating the values in the Customer Table


UPDATE Customer
SET CustomerID = 20
WHERE CustomerID = 1


UPDATE Customer
SET LastName = ‘Jones'
WHERE LastName = ‘JimsonJones’


UPDATE Items
SET ItemId = 2
WHERE ItemId = 4
Deleting Values


DELETE FROM Customer
WHERE CustomerID = 4


DELETE FROM Items
WHERE ItemId = 6


Selecting values from table


SELECT CustomerID
FROM Customer


SELECT ItemId
FROM ItemId


SELECT Address
FROM Customer




PHP
Connecting to local host, error checking connection, searching my company database for LastName and FirstName in the Customer table using the select query, Deleting CustomerID value 3, updating the customer table and setting the CustomerID value 20 to 3, inserting itemId and items into the items table.


<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myCompany";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


//Select query


$sql = "SELECT id, FirstName, LastName FROM Customer";
$result = $conn->query($sql);


if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["FirstName"]. " " . $row["LastName"]. "<br>";
	}
} else {
    echo "0 results";
}


//Delete query


$sql = "DELETE FROM CustomerID WHERE id=3";


if ($conn->query($sql) === TRUE) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . $conn->error;
}


//Update query


$sql = "UPDATE Customer SET CustomerID = 20 WHERE CustomerID = 1";


if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}


//Insert into


$sql = "INSERT INTO Items (ItemId, Items)
VALUES (1, ‘Fruit’)”;


if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>