{"id":20,"date":"2004-11-08T19:10:25","date_gmt":"2004-11-09T00:10:25","guid":{"rendered":"http:\/\/www.simplykaren.org\/wordpress\/?p=20"},"modified":"2004-11-08T19:11:28","modified_gmt":"2004-11-09T00:11:28","slug":"programming-update","status":"publish","type":"post","link":"https:\/\/simplykaren.org\/wordpress\/2004\/11\/08\/programming-update\/","title":{"rendered":"Programming Update"},"content":{"rendered":"<p>I&#8217;ve been actively using the database for a paper I have to write as well as just general data entry for resources I&#8217;ve had marked for ages just waiting for the creation of this database.  It seems the best way to troubleshoot and think about what else I would like it to be able to do.  Here&#8217;s a brief list:<\/p>\n<ul>\n<li>Add an institution field for the authors: and speaking of institution, it really should be a separate table where I can pick off a list so the data entry is consistent for the field.  There is an institution field in the resource table as well and I could use the same table.<\/li>\n<li>Continue to add fields to the resource update field (editbook.php).  I added pull-down menus for periodicals and types.  I based them on the checkboxes for keywords and authors but in this case, it&#8217;s a one-to-one relationship.  It took a little while to get the lists to appear and then to get them to show the correct periodical and type.  I&#8217;ve solved all that but the continuing problem is that when you&#8217;re in the edit screen, the first periodical and publisher appear and when you press submit, their id numbers get written to the resource table.  I could solve it through the database but creating a row called &#8220;None Selected&#8221; and choose that each time I enter a new resource but I wonder if there&#8217;s a way to do it with the code?  I tried echoing &#8220;None Selected&#8221; when there was no id match but then the pull-down menu just displayed that instead of the periodicals and types.  I&#8217;m wondering if I can write an if\/else statement that says that if no match exists then the list should display &#8220;None Selected&#8221; but also providing all the choices.  <\/li>\n<li>quotequery.php passes the id of the resource but is directed to the edit quotes page so the wrong quote appears.  In the quotequery.php page, the edit\/delete\/add choices functions refer to the resource.  <\/li>\n<li>Create a Views page that includes the various queries I&#8217;ve developed.  And I need to continue to hone my formatting skills by incoporating html code and php echo statements.<\/li>\n<\/ul>\n<p>There&#8217;s plenty more but that&#8217;s a good start&#8230;I&#8217;m going to watch Part II of The Fellowship of the Ring tonight and do some coding and then data entry.<\/p>\n<p>Things I&#8217;ve Learned:<\/p>\n<p>Choosing the right data storage type is important.  I choose smallint for my quotespage field only to discover that it goes to 127.  So, when I started entering page numbers that were larger than that, they defaulted to 127.<\/p>\n<p>There are lots of other formatting issues.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been actively using the database for a paper I have to write as well as just general data entry for resources I&#8217;ve had marked for ages just waiting for the creation of this database. It seems the best way to troubleshoot and think about what else I would like \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/simplykaren.org\/wordpress\/2004\/11\/08\/programming-update\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p31UVs-k","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/posts\/20"}],"collection":[{"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/comments?post=20"}],"version-history":[{"count":0,"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/posts\/20\/revisions"}],"wp:attachment":[{"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/media?parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/categories?post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/simplykaren.org\/wordpress\/wp-json\/wp\/v2\/tags?post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}