databases and poll scripts

I’ve been testing a simple poll script that has a few advantages. These include cookies that stop people from filling out the questionnaire twice, a pie chart that gives results immediately after filling the form out (which is linked to the Google API) and a simple form based admin process that means I can create a questionnaire in ten minutes.

I should have done this ages ago really but I’ve been trying to learn php properly for reasons I’ll cover in a minute. I thought I’d try this to see how it works. I’ve learned how to do a simple poll in php off my own back but the cookies and the instant results in this are appealing. Mind you, saying that, I’m not 100% sold on the cookie thing. it basically means that any given computer can only fill it out once, so groups of people can’t do it in the same place. Not what I want. I may be better off leaving the cookies alone, which leaves the whole thing open to poll stuffing. I admit this may be an experiential thing with learning about interactive art generally. One of those where I’ll do better next time.

One thing that’s frustrating me is the fact that I can’t connect to the humjam database. This is pissing me off, to say the least. I’ve connected to wordpress with no problems but for some reason the mysql connect script doesn’t work in this. I think it may be because the server give you a specially concocted connection script to use. If this is the case, why can I use wordpress, though?

The thing that bugs me about using plugins like this is the fact that it comes with lots of php attached, most of which I don’t fully understand. One consequence of this is that it’s really hard to modify. What can I move around without messing anything up? I know I can’t use the server’s own connection script which they provide because it uses slightly different connection conventions. The server’s own connection convention is annoying anyway. By many accounts the better way of connecting to MySQL is $mysqli, not $mysql_connect, which is what they give you. Nevermind. Anyway, this is why I want to learn php properly and not just use other people’s scripts all the time. It will serve me well in the long run, es pecially if I’m going to do more of these kinds of things on humjam in the future.

Will hopefully blog again later on another approach to this.

Category making humjam | Tags: ,

No Comments

You can follow any responses to this entry through the RSS 2.0 feed.

No Responses to “databases and poll scripts”

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>

By submitting a comment here you grant Hammerhead Rabbits a perpetual license to reproduce your words and name/web site in attribution. Inappropriate comments will be removed at admin's discretion.