Example #1
0
function retrievePointsList()
{
    global $requestResult;
    $Connection = mysqli_connect(ServerName, UserName, Password, DBName);
    if (mysqli_connect_errno()) {
        $errText = "DataBase connection failed: " . mysqli_connect_error();
        $requestResult[error] = true;
        $requestResult[errorText] = $errText;
        return;
    }
    $TblName = PointsTableName;
    $Request = " SELECT * FROM {$TblName} ";
    $result = mysqli_query($Connection, $Request);
    if ($result) {
        $requestResult[data] = parceQueryResult($result);
        $requestResult[points] = true;
    } else {
        $errText = "Query error: " . mysqli_error($Connection);
        $requestResult[error] = true;
        $requestResult[errorText] = $errText;
        $requestResult[queryText] = $Request;
    }
    //mysql_close($Connection);
    mysqli_close($Connection);
}
Example #2
0
function getRoutesArray()
{
    global $requestResult;
    $result = false;
    $Connection = mysqli_connect(ServerName, UserName, Password, DBName);
    if (mysqli_connect_errno()) {
        $errText = "DataBase connection failed: " . mysqli_connect_error();
        $requestResult[error] = true;
        $requestResult[errorText] = $errText;
        return;
    }
    $relationsTbl = RelationsTableName;
    $Request = "SELECT StartPointID, EndPointID, Distance, TimeValue FROM {$relationsTbl} ";
    $queryResult = mysqli_query($Connection, $Request);
    if ($queryResult) {
        $result = parceQueryResult($queryResult);
    } else {
        $errText = "Query error: " . mysqli_error($Connection);
        $requestResult[error] = true;
        $requestResult[errorText] = $errText;
    }
    mysqli_close($Connection);
    return $result;
}