{"id":19082,"date":"2024-03-15T18:12:48","date_gmt":"2024-03-15T18:12:48","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/"},"modified":"2024-03-21T14:51:02","modified_gmt":"2024-03-21T14:51:02","slug":"how-can-php-submit-form-data-to-a-database","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/","title":{"rendered":"How can PHP submit form data to a database?"},"content":{"rendered":"<p>To submit form data to a database, you first need to establish a connection to the database. You can use either the MySQLi extension or PDO extension in PHP to connect to and interact with the database.<\/p>\n<p>Here is an example code using the MySQLi extension:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-meta\">&lt;?php<\/span>\r\n<span class=\"hljs-comment\">\/\/ \u8fde\u63a5\u5230\u6570\u636e\u5e93<\/span>\r\n<span class=\"hljs-variable\">$servername<\/span> = <span class=\"hljs-string\">\"localhost\"<\/span>;\r\n<span class=\"hljs-variable\">$username<\/span> = <span class=\"hljs-string\">\"your_username\"<\/span>;\r\n<span class=\"hljs-variable\">$password<\/span> = <span class=\"hljs-string\">\"your_password\"<\/span>;\r\n<span class=\"hljs-variable\">$dbname<\/span> = <span class=\"hljs-string\">\"your_database\"<\/span>;\r\n\r\n<span class=\"hljs-variable\">$conn<\/span> = <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title function_ invoke__\">mysqli<\/span>(<span class=\"hljs-variable\">$servername<\/span>, <span class=\"hljs-variable\">$username<\/span>, <span class=\"hljs-variable\">$password<\/span>, <span class=\"hljs-variable\">$dbname<\/span>);\r\n<span class=\"hljs-keyword\">if<\/span> (<span class=\"hljs-variable\">$conn<\/span>-&gt;connect_error) {\r\n    <span class=\"hljs-keyword\">die<\/span>(<span class=\"hljs-string\">\"\u8fde\u63a5\u5931\u8d25: \"<\/span> . <span class=\"hljs-variable\">$conn<\/span>-&gt;connect_error);\r\n}\r\n\r\n<span class=\"hljs-comment\">\/\/ \u5904\u7406\u8868\u5355\u63d0\u4ea4<\/span>\r\n<span class=\"hljs-keyword\">if<\/span> (<span class=\"hljs-variable\">$_SERVER<\/span>[<span class=\"hljs-string\">\"REQUEST_METHOD\"<\/span>] == <span class=\"hljs-string\">\"POST\"<\/span>) {\r\n    <span class=\"hljs-variable\">$name<\/span> = <span class=\"hljs-variable\">$_POST<\/span>[<span class=\"hljs-string\">\"name\"<\/span>];\r\n    <span class=\"hljs-variable\">$email<\/span> = <span class=\"hljs-variable\">$_POST<\/span>[<span class=\"hljs-string\">\"email\"<\/span>];\r\n    <span class=\"hljs-variable\">$message<\/span> = <span class=\"hljs-variable\">$_POST<\/span>[<span class=\"hljs-string\">\"message\"<\/span>];\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u63d2\u5165\u6570\u636e\u5230\u6570\u636e\u5e93<\/span>\r\n    <span class=\"hljs-variable\">$sql<\/span> = <span class=\"hljs-string\">\"INSERT INTO your_table (name, email, message) VALUES ('<span class=\"hljs-subst\">$name<\/span>', '<span class=\"hljs-subst\">$email<\/span>', '<span class=\"hljs-subst\">$message<\/span>')\"<\/span>;\r\n    <span class=\"hljs-keyword\">if<\/span> (<span class=\"hljs-variable\">$conn<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">query<\/span>(<span class=\"hljs-variable\">$sql<\/span>) === <span class=\"hljs-literal\">TRUE<\/span>) {\r\n        <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">\"\u6570\u636e\u63d0\u4ea4\u6210\u529f\"<\/span>;\r\n    } <span class=\"hljs-keyword\">else<\/span> {\r\n        <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">\"Error: \"<\/span> . <span class=\"hljs-variable\">$sql<\/span> . <span class=\"hljs-string\">\"&lt;br&gt;\"<\/span> . <span class=\"hljs-variable\">$conn<\/span>-&gt;error;\r\n    }\r\n}\r\n\r\n<span class=\"hljs-comment\">\/\/ \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5<\/span>\r\n<span class=\"hljs-variable\">$conn<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">close<\/span>();\r\n<span class=\"hljs-meta\">?&gt;<\/span>\r\n<\/code><\/pre>\n<p>Please make sure to properly validate and filter user input in actual use to prevent security issues such as SQL injection.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To submit form data to a database, you first need to establish a connection to the database. You can use either the MySQLi extension or PDO extension in PHP to connect to and interact with the database. Here is an example code using the MySQLi extension: &lt;?php \/\/ \u8fde\u63a5\u5230\u6570\u636e\u5e93 $servername = &#8220;localhost&#8221;; $username = &#8220;your_username&#8221;; [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-19082","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can PHP submit form data to a database? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can PHP submit form data to a database?\" \/>\n<meta property=\"og:description\" content=\"To submit form data to a database, you first need to establish a connection to the database. You can use either the MySQLi extension or PDO extension in PHP to connect to and interact with the database. Here is an example code using the MySQLi extension: &lt;?php \/\/ \u8fde\u63a5\u5230\u6570\u636e\u5e93 $servername = &quot;localhost&quot;; $username = &quot;your_username&quot;; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T18:12:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T14:51:02+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How can PHP submit form data to a database?\",\"datePublished\":\"2024-03-15T18:12:48+00:00\",\"dateModified\":\"2024-03-21T14:51:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\"},\"wordCount\":76,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\",\"name\":\"How can PHP submit form data to a database? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T18:12:48+00:00\",\"dateModified\":\"2024-03-21T14:51:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can PHP submit form data to a database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can PHP submit form data to a database? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/","og_locale":"en_US","og_type":"article","og_title":"How can PHP submit form data to a database?","og_description":"To submit form data to a database, you first need to establish a connection to the database. You can use either the MySQLi extension or PDO extension in PHP to connect to and interact with the database. Here is an example code using the MySQLi extension: &lt;?php \/\/ \u8fde\u63a5\u5230\u6570\u636e\u5e93 $servername = \"localhost\"; $username = \"your_username\"; [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T18:12:48+00:00","article_modified_time":"2024-03-21T14:51:02+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How can PHP submit form data to a database?","datePublished":"2024-03-15T18:12:48+00:00","dateModified":"2024-03-21T14:51:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/"},"wordCount":76,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/","name":"How can PHP submit form data to a database? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T18:12:48+00:00","dateModified":"2024-03-21T14:51:02+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-submit-form-data-to-a-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can PHP submit form data to a database?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=19082"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19082\/revisions"}],"predecessor-version":[{"id":52804,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19082\/revisions\/52804"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=19082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=19082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=19082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}