{"id":4291,"date":"2009-02-24T19:53:11","date_gmt":"2009-02-25T00:53:11","guid":{"rendered":"http:\/\/klishis.com\/notreally\/?p=4291"},"modified":"2009-02-24T19:54:42","modified_gmt":"2009-02-25T00:54:42","slug":"still-writing","status":"publish","type":"post","link":"https:\/\/klishis.com\/notreally\/archives\/4291","title":{"rendered":"Still Writing!"},"content":{"rendered":"<p>But still not, like, fiction writing.<\/p>\n<blockquote><p>\n\/\/ function to add\/update reviews<\/p>\n<p>function update_reviews($book_ID, $Review)<br \/>\n\t{<br \/>\n\t$query_review = &#8220;UPDATE books<br \/>\n\t\tSET Review = &#8216;$Review&#8217;, Status = &#8216;$Status&#8217;<br \/>\n\t\tWHERE book_ID = &#8216;$book_ID'&#8221;;<br \/>\n\t$result_review = mysql_query($query_review);<br \/>\n\t}<\/p>\n<p>\/\/ create the query to add the review web address<\/p>\n<p>$a = 1;<br \/>\nWHILE ($a <= $r)\n\t{\n\t$book_ID = $_POST['book_ID'.$a];\n\t$Review = $_POST['Review'.$a];\n\t$Status = $_POST['Status'.$a];\n\t$Review_updated = update_reviews($book_ID, $Review, $Status);\n\t$a++;\n\t}\n\t\n$a = $a - 1;<\/p><\/blockquote>\n<p>Of course after two days of fighting with it, Michael fixed my concatenation: <strong>$book_ID = $_POST[&#8216;book_ID&#8217;.$a];<\/strong>. I tried everything under the sun but that.<\/p>\n<p>However, it all works now, which is all that&#8217;s important.<\/p>\n<p>And of course this is all for the back end\/management of my <a href=\"http:\/\/klishis.com\/Books\/library\/search.php\">book database<\/a>. You all don&#8217;t get to play around in the back end&#8211;no offense, but I don&#8217;t need anyone else adding or editing books. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>But still not, like, fiction writing. \/\/ function to add\/update reviews function update_reviews($book_ID, $Review) { $query_review = &#8220;UPDATE books SET Review = &#8216;$Review&#8217;, Status = &#8216;$Status&#8217; WHERE book_ID = &#8216;$book_ID&#8217;&#8221;; $result_review = mysql_query($query_review); } \/\/ create the query to add the review web address $a = 1; WHILE ($a<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":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},"jetpack_post_was_ever_published":false},"categories":[17],"tags":[451,405],"class_list":["post-4291","post","type-post","status-publish","format-standard","hentry","category-computers-technology","tag-book-database","tag-february-writing-challenge"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pefxA-17d","_links":{"self":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/posts\/4291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/comments?post=4291"}],"version-history":[{"count":0,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/posts\/4291\/revisions"}],"wp:attachment":[{"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/media?parent=4291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/categories?post=4291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/klishis.com\/notreally\/wp-json\/wp\/v2\/tags?post=4291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}