I had partial success with my mapping project this weekend. I had originally planned to map each state with little popup boxes showing details on the numbers for each state. It turns out that I greatly underestimated both my skills with JSON files and the Google APIv3 for maps. But let me back up. I…
Tag: clio3
Getting Ready to Map
I started the evening ready to tutorialize myself in Google APIs and mapping examples. I read two paragraphs and realized that I’d better do some prep work on my own data before I continue. I also realized that I can organize myself better if I set some goals for my coding work. I have one…
Averting Distraction and Thinking Ahead
Sometimes you aren’t as productive as you’d like to be. Fred warned us that this class might do that, so I’m taking it as part of the territory. This week I ignored the urge to scrap my entire site and rebuild it using the fancy new tools in my toolkit. I admit that redesigning websites…
Getting Answers from Your Data
My assignment this week was was to run the queries I “designed” last week. (*I am, of course, using the term “design” very loosely, as last week was full of hand wringing and general PHP consternation.) This week, I ran 4 total queries. I am pretty happy with how they turned out: Total numbers of…
Asking Questions of Your Data
Now that my data is normalized and I have a good idea of what is contained in my database, it’s time to start asking questions of my data. What do I want to know? Which queries are only for me? Which would I like to embed into a web page? While they don’t seem like…
PHP Tango
Oh PHP. How you vex me. Our assignment this week was to play with PHP, specifically to create a working data entry form using HTML, PHP and MySQL. I can report that, with very generous help from my Clio class, I did all of that. My simple, but working form is here. My simple, but functional…