{"id":5329,"date":"2023-03-30T17:39:51","date_gmt":"2023-03-30T12:09:51","guid":{"rendered":"https:\/\/designcollection.in\/blog\/?p=5329"},"modified":"2023-10-17T17:41:48","modified_gmt":"2023-10-17T12:11:48","slug":"import-csv-to-mysql-using-php-file-read","status":"publish","type":"post","link":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/","title":{"rendered":"Import CSV to Mysql using PHP File Read"},"content":{"rendered":"

Import CSV to Mysql using PHP File Read<\/h1>\r\n

There are many ways to implement CSV import. We have seen one or two examples of it previously. Even, this article gives two examples on CSV to MySQL import To import a CSV file into a MySQL database using PHP, you can follow these steps and use the following code as an example. In this example, we’ll assume you have a CSV file named “data.csv” with columns “column1,” “column2,” and “column3,” and you want to import it into a MySQL table named “mytable.”.<\/p>\r\n

Target MySQL database<\/h2>\r\n
\r\nCREATE TABLE `tbl_users` (\r\n  `id` int(11) NOT NULL,\r\n  `userName` varchar(255) NOT NULL,\r\n  `firstName` varchar(255) NOT NULL,\r\n  `lastName` varchar(255) NOT NULL,\r\n  `create_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()\r\n);\r\nALTER TABLE `tbl_users`\r\n  ADD PRIMARY KEY (`id`);\r\n\r\nALTER TABLE `tbl_users`\r\n  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\r\n<\/pre>\r\n
HTML form to choose CSV source<\/h4>\r\n
This HTML form allows users to choose the CSV source file. It accepts CSV and Excel files to read data to import.<\/p>\r\n\r\n
index.php (Import Form)<\/h4>\r\n\"csv-2\"\r\n
CSS and JavaScript validation script<\/h5>\r\n
The above form calls the validation script on submit. The validation script is in JavaScript to check if the file input is not empty. It is in the head section of the same index.php page.<\/p>\r\n
index.php (Validation) add in script tag top of the head<\/h5>\r\n
\r\nfunction validateFile() {\r\n    var csvInputFile = document.forms[\"frmCSVImport\"][\"file\"].value;\r\n    if (csvInputFile == \"\") {\r\n      error = \"No source found to import. Please choose a CSV file. \";\r\n      $(\"#response\").html(error).addClass(\"error\");;\r\n      return false;\r\n    }\r\n    return true;\r\n  }\r\n\r\n<\/pre>\r\n\"csv-6\"\r\n
CSV to MySQL import in PHP<\/h5>\r\n
On submitting the form, the PHP code triggers the CSV read handler. The readUserRecords() function of the UserModel class is doing this CSV parsing.<\/p>\r\n\r\n
index.php (php code add top of the page)<\/h5>\r\n
\r\nnamespace Phppot;\r\n\r\nuse Phppot\\DataSource;\r\nrequire_once __DIR__ . '\/lib\/UserModel.php';\r\n$userModel = new UserModel();\r\nif (isset($_POST[\"import\"])) {\r\n    $response = $userModel->readUserRecords();\r\n}\r\n\r\n<\/pre>\r\n
and the UserModel class contains the functions to do the following.<\/p>\r\n
    \r\n
  1. Read CSV data using PHP fgetcsv()<\/p><\/li>\r\n
  2. Verify CSV to ignore empty rows.<\/p><\/li>\r\n
  3. Read all imported data from the MySQL database.<\/p><\/li>\r\n<\/ol>\r\n
    This model class connects the database in its constructor and set the connection object.<\/p>\r\n
    UserModel.php<\/h5>\r\n
    \r\n\r\nnamespace Phppot;\r\n\r\nuse Phppot\\DataSource;\r\n\r\nclass UserModel\r\n{\r\n\r\n    private $conn;\r\n\r\n    function __construct()\r\n    {\r\n        require_once 'DataSource.php';\r\n        $this->conn = new DataSource();\r\n    }\r\n\r\n    function getAllUser()\r\n    {\r\n        $sqlSelect = \"SELECT * FROM users\";\r\n        $result = $this->conn->select($sqlSelect);\r\n        return $result;\r\n    }\r\n\r\n    function readUserRecords()\r\n    {\r\n        $fileName = $_FILES[\"file\"][\"tmp_name\"];\r\n        if ($_FILES[\"file\"][\"size\"] > 0) {\r\n            $file = fopen($fileName, \"r\");\r\n            $importCount = 0;\r\n            while (($column = fgetcsv($file, 10000, \",\")) !== FALSE) {\r\n                if (! empty($column) && is_array($column)) {\r\n                    if ($this->hasEmptyRow($column)) {\r\n                        continue;\r\n                    }\r\n                    if (isset($column[1], $column[3], $column[4])) {\r\n                        $userName = $column[1];\r\n                        $password = $column[2];\r\n                        $firstName = $column[3];\r\n                        $lastName = $column[4];\r\n                        $insertId = $this->insertUser($userName, $password, $firstName, $lastName);\r\n                        if (! empty($insertId)) {\r\n                            $output[\"type\"] = \"success\";\r\n                            $output[\"message\"] = \"Import completed.\";\r\n                            $importCount ++;\r\n                        }\r\n                    }\r\n                } else {\r\n                    $output[\"type\"] = \"error\";\r\n                    $output[\"message\"] = \"Problem in importing data.\";\r\n                }\r\n            }\r\n            if ($importCount == 0) {\r\n                $output[\"type\"] = \"error\";\r\n                $output[\"message\"] = \"Duplicate data found.\";\r\n            }\r\n            return $output;\r\n        }\r\n    }\r\n\r\n    function hasEmptyRow(array $column)\r\n    {\r\n        $columnCount = count($column);\r\n        $isEmpty = true;\r\n        for ($i = 0; $i < $columnCount; $i ++) {\r\n            if (! empty($column[$i]) || $column[$i] !== '') {\r\n                $isEmpty = false;\r\n            }\r\n        }\r\n        return $isEmpty;\r\n    }\r\n\r\n    function insertUser($userName, $password, $firstName, $lastName)\r\n    {\r\n        $sql = \"SELECT userName FROM users WHERE userName = ?\";\r\n        $paramType = \"s\";\r\n        $paramArray = array(\r\n            $userName\r\n        );\r\n        $result = $this->conn->select($sql, $paramType, $paramArray);\r\n        $insertId = 0;\r\n        if (empty($result)) {\r\n            $hashedPassword = password_hash($password, PASSWORD_DEFAULT);\r\n            $sql = \"INSERT into users (userName,password,firstName,lastName)\r\n                       values (?,?,?,?)\";\r\n            $paramType = \"ssss\";\r\n            $paramArray = array(\r\n                $userName,\r\n                $hashedPassword,\r\n                $firstName,\r\n                $lastName\r\n            );\r\n            $insertId = $this->conn->insert($sql, $paramType, $paramArray);\r\n        }\r\n        return $insertId;\r\n    }\r\n}\r\n?>\r\n<\/pre>\r\n
    List imported data from the database<\/h5>\r\n
    This is for closing the CSV to MySQL import process loop. With this step, the user experiences that the import is completed successfully.<\/p>\r\n
    It shows the imported data on the screen. Instead of showing a static message like \u2018Imported successfully\u2019, this will give a good user experience.<\/p>\r\n
    list.php<\/h5>\r\n
    \r\n<?php<\/span>\r\nnamespace<\/span> \r\n$result<\/span> = $userModel<\/span>->getAllUser<\/span>();\r\nif<\/span> (! empty<\/span>($result<\/span>)) {\r\n    ?><\/span><\/span>\r\n<h3<\/span>><\/span>Imported records:<\/h3<\/span>><\/span>\r\n<table<\/span> id<\/span>='userTable'<\/span>><\/span>\r\n\t<thead<\/span>><\/span>\r\n\t\t<tr<\/span>><\/span>\r\n\t\t\t<th<\/span>><\/span>User Name<\/th<\/span>><\/span>\r\n\t\t\t<th<\/span>><\/span>First Name<\/th<\/span>><\/span>\r\n\t\t\t<th<\/span>><\/span>Last Name<\/th<\/span>><\/span>\r\n\t\t<\/tr<\/span>><\/span>\r\n\t<\/thead<\/span>><\/span>\r\n<\/span><?php<\/span>\r\n    foreach<\/span> ($result<\/span> as<\/span> $row<\/span>) {\r\n        ?><\/span><\/span>\r\n    <tbody<\/span>><\/span>\r\n\t\t<tr<\/span>><\/span>\r\n\t\t\t<td<\/span>><\/span><\/span><?php<\/span>  echo<\/span> $row<\/span>['userName'<\/span>]; ?><\/span><\/span><\/td<\/span>><\/span>\r\n\t\t\t<td<\/span>><\/span><\/span><?php<\/span>  echo<\/span> $row<\/span>['firstName'<\/span>]; ?><\/span><\/span><\/td<\/span>><\/span>\r\n\t\t\t<td<\/span>><\/span><\/span><?php<\/span>  echo<\/span> $row<\/span>['lastName'<\/span>]; ?><\/span><\/span><\/td<\/span>><\/span>\r\n\t\t<\/tr<\/span>><\/span>\r\n                    <\/span><?php<\/span>\r\n    }\r\n    ?><\/span><\/span>\r\n    <\/tbody<\/span>><\/span>\r\n<\/table<\/span>><\/span>\r\n<\/span><?php<\/span> \r\n} \r\n?><\/span><\/span>\r\n<\/span><\/code>\r\n\r\n<\/pre>\r\n
    Output: CSV to MySQL import<\/h5>\r\n\"forms-csv\"\r\n\r\n
    \r\n    \r\n    
    Download Source Code<\/a><\/h5>    \r\n    <\/div>\r\n\r\n\r\n
     PHP<\/span>MySQL  <\/span>CSV File<\/span>Javascript <\/span>WordPress <\/span><\/h5>\r\n\r\n","protected":false},"excerpt":{"rendered":"
    Import CSV to Mysql using PHP File Read There are many ways to implement CSV import. We have seen one or two examples of it previously. Even, this article gives two examples on CSV to MySQL import To import a CSV file into a MySQL database using PHP, you can follow these steps and use […]<\/p>\n","protected":false},"author":1,"featured_media":5330,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[282],"tags":[463,372,350,284,380],"class_list":["post-5329","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-csv-file","tag-javascript","tag-mysql","tag-php","tag-wordpress"],"yoast_head":"\nImport CSV to Mysql using PHP File<\/title>\n<meta name=\"description\" content=\"Import CSV to Mysql using PHP File\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import CSV to Mysql using PHP File\" \/>\n<meta property=\"og:description\" content=\"Import CSV to Mysql using PHP File\" \/>\n<meta property=\"og:url\" content=\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog is an ocean of knowledge\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/designcollection.in\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-30T12:09:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-17T12:11:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/designcollection.in\/blog\/wp-content\/uploads\/2023\/03\/Import-CSV-to-Mysql-using-PHP-File-Read.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1300\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"designcollection\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"designcollection\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\"},\"author\":{\"name\":\"designcollection\",\"@id\":\"https:\/\/designcollection.in\/blog\/#\/schema\/person\/612562f8760f1b42e074b2a2e84bdd67\"},\"headline\":\"Import CSV to Mysql using PHP File Read\",\"datePublished\":\"2023-03-30T12:09:51+00:00\",\"dateModified\":\"2023-10-17T12:11:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\"},\"wordCount\":343,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/designcollection.in\/blog\/#organization\"},\"keywords\":[\"CSV File\",\"Javascript\",\"MYSQL\",\"PHP\",\"Wordpress\"],\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\",\"url\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\",\"name\":\"Import CSV to Mysql using PHP File\",\"isPartOf\":{\"@id\":\"https:\/\/designcollection.in\/blog\/#website\"},\"datePublished\":\"2023-03-30T12:09:51+00:00\",\"dateModified\":\"2023-10-17T12:11:48+00:00\",\"description\":\"Import CSV to Mysql using PHP File\",\"breadcrumb\":{\"@id\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/designcollection.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import CSV to Mysql using PHP File Read\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/designcollection.in\/blog\/#website\",\"url\":\"https:\/\/designcollection.in\/blog\/\",\"name\":\"Design Collection\",\"description\":\"Technology Tips, Tutorials, Learning & How to Guides\",\"publisher\":{\"@id\":\"https:\/\/designcollection.in\/blog\/#organization\"},\"alternateName\":\"IT Services | Best Lead Generation Company In Indore - Design Collection\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/designcollection.in\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/designcollection.in\/blog\/#organization\",\"name\":\"Design Collection\",\"alternateName\":\"IT Services | Best Lead Generation Company In Indore - Design Collection\",\"url\":\"https:\/\/designcollection.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/designcollection.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/designcollection.in\/blog\/wp-content\/uploads\/2022\/12\/design-collection.png\",\"contentUrl\":\"https:\/\/designcollection.in\/blog\/wp-content\/uploads\/2022\/12\/design-collection.png\",\"width\":240,\"height\":41,\"caption\":\"Design Collection\"},\"image\":{\"@id\":\"https:\/\/designcollection.in\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/designcollection.in\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/designcollection.in\/blog\/#\/schema\/person\/612562f8760f1b42e074b2a2e84bdd67\",\"name\":\"designcollection\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/designcollection.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e791d735751a16b72683b42279ea62b4bcfcbe6dd200da2f7240cdeae878c3ff?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e791d735751a16b72683b42279ea62b4bcfcbe6dd200da2f7240cdeae878c3ff?s=96&d=mm&r=g\",\"caption\":\"designcollection\"},\"sameAs\":[\"https:\/\/designcollection.in\/blog\/\"],\"url\":\"https:\/\/designcollection.in\/blog\/author\/designcollection\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import CSV to Mysql using PHP File","description":"Import CSV to Mysql using PHP File","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:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/","og_locale":"en_US","og_type":"article","og_title":"Import CSV to Mysql using PHP File","og_description":"Import CSV to Mysql using PHP File","og_url":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/","og_site_name":"Blog is an ocean of knowledge","article_publisher":"https:\/\/www.facebook.com\/designcollection.in","article_published_time":"2023-03-30T12:09:51+00:00","article_modified_time":"2023-10-17T12:11:48+00:00","og_image":[{"width":1300,"height":1000,"url":"https:\/\/designcollection.in\/blog\/wp-content\/uploads\/2023\/03\/Import-CSV-to-Mysql-using-PHP-File-Read.jpg","type":"image\/jpeg"}],"author":"designcollection","twitter_card":"summary_large_image","twitter_misc":{"Written by":"designcollection","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#article","isPartOf":{"@id":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/"},"author":{"name":"designcollection","@id":"https:\/\/designcollection.in\/blog\/#\/schema\/person\/612562f8760f1b42e074b2a2e84bdd67"},"headline":"Import CSV to Mysql using PHP File Read","datePublished":"2023-03-30T12:09:51+00:00","dateModified":"2023-10-17T12:11:48+00:00","mainEntityOfPage":{"@id":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/"},"wordCount":343,"commentCount":0,"publisher":{"@id":"https:\/\/designcollection.in\/blog\/#organization"},"keywords":["CSV File","Javascript","MYSQL","PHP","Wordpress"],"articleSection":["PHP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/","url":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/","name":"Import CSV to Mysql using PHP File","isPartOf":{"@id":"https:\/\/designcollection.in\/blog\/#website"},"datePublished":"2023-03-30T12:09:51+00:00","dateModified":"2023-10-17T12:11:48+00:00","description":"Import CSV to Mysql using PHP File","breadcrumb":{"@id":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/designcollection.in\/blog\/import-csv-to-mysql-using-php-file-read\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/designcollection.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Import CSV to Mysql using PHP File Read"}]},{"@type":"WebSite","@id":"https:\/\/designcollection.in\/blog\/#website","url":"https:\/\/designcollection.in\/blog\/","name":"Design Collection","description":"Technology Tips, Tutorials, Learning & How to Guides","publisher":{"@id":"https:\/\/designcollection.in\/blog\/#organization"},"alternateName":"IT Services | Best Lead Generation Company In Indore - Design Collection","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/designcollection.in\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/designcollection.in\/blog\/#organization","name":"Design Collection","alternateName":"IT Services | Best Lead Generation Company In Indore - Design Collection","url":"https:\/\/designcollection.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/designcollection.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/designcollection.in\/blog\/wp-content\/uploads\/2022\/12\/design-collection.png","contentUrl":"https:\/\/designcollection.in\/blog\/wp-content\/uploads\/2022\/12\/design-collection.png","width":240,"height":41,"caption":"Design Collection"},"image":{"@id":"https:\/\/designcollection.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/designcollection.in"]},{"@type":"Person","@id":"https:\/\/designcollection.in\/blog\/#\/schema\/person\/612562f8760f1b42e074b2a2e84bdd67","name":"designcollection","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/designcollection.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e791d735751a16b72683b42279ea62b4bcfcbe6dd200da2f7240cdeae878c3ff?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e791d735751a16b72683b42279ea62b4bcfcbe6dd200da2f7240cdeae878c3ff?s=96&d=mm&r=g","caption":"designcollection"},"sameAs":["https:\/\/designcollection.in\/blog\/"],"url":"https:\/\/designcollection.in\/blog\/author\/designcollection\/"}]}},"_links":{"self":[{"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/posts\/5329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/comments?post=5329"}],"version-history":[{"count":24,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/posts\/5329\/revisions"}],"predecessor-version":[{"id":6043,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/posts\/5329\/revisions\/6043"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/media\/5330"}],"wp:attachment":[{"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/media?parent=5329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/categories?post=5329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/designcollection.in\/blog\/wp-json\/wp\/v2\/tags?post=5329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}