----------------------
TODO:
Optimization? Dynamic creation of objects?
*/
$project_id = (int) $_POST["id"];
$querytype = (int) $_POST["querytype"];
$operation = (int) $_POST["operation"];
include '../Login/db_connection.php';
//Check connection
if (mysqli_connect_errno($con)) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
} else {
mysqli_select_db($con, $db_name);
//Type 0 is used for echoing whole tables
if ($querytype == 0) {
echoResults($operation, $project_id, $con, "*", "1", "");
} else {
if ($querytype == 1) {
getProjectDataForCharts($project_id, $con);
}
}
}
/* Use this function for echoing results from a certain query */
/* json_encoding is used for creation of objects understandable by js */
function echoResults($operation, $project_id, $con, $scope, $where, $equal)
{
if ($operation == 0) {
echo json_encode(getWeeklyReports($project_id, $con, $scope, $where, $equal));
} else {
if ($operation == 1) {
echo json_encode(getProjects($project_id, $con, $scope, $where, $equal));
$first_initial = $matches[0];
} else {
$last = $name;
}
$select = sprintf("SELECT * FROM players WHERE first_name ='%s' and last_name='%s'", mysql_real_escape_string($first), mysql_real_escape_string($last));
$r1 = mysql_query($select);
if (mysql_num_rows($r1) == 0) {
$select = sprintf("SELECT * FROM players WHERE first_name like '%s' and last_name = '%s' limit 15", "%" . mysql_real_escape_string($first) . "%", mysql_real_escape_string($last) . "%");
$r2 = mysql_query($select);
if (mysql_num_rows($r2) == 0) {
$select = sprintf("SELECT * FROM players WHERE first_name like '%s' and last_name like '%s' limit 15", mysql_real_escape_string($first_initial) . "%", mysql_real_escape_string($last) . "%");
$r3 = mysql_query($select);
if (mysql_num_rows($r3) == 0) {
$select = sprintf("SELECT * FROM players WHERE last_name like '%s' limit 15", mysql_real_escape_string($last) . "%");
$r4 = mysql_query($select);
if (mysql_num_rows($r4) == 0) {
$select = sprintf("SELECT * FROM players WHERE last_name like '%s' limit 15", "%" . mysql_real_escape_string($last) . "%");
$r5 = mysql_query($select);
echoResults($r5);
} else {
echoResults($r4);
}
} else {
echoResults($r3);
}
} else {
echoResults($r2);
}
} else {
echoResults($r1);
}
