{"id":22127,"date":"2024-03-15T23:04:46","date_gmt":"2024-03-15T23:04:46","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/"},"modified":"2024-03-21T22:08:06","modified_gmt":"2024-03-21T22:08:06","slug":"how-can-data-be-added-to-mysql-using-php","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/","title":{"rendered":"How can data be added to MySQL using PHP?"},"content":{"rendered":"<p>To add data to MySQL, you can connect to the database and perform insert operations using either the MySQLi extension or PDO extension in PHP. Here is an example code using the MySQLi extension:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\">\/\/ \u8fde\u63a5\u5230MySQL\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\uff1a\"<\/span> . <span class=\"hljs-variable\">$conn<\/span>-&gt;connect_error);\r\n}\r\n\r\n<span class=\"hljs-comment\">\/\/ \u51c6\u5907\u63d2\u5165\u8bed\u53e5<\/span>\r\n<span class=\"hljs-variable\">$sql<\/span> = <span class=\"hljs-string\">\"INSERT INTO your_table (column1, column2, column3) VALUES ('value1', 'value2', 'value3')\"<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6267\u884c\u63d2\u5165\u8bed\u53e5<\/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\u63d2\u5165\u6210\u529f\"<\/span>;\r\n} <span class=\"hljs-keyword\">else<\/span> {\r\n    <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">\"\u6570\u636e\u63d2\u5165\u5931\u8d25\uff1a\"<\/span> . <span class=\"hljs-variable\">$conn<\/span>-&gt;error;\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<\/code><\/pre>\n<p>Please replace the database connection information, table name, column names, and values to be inserted based on the actual situation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To add data to MySQL, you can connect to the database and perform insert operations using either the MySQLi extension or PDO extension in PHP. Here is an example code using the MySQLi extension: \/\/ \u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93 $servername = &#8220;localhost&#8221;; $username = &#8220;your_username&#8221;; $password = &#8220;your_password&#8221;; $dbname = &#8220;your_database&#8221;; $conn = new mysqli($servername, $username, $password, $dbname); [&hellip;]<\/p>\n","protected":false},"author":10,"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-22127","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 data be added to MySQL using PHP? - 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-data-be-added-to-mysql-using-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can data be added to MySQL using PHP?\" \/>\n<meta property=\"og:description\" content=\"To add data to MySQL, you can connect to the database and perform insert operations using either the MySQLi extension or PDO extension in PHP. Here is an example code using the MySQLi extension: \/\/ \u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93 $servername = &quot;localhost&quot;; $username = &quot;your_username&quot;; $password = &quot;your_password&quot;; $dbname = &quot;your_database&quot;; $conn = new mysqli($servername, $username, $password, $dbname); [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/\" \/>\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-15T23:04:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T22:08:06+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\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=\"Jackson Davis\" \/>\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-data-be-added-to-mysql-using-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How can data be added to MySQL using PHP?\",\"datePublished\":\"2024-03-15T23:04:46+00:00\",\"dateModified\":\"2024-03-21T22:08:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/\"},\"wordCount\":63,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/\",\"name\":\"How can data be added to MySQL using PHP? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T23:04:46+00:00\",\"dateModified\":\"2024-03-21T22:08:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can data be added to MySQL using PHP?\"}]},{\"@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\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can data be added to MySQL using PHP? - 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-data-be-added-to-mysql-using-php\/","og_locale":"en_US","og_type":"article","og_title":"How can data be added to MySQL using PHP?","og_description":"To add data to MySQL, you can connect to the database and perform insert operations using either the MySQLi extension or PDO extension in PHP. Here is an example code using the MySQLi extension: \/\/ \u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93 $servername = \"localhost\"; $username = \"your_username\"; $password = \"your_password\"; $dbname = \"your_database\"; $conn = new mysqli($servername, $username, $password, $dbname); [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T23:04:46+00:00","article_modified_time":"2024-03-21T22:08:06+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How can data be added to MySQL using PHP?","datePublished":"2024-03-15T23:04:46+00:00","dateModified":"2024-03-21T22:08:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/"},"wordCount":63,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/","name":"How can data be added to MySQL using PHP? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T23:04:46+00:00","dateModified":"2024-03-21T22:08:06+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-added-to-mysql-using-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can data be added to MySQL using PHP?"}]},{"@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\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22127","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=22127"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22127\/revisions"}],"predecessor-version":[{"id":56031,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22127\/revisions\/56031"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=22127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=22127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=22127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}