$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);