$prep->bind_result($fromdb_visitor_uid_page_category_recommendation, $fromdb_visitor_uid_page_category_recommendation_count);
$prep->fetch();
$fromdb_affected_rows = $prep->num_rows;
$prep->close();
if ($fromdb_affected_rows > 0) {
$system_allgood = TRUE;
} else {
$system_allgood = FALSE;
}
}
// Prepare output
if ($system_allgood == TRUE) {
setResponseCode($response, 200);
if (isset($fromdb_visitor_ip_page_category_recommendation) && !empty($fromdb_visitor_ip_page_category_recommendation)) {
pushResponseData($response, 'site_log_v_ip_p_cat_recommendation', $fromdb_visitor_ip_page_category_recommendation);
}
if (isset($fromdb_visitor_uid_page_category_recommendation) && !empty($fromdb_visitor_uid_page_category_recommendation)) {
pushResponseData($response, 'site_log_v_uid_p_cat_recommendation', $fromdb_visitor_uid_page_category_recommendation);
}
} else {
setResponseCode($response, 400);
pushResponseError($response, 'No rows returned.');
}
} else {
setResponseCode($response, 400);
pushResponseError($response, 'No input was given.');
}
// Close the database connection
$db_con->close();
// Output response
outputResponse($response);
$todb_page_category = 1;
}
if (isset($page_url) && !empty($page_url)) {
$page_url = protocolRemoval($page_url);
$todb_page_url = $page_url;
} else {
$todb_page_url = NULL;
}
// Add data to the database
$prep = $db_con->prepare('INSERT INTO site_log (v_ip, v_ref, v_uid, p_cat, p_url) VALUES (?, ?, ?, ?, ?)');
$prep->bind_param('sssis', $todb_visitor_ip, $todb_visitor_refferer, $todb_visitor_unique_id, $todb_page_category, $todb_page_url);
$prep->execute();
$fromdb_affected_rows = $prep->affected_rows;
$fromdb_site_log_id = $db_con->insert_id;
$prep->close();
if ($fromdb_affected_rows > 0) {
setResponseCode($response, 200);
pushResponseData($response, 'site_log_id', $fromdb_site_log_id);
pushResponseData($response, 'site_log_v_ip', $todb_visitor_ip);
pushResponseData($response, 'site_log_v_ref', $todb_visitor_refferer);
pushResponseData($response, 'site_log_v_uid', $todb_visitor_unique_id);
pushResponseData($response, 'site_log_p_cat', $todb_page_category);
pushResponseData($response, 'site_log_p_url', $todb_page_url);
} else {
setResponseCode($response, 400);
pushResponseError($response, 'Something went wrong when the database was queried.');
}
// Close the database connection
$db_con->close();
// Output response
outputResponse($response);
