I need some help with this PHP code?

S

Sam

New member
I need to add a contact into the DB, but when you enter the information in, it doesn't add. I have no errors and cannot find the problem. Can someone help?

<?php
session_start();
if ( (isset($_SESSION['loggedIn'])) &&
($_SESSION['loggedIn'] == true) ){
if(isset($_GET['lname']) && isset($_GET['fname'])&& isset($_GET['address'])&& isset($_GET['city'])&& isset($_GET['state'])&& isset($_GET['zip'])&& isset($_GET['phnum'])){
$lname = $_GET['lname'];
$fname = $_GET['fname'];
$address = $_GET['address'];
$city = $_GET['city'];
$state = $_GET['state'];
$zip = $_GET['zip'];
$phnum = $_GET['phnum'];
$query = "INSERT INTO contacts (FirstName, LastName, City, State, Zip, AreaCode_PhoneNumber)";
$query .= " VALUES ('$fname',";
$query .= "'$lname',";
$query .= "'$address'),";
$query .= "'$city'),";
$query .= "'$state'),";
$query .= "'$zip'),";
$query .= "'$phnum')";
$db = mysqli_connect("localhost","root", "","warner_it250");
$result = mysqli_query($db, $query);
//close
mysqli_close($db);
//test result, if 0 then not inserted
echo "Contact Added";
}

else
echo "Please fill in all text fields";
}//end if logged in
else// unauthorized person, not logged in
header('Location:login.htm');
?>
 
Back
Top