---------------------- 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); }