{"id":1135,"date":"2012-01-27T17:04:18","date_gmt":"2012-01-27T17:04:18","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/01\/27\/php-insert-database\/"},"modified":"2024-07-23T17:16:54","modified_gmt":"2024-07-23T21:16:54","slug":"using-mysqli-to-insert","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/","title":{"rendered":"Using MySQLi to INSERT Data into a Database"},"content":{"rendered":"
\"using<\/figure>\n\n\n\n

Since newer versions of PHP no longer support the ability to insert data into a database using PHP extensions, users will need to make use of an extension such as MySQLi to insert data into their databases. Using MySQLi to insert data can be done directly in the command line or via PHP script. In this article we will discuss using MySQLi to insert data into MySQL databases.<\/p>\n\n\n\n

Using MySQLi to INSERT Data<\/h2>\n\n\n\n
    \n
  1. First, ensure that your database has been created<\/a> and can be accessed.<\/li>\n\n\n\n
  2. Next, connect to your database server via SSH<\/a>. Please note that this will require the use of command-line operations. It is only recommended to perform these steps if you are comfortable using command-line interfaces.<\/li>\n\n\n\n
  3. Once you\u2019ve connected to your database server you will want to log into MySQL<\/a>. <\/li>\n\n\n\n
  4. Once logged in, you can use the mysql prompt to execute the following query and insert data into your database.\u00a0
    $sql = \"INSERT INTO data_product1 (size, color, price) VALUES ('M', 'Blue', '39.99')\";<\/pre><\/li>\n\n\n\n
  5. In our example, data_product represents the database table being modified. The size, color, and price all represent separate columns in the database structure. The values represent the data being stored, in this case the size, color, and price of the product in question. For a typical eCommerce website, a database will contain thousands of tables storing a variety of data ranging from contact information to product descriptions and specifications.<\/li>\n<\/ol>\n\n\n\n
    Creating a PHP script to INSERT Data using MySQLi<\/h3>\n\n\n\n
    While it is not possible to use PHP extensions to insert data, you can still write a PHP script that uses the MySQLi extension to insert the data.<\/p>\n\n\n\n
    The first portion of the script will involve connecting to the database. The dbhost<\/strong> is the hostname of the database server, usually localhost. The dbuser<\/strong> is the database username, dbpass<\/strong> is the password for the database user, and the dbname<\/strong> is the name of the database itself:<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    <<\/span>html<\/span>><\/span><\/span>\n\u00a0\u00a0\u00a0<\/span><<\/span>head<\/span>><\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><<\/span>title<\/span>><\/span>Adding<\/span> <\/span>Product<\/span> <\/span>Data<\/span><\/<\/span>title<\/span>><\/span><\/span>\n\u00a0\u00a0\u00a0<\/span><\/<\/span>head<\/span>><\/span><\/span>\n\u00a0\u00a0\u00a0<\/span><<\/span>body<\/span>><\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><?<\/span>php<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$dbhost <\/span>=<\/span> <\/span>'localhost'<\/span>;<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$dbuser <\/span>=<\/span> <\/span>'root'<\/span>;<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$dbpass <\/span>=<\/span> <\/span>'securepassword123'<\/span>;<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$dbname <\/span>=<\/span> <\/span>'eCommercedata'<\/span>;<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$mysqli <\/span>=<\/span> <\/span>new<\/span> <\/span>mysqli<\/span>($dbhost, $dbuser, $dbpass, $dbname);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    The next portion of the script will contain the INSERT query with the same information we used in the previous section. <\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    $sql <\/span>=<\/span> <\/span>\"<\/span>INSERT INTO<\/span> data_product1 \"<\/span>.<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"(size, color, price) \"<\/span>.<\/span>\"VALUES \"<\/span>.<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"('M','Blue','39.99$')\"<\/span>;<\/span><\/span>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>?><\/span>\u00a0\u00a0<\/span><\/span>\n\u00a0\u00a0\u00a0<\/span><\/<\/span>body<\/span>><\/span><\/span>\n<\/<\/span>html<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    Save this file as mysqli_insertexample.php for use with your web server. <\/p>\n\n\n\n
    Congratulations, you now know how to insert data using MySQLi!<\/p>\n\n\n
    Trust your business to an industry leader in fast and reliable website hosting solutions. InMotion Hosting offers secure web hosting<\/a> with 99.99% uptime, 24\/7 expert human support, and 100% money-back guarantee.<\/div>\n","protected":false},"excerpt":{"rendered":"
    Since newer versions of PHP no longer support the ability to insert data into a database using PHP extensions, users will need to make use of an extension such as MySQLi to insert data into their databases. Using MySQLi to insert data can be done directly in the command line or via PHP script. In Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4288,4305],"tags":[],"class_list":["post-1135","post","type-post","status-publish","format-standard","hentry","category-website","category-databases"],"acf":[],"yoast_head":"\nUsing MySQLi to Insert Data: MySQL Database Management<\/title>\n<meta name=\"description\" content=\"Looking to use PHP to insert data to your database? Learn how with this easy to follow article.\" \/>\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.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using MySQLi to Insert Data: MySQL Database Management\" \/>\n<meta property=\"og:description\" content=\"In this article we will discuss using MySQLi to insert data into MySQL databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-27T17:04:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-23T21:16:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\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:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"Using MySQLi to INSERT Data into a Database\",\"datePublished\":\"2012-01-27T17:04:18+00:00\",\"dateModified\":\"2024-07-23T21:16:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\"},\"wordCount\":364,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image-1024x538.png\",\"articleSection\":[\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\",\"name\":\"Using MySQLi to Insert Data: MySQL Database Management\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image-1024x538.png\",\"datePublished\":\"2012-01-27T17:04:18+00:00\",\"dateModified\":\"2024-07-23T21:16:54+00:00\",\"description\":\"Looking to use PHP to insert data to your database? Learn how with this easy to follow article.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image.png\",\"width\":1200,\"height\":630,\"caption\":\"using mysqli to insert data hero image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using MySQLi to INSERT Data into a Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using MySQLi to Insert Data: MySQL Database Management","description":"Looking to use PHP to insert data to your database? Learn how with this easy to follow article.","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.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/","og_locale":"en_US","og_type":"article","og_title":"Using MySQLi to Insert Data: MySQL Database Management","og_description":"In this article we will discuss using MySQLi to insert data into MySQL databases.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-01-27T17:04:18+00:00","article_modified_time":"2024-07-23T21:16:54+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image.png","type":"image\/png"}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"Using MySQLi to INSERT Data into a Database","datePublished":"2012-01-27T17:04:18+00:00","dateModified":"2024-07-23T21:16:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/"},"wordCount":364,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image-1024x538.png","articleSection":["Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/","name":"Using MySQLi to Insert Data: MySQL Database Management","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image-1024x538.png","datePublished":"2012-01-27T17:04:18+00:00","dateModified":"2024-07-23T21:16:54+00:00","description":"Looking to use PHP to insert data to your database? Learn how with this easy to follow article.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/08\/using-mysqli-to-insert-data-hero-image.png","width":1200,"height":630,"caption":"using mysqli to insert data hero image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/using-mysqli-to-insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Using MySQLi to INSERT Data into a Database"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4305,"name":"Working with Databases","slug":"databases","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=1135"}],"version-history":[{"count":9,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1135\/revisions"}],"predecessor-version":[{"id":128451,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1135\/revisions\/128451"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=1135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=1135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=1135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}