<?php include_once 'connect.php'; switch ($_GET["table"] || $_POST["table"]) { case "score": updateScore($_GET); break; case "personne": updatePersonne($_GET); break; case "document": updateDocument($_GET); break; case "personnesw2ui": updatePersonnesForW2UIGrid(); break; default: break; } function updateScore($data) { global $conn; $sql = "update scores set distance=" . $data["distance"] . ", maj = NOW() where id_scores =" . $data["id_score"]; //echo $sql; if ($conn->query($sql) === TRUE) { echo "score updated successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } } function updatePersonne($data)
function grabAnchors($hrefLinks, $main_site) { // grab the last id for this main site $query = 'SELECT max(link_id),link_id FROM scrapper WHERE main_site_id = ' . $hrefLinks['main_site_id']; $result = fetch_record($query); $id = intval($result['link_id']); // cURL the link and dump into the array the result $array = curlHREF($hrefLinks['ref_link']); sort($array); // $array is returned as sorted array. get the fist and last // index of the a-html-tag and start the loop from there // anything else can be ignored // get begin index $startpos = getStart($array); // get last index $endpos = getLast($array, $startpos); // if startpos = endpos, it would mean that the a-html-tag is not found properly // update the document and exit if ($startpos == $endpos) { updateDocument($hrefLinks); return; } // start parsing the a-html-tag for ($i = $startpos; $i <= $endpos; $i++) { // extract the href from the a-html-tag $href_a = getHREF($array[$i]); // check if link if to be excluded if (excludLink($href_a, $main_site) === false) { if (checkduplicate($href_a) === true) { $id = $id + 1; $query = "INSERT INTO scrapper (main_site_id, ref_link, link_id) VALUES ('" . $hrefLinks['main_site_id'] . "','" . $href_a . "','" . $id . "')"; // add the links run_mysql_query($query); } } } // update the document after the parsing of the a-html-tag updateDocument($hrefLinks); return; }