![\"PHP](\"https:\/\/www.diaryofanadi.co.uk\/wp-content\/uploads\/2011\/09\/php.gif\" "\\"PHP")
<\/p>\nI’ve been a bit quiet lately as far as blog posts go. The main reason for this is that I am trying to get the current theory test database on to my server, and so I am playing around with a lot of programming for various reasons (which keep changing).<\/p>\n
<\/p>\n
I’d initially started typing in the questions and answers from the question bank – reasoning that if I did a handful of questions each day then it would only take a few weeks to get them all in. But then I had trouble getting a suitable GUI for the MySQL database – one which didn’t involve a lot of clicking and which would allow me to repetitively enter question and answer text. So I wrote my own.<\/p>\n
I’d had a close look at the Driving Test Success DVD and couldn’t find the questions database or any readable files. But then, one of my pupils who has a Mac had had problems running the DSA disk, so she gave it to me and I got her a Mac-compatible one.<\/p>\n
The DSA disk has all the questions as XML files.<\/p>\n
So, at the moment I am writing a PHP utility to extract the data and convert it to a suitable file format that I’ll be able to import to a MySQL database.<\/p>\n","protected":false},"excerpt":{"rendered":"
I’ve been a bit quiet lately as far as blog posts go. The main reason for this is that I am trying to get the current theory test database on to my server, and so I am playing around with a lot of programming for various reasons (which keep changing). I’d initially started typing in […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[80,90],"tags":[],"class_list":["post-6890","post","type-post","status-publish","format-standard","hentry","category-adi-related","category-computer-tech-related"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/6890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6890"}],"version-history":[{"count":0,"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/6890\/revisions"}],"wp:attachment":[{"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diaryofanadi.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}