Getting this error:
ERROR: Hush! Sorry INSERT INTO Tennis_DB.Coach (membership, firstname, lastname, adress, phonenumber, email) VALUES ('','First','Last,'adress','number','email' '']; ). You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'adress','number','email' '']; )' at line 1
Here is my code:
<!DOCTYPE html>
<html>
<head>
<title>Insert Page</title>
</head>
<body>
<center>
<?php
$conn = mysqli_connect("127.0.0.1:3306","root","Farming123", "Tennis_DB");
if($conn === false){
die("ERROR: Yell at Miss Chileshe or Malachi. "
. mysqli_connect_error());
}
$membershipid = $_REQUEST['membershipid'];
$firstname = $_REQUEST['firstname'];
$lastname = $_REQUEST['lastname'];
$address = $_REQUEST['address'];
$phonenumber = $_REQUEST['phonenumber'];
$email = $_REQUEST['email'];
$sql = "INSERT INTO Tennis_DB.Coach (membership, firstname, lastname, adress, phonenumber, email) VALUES ('$membershipid','$firstname','$lastname,'$address','$phonenumber','$email' '']; )";
if(mysqli_query($conn, $sql)){
echo "<h3>Data stored sucsessfully."
. " Saved to swimming MYSQL "
. " to view the updated data</h3>";
echo nl2br("\n$membershipid\n$firstname\n$lastname\n$address\n$phonenumber\n$email");
} else{
echo "ERROR: Hush! Sorry $sql. "
. mysqli_error($conn);
}
mysqli_close($conn);
?>
</center>
</body>
</html>
What I have tried:
I have tried troubleshooting myself but I am new so... No luck.