$curl = curl_init($url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $a = curl_exec($curl); curl_close($curl); $json = json_decode($a); $var = $json->List; $session_id = $var[0]->PHPSESSID; if (isset($_POST['keuze'])) { if ($_POST['keuze'] == 'Uitslagen') { $data = Apicall($baseUrl, "/competities/{$teamid}/{$district}/{$compId}/{$classId}/{$pouleId}/results", $session_id, $apikey, "?weeknummer=46"); $json = json_decode($data, true); } elseif ($_POST['keuze'] == 'Programma') { $data = Apicall($baseUrl, "/teams/{$teamid}/schedule", $session_id, $apikey, "?weeknummer=A"); $json = json_decode($data, true); } elseif ($_POST['keuze'] == 'Stand') { $data = Apicall($baseUrl, "/teams/{$teamid}/ranking", $session_id, $apikey, "?"); $json = json_decode($data, true); } } function Apicall($baseUrl, $url, $session_id, $apikey, $parameters) { #hash berekenen $hash = md5($apikey . '#' . $url . '#' . $session_id); $curl_url = $baseUrl . $url . $parameters . "&PHPSESSID=" . $session_id . '&hash=' . $hash; $curl = curl_init(); curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $curl_url, CURLOPT_USERAGENT => 'cURL Request pw', CURLOPT_COOKIESESSION => true)); // echo $curl_url.'<br>'; $resp = curl_exec($curl); curl_close($curl); return $resp; }
ini_set('display_errors', 1); error_reporting(E_ALL); $apikey = 'mFD3py75GaAJkOc'; $baseUrl = 'http://api.knvbdataservice.nl/api'; $url = $baseUrl . '/initialisatie/pw'; $curl = curl_init($url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $a = curl_exec($curl); curl_close($curl); $json = json_decode($a); $var = $json->List; $session_id = $var[0]->PHPSESSID; echo '<pre>'; // $data = Apicall($baseUrl,"/competities/166209/OO/0212/14/419817/results",$session_id,$apikey,"?");$json = json_decode($data);var_dump($json); $data = Apicall($baseUrl, "/competities/166209/OO/0212/14/419817/schedule", $session_id, $apikey, "?"); $json = json_decode($data, true); function Apicall($baseUrl, $url, $session_id, $apikey, $parameters) { #hash berekenen $hash = md5($apikey . '#' . $url . '#' . $session_id); $curl_url = $baseUrl . $url . $parameters . "&PHPSESSID=" . $session_id . '&hash=' . $hash; $curl = curl_init(); curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $curl_url, CURLOPT_USERAGENT => 'cURL Request pw', CURLOPT_COOKIESESSION => true)); echo $curl_url . '<br>'; $resp = curl_exec($curl); curl_close($curl); return $resp; ?> <div class="container"> <div class="row">
public static function setUrl($params) { $team = $_POST['team']; $com = $_POST['competitie']; // Als er geen selectie gemaakt wordt dan gebruik default de R vn Regulier if ($com == "0") { $com = "R"; } else { $com = $_POST['competitie']; } $keuze = $_POST['keuze']; // $pw = $_POST['PW']; $week = date("W"); $num = $week; $nummineen = $week - 1; //Value of POST $team = $_POST['team']; // get database connection $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // Select the appropriate data $query->select($db->quoteName(array('id', 'Teamid', 'District', 'CompId', 'ClassId', 'PouleId', 'CompName'))); $query->from($db->quoteName('#__knvb_api_team')); $query->where($db->quoteName('id') . " = " . $db->quote($team)); // Reset the query using our newly populated query object. $db->setQuery($query); // De database execute is tbv van de regelstellen $results = $db->loadObjectList(); // Put restults in Vars if (empty($results)) { echo ""; } else { foreach ($results as $row) { $teamid = $row->Teamid; $district = $row->District; $compId = $row->CompId; $classId = $row->ClassId; $pouleId = $row->PouleId; $compname = $row->CompName; } } $apikey = $params->get('apikey'); $baseUrl = $params->get('dataserviceurl'); $vereniging = $params->get('vereniging'); $url = $baseUrl . '/initialisatie/' . $vereniging; $curl = curl_init($url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $a = curl_exec($curl); curl_close($curl); $json = json_decode($a); $var = $json->List; $session_id = $var[0]->PHPSESSID; function Apicall($baseUrl, $url, $session_id, $apikey, $parameters) { #hash berekenen $hash = md5($apikey . '#' . $url . '#' . $session_id); $curl_url = $baseUrl . $url . $parameters . "&PHPSESSID=" . $session_id . '&hash=' . $hash; $curl = curl_init(); curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $curl_url, CURLOPT_USERAGENT => 'cURL Request pw', CURLOPT_COOKIESESSION => true)); // echo $curl_url.'<br>'; $resp = curl_exec($curl); curl_close($curl); return $resp; } if (isset($_POST['keuze'])) { if ($_POST['keuze'] == 'Uitslagen') { $data = Apicall($baseUrl, "/competities/{$teamid}/{$district}/{$compId}/{$classId}/{$pouleId}/results", $session_id, $apikey, "?weeknummer=" . $nummineen); $json = json_decode($data, true); } elseif ($_POST['keuze'] == 'Programma') { $data = Apicall($baseUrl, "/teams/{$teamid}/schedule", $session_id, $apikey, "?weeknummer=A&comptype=" . $com); $json = json_decode($data, true); } elseif ($_POST['keuze'] == 'Stand') { $data = Apicall($baseUrl, "/teams/{$teamid}/ranking", $session_id, $apikey, "?"); $json = json_decode($data, true); } elseif ($_POST['keuze'] == 'PW') { $data = Apicall($baseUrl, "/wedstrijden", $session_id, $apikey, "?weeknummer=" . $num); $json = json_decode($data, true); } return $json; } }