{"id":21273,"date":"2022-11-12T20:59:46","date_gmt":"2022-11-12T15:29:46","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/"},"modified":"2022-11-12T20:59:46","modified_gmt":"2022-11-12T15:29:46","slug":"solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/","title":{"rendered":"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

First of all I would change these<\/p>\n

    <form method=\"post\">\n            <input type=\"hidden\" name=\"blah\" value=\"blah\">\n\n            <input type=\"checkbox\" name=\"cbox[]\" value=\"1\">\n            <input type=\"checkbox\" name=\"cbox[]\" value=\"1\">\n            <input type=\"checkbox\" name=\"cbox[]\" value=\"1\">\n            <input type=\"checkbox\" name=\"cbox[]\" value=\"1\">\n            <input type=\"checkbox\" name=\"cbox[]\" value=\"1\">\n\n            <button type=\"submit\">Submit<\/button>\n    <\/form>\n<\/code><\/pre>\n
As you wont be able to tell severside which one is checked currently you’ll get something like this if only one of them is checked, in the $_POST<\/p>\n
  array(\n       'blah' => 'blah', \/\/your hidden field\n       'cbox' => array(\n            0 => 1\n        )\n  );\n<\/code><\/pre>\n
And if 2 are checked<\/p>\n
   array(\n       'blah' => 'blah', \/\/your hidden field\n       'cbox' => array(\n            0 => 1\n            1 => 1\n        )\n  );\n<\/code><\/pre>\n
But the question is which 2?  So you will either need to change the names of these or the values<\/p>\n
        <input type=\"checkbox\" name=\"cbox[]\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox[]\" value=\"2\">\n        <input type=\"checkbox\" name=\"cbox[]\" value=\"3\">\n        <input type=\"checkbox\" name=\"cbox[]\" value=\"4\">\n        <input type=\"checkbox\" name=\"cbox[]\" value=\"5\">\n<\/code><\/pre>\n
OR<\/p>\n
        <input type=\"checkbox\" name=\"cbox1\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox2\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox3\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox4\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox5\" value=\"1\">\n<\/code><\/pre>\n
OR if you want to further complicate things<\/p>\n
        <input type=\"checkbox\" name=\"cbox[cbox1]\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox[cbox2]\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox[cbox3]\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox[cbox4]\" value=\"1\">\n        <input type=\"checkbox\" name=\"cbox[cbox5]\" value=\"1\">\n<\/code><\/pre>\n
Depending on what one you pick, you will need to then check if it is set, if the checkbox is not checked it wont be sent to the sever.  There are a few ways around this depending how you name or do the values.  The best approach is simply using<\/p>\n
   $cbox1 = isset( $_POST['cbox1'] ) ? 1 : 0; \/\/if you rename them\n   \/\/\/or -- ( or something similar for each if you change the value )\n   if( in_array( 1, $_POST['cbox'] )){\n       $cbox1 = 1\n   }else{\n       $cbox1 = 0;\n   }\n<\/code><\/pre>\n
Now which one you pick to do should depend on if the number of checkboxes is known, a fixed number, or dynamic.  If it’s a fixed number I would change the name ( the 2nd option ) as it is cleaner and will be much easier to deal with server side.<\/p>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            1<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved How do I insert the value from a checkbox into MySQL in php? [duplicate] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] First of all I would change these <form method=”post”> <input type=”hidden” name=”blah” value=”blah”> <input type=”checkbox” name=”cbox[]” value=”1″> <input type=”checkbox” name=”cbox[]” value=”1″> <input type=”checkbox” name=”cbox[]” value=”1″> <input type=”checkbox” name=”cbox[]” value=”1″> <input type=”checkbox” name=”cbox[]” value=”1″> <button type=”submit”>Submit<\/button> <\/form> As you wont be able to tell severside which one is checked currently you’ll get something like this … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[346,333,340,339],"class_list":["post-21273","post","type-post","status-publish","format-standard","hentry","category-solved","tag-html","tag-javascript","tag-mysql","tag-php"],"yoast_head":"\n[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] First of all I would change these <form method="post"> <input type="hidden" name="blah" value="blah"> <input type="checkbox" name="cbox[]" value="1"> <input type="checkbox" name="cbox[]" value="1"> <input type="checkbox" name="cbox[]" value="1"> <input type="checkbox" name="cbox[]" value="1"> <input type="checkbox" name="cbox[]" value="1"> <button type="submit">Submit<\/button> <\/form> As you wont be able to tell severside which one is checked currently you’ll get something like this ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-12T15:29:46+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate]\",\"datePublished\":\"2022-11-12T15:29:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\"},\"wordCount\":200,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"html\",\"javascript\",\"mysql\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\",\"name\":\"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-12T15:29:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate] - JassWeb","og_description":"[ad_1] First of all I would change these <form method=\"post\"> <input type=\"hidden\" name=\"blah\" value=\"blah\"> <input type=\"checkbox\" name=\"cbox[]\" value=\"1\"> <input type=\"checkbox\" name=\"cbox[]\" value=\"1\"> <input type=\"checkbox\" name=\"cbox[]\" value=\"1\"> <input type=\"checkbox\" name=\"cbox[]\" value=\"1\"> <input type=\"checkbox\" name=\"cbox[]\" value=\"1\"> <button type=\"submit\">Submit<\/button> <\/form> As you wont be able to tell severside which one is checked currently you’ll get something like this ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/","og_site_name":"JassWeb","article_published_time":"2022-11-12T15:29:46+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate]","datePublished":"2022-11-12T15:29:46+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/"},"wordCount":200,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["html","javascript","mysql","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/","url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/","name":"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-12T15:29:46+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-insert-the-value-from-a-checkbox-into-mysql-in-php-duplicate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How do I insert the value from a checkbox into MySQL in php? [duplicate]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/21273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=21273"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/21273\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=21273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=21273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=21273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}