Comments (13)
Current db results table is named vcd_results
(index.php
line 79).
Based on this section, it looks like each respondent is recorded as a single row (ID by IP address REMOTE_ADDR
), with three columns per phase. These three columns record the xcoordinate, ycoordinate, and response time of the respondent.
Columns referenced now:
result_host
result_date
Option 1:
Continue with this schema, and create a table in the database for each study (group of phases/scenes) with fields based on settings.json
. This format is probably easier for RAs to analyze unless it is rewritten before download. This also means that the number of columns has to be hardcoded into index.php
unless this section is changed.
Option 2:
Rebuild the schema as EVA so that a study can be modified by changing settings.json
and without needing to run a db install script.
from changeblindness.
Fatal error: Call to a member function bind_param() on a non-object in /home/mattbkco/public_html/_projects/change/index.php on line 80
http://php.net/manual/en/mysqli-stmt.bind-param.php
I think this is because the table and columns don't exist.
from changeblindness.
from changeblindness.
That's better, now we get Could not execute query
.
from changeblindness.
Got it to work in https://github.com/mattbk/changeblindnesstest/commit/839e7fe17f1d6b706a7b8b0015b3e95a55409257 (added the mysql error to die()
), but phase names are still hardcoded.
from changeblindness.
First column of the database must be a generated UID.
from changeblindness.
First column of the database must be a generated UID.
That's exactly what it is (or, it works when you make it as such).
from changeblindness.
I know more. The way it is set up, the phase name needs to be in the field name as well.
_host
_date
_xcoordinate
_ycoordinate
_responsetime
are used in the code to pass to Twig.
from changeblindness.
Adding all of this to an install script would probably be easier than going an EVA route right now.
Then if you run another study in the future, you specify a different table name and can use the same database. Would be best to install in a different folder with a different settings.json
, though.
Should work for now, except for all the hardcoded phase names!
from changeblindness.
Hardcoded phase/scene names are only a problem in the part in index.php where they are written to db.
Since $_SESSION['results'] is a 2d array, can I use a nested foreach to build the insert query?
from changeblindness.
$_SESSION['results'['scene1'] is not built right. Should be $_SESSION['results'['phase1']. Scene1 is a value, not a key. Hmm.
from changeblindness.
I had result_host and result_date swapped in table. Fixed now.
from changeblindness.
Still needs to be done; does NOT need settings.json to be completed first.
Still need to do this first: #2
from changeblindness.
Related Issues (20)
- Generalize phase names HOT 1
- Check responses and record whether right or wrong HOT 3
- Set timezone so results are useful HOT 1
- Update ReadMe
- Select table in settings.json so you can run multiple studies in the same database
- CSV entries for target zone settings rather than settings.json HOT 4
- Link to results HOT 1
- Image duration in settings.json
- Large images don't show up on small screens HOT 3
- Large images load slowly HOT 4
- "Step 16 of 3" HOT 1
- Results table should sort by datetime and participant ID, then by phase name
- Image extension in settings.json
- Retry button broken
- Need to clear session at start HOT 1
- Clicks between images don't work as well HOT 3
- Recreate in Python/Flask, including standalone app
- Twig license HOT 1
- Clean up URLs HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from changeblindness.