I tried catch if do CRUD in foreach loop, if success loop finish push message into array, below is my function, I push message after foreach is it correct?
// .. defined response_message array
try {
foreach ($data as $i => $each_data) {
$sql = "UPDATE tag_0 SET sequence = :sequence WHERE id = :id";
$stmt = $connect_db_read->prepare($sql);
$stmt->bindValue(':id', $each_data['id']);
$stmt->bindValue(':sequence', $each_data['sequence']);
$stmt->execute();
}
// here
$success_message = 'success_message: store in database success';
array_push($response_message['success_message'], $success_message);
} catch (PDOException $e) {
$debug_message = $e->getMessage();
array_push($response_message['debug_message'], $debug_message);
$error_message = "error_message: ? database";
array_push($response_message['error_message'], $error_message);
}
$data = array();
$data['response_message'] = $response_message;
return $data;