function getMarks($username, $ch)
{
curl_setopt($ch, CURLOPT_URL, 'http://evarsity.srmuniv.ac.in/srmswi/resource/StudentDetailsResources.jsp?resourceid=6');
$content = curl_exec($ch);
$html = str_get_html($content);
$trs = $html->find('tr[align=left]');
array_shift($trs);
$final_values = "";
$gpas = "";
$cgpa = "";
$sem = "";
foreach ($trs as $tr) {
$tds = $tr->find('TD');
$final_values .= "('" . $username . "'";
if (count($tds) == 7) {
$sem = trim($tds[1]->plaintext);
foreach ($tds as $td) {
$final_values .= ",'" . trim($td->plaintext) . "'";
}
$final_values .= ")";
}
}
$trs = $html->find('tr');
$sem = 1;
foreach ($trs as $tr) {
$tds = $tr->find('TD');
if (count($tds) == 2) {
if (trim($tds[0]->plaintext) == "CGPA") {
$cgpa = "('" . $username . "','" . trim($tds[1]->plaintext) . "')";
} else {
if (trim($tds[0]->plaintext) == "SGPA") {
$gpas .= "('" . $username . "','" . $sem . "','" . trim($tds[1]->plaintext) . "')";
$sem = $sem + 1;
}
}
}
}
$final_values = str_replace(")(", "),(", $final_values);
$gpas = str_replace(")(", "),(", $gpas);
$cgpa = str_replace(")(", "),(", $cgpa);
storeDatabase("marks", $final_values);
storeDatabase('cgpa', $cgpa);
storeDatabase('gpa', $gpas);
echo str_replace("'", '"', '{"scores":[' . str_replace('(', '[', str_replace(')', ']', $final_values)) . '], "cgpa":' . str_replace('(', '[', str_replace(')', ']', $cgpa)) . ', "gpa":' . str_replace('(', '[', str_replace(')', ']', $gpas)) . '}');
}
<?php
if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_GET["name"]) && isset($_GET["gameid"]) && isset($_GET["uuid"])) {
$name = $_GET["name"];
$gameid = $_GET["gameid"];
$uuid = $_GET["uuid"];
$leader = isset($_GET["newgame"]);
storeDatabase($uuid, $name, $gameid);
} else {
echo "Error: Invalid request.";
}
function storeDatabase($uuid, $name, $gameid)
{
$servername = "localhost";
$username = "******";
$password = "";
$dbname = "mafia";
try {
$conn = new PDO("mysql:host={$servername};dbname={$dbname}", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO mafia (uuid, name, gameid, role, status) VALUES ('{$uuid}', '{$name}', '{$gameid}', -1, 0)";
$conn->exec($sql);
} catch (PDOException $e) {
//echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
}
?>
<!DOCTYPE HTML>
<html>
