public static function itexmo_less($number, $message)
{
$config = new Config();
$url = 'https://www.itexmo.com/php_api/api.php';
$itexmo = array('1' => $number, '2' => $message, '3' => $config->sms_api_code);
$param = array('http' => array('header' => "Content-type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'content' => http_build_query($itexmo)));
$context = stream_context_create($param);
$result = file_get_contents($url, false, $context);
$response = $config->sms_response($result);
return print_r(json_encode(array('number' => $result, 'response' => $response)));
}
public function getQuizResults()
{
$config = new Config();
$mysqli = new mysqli($config->host, $config->user, $config->pass, $config->db);
if ($mysqli->connect_errno) {
return print json_encode(array('success' => false, 'status' => 400, 'msg' => "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error));
die;
} else {
$data = array();
$data1 = array();
$data2 = array();
$studid = $_SESSION['entrance_student']['studid'];
$mobileno = $_SESSION['entrance_student']['mobileno'];
$totalScore = 0;
$coverage = 0;
$message = 'EXAM Results :' . "\r\n";
$query = "SELECT c.`name`,r.* FROM result r INNER JOIN category c ON r.category_id = c.id WHERE r.stud_id='{$studid}';";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
$total = $row['score'] / $row['total'];
$p = $total * 100;
$totalScore += $row['score'];
$coverage += $row['total'];
$row['percent'] = number_format($p, 2) . '%';
array_push($data, $row);
// $message .= '* '.$row['name'].' - '. $row['score'].'/'.$row['total'] . "\r\n";
}
$message .= 'TOTAL SCORE: ' . $totalScore . '/' . $coverage . "\r\n";
$query1 = "SELECT C.id as course_id,C.coursecode,C.coursename FROM student S, courses C WHERE (SELECT SUM(score) FROM result WHERE stud_id=S.studid) >= C.passing_score AND S.studid='{$studid}';";
$result1 = $mysqli->query($query1);
while ($row1 = $result1->fetch_array(MYSQLI_ASSOC)) {
array_push($data1, $row1);
array_push($data2, $row1['coursecode']);
}
$message .= 'COURSE SUGGESTIONS: [' . implode(", ", $data2) . "]\r\n";
$url = 'https://www.itexmo.com/php_api/api.php';
$itexmo = array('1' => $mobileno, '2' => $message, '3' => $config->sms_api_code);
$param = array('http' => array('header' => "Content-type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'content' => http_build_query($itexmo)));
$context = stream_context_create($param);
$result = file_get_contents($url, false, $context);
$response = $config->sms_response($result);
print json_encode(array('success' => true, 'status' => 200, 'results' => $data, 'suggest_course' => $data1, 'message_status' => $response), JSON_PRETTY_PRINT);
// print json_encode(array('success' =>true,'status'=>200,'results' =>$data),JSON_PRETTY_PRINT);
}
}
public function updateAccount($id, $data)
{
$config = new Config();
$mysqli = new mysqli($config->host, $config->user, $config->pass, $config->db);
if ($mysqli->connect_errno) {
print json_encode(array('success' => false, 'msg' => "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error));
return;
} else {
$username = $mysqli->real_escape_string($data['username']);
$password = $mysqli->real_escape_string($data['password']);
$newid = explode('-', $id);
if ($stmt = $mysqli->prepare('UPDATE userdata SET username=?,password=?,str_password=? WHERE id=?')) {
$stmt->bind_param("ssss", $username, sha1($password), $password, $newid[1]);
$stmt->execute();
$query1 = "SELECT u.id,u.username,u.email,u.mobileno,u.fname,u.lname,u.level,s.studid FROM userdata u LEFT JOIN student s ON u.id = s.user_id WHERE u.id = {$id};";
$result = $mysqli->query($query1);
if ($result) {
if ($row = $result->fetch_assoc()) {
/*** set the session user_id variable ***/
if (isset($_SESSION['entrance_student'])) {
$_SESSION['entrance_student'] = $row;
}
$message = 'Hello there! You have successfully changed your password. Your New App Password: '******' .';
$url = 'https://www.itexmo.com/php_api/api.php';
$itexmo = array('1' => $row['mobileno'], '2' => $message, '3' => $config->sms_api_code);
$param = array('http' => array('header' => "Content-type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'content' => http_build_query($itexmo)));
$context = stream_context_create($param);
$result = file_get_contents($url, false, $context);
$response = $config->sms_response($result);
}
}
print json_encode(array('success' => true, 'msg' => 'User Account successfully updated'), JSON_PRETTY_PRINT);
} else {
print json_encode(array('success' => false, 'msg' => "Error message: %s\n" . $mysqli->error), JSON_PRETTY_PRINT);
}
}
}
