02.11.08
Posted in MySQL, PHP at 1:33 pm by bwalker
As I was meddling with registrant_list_demo.php I found that the demographics were not showing up for any of my test cases. I was under the mistaken impression this data was obtained from an external server, but it is actually taken from a data dump from the nces stored on our server in a database called ‘demographics’ (go figure). The demographics data appears to be sorted by zip code. I am surmising that this data dump is requested from nces after the registration process is complete and an updated list of zip codes has been generated.
I’m sure Mr. Sweeney can provide details of this request procedure upon his return. The demographics script is working fine, but the demographics data is most likely out if date. Cari indicated the demographics data will not be needed for a few weeks.
Permalink
Posted in MySQL, PHP at 1:23 pm by bwalker
When I first opened up the register dir I found register.php, review.php and review.v1.php. Based on script and notes in the script the registration and review registration processes were consolidatedby Mr. Sweeney in register.php, but perhaps at one point they were separate. review.php and review.v1.php turned out to be the registrant listing scripts.
This names were confusing so I renamed them to registrant_list.php and registrant_list_demo.php (demographics).
I added a filter (by year) to limit output results. However it is not technically filtering by year. There was already a date limit written into the existing query (2007-04-27, I think) which I used as the start range marker for 2007. The start range for 2008 is 2008-01-01. The messy part is that everything prior to 2007-04-27 is marked as 2006 in the filter when in fact the records only go back to 2007-04-17. I expect to be working on this script again in the near future (see “Updates to field test registrant_list_demo”) at which point I will probably change the filter to just ‘Prior’.
Permalink
Posted in PHP at 1:03 pm by bwalker
Mostly minor or content changes, not worth mentioning.
Cari did have some concerns about the distribution of assigned topics so I disabled the array_rand() method of topic selection and wrote a function that tallies current registrant topic assignments and selects which ever is least.
Permalink
10.29.07
Posted in PHP, Web Development at 3:22 pm by BrianS
We’ve been helping with the development of the PRISMS resource review utility and public interface.
Our most recent task was to find a way to provide access to the data in an exchange format compatible with the NSDL. To do this we were looking for a PHP-based OAI provider that could interface with our MySQL database. We found a capable application in the work of Heinrich Stamerjohanns. He has put together a set of PHP scripts which provides exactly the kind of functionality we needed.
Read the rest of this entry »
Permalink
08.15.07
Posted in PHP, Web Development at 6:49 pm by BrianS
The items utility has had a nasty habit of timing out users after a relatively short amount of time. In the past I tried extending the cookie timeout, but that didn’t really seem to help. The problem has been troublesome because it seems to happen almost randomly.
A little web research has led me to another conclusion as to the source of the problem: session data garbage collection.
Read the rest of this entry »
Permalink
Next entries »