{"id":14495,"date":"2024-03-15T09:16:02","date_gmt":"2024-03-15T09:16:02","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/"},"modified":"2025-08-06T09:28:55","modified_gmt":"2025-08-06T09:28:55","slug":"how-do-i-connect-to-a-database-in-xampp","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/","title":{"rendered":"How to Connect Database in XAMPP (PHP)"},"content":{"rendered":"<p>In order to connect to a database, you will need to follow different methods based on the database system you are using. Here are the steps to connect common database systems on XAMPP:<\/p>\n<ol>\n<li>By default, XAMPP comes installed with the MySQL database. To connect to the MySQL database, you can use either the MySQLi or PDO extensions in PHP. Firstly, make sure the MySQL server is running. Then, you can use the following example code to connect to the MySQL database:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-variable\">$servername<\/span> = <span class=\"hljs-string\">\"localhost\"<\/span>;\r\n<span class=\"hljs-variable\">$username<\/span> = <span class=\"hljs-string\">\"root\"<\/span>;\r\n<span class=\"hljs-variable\">$password<\/span> = <span class=\"hljs-string\">\"\"<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ \u521b\u5efa\u8fde\u63a5<\/span>\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>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u68c0\u67e5\u8fde\u63a5\u662f\u5426\u6210\u529f<\/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-keyword\">echo<\/span> <span class=\"hljs-string\">\"\u6210\u529f\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\"<\/span>;\r\n<\/code><\/pre>\n<ol>\n<li>MariaDB is a fork of MySQL, and it has the same connection methods as MySQL. You can use the same sample code to connect to a MariaDB database.<\/li>\n<li>In order to connect to a PostgreSQL database, you will need to use the PDO extension in PHP. First, make sure the PostgreSQL server is running. Then, you can use the following sample code to connect to the PostgreSQL database:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-variable\">$host<\/span> = <span class=\"hljs-string\">\"localhost\"<\/span>;\r\n<span class=\"hljs-variable\">$dbname<\/span> = <span class=\"hljs-string\">\"your_database\"<\/span>;\r\n<span class=\"hljs-variable\">$user<\/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\r\n<span class=\"hljs-keyword\">try<\/span> {\r\n    <span class=\"hljs-variable\">$conn<\/span> = <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title function_ invoke__\">PDO<\/span>(<span class=\"hljs-string\">\"pgsql:host=<span class=\"hljs-subst\">$host<\/span>;dbname=<span class=\"hljs-subst\">$dbname<\/span>\"<\/span>, <span class=\"hljs-variable\">$user<\/span>, <span class=\"hljs-variable\">$password<\/span>);\r\n    <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">\"\u6210\u529f\u8fde\u63a5\u5230PostgreSQL\u6570\u636e\u5e93\"<\/span>;\r\n} <span class=\"hljs-keyword\">catch<\/span> (PDOException <span class=\"hljs-variable\">$e<\/span>) {\r\n    <span class=\"hljs-keyword\">die<\/span>(<span class=\"hljs-string\">\"\u8fde\u63a5\u5931\u8d25\uff1a\"<\/span> . <span class=\"hljs-variable\">$e<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">getMessage<\/span>());\r\n}\r\n<\/code><\/pre>\n<ol>\n<li>To connect to an SQLite database, you can utilize the PHP PDO extension. Ensure that the SQLite extension is enabled and then you can connect to the SQLite database using the sample code provided.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-variable\">$database<\/span> = <span class=\"hljs-string\">\"path\/to\/your\/database.sqlite\"<\/span>;\r\n\r\n<span class=\"hljs-keyword\">try<\/span> {\r\n    <span class=\"hljs-variable\">$conn<\/span> = <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title function_ invoke__\">PDO<\/span>(<span class=\"hljs-string\">\"sqlite:<span class=\"hljs-subst\">$database<\/span>\"<\/span>);\r\n    <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">\"\u6210\u529f\u8fde\u63a5\u5230SQLite\u6570\u636e\u5e93\"<\/span>;\r\n} <span class=\"hljs-keyword\">catch<\/span> (PDOException <span class=\"hljs-variable\">$e<\/span>) {\r\n    <span class=\"hljs-keyword\">die<\/span>(<span class=\"hljs-string\">\"\u8fde\u63a5\u5931\u8d25\uff1a\"<\/span> . <span class=\"hljs-variable\">$e<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">getMessage<\/span>());\r\n}\r\n<\/code><\/pre>\n<p>The above sample code is used only for connecting to the database and does not include any database operations. Depending on your specific needs, you may need to perform queries, inserts, updates, and so on.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to connect to a database, you will need to follow different methods based on the database system you are using. Here are the steps to connect common database systems on XAMPP: By default, XAMPP comes installed with the MySQL database. To connect to the MySQL database, you can use either the MySQLi or [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1788,3136,3137,3135,18902],"class_list":["post-14495","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-connection","tag-mysqli","tag-pdo","tag-php-mysql","tag-xampp"],"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 to Connect Database in XAMPP (PHP) - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Step-by-step guide to connect MySQL database in XAMPP using PHP (MySQLi\/PDO). Code examples included!\" \/>\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-do-i-connect-to-a-database-in-xampp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect Database in XAMPP (PHP)\" \/>\n<meta property=\"og:description\" content=\"Step-by-step guide to connect MySQL database in XAMPP using PHP (MySQLi\/PDO). Code examples included!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/\" \/>\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-15T09:16:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T09:28:55+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\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=\"William Carter\" \/>\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-do-i-connect-to-a-database-in-xampp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How to Connect Database in XAMPP (PHP)\",\"datePublished\":\"2024-03-15T09:16:02+00:00\",\"dateModified\":\"2025-08-06T09:28:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/\"},\"wordCount\":225,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Database Connection\",\"MySQLi\",\"PDO\",\"PHP MySQL\",\"XAMPP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/\",\"name\":\"How to Connect Database in XAMPP (PHP) - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T09:16:02+00:00\",\"dateModified\":\"2025-08-06T09:28:55+00:00\",\"description\":\"Step-by-step guide to connect MySQL database in XAMPP using PHP (MySQLi\/PDO). Code examples included!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect Database in XAMPP (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\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Connect Database in XAMPP (PHP) - Blog - Silicon Cloud","description":"Step-by-step guide to connect MySQL database in XAMPP using PHP (MySQLi\/PDO). Code examples included!","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-do-i-connect-to-a-database-in-xampp\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect Database in XAMPP (PHP)","og_description":"Step-by-step guide to connect MySQL database in XAMPP using PHP (MySQLi\/PDO). Code examples included!","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T09:16:02+00:00","article_modified_time":"2025-08-06T09:28:55+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How to Connect Database in XAMPP (PHP)","datePublished":"2024-03-15T09:16:02+00:00","dateModified":"2025-08-06T09:28:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/"},"wordCount":225,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Database Connection","MySQLi","PDO","PHP MySQL","XAMPP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/","name":"How to Connect Database in XAMPP (PHP) - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T09:16:02+00:00","dateModified":"2025-08-06T09:28:55+00:00","description":"Step-by-step guide to connect MySQL database in XAMPP using PHP (MySQLi\/PDO). Code examples included!","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-connect-to-a-database-in-xampp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Connect Database in XAMPP (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\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14495","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=14495"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14495\/revisions"}],"predecessor-version":[{"id":158527,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14495\/revisions\/158527"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}