no database?

[Scott-Wood]

umm what happened to the database?

[JMV2112]

I'm not sure. I've been working from a separate branch and still have a database. We need to have a skype meeting because things are changing. I'm going to remake the whole database because Dan did a terrible job making it and we're going to have a database set up on Anthony's private server that will have an API so we can update the database accordingly. But like I said there should still be a database in there because on my branch it shows it. Here's Tony's number (314)-805-0127, text him and let him know who you are and ask him about your problems.

[Scott-Wood]

Alright I'll check again. Sorry about the radio silence. I'll be working on the filters over the next week.

On Dec 29, 2013, at 11:12 PM, "Josh" notifications@github.com<mailto:notifications@github.com> wrote:

I'm not sure. I've been working from a separate branch and still have a database. We need to have a skype meeting because things are changing. I'm going to remake the whole database because Dan did a terrible job making it and we're going to have a database set up on Anthony's private server that will have an API so we can update the database accordingly. But like I said there should still be a database in there because on my branch it shows it. Here's Tony's number (314)-805-0127, text him and let him know who you are and ask him about your problems.

— Reply to this email directly or view it on GitHubhttps://github.com/forsythetony/CollegeComparison/issues/7#issuecomment-31333777.

[JMV2112]

Have you worked with databases before scott?

[Scott-Wood]

I took database so I've used Postgres but not SQL

On Jan 1, 2014, at 12:17 PM, "Josh" notifications@github.com<mailto:notifications@github.com> wrote:

Have you worked with databases before scott?

— Reply to this email directly or view it on GitHubhttps://github.com/forsythetony/CollegeComparison/issues/7#issuecomment-31427212.

[JMV2112]

It's the same but with some syntax differences. I worked on the filters page some with setting variables so we can take those variables and apply them to a query that will be ran based upon all filters. I'm on vacation but when I get back to my room I'll merge my branch to the master branch so you can make make a branch from the master with my changes.

[forsythetony]

Here's the API if you want to use it http://54.201.179.180/api/api.php?method=getCollege&range=all This will return an array of JSON objects or if you just want one college then you can set the range to the ID of that college like so http://54.201.179.180/api/api.php?method=getCollege&range=100654 which would return the following:

[{
    "id":"100654",
    "name":"Alabama A & M   University",
    "state":"AL",
    "out_state_tuition":"11184",
    "in_state_tuition":"5592",
    "enrollment_total":"1033",
    "enrollment_men":"520",
    "enrollment_women":"513",
    "sat_reading_25":"370",
    "sat_reading_75":"455",
    "sat_math_25":"370",
    "sat_math_75":"460",
    "sat_writing_25":"0",
    "sat_writing_75":"0",
    "act_25":"16",
    "act_75":"19",
    "act_english_25":"14",
    "act_english_75":"19",
    "act_math_25":"15",
    "act_math_75":"18",
    "act_writing_25":"0",
    "act_writing_75":"0"
}]

[forsythetony]

Also if you have any trouble with it or want me to add some feature just let me know.