My thoughts, written down.

My final project for S75 = Ajax, PHP, javascript, XML, CSS, mySQL, HTML, Google and BART

Posted by signal on August 2nd, 2012

I am finally done with my Summer School class S-75 Building Dynamic Websites, taught by Professor David Malan. It was a very intense course. I liked how fast things moved and how we were challenged every single day. I already had a background in some of the technologies (PHP, HTML, mySQL) but had really no working knowledge in so much other stuff such as xPath, XML, CSS, Ajax, javascript, etc.

My final project was building a mashup between the BART (Bay Area Rapid Transit) using their API and the Google Maps v3 API. It was written in PHP, used mySQL as a datastore cache, and pulled realtime information from BART using Ajax. The program was written using the Model / View / Controller methodology and even version controlled via git using as a repository host.

I pretty much gave my soul to this class for the 7 weeks. I was even coding on my vacation :). However, I feel it was a good investment and I would do it again. If you ever have the opportunity to take any course from Professor Malan I highly recommend it. I am considering taking CS-50 possibly in Spring 2013 to fill in some of the gaps of my computer science background.

Below is a screenshot of my final project, where the Pitssburg/Bay Point – SFIA/Millbrae route has been selected. You can see stations plotted along a path that was drawn in the actual route color used by BART.

The user an click on the stations and it pulls realtime data from BART. Since it is using Ajax, there is no additional page load that happens and so the whole process is a very seamless user experience. It was one of those projects where when it starts off you wonder how you will make it happen in such a short period of time, but then you amaze yourself by pulling it off. Now that I know my way around the Google Maps API, and I have a reasonably good foundation in xPath/XML, I am on the hunt to find some other sites with GIS data, where I can build a mashup of something that does not yet exist, something with Big Data.

Below is another screenshot of what it looks like when the user clicks on a station and receives realtime data, this time on the Fremont – Daly City route (green).

3 Responses to “My final project for S75 = Ajax, PHP, javascript, XML, CSS, mySQL, HTML, Google and BART”

  1. Sam Says:


    This sounds interesting, would it be possible to share the code for learning purpose ?


  2. signal Says:


    I wish I could. Unfortunately it was done as an assignment for CS-75 and I cannot share the code, it would be like revealing the answers to an exam.


  3. Sam Says:

    Oh okay

    I am interested in learning and this project sounds interesting and would like see how and what was logic behind this project. If you are not comfortable, thats fine.


Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>