{"id":1303,"date":"2021-04-20T19:45:55","date_gmt":"2021-04-20T19:45:55","guid":{"rendered":"https:\/\/www.antpace.com\/blog\/?p=1303"},"modified":"2025-08-25T17:49:55","modified_gmt":"2025-08-25T17:49:55","slug":"radio-button-value-checked-from-a-database-in-php","status":"publish","type":"post","link":"https:\/\/www.antpace.com\/blog\/radio-button-value-checked-from-a-database-in-php\/","title":{"rendered":"Radio Button Value Checked from a Database in PHP"},"content":{"rendered":"<p>When building software user interfaces, I create HTML forms to manage any app settings. I&#8217;ll usually have a few text and radio inputs like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1305 size-full\" src=\"https:\/\/www.antpace.com\/blog\/wp-content\/uploads\/2021\/09\/form-settings.png\" alt=\"settings input form\" width=\"815\" height=\"738\" \/><\/p>\n<p>Using PHP, I grab a database record and access its properties to populate the form. Filling out the text inputs is straight-forward:<\/p>\n<pre>&lt;?php $clickToCallRecord = $db_service-&gt;getClickToCallRecord($installation_complete_id); ?&gt;\n\n&lt;div class=\"form-group\"&gt;\n    &lt;label&gt;Phone number:&lt;\/label&gt;\n    &lt;input class=\"form-control\" type=\"tel\" name=\"phone_number\" value=\"&lt;?php echo $clickToCallRecord['phone_number']; ?&gt;\" placeholder=\"(123)-456-7890\"&gt;\n&lt;\/div&gt;\n&lt;div class=\"form-group\"&gt;\n    &lt;label&gt;Message:&lt;\/label&gt;\n    &lt;input class=\"form-control\" type=\"text\" name=\"message_text\" value=\"&lt;?php echo $clickToCallRecord['message_text']; ?&gt;\" placeholder=\"Call Us Now\"&gt;\n&lt;\/div&gt;\n&lt;div class=\"form-group\"&gt;\n    &lt;label&gt;Background Color:&lt;\/label&gt;\n    &lt;input class=\"form-control\" type=\"text\" value=\"&lt;?php echo $clickToCallRecord['bg_color']; ?&gt;\" name=\"bg_color\"&gt;\n&lt;\/div&gt;\n<\/pre>\n<p>Checking the correct radio input requires our code to evaluate the data value. I add a PHP variable to each of the inputs as attributes. Those variables will render to either &#8220;checked&#8221; or blank:<\/p>\n<pre>&lt;?php\n    $top_checked = \"\";\n    $bottom_checked = \"\";\n    $position = $clickToCallRecord['position'];\n    if($position == \"top\"){\n        $top_checked = \"checked\";\n        $bottom_checked = \"\";\n    }else{\n        $top_checked = \"\";\n        $bottom_checked = \"checked\";\n    }\n\n    $show_checked = \"\";\n    $hide_checked = \"\";\n    $display = $clickToCallRecord['display'];\n    if($display == \"show\"){\n        $show_checked = \"checked\";\n        $hide_checked = \"\";\n    }else{\n        $show_checked = \"\";\n        $hide_checked = \"checked\";\n    }\n\n?&gt;\n\n&lt;div class=\"form-group\"&gt;\n    &lt;label&gt;Position:&lt;\/label&gt;\n    &lt;div&gt;\n        &lt;div class=\"form-check form-check-inline\"&gt;\n          &lt;input &lt;?php echo $top_checked; ?&gt; class=\"form-check-input\" type=\"radio\" name=\"position\" value=\"top\"&gt;\n          &lt;label class=\"form-check-label\" for=\"matchtype\"&gt;Top&lt;\/label&gt;\n        &lt;\/div&gt;\n        &lt;div class=\"form-check form-check-inline\"&gt;\n          &lt;input &lt;?php echo $bottom_checked; ?&gt; class=\"form-check-input\" type=\"radio\" name=\"position\"  value=\"bottom\"&gt;\n          &lt;label class=\"form-check-label\" for=\"matchtype\"&gt;Bottom&lt;\/label&gt;\n        &lt;\/div&gt;\n    &lt;\/div&gt;\n&lt;\/div&gt;\n&lt;hr \/&gt;\n&lt;div class=\"form-group\"&gt;\n    &lt;label&gt;Display:&lt;\/label&gt;\n    &lt;div&gt;\n        &lt;div class=\"form-check form-check-inline\"&gt;\n          &lt;input &lt;?php echo $show_checked; ?&gt; class=\"form-check-input\" type=\"radio\" name=\"display\" value=\"show\"&gt;\n          &lt;label class=\"form-check-label\" for=\"matchtype\"&gt;Show&lt;\/label&gt;\n        &lt;\/div&gt;\n        &lt;div class=\"form-check form-check-inline\"&gt;\n          &lt;input &lt;?php echo $hide_checked; ?&gt; class=\"form-check-input\" type=\"radio\" name=\"display\"  value=\"hide\"&gt;\n          &lt;label class=\"form-check-label\" for=\"matchtype\"&gt;Hide&lt;\/label&gt;\n        &lt;\/div&gt;\n    &lt;\/div&gt;\n&lt;\/div&gt;\n<\/pre>\n<p>This example comes from a Shopify app that helps stores increase conversions by adding a UI element prompting customers to call a phone number.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When building software user interfaces, I create HTML forms to manage any app settings. I&#8217;ll usually have a few text and radio inputs like this: Using PHP, I grab a database record and access its properties to populate the form. Filling out the text inputs is straight-forward: &lt;?php $clickToCallRecord = $db_service-&gt;getClickToCallRecord($installation_complete_id); ?&gt; &lt;div class=&#8221;form-group&#8221;&gt; &lt;label&gt;Phone &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.antpace.com\/blog\/radio-button-value-checked-from-a-database-in-php\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Radio Button Value Checked from a Database in PHP&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":3219,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[66,67,92,140],"class_list":["post-1303","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-development","tag-html","tag-html5","tag-php","tag-web-development"],"_links":{"self":[{"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/posts\/1303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/comments?post=1303"}],"version-history":[{"count":1,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/posts\/1303\/revisions"}],"predecessor-version":[{"id":3220,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/posts\/1303\/revisions\/3220"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/media\/3219"}],"wp:attachment":[{"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/media?parent=1303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/categories?post=1303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antpace.com\/blog\/wp-json\/wp\/v2\/tags?post=1303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}