Greetings! Digital Center friends,

It has been a while since my last blog released. So, I’m desperate to share you some of my latest progress.

Along with my ongoing project of Agency Catalog Database, I was getting myself familiarized with JavaScript, java, JDBC and SQL by creating a website, the major functions of which including searching restaurants around Columbia community, creating account, writing reviews, making reservations and voting for your favorite dishes. So, it’s pretty much like Yelp, since it includes all 267 restaurants within a 3-mile radius of Columbia University, you can call it a ‘Columbia Yelp’ as you like.

This is the index page, where you can search restaurants mainly through 4 approaches. You can search by typing the name of restaurants (partial name also works if you can’t remember the full name), you can search by specifying the categories of food you’d like, ‘Italian’ for example, and you can search by neighborhood (most of them are centered on Morningside Heights and Harlem). If you remain blank, the default search will be made on the map, where you can zoom up the Google map and locate the restaurants directly.

There is a login/sign up icon on the right top corner of the screen, you can use it to login or create an account. Notably, you can still search restaurants without login, but you can’t play with other functions like writing reviews, making reservations and voting without login first.

 

Now let’s have a brief view on the searching results, the following results come from the searching keyword ‘Italian’.

The result page will show you how many restaurants it could find based on the keywords and the basic information of these restaurants, including ratings, number of reviews, neighborhood, address and photos.

When you click one of the results, it will lead you to the restaurant homepage where you can view more information (Menus & Deals of the week & Comments from previous users) as well as functions available, including making reservations, voting for your favorite dishes and writing reviews. You can see from the picture below, my first user, Jeremiah just made a comment on this restaurant and rated it with 2 stars, haha…

 

I will show you more details of these functions in my next blog.  The dataset are imported from Yelp Dataset Challenge with certain constraints I created to narrow down searching scope in my database.

More information will come with my next blog soon!