Posts by Category : Database

Omeka for the Programming Historian 1

If you are like me and your research involves a lot of primary sources that have not already been gathered into a database, Omeka brought to you from the kind people at George Mason’s Center for History and New Media might seem like a viable option. As it states on their website, “Omeka is a free, flexible, and open source web-publishing platform for the display of library, museum, archives, and scholarly collections and exhibitions.” But before you begin to use Omeka to house your database Read More

What do you look for in an advanced search? 0

As I've been going through and entering my cartoons into my database I've been thinking about how I eventually want to interact with it but more importantly, I've been thinking about how a user would want to interact with it. A major goal of this work is that I want to make my database available to the public. The reason I'm building this is because it doesn't exist anywhere else and it seems silly to me to keep it to myself, and while I can access the back end and interact with it via PHPmyAdmin, Read More

If it ain’t broke, don’t fix it 0

I don't have too much to report this week. My work at the CHNM took a bit of precidence over Clio as we just launched our new issue of the Journal of Digital Humanities today and my job is to create the iBook. This is a pretty involved process but it's really fun. It was also a nice break from coding as it's very visual and design orientated so it gave the other side of my brain a chance to play a bit. But I did manage to get quite a bit done on my form before I had to switch gears and brains. I Read More

Populating Multi-Select Boxes From Your DB Using an All-in-One PHP Form 5

*Author's note: this post has been updated and rewritten as of Nov. 8 based on comments in the comment section. So you have a database that you want to enter information into via a form and you want the form to have a multi-select box that both gets populated from your database and will have the associated data to an entry pre-populated when you edit an entry. It would look something like this in new entry mode: and something like this in 'Edit' mode: This tutorial is designed to teach you three Read More

When You Need to do More than Just Tag: Controlled Vocabulary and Metadata 3

As I'm approaching finishing building my form for my Clio3 project, I'm starting to think ahead to what I need to do when I actually begin using my form to input my meta data. I have four "categories" of meta information beyond the basic cartoon date, caption and artist information. These categories are: character, events, keywords and themes. The first two are relatively easy and straight-forward. Was Uncle Sam depicted in a particular cartoon or not? Was this cartoon referencing the 1960 Election, Read More

Arrays, Foreach, & Explode…Oh My! 1

So since the other cool kids in my class are blogging their progress I thought maybe I should do the same. I figure it would also be a good way to track what I've done, what I have left to do and keep track of some of the places where I found my code. Up until last week I've felt very behind the rest of my classmates. While they were already playing with data sets that already existed (and this does not mean they had it easier than me as Jeri's post can attest to) I had to first figure out how to Read More