// convert the number $original_number = $number["phonenumber"]; if ($original_number[0] == '0') { $number = substr($original_number, 1); $original_number = "+91" . $number; } else { if ($original_number[0] == '+') { // do nothing every thing is fine } else { $original_number = "+91" . $original_number; } } $query_string = "SELECT * FROM login WHERE id = '{$original_number}'"; $result = $db->query_db($query_string); if ($db->number_of_rows($result) > 0) { $row = $db->fetch_array($result); // If number["phonenumber"] is found in the login table... // Check if it is already added or not... $query_string2 = "SELECT * FROM family WHERE family_id = '{$original_number}'\n\t\t\t\t\t\t\t\t && member_id = '{$id}'"; $result2 = $db->query_db($query_string2); if ($db->number_of_rows($result2) > 0) { } else { $query_string3 = "INSERT INTO family(member_id,family_id) VALUES('{$id}','{$original_number}')"; $result3 = $db->query_db($query_string3); } } } $queryString = "SELECT * FROM family,login WHERE member_id = '{$id}' && id = family_id"; $result = $db->query_db($queryString); $addednumbers = array(); if ($db->number_of_rows($result) > 0) {
require_once '../includes/db_connect.php'; require_once '../includes/functions.php'; require_once '../includes/session.php'; confirm_logged_in(); $db = new DB_CONNECT(); // get username from the session $username = get_username(); //select all test created by him from test table if (isset($_GET["message"])) { $message = "The Test has been deleted."; } $query = "SELECT test_name,start_time,end_time,event_date,duration FROM test WHERE username='******'"; $admin_tests = $db->query_database($query); if ($db->number_of_rows($admin_tests) > 0) { $i = 1; while ($row = $db->fetch_array($admin_tests)) { $table_data = array(); $table_data_array[$i] = array(); $table_data["test_name"] = $row["test_name"]; $table_data["start_time"] = $row["start_time"]; $table_data["end_time"] = $row["end_time"]; $table_data["event_date"] = $row["event_date"]; $table_data["duration"] = $row["duration"]; $table_data_array[$i] = $table_data; $i++; } $no_of_rows = $i - 1; $table_data_array["number_of_rows"] = $no_of_rows; $table_html = make_test_information_table(); } else { //echo " No tables created by admin";
<?php require_once "includes/db_connect.php"; require_once "includes/functions.php"; $response = array(); $db = new DB_CONNECT(); if (isset($_POST["id"]) && isset($_POST["phonenumber"])) { $id = $_POST["id"]; $number = $_POST["phonenumber"]; $query = "SELECT * FROM family WHERE member_id = '{$number}' && family_id = '{$id}'"; $result = $db->query_db($query); if ($db->number_of_rows($result) > 0) { $row = $db->fetch_array($result); $permission = $row["permission_given"]; if ($permission == 1) { // now get the position of the specified user $query1 = "SELECT * FROM login where id = '{$number}'"; $result1 = $db->query_db($query1); if ($db->number_of_rows($result1) > 0) { $row = $db->fetch_array($result1); $response["success"] = 1; $response["latitude"] = $row["latitude"]; $response["longitude"] = $row["longitude"]; $response["message"] = "You can access his location"; } } else { // permission is 0 $response["success"] = 0; $response["message"] = "The user has not provied the accces to its location"; } } else {
} else { redirect_to("question_list.php?test_name=" . get_test_name()); } } else { echo "empty fields"; } } else { echo "Someting was not set"; } } else { $db = new DB_CONNECT(); $query = "SELECT * FROM test WHERE test_name='" . get_test_name() . "' AND username='******' "; $details = $db->query_database($query); if ($db->number_of_rows($details) > 0) { $i = 1; $row = $db->fetch_array($details); $table_data = array(); $table_data["test_name"] = $row["test_name"]; $table_data["start_time"] = $row["start_time"]; $table_data["end_time"] = $row["end_time"]; $table_data["event_date"] = $row["event_date"]; $table_data["duration"] = $row["duration"]; } } ?> <!DOCTYPE html> <html> <head> <title> Test Details</title> <meta charset="UTF-8">
<?php require_once '../includes/db_connect.php'; require_once '../includes/functions.php'; require_once '../includes/session.php'; confirm_logged_in(); $db = new DB_CONNECT(); // get username from the session $username = get_username(); $test_name = urldecode($_GET['test_name']); //select all test created by him from test table $query = "SELECT * FROM " . $test_name . "_users"; $users_table = $db->query_database($query); if ($db->number_of_rows($users_table) > 0) { $i = 1; while ($row = $db->fetch_array($users_table)) { $table_data = array(); $table_data_array[$i] = array(); $table_data["first_name"] = $row["first_name"]; $table_data["last_name"] = $row["last_name"]; $table_data["email"] = $row["email"]; $table_data["phone_number"] = $row["phone_number"]; $table_data["score"] = $row["score"]; $table_data["questions_attempted"] = $row["questions_attempted"]; $table_data["correct_ans"] = $row["correct_ans"]; $table_data["wrong_ans"] = $row["wrong_ans"]; $table_data_array[$i] = $table_data; $i++; } $no_of_rows = $i - 1; $table_data_array["number_of_rows"] = $no_of_rows;