Projects tagged ‘mysql’, ‘php’, and ‘rubyonrails’

php mysql query like Ror; example： $db->where_value=1; $a=$db->find_by('id'); $a array: array(1_field=>array(0=>value,1=>value),2_field=>array(0=>value,1=>value));

For my master thesis research on duck migration I created a set of scripts to process and visualize the data. Ducks are captured, given a ring and then released. Days or years later the duck is found ... [More] again and reported. Information such as age, cause of death, geographical location is added. Note: I moved the source code to Github, but other information will remain here. Many countries keep a database with many different bird species that were ringed in their country. My research focussed on ducks ringed in the Netherlands. Because the data is stored according to the international EURING standard, this software can - with some modifications - in principle be used for all bird species in all countries that use the EURING standard or something similar. The original EURING data is imported from a fixed-width text format into a MySQL database. Several Ruby on Rails migrations (some executing other SQL & PHP scripts) convert this data into a relational database, perform consistency checks and mix it with some other data. Finally, the Rails program visualizes the data. I deviate from the EURING standard in several ways which I believe are necessary. For example I strictly adhere to the ISO 3166 standard of country (subdivision) codes (using e.g. geonames.org for the conversion) and use decimal coordinates of latitude and longitude. More information is available on the Wiki. You can download the source code and visit a demonstration website. The data is not (always) freely available, but there is a small example dataset and I will provide information on how to obtain more. The wiki also provides several MySQL queries that I used for my research. After I graduate I may not have a lot of time for further development, but I will be available to answer questions and suggest ideas. [Less]

Laivsys is a web-based management tool for live role-playing games, handling multiple laivs, applications, rolesheets, e-mailing participants, groups, files, and more. Everything is in Norwegian and ... [More] tailored for a specific laiv group at the moment, but a more general approach is planned. The project has a first version based off PHP+MySql, which is poorly coded & poorly documented but functional. The next generation (laivsys2) will be based on Ruby on Rails. [Less]