Hi,

I am not able to add a new contact to the database (Lesson 22 Try it; ).
I am getting fail message -
"No Contact Record Added. Unable to create record." (file: includes/classes/contact.php

I have moved on to lesson 26 and I am able to edit the existing contacts. I am not sure about the problem with adding new contact. It seems that the code for query is not working.

Since, I have downloaded the files from wrox.com, I don't know where the error lies.

Have you tried doing a compare with your files and the ones you downloaded to see what differences you might have? Two other things you could try would be to either use the debuggger with a breakpoint just before the places that error can get set or to throw in some var_dump()'s of the variables there. That will let you see what's going on.

Thanks for the prompt response.

I am using the downloaded file and it is not working. I am running window 7 (64 bit) because of which my debugger is not working as expected. I cannot get breakpoints. I tried doing var_dump, but it is not reaching to that line. The var_dump is not being executed.


public function addRecord() {

// Verify the fields
if ($this->_verifyInput()) {

// Get the Database connection
$connection = Database::getConnection();

// Prepare the data
$query = "INSERT INTO contacts(first_name, last_name, position, email, phone)
VALUES ('" . Database::prep($this->first_name) . "',
'" . Database::prep($this->last_name) . "',
'" . Database::prep($this->position) . "',
'" . Database::prep($this->email) . "',
'" . Database::prep($this->phone) . "')";
// Run the MySQL statement

if ($connection->query($query)) {
$return = array('', 'Contact Record successfully added.');

// add success message
return $return;
} else {
// send fail message and return to contactmaint
$return = array('contactmaint', 'No Contact Record Added. Unable to create record.');
return $return;
}
} else {
// send fail message and return to contactmaint
$return = array('contactmaint', 'No Contact Record Added. Missing required information.');
return $return;
}

}

Since, I am getting the error listed in the nested if statement, I am assuming that the first IF statement <if ($this->_verifyInput())> is executed. However, var_dump() is not being executed within the IF statement.