Добавить новость
smi24.net
Все новости
Апрель
2015

Написать два запроса на SQL и XQuery

0
1) PHP + SQL Database: https://www.sendspace.com/file/0959zj

A web page is required that shows the average number of bikes available at TFL bike stations at a particular time of day as a proportion of the station capacity. The page connects to the online tflBikes database and generates HTML content in real time using PHP and MySQL. It must contain a table with rows representing each station that is within a square cell of a particular size that is centred on the focus station. Each row of the table must show four items of data from left to right in this order:
  1. the average number of bikes available at the specified time of day;
  2. this number as a percentage of station capacity;
  3. the station name;
  4. the postcode.
... within a square cell with sides of length 1050m that is centered on the bike station at Emperor's Gate, South Kensington over a 11 hour period commencing at 6am. 

В базе указаны не метры, а широта и долгота!

2) XML  db: https://www.sendspace.com/file/u70mw5

The HTML that is generated must contain a list of all stations that have
  1. the same number of bikes currently docked, and
  2. at least as many empty docks as Emperor's Gate, South Kensington.














Музыкальные новости






















СМИ24.net — правдивые новости, непрерывно 24/7 на русском языке с ежеминутным обновлением *