{"id":11856,"date":"2023-12-30T07:00:00","date_gmt":"2023-12-30T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=11856"},"modified":"2024-01-02T19:28:59","modified_gmt":"2024-01-02T13:58:59","slug":"html-to-mysql-database-using-php","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/html-to-mysql-database-using-php\/","title":{"rendered":"How to Connect HTML to MySQL Database using PHP"},"content":{"rendered":"\n<p>In this comprehensive tutorial (HTML to MySQL), learn how to connect HTML forms to a MySQL database using PHP. Whether you&#8217;re a beginner or looking to refresh your skills, this step-by-step guide will walk you through the entire process. You&#8217;ll discover how to set up your database, create HTML forms, and use PHP to establish a connection. By the end of this video, you&#8217;ll be equipped with the knowledge to build dynamic web applications with ease.<\/p>\n\n\n\n<p>HTML Bootstrap JavaScript \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092f\u0926\u093f \u0906\u092a \u090f\u0915 Invoice \u092c\u0928\u093e \u0915\u0930 \u0909\u0938\u0915\u0947 data \u0915\u094b MySQL  Database \u092e\u0947 Store \u0915\u0930\u0935\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Article \u0906\u092a\u0915\u0947 \u0932\u093f\u090f \u0939\u0940 \u0939\u0948, Welcome Friends \u092e\u0947 \u0939\u0941 \u0938\u0902\u0926\u0940\u092a \u0928\u093f\u0917\u092e \u0914\u0930 \u0906\u091c \u0906\u092a\u0915\u094b \u092c\u0924\u093e\u090a\u0901\u0917\u093e \u0915\u0940 \u0915\u0948\u0938\u0947 \u0939\u092e HTML Bootstrap \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Invoice \u0915\u0947 data \u0915\u0940 MySQL database \u092e\u0947 Store \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#html-to-my-sql-output\">HTML to MySQL Output <\/a><\/li><li><a href=\"#html-code-for-html-to-my-sql\">HTML Code for HTML to MySQL <\/a><\/li><li><a href=\"#css-for-html-to-my-sql\">CSS for HTML to MySQL <\/a><\/li><li><a href=\"#java-script-code-for-html-to-my-sql\">JavaScript Code for HTML to MySQL <\/a><\/li><li><a href=\"#table-structure-for-html-to-my-sql\">Table Structure for HTML to MySQL <\/a><\/li><li><a href=\"#php-code-for-html-to-my-sql\">PHP Code for HTML to MySQL <\/a><\/li><li><a href=\"#testing-html-to-my-sql\">Testing HTML to MySQL <\/a><\/li><li><a href=\"#video-\u0915\u0947-\u092e\u093e\u0927\u094d\u092f\u092e-\u0938\u0947-\u0938\u092e\u091d\u0928\u0947-\u0915\u0947-\u0932\u093f\u090f\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f <\/a><\/li><li><a href=\"#\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"html-to-my-sql-output\">HTML to MySQL Output <\/h2>\n\n\n\n<p>\u0939\u092e \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0926\u0947\u0916 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e \u091c\u094b \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948 \u0909\u0938\u0938\u0947 Output \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0928\u093f\u0915\u0947\u0932\u0947\u0917\u093e, \u0939\u092e \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u090f\u0915 Simple HTML Bootstrap \u0915\u0940 Invoice \u092c\u0928\u093e\u090f\u0902\u0917\u0947\u0964 \u0907\u0938\u092e\u0947 \u091c\u092c \u0921\u093e\u091f\u093e \u0915\u094b Save \u0915\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e \u0924\u092c Data MySQL \u092e\u0947 \u091c\u093e \u0915\u0930 Store \u0939\u094b \u091c\u093e\u090f\u0917\u093e <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"325\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=640%2C325&#038;ssl=1\" alt=\"HTML to MySQL\" class=\"wp-image-11860\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=1024%2C520&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=300%2C152&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=768%2C390&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=1536%2C779&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?resize=150%2C76&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?w=1693&amp;ssl=1 1693w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-28.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>MySQL \u092e\u0947 data \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"258\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?resize=640%2C258&#038;ssl=1\" alt=\"MySQL Table \" class=\"wp-image-11861\" style=\"width:840px;height:auto\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?resize=1024%2C413&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?resize=300%2C121&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?resize=768%2C310&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?resize=1536%2C620&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?resize=150%2C61&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?w=1803&amp;ssl=1 1803w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-29.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u091a\u0932\u093f\u090f \u0905\u092c Step By Step \u0938\u092e\u091d\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"html-code-for-html-to-my-sql\">HTML Code for HTML to MySQL <\/h2>\n\n\n\n<p>\u0939\u092e \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 Simple Invoice Page \u0915\u094b Design \u0915\u0930\u0947\u0902\u0917\u0947 \u0907\u0938\u092e\u0947 \u0926\u094b \u092d\u093e\u0917 \u0939\u0948\u0902 \u090f\u0915 \u0924\u094b Header \u0935\u093e\u0932\u093e \u091c\u093f\u0938\u092e\u0947 Customer \u0915\u093e \u0928\u093e\u092e, Invoice No, Date \u0906\u0926\u093f Columns \u0939\u0948\u0902 \u0913\u0930 \u090f\u0915 Detail \u0915\u093e Part \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 Item, Qty, Rate, Amount \u0906\u0926\u093f Columns \u0939\u0948\u0902 \u0911\u092b \u092b\u093f\u0930 Footer \u092e\u0947 Total \u0914\u0930 GST \u0915\u0947 Columns \u0939\u0948\u0902 , \u0907\u0928\u094d\u0939\u0947 \u092e\u0948\u0902\u0928\u0947 Store \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u092f\u0939 \u0906\u092a\u0915\u094b Home Work \u0906\u092a\u0915\u094b Concept \u0938\u092e\u091d \u0915\u0930 \u0916\u0941\u0926 \u0939\u0940 Solve \u0915\u0930\u0928\u093e \u0939\u0948 \u0964 <\/p>\n\n\n\n<p>\u0907\u0938 Invoice HTML \u092e\u0947 \u0939\u092e\u0928\u0947 \u0915\u0941\u091b \u0914\u0930 File \u0910\u0921 \u0915\u0940 \u0939\u0948\u0902 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>invoiceprint.css : <\/strong>\u092f\u0939 \u0939\u092e\u0928\u0947 \u090f\u0915 Print Format \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u092f\u0939 Invoice Print Format \u092e\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 \u0932\u0917\u0924\u0940 \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 print Media \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>invoice.css : <\/strong>\u0907\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 Invoice \u0938\u0947 Related \u091c\u094b \u092d\u0940 Css \u0915\u0947 changes \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u0932\u093f\u0916\u0947\u0902\u0917\u0947 <\/li>\n\n\n\n<li><strong>invoice.js : <\/strong>\u0907\u0938\u092e\u0947 \u0907\u0928\u094d\u0935\u093e\u0907\u0938 \u092e\u0947 \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 Event handle \u0915\u093f\u090f \u0939\u0948 \u0909\u0928\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0932\u093f\u0916\u093e \u0939\u0948\u0902 <\/li>\n\n\n\n<li><strong>save.php : <\/strong>MySQL \u092e\u0947 Data Store \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 PHP \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0921\u091f \u0915\u094b MySQL \u092e\u0947 Store \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0938\u093e\u0925 \u0939\u0940 \u092e\u0947 Bootstrap \u0914\u0930 jQuery \u0915\u0940 CDN \u092d\u0940 Connect \u0915\u0940 \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0939\u092e \u0907\u0928 \u0926\u094b\u0928\u094b\u0902 \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092a\u093e\u090f \u0964 <\/li>\n<\/ul>\n\n\n\n\n\n<pre title=\"invoice.html\" class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">\n&lt;!doctype html&gt;\n&lt;html lang=\"en\"&gt;\n  &lt;head&gt;\n    &lt;meta charset=\"utf-8\"&gt;\n    &lt;meta name=\"viewport\" content=\"width=device-width, initial-scale=1\"&gt;\n    &lt;title&gt;Imagination Invoice Example&lt;\/title&gt;\n    &lt;!-- For Bootstrap--&gt;\n    &lt;link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\" integrity=\"sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65\" crossorigin=\"anonymous\"&gt;\n    \n    &lt;!-- CSS For Print Format --&gt;\n    &lt;link rel=\"stylesheet\" media=\"print\" href=\"invoiceprint.css\"&gt;\n    \n    &lt;!-- CSS For Invoice --&gt;\n    &lt;link rel=\"stylesheet\"  href=\"invoice.css\"&gt;\n\n    &lt;!-- jQuery CDN --&gt;\n    &lt;script src=\"https:\/\/code.jquery.com\/jquery-3.6.2.slim.js\" integrity=\"sha256-OflJKW8Z8amEUuCaflBZJ4GOg4+JnNh9JdVfoV+6biw=\" crossorigin=\"anonymous\"&gt;&lt;\/script&gt;\n    \n    &lt;!-- For Invoice  --&gt;\n    &lt;script src=\"invoice.js\"&gt;&lt;\/script&gt;\n\n\n&lt;\/head&gt;\n&lt;body&gt;\n&lt;div class=\"container \"&gt;\n\t&lt;form  method=\"POST\" action=\"save.php\"   &gt;\n       \n\n        &lt;div class=\"card border-primary border-2 mt-2\"&gt;\n            &lt;div class=\"card-header text-center\"&gt;\n              &lt;h4&gt;HTML Invoice to MySQL using PHP&lt;\/h4&gt;\n            &lt;\/div&gt;\n            &lt;div class=\"card-body\"&gt;\n\n                &lt;div class=\"row\"&gt;\n                    &lt;div class=\"col-8\"&gt;\n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;Customer&lt;\/span&gt;\n                            &lt;input type=\"text\" class=\"form-control\" name=\"cust_nm\" placeholder=\"Customer\"  &gt;\n                        &lt;\/div&gt;\n            \n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;Address&lt;\/span&gt;\n                            &lt;input type=\"text\" class=\"form-control\" name=\"addr\" placeholder=\"Address\"  &gt;\n                        &lt;\/div&gt;\n            \n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;City&lt;\/span&gt;\n                            &lt;input type=\"text\" class=\"form-control\" name=\"city\" placeholder=\"City\"  &gt;\n                        &lt;\/div&gt;\n                    &lt;\/div&gt;\n                    &lt;div class=\"col-4\"&gt;\n                      \n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;Inv. No&lt;\/span&gt;\n                            &lt;input type=\"text\" class=\"form-control\" name=\"inv_no\" placeholder=\"Inv. No\"  &gt;\n                        &lt;\/div&gt;\n\n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;Inv. Date&lt;\/span&gt;\n                            &lt;input type=\"date\" class=\"form-control\" name=\"inv_dt\" placeholder=\"Inv. Date\"  &gt;\n                        &lt;\/div&gt;\n\n\n\n                    &lt;\/div&gt;\n                &lt;\/div&gt;\n\n\n                &lt;table class=\"table table-bordered\"&gt;\n                    &lt;thead class=\"table-primary\"&gt;\n                      &lt;tr&gt;\n                        &lt;th scope=\"col\"&gt;#&lt;\/th&gt;\n                        &lt;th scope=\"col\"&gt;Particular&lt;\/th&gt;\n                        &lt;th scope=\"col\" class=\"text-end\"&gt;Qty&lt;\/th&gt;\n                        &lt;th scope=\"col\" class=\"text-end\"&gt;Rate&lt;\/th&gt;\n                        &lt;th scope=\"col\" class=\"text-end\"&gt;Amount&lt;\/th&gt;\n                        &lt;th scope=\"col\" class=\"NoPrint\"&gt;                         \n                            &lt;button type=\"button\" class=\"btn btn-sm btn-primary\" onclick=\"BtnAdd()\"&gt;+&lt;\/button&gt;\n                          \n                        &lt;\/th&gt;\n\n                      &lt;\/tr&gt;\n                    &lt;\/thead&gt;\n                    &lt;tbody id=\"TBody\"&gt;\n                      &lt;tr id=\"TRow\" class=\"d-none\"&gt;\n                        &lt;th scope=\"row\"&gt;1&lt;\/th&gt;\n                        &lt;td&gt;&lt;input type=\"text\" class=\"form-control\" &gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\" class=\"form-control text-end\" name=\"qty[]\" onchange=\"Calc(this);\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\" class=\"form-control text-end\" name=\"rate[]\"  onchange=\"Calc(this);\"&gt;&lt;\/td&gt;\n                        &lt;td&gt;&lt;input type=\"number\" class=\"form-control text-end\" name=\"amt[]\" value=\"0\" readonly=\"readonly\"&gt;&lt;\/td&gt;\n                        &lt;td class=\"NoPrint\"&gt;&lt;button type=\"button\" class=\"btn btn-sm btn-danger\" onclick=\"BtnDel(this)\"&gt;X&lt;\/button&gt;&lt;\/td&gt;\n                      &lt;\/tr&gt;\n                    &lt;\/tbody&gt;\n                  &lt;\/table&gt;\n\n\n                  &lt;div class=\"row\"&gt;\n                    &lt;div class=\"col-8\"&gt;\n                      \n                        &lt;button type=\"button\" class=\"btn btn-primary\" onclick=\"GetPrint()\"&gt;Print&lt;\/button&gt;\n\t\t\t\t\t\t&lt;button type=\"submit\" class=\"btn btn-primary\" &gt;Save to MySQL&lt;\/button&gt;\n\n                    &lt;\/div&gt;\n                    &lt;div class=\"col-4\"&gt;\n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;Total&lt;\/span&gt;\n                            &lt;input type=\"number\" class=\"form-control text-end\" id=\"FTotal\" name=\"FTotal\" disabled=\"\"&gt;\n                        &lt;\/div&gt;\n                        &lt;div class=\"input-group mb-3\"&gt;\n                            &lt;span class=\"input-group-text\" &gt;GST&lt;\/span&gt;\n                            &lt;input type=\"number\" class=\"form-control text-end\" id=\"FGST\" name=\"FGST\" onchange=\"GetTotal()\"&gt;\n                        &lt;\/div&gt;\n                        &lt;div class=\"input-group \"&gt;\n                            &lt;span class=\"input-group-text\" &gt;Net Amt&lt;\/span&gt;\n                            &lt;input type=\"number\" class=\"form-control text-end\" id=\"FNet\" name=\"FNet\" disabled=\"\"&gt;\n                        &lt;\/div&gt;\n\n\n                    &lt;\/div&gt;\n                &lt;\/div&gt;\n             &lt;\/div&gt;\n          &lt;\/div&gt;\n\t\t&lt;\/form&gt;\n  &lt;\/div&gt;\n    &lt;!-- Bootstrap Bundle JS --&gt;\n    &lt;script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/js\/bootstrap.bundle.min.js\" integrity=\"sha384-kenU1KFdBIe4zVF0s0G1M5b4hcpxyD9F7jL+jjXkk+Q2h455rYXK\/7HAuoJl+0I4\" crossorigin=\"anonymous\"&gt;&lt;\/script&gt;\n  &lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"css-for-html-to-my-sql\">CSS for HTML to MySQL <\/h2>\n\n\n\n<p>Invoice \u092e\u0947 \u0939\u092e\u0928\u0947 \u0915\u094b\u0908 \u091c\u094d\u092f\u093e\u0926\u093e CSS \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0915\u0947\u0935\u0932 \u0938\u092d\u0940 Label \u0915\u0940 \u090f\u0915 \u091c\u0948\u0938\u0940 Width \u0915\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre title=\"invoice.css\" class=\"wp-block-code\"><code lang=\"css\" class=\"language-css\">.input-group-text {\n   width: 85px;\n}      <\/code><\/pre>\n\n\n\n<p>Invoice \u0915\u0947 Print Format \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u0915\u0941\u091b CSS \u0932\u093f\u0916\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre title=\"invoiceprint.css\" class=\"wp-block-code\"><code lang=\"css\" class=\"language-css\">.btn , .NoPrint \n{\n    display: none;\n}\n\n.form-control\n{\n    border: 0px;\n}\n\n.input-group-text\n{\n    border: 0px;\n    background-color: white;\n}\n\ntable \n{\n    border : 1px solid black;\n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"java-script-code-for-html-to-my-sql\">JavaScript Code for HTML to MySQL <\/h2>\n\n\n\n<p>\u092f\u0939 Javascript File \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 \u0938\u092d\u0940 Function \u0932\u093f\u0916\u0947 \u0939\u0948\u0902  \u091c\u094b \u0915\u0940 \u0906\u092a\u0915\u094b Invoice \u092e\u0947 data Entry \u0915\u0930\u0928\u0947 \u092e\u0947 \u092e\u0926\u0926 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<pre title=\"invoice.js\" class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">function GetPrint() {\n    \/*For Print*\/\n    window.print();\n}\n\nfunction BtnAdd() {\n    \/*Add Button*\/\n    var v = $(\"#TRow\").clone().appendTo(\"#TBody\") ;\n    $(v).find(\"input\").val('');\n    $(v).removeClass(\"d-none\");\n    $(v).find(\"th\").first().html($('#TBody tr').length - 1);\n}\n\nfunction BtnDel(v) {\n    \/*Delete Button*\/\n       $(v).parent().parent().remove(); \n       GetTotal();\n       $(\"#TBody\").find(\"tr\").each(\n        function(index)  {\n           $(this).find(\"th\").first().html(index);\n        }\n       );\n}\n\nfunction Calc(v) {\n    \/*Detail Calculation Each Row*\/\n    var index = $(v).parent().parent().index();\n    var qty  = document.getElementsByName(\"qty[]\")[index].value;\n    var rate = document.getElementsByName(\"rate[]\")[index].value;\n    var amt = qty * rate;\n    document.getElementsByName(\"amt[]\")[index].value = amt;\n    GetTotal();\n}\n\nfunction GetTotal() {\n    \/*Footer Calculation*\/   \n    var sum=0;\n    var amts =  document.getElementsByName(\"amt[]\");\n\n    for (let index = 0; index &lt; amts.length; index++) {\n        var amt = amts[index].value;\n        sum = +(sum) +  +(amt) ; \n    }\n    document.getElementById(\"FTotal\").value = sum;\n\n    var gst =  document.getElementById(\"FGST\").value;\n    var net = +(sum) + +(gst);\n    document.getElementById(\"FNet\").value = net;\n}<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>GetPrint() : <\/strong>\u0907\u0938 Function \u0938\u0947 Invoice \u0915\u094b Print Format \u092e\u0947 \u0926\u093f\u0916\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li><strong>BtnAdd() : <\/strong>\u0907\u0938 Function \u0938\u0947 Detail \u092e\u0947 Rows \u0915\u094b Add \u0915\u0930\u0928\u0947 \u092e\u0947 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>BtnDel() :<\/strong> \u0907\u0938 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 Invoice \u0915\u0940 Rows \u0915\u094b Delete \u0915\u0930\u0928\u0947 \u092e\u0947 \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li><strong>Calc() :<\/strong> \u0907\u0938 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 Amount \u0915\u094b Calculate \u0915\u0930\u0928\u0947 \u092e\u0947 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>GetTotal() :<\/strong> \u091c\u094b Footer \u092e\u0947 Total \u0906\u0924\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0907\u0938 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"table-structure-for-html-to-my-sql\">Table Structure for HTML to MySQL <\/h2>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0939\u092e MySQL \u092e\u0947 \u090f\u0915 database \u092c\u0928\u093e \u0915\u0930 \u0909\u0938\u092e\u0947 \u090f\u0915 Table \u092c\u0928\u093e\u090f\u0902\u0917\u0947 \u091c\u093f\u0938\u0915\u093e Structure \u0906\u092a \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE `invoice` (                                                            \n           `id` int(9) NOT NULL AUTO_INCREMENT,                                              \n           `inv_no` varchar(10) NOT NULL,                                                    \n           `inv_dt` date NOT NULL,                                                           \n           `cust_nm` varchar(40) NOT NULL,                                                   \n           `addr` varchar(80) NOT NULL,                                                      \n           `city` varchar(40) NOT NULL,                                                      \n           `qty` decimal(9,2) NOT NULL DEFAULT 0.00,                                         \n           `rate` decimal(9,2) NOT NULL DEFAULT 0.00,                                        \n           `amt` decimal(9,2) NOT NULL DEFAULT 0.00,                                         \n           PRIMARY KEY (`id`)                                                                \n         ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"php-code-for-html-to-my-sql\">PHP Code for HTML to MySQL <\/h2>\n\n\n\n<p>\u0907\u0938\u092e\u0947 \u092c\u093e\u0926 \u0939\u092e \u090f\u0915 PHP File \u092c\u0928\u093e \u0915\u0930 Data \u0915\u094b PHP \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 MySQL \u092e\u0947 \u092d\u0947\u091c \u0926\u0947\u0902\u0917\u0947\u0964 <\/p>\n\n\n\n<pre title=\"save.php\" class=\"wp-block-code\"><code lang=\"php\" class=\"language-php\">&lt;?php\nif (isset($_POST['cust_nm'])) {\n\t$cust_nm  = $_POST['cust_nm'];\n\t$addr     = $_POST['addr'];\n\t$city     = $_POST['city']; \n\t$inv_no   = $_POST['inv_no'];\n\t$inv_dt   = $_POST['inv_dt'];\n\n\t$qtys     = $_POST['qty'];\n\t$rates    = $_POST['rate'];\n\t$amts     = $_POST['amt'];\n\n\t$Ret = 0;\n        \/\/$con=mysqli_connect(\"HOST\",\"USERID\",\"PASSWORD\",\"DATABASE\");\n\t$con=mysqli_connect(\"localhost:3307\",\"root\",\"\",\"mydb\");\n\tif (mysqli_connect_errno())\n\t\techo \"Failed to connect to MySQL: \" . mysqli_connect_error();\n\t$cnt = count($qtys);\n\tfor ($i=1; $i&lt;$cnt; $i++) {\n\t\t$qty  = $qtys[$i] ;\n\t\t$rate = $rates[$i] ;\n\t\t$amt  = $amts[$i] ;\n\n\t\t$LsSQL = \"INSERT INTO `invoice`( `inv_no`, `inv_dt`, `cust_nm`, `addr`, `city`, `qty`, `rate`, `amt`) \n\t\tVALUES ('$inv_no','$inv_dt','$cust_nm ','$addr','$city', $qty, $rate, $amt)\";\n\t\t$Ret = mysqli_query($con, $LsSQL);\n\t}\n\n\tif ($Ret == 1) {\n\t\techo \"\\nSuccessfully Saved\";\n\t}\n\telse {\n\t\techo \"\\nError in Save\";\n\t}\n\tmysqli_close($con);\n\n}\n\n\n?&gt;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938\u092e\u0947 \u0939\u092e\u0947\u0902 \u091c\u094b Single \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0948\u0902 \u0909\u0928\u094d\u0939\u0947 direct \u0939\u0940 Get \u0915\u093f\u092f\u093e \u0964 <\/li>\n\n\n\n<li>\u0914\u0930 Multiple Value \u0935\u093e\u0932\u0947 Columns (Detail \u0935\u093e\u0932\u0947 \u0915\u0949\u0932\u092e \u091c\u0948\u0938\u0947 Qty, Rate, Amt) \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947 Array \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964<\/li>\n\n\n\n<li><strong>mysqli_connect :<\/strong> \u092e\u0947 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0947 localhost \u0915\u093e \u092a\u094b\u0930\u094d\u091f \u0914\u0930 User Id \u0913\u0930 Password \u0926\u0947\u0928\u093e \u0939\u0948\u0902 \u091c\u094b Default id Password \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 \u092e\u0948\u0902\u0928\u0947 \u0926\u0947 \u0926\u093f\u090f \u0939\u0948\u0902, Host \u0915\u094b \u0906\u092a \u090f\u0915 \u092c\u093e\u0930 \u091c\u0930\u0942\u0930 Check \u0915\u0930\u0947 \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u0906\u092a\u0915\u0947 Computer \u092e\u0947 \u0915\u0947\u0935\u0932 localhost \u0939\u0940 \u0939\u094b\u0964 \u092f\u093e \u0915\u094b\u0908 IP \u092d\u0940 \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948\u0902\u0964 <\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"testing-html-to-my-sql\">Testing HTML to MySQL <\/h2>\n\n\n\n<p>\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a HTML page \u0915\u094b Execute \u0915\u0930\u0947\u0902\u0917\u0947 , \u0906\u092a\u0915\u094b \u0907\u0924\u0928\u093e \u0927\u094d\u092f\u093e\u0928 \u0930\u0916\u0928\u093e \u0939\u0948\u0902 \u0915\u0940 \u0907\u0938\u0947 Wamp \u092f\u093e Xamp folder \u092e\u0947 html page \u0913\u0930 \u0938\u092d\u0940 files \u0915\u094b \u0930\u0916\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u0940 Execute  \u0915\u0930\u0947 \u0915\u094d\u092f\u0941\u0915\u0940 \u092f\u0926\u093f \u0906\u092a \u0915\u093f\u0938\u0940 \u092d\u0940 folder \u092e\u0947 \u0930\u0916 \u0915\u0930 Execute \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u0906\u092a\u0915\u094b Html View \u0924\u094b \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u0932\u0947\u0915\u093f\u0928 Data Post \u0928\u0939\u0940\u0902 \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"167\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-33.png?resize=640%2C167&#038;ssl=1\" alt=\"\" class=\"wp-image-11892\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-33.png?resize=1024%2C267&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-33.png?resize=300%2C78&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-33.png?resize=768%2C200&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-33.png?resize=150%2C39&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-33.png?w=1059&amp;ssl=1 1059w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b localhost \u0938\u0947 \u0939\u0940 project \u0915\u094b \u0935\u094d\u092f\u0942 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u091c\u0948\u0938\u093e \u0915\u0940 \u092e\u0947 \u0928\u0940\u091a\u0947 \u092c\u093e\u0924 \u0930\u0939\u093e \u0939\u0941\u0964 \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Wamp ya xamp \u0906\u092a \u091c\u094b \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0935\u0939 start \u0939\u094b\u0928\u093e \u091c\u0930\u0942\u0930\u0940 \u0939\u0948\u0902 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"457\" height=\"74\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-34.png?resize=457%2C74&#038;ssl=1\" alt=\"\" class=\"wp-image-11894\" style=\"width:303px;height:auto\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-34.png?w=457&amp;ssl=1 457w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-34.png?resize=300%2C49&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-34.png?resize=150%2C24&amp;ssl=1 150w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b Browser \u092a\u0930 \u0928\u093f\u092e\u094d\u0928 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u091f\u093e\u0907\u092a \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"44\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-35.png?resize=640%2C44&#038;ssl=1\" alt=\"\" class=\"wp-image-11895\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-35.png?resize=1024%2C71&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-35.png?resize=300%2C21&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-35.png?resize=768%2C54&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-35.png?resize=150%2C10&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/image-35.png?w=1075&amp;ssl=1 1075w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 URL \u092e\u0947 %20 \u0907\u0938\u0932\u093f\u090f \u0906 \u0930\u0939\u093e \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u092e\u0948\u0902\u0928\u0947 \u091c\u094b \u095e\u094b\u0932\u094d\u0921\u0930 \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 Name \u0915\u0947 \u092c\u0940\u091a \u092c\u0940\u091a \u092e\u0947 Space \u0926\u0940 \u0939\u0941\u090f \u0939\u0948\u0902 \u0964 \u0906\u092a \u092f\u0926\u093f \u0907\u0924\u0928\u093e \u091f\u093e\u0907\u092a \u0915\u0930\u0928\u0947 \u0938\u0947 \u092c\u091a\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b Folder \u0915\u093e \u0928\u093e\u092e \u091b\u094b\u091f\u093e \u0913\u0930 \u092c\u093f\u0928\u093e Space \u0915\u0947 \u0926\u0947\u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/mysql-installation\/\">\u092f\u0926\u093f \u0906\u092a\u0915\u094b MySQL \u0914\u0930 Wamp Install \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Article Read \u0915\u0930\u0947<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"video-\u0915\u0947-\u092e\u093e\u0927\u094d\u092f\u092e-\u0938\u0947-\u0938\u092e\u091d\u0928\u0947-\u0915\u0947-\u0932\u093f\u090f\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f <\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"\ud83d\udcf0How to Connect HTML to MySQL Database using PHP\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/OOBmyup5FIY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0906\u092a\u0915\u094b HTML to MySQL Database Connection \u092c\u0939\u0941\u0924 \u0939\u0940 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u092f\u093e \u0939\u0948\u0902, \u0907\u0938 Article \u0938\u0947 related \u0915\u094b\u0908 \u092d\u0940 Query \u0939\u094b \u0924\u094b \u0906\u092a \u092e\u0941\u091d\u0947 \u0928\u093f\u0903\u0938\u0902\u0915\u094b\u091a comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e Comment \u0915\u0930\u0928\u093e \u0928 \u092d\u0942\u0932\u0947 \u0964 \u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964<\/p>\n\n\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this comprehensive tutorial (HTML to MySQL), learn how to connect HTML forms to a MySQL database using PHP. Whether you&#8217;re a beginner or looking to refresh your skills, this step-by-step guide will walk you through the entire process. You&#8217;ll discover how to set up your database, create HTML forms, and use PHP to establish [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13,12,5,3],"tags":[],"class_list":["post-11856","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-html","category-javascript","category-mysql","category-php"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/12\/html-to-mysql-using-php.jpg?fit=1280%2C720&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/11856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=11856"}],"version-history":[{"count":128,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/11856\/revisions"}],"predecessor-version":[{"id":12074,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/11856\/revisions\/12074"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/11858"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=11856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=11856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=11856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}