{"id":238,"date":"2026-06-19T07:25:09","date_gmt":"2026-06-19T14:25:09","guid":{"rendered":"https:\/\/choice.work\/?p=238"},"modified":"2026-06-19T07:25:09","modified_gmt":"2026-06-19T14:25:09","slug":"choice-log-no-1781878800-jon-ducketts-php-and-mysql","status":"publish","type":"post","link":"https:\/\/choice.work\/?p=238","title":{"rendered":"Choice log no. 1781878800 &#8211; Jon Duckett&#8217;s PHP and MySQL"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/choice.work\/wp-content\/uploads\/2026\/06\/JonDuckettPHPMySQL.webp?w=776&#038;ssl=1\" alt=\"JonDuckettPHPMySQL\" class=\"size-full wp-image aligncenter\" id=\"i-237\"><\/p>\n<style>\n.aright {\n    text-align: right;\n    }\n.aleft {\n    text-align: left;\n}\n.acenter {\n    text-align: center;\n}\n.bbottom { \n    border-bottom: 3px solid #ccc; \n    }\n.btop { \n    border-top: 3px solid #ccc; \n    }\n.headerfont {\n    font-size: 12px;\n}\n<\/style>\n<table border=\"0\">\n<tr>\n<td class=\"aleft\" colspan=\"4\">\n<h1>Table of Contents<\/h1>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\"><\/td>\n<td class=\"aleft\">Introduction<\/td>\n<td class=\"aright\">1<\/td>\n<\/tr>\n<tr>\n<th class=\"aleft bbottom\" colspan=\"3\">Section A Basic Programming Instructions<\/th>\n<th class=\"aright\">17<\/th>\n<\/tr>\n<tr>\n<th class=\"aleft\">Done<\/th>\n<th class=\"aleft\">Chapter<\/th>\n<th class=\"aleft\">Description<\/th>\n<th class=\"aright\">Page<\/th>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 1<\/td>\n<td class=\"aleft\">Variables, Expressions &amp; Operators<\/td>\n<td class=\"aright\">29<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 2<\/td>\n<td class=\"aleft\">Control Structures<\/td>\n<td class=\"aright\">67<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 3<\/td>\n<td class=\"aleft\">Functions<\/td>\n<td class=\"aright\">103<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 4<\/td>\n<td class=\"aleft\">Objects &amp; Classes<\/td>\n<td class=\"aright\">143<\/td>\n<\/tr>\n<tr>\n<th class=\"aleft bbottom\" colspan=\"3\">Section B Dynamic Web Pages<\/th>\n<th class=\"aright\">143<\/th>\n<\/tr>\n<tr>\n<th class=\"aleft\">Done<\/th>\n<th class=\"aleft\">Chapter<\/th>\n<th class=\"aleft\">Description<\/th>\n<th class=\"aright\">Page<\/th>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 5<\/td>\n<td class=\"aleft\">Built-In Functions<\/td>\n<td class=\"aright\">201<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 6<\/td>\n<td class=\"aleft\">Getting Data From Browsers<\/td>\n<td class=\"aright\">231<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 7<\/td>\n<td class=\"aleft\"> Images &amp; Files<\/td>\n<td class=\"aright\">285<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 8<\/td>\n<td class=\"aleft\">Dates &amp; Times<\/td>\n<td class=\"aright\">309<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 9<\/td>\n<td class=\"aleft\">Cookies &amp; Sessions<\/td>\n<td class=\"aright\">329<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 10<\/td>\n<td class=\"aleft\">Error Handling<\/td>\n<td class=\"aright\">349<\/td>\n<\/tr>\n<tr>\n<th class=\"aleft bbottom\" colspan=\"3\">Section C Database Driven Websites<\/th>\n<th class=\"aright\">381<\/th>\n<\/tr>\n<tr>\n<th class=\"aleft\">Done<\/th>\n<th class=\"aleft\">Chapter<\/th>\n<th class=\"aleft\">Description<\/th>\n<th class=\"aright\">Page<\/th>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 11<\/td>\n<td class=\"aleft\">Structured Query Language<\/td>\n<td class=\"aright\">397<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 12<\/td>\n<td class=\"aleft\">Get &amp; Show Data From a Database<\/td>\n<td class=\"aright\">433<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 13<\/td>\n<td class=\"aleft\">Updating Data in a Database<\/td>\n<td class=\"aright\">483<\/td>\n<\/tr>\n<tr>\n<th class=\"aleft bbottom\" colspan=\"3\">Section D Extending the Sample Application<\/th>\n<th class=\"aright\">521<\/th>\n<\/tr>\n<tr>\n<th class=\"aleft\">Done<\/th>\n<th class=\"aleft\">Chapter<\/th>\n<th class=\"aleft\">Description<\/th>\n<th class=\"aright\">Page<\/th>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 14<\/td>\n<td class=\"aleft\">Refactoring &amp; Dependency Injection<\/td>\n<td class=\"aright\">533<\/td>\n<\/tr>\n<tr>\n<\/tr><tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 15<\/td>\n<td class=\"aleft\">Namespaces &amp; Libraries<\/td>\n<td class=\"aright\">557<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 16<\/td>\n<td class=\"aleft\">Membership<\/td>\n<td class=\"aright\">603<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter\"><input type=\"checkbox\" name=\"done\" value=\"no\"><\/td>\n<td class=\"aleft\">Chapter 17<\/td>\n<td class=\"aleft\">Adding Functionality<\/td>\n<td class=\"aright\">633<\/td>\n<\/tr>\n<tr>\n<td class=\"aleft\" colspan=\"3\">Index<\/td>\n<td class=\"aright\">662<\/td>\n<\/tr>\n<tr>\n<td class=\"acenter btop\" colspan=\"4\">Code download: <a href=\"https:\/\/phpandmysql.com\/\" target=\"_blank\">https:\/\/phpandmysql.com<\/a><\/td>\n<\/tr>\n<\/table>\n<p>Start date: 06-19-2026<br>\nFinish date: <\/p>\n<p><a href=\"https:\/\/choice.work\/?tag=php\" class=\"tag\"><span class=\"tag-prefix\">#<\/span>php<\/a> <a href=\"https:\/\/choice.work\/?tag=mysql\" class=\"tag\"><span class=\"tag-prefix\">#<\/span>mysql<\/a> <a href=\"https:\/\/choice.work\/?tag=learn\" class=\"tag\"><span class=\"tag-prefix\">#<\/span>learn<\/a><\/p>\n<nav class='o2-post-footer-actions'><ul class='o2-post-footer-action-row'><li class='o2-post-footer-action'><a href=\"https:\/\/choice.work\/?p=238#respond\" title=\"Reply\"  class=\"o2-post-reply o2-reply genericon  genericon-reply\"  data-action=\"reply\"  data-actionstate=\"default\" >Reply<\/a><\/li><\/ul><div class='o2-post-footer-action-likes'><\/div><ul class='o2-post-footer-action-row'><\/ul><\/nav>","protected":false},"excerpt":{"rendered":"<p>Table of Contents Introduction 1 Section A Basic Programming Instructions 17 Done Chapter Description Page Chapter 1 Variables, Expressions &amp; Operators 29 Chapter 2 Control Structures 67 Chapter 3 Functions 103 Chapter 4 Objects &amp; Classes 143 Section B Dynamic Web Pages 143 Done Chapter Description Page Chapter 5 Built-In Functions 201 Chapter 6 Getting [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","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_post_was_ever_published":false},"categories":[1],"tags":[46,39,48,47],"class_list":["post-238","post","type-post","status-publish","format-standard","hentry","category-choice","tag-ccc","tag-learn","tag-mysql","tag-php","author-choice"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/choice.work\/index.php?rest_route=\/wp\/v2\/posts\/238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/choice.work\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/choice.work\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/choice.work\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/choice.work\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=238"}],"version-history":[{"count":1,"href":"https:\/\/choice.work\/index.php?rest_route=\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/choice.work\/index.php?rest_route=\/wp\/v2\/posts\/238\/revisions\/239"}],"wp:attachment":[{"href":"https:\/\/choice.work\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/choice.work\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/choice.work\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}