Alex Lord
asked on
pdo insert not working and going st8 to ajax error.
Insert into pdo table not working and no error.
Ok so what this code is doing and suppose to do. I am checking to see if a record exists first and this part works as expected if record exist goto else if not then create a record.
Now the record is created with two ID which is stored in a session they seem fine. now im not sure if the last one is the issue as i tried hard coding and same response but the field chk_name is populated by the forach which gets it details from ajax post array which looks like this -
the problem is when it gets to the INSERT it doenst add and the ajax response is not successful with not errors. so im lost on what is the issue.
$stmt = new Database();
//check to make sure there is a record to update
$query = "SELECT chk_name FROM a_test WHERE charityID = :clientID AND contactID = :contactId";
$stmt->query( $query );
$stmt->bind( ':clientID', $clientId);
$stmt->bind( ':contactId', $contactId );
$stmt->execute();
$result = $stmt->all();
if($result == null){
foreach($_POST['chkStateCollection'] as $chkState) {
$stmt = new Database();
//Inserting check state.
$query = "INSERT INTO a_test (charityID, contactID, chk_name) VALUES (:clientId, :contactId :chkName) ";
$stmt->query( $query );
$stmt->bind( ':clientId', $clientId );
$stmt->bind( ':contactId', $contactId );
$stmt->bind( ':chkName', $chkState );
$stmt->execute();
$result = $stmt->all();
}
} else {
$testreply = "no rows detected";
}
Ok so what this code is doing and suppose to do. I am checking to see if a record exists first and this part works as expected if record exist goto else if not then create a record.
Now the record is created with two ID which is stored in a session they seem fine. now im not sure if the last one is the issue as i tried hard coding and same response but the field chk_name is populated by the forach which gets it details from ajax post array which looks like this -
(2) ["POSTITION", "FIRST_NAME"]
the problem is when it gets to the INSERT it doenst add and the ajax response is not successful with not errors. so im lost on what is the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.