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