Solution Idea!
php file
CS301.php
<?php
$host = "localhost";
$user = "root";
$password = "";
$dbname = "bc12345";
// Create connection
$conn = mysqli_connect($host, $user, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO `sales` (`ID`, `Name`, `Region`, `Client_Name`, `Unit`, `Unit_Cost`, `Date`)
VALUES ('5', 'boll point', 'south', 'Jhon', '230', '120.99', '2020-01-12')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
<!DOCTYPE html>
<html>
<head>
<title>CS310 Assignment</title>
</head>
<body>
</body>
</html>