{"id":207,"date":"2009-05-30T20:42:00","date_gmt":"2009-05-30T19:42:00","guid":{"rendered":"http:\/\/www.withinweb.com\/info\/?p=207"},"modified":"2010-04-17T12:02:12","modified_gmt":"2010-04-17T12:02:12","slug":"extracting-data-from-myphpadmin","status":"publish","type":"post","link":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/","title":{"rendered":"Extracting data from myPHPAdmin"},"content":{"rendered":"<p>A question I am often asked is how can I create better reports from the data that is in the mySQL database for transactions processed by <a href=\"\/phpeseller\">PHPeSeller<\/a> or by <a href=\"\/phpsecurearea\/\">PHPSecureArea<\/a>.\u00a0 Both of these have sales history displays but you may wish to process the data in another application such as MS Excel or MS Access.<\/p>\n<p>One approach is to extract the data from mySQL using your web server control panel.\u00a0 Login into the control panel of your server and find the section that deals with mySQL.\u00a0 You should have a link to myPHPAdmin or a similar database tool.<\/p>\n<p>Navigate to the correct database in myPHPAdmin.\u00a0 Navigate to the table that you want to export and at the top of the page you should see an EXPORT tab.\u00a0 Click on this.\u00a0 You will need to select a particular format for the export. This is normally CSV for Excel or CSV.\u00a0 CSV stands for Comma Separted Values and is a very common method of transfering data to and from different application.\u00a0 That should then allow you to download the file which can then be opened in your required application.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A question I am often asked is how can I create better reports from the data that is in the mySQL database for transactions processed by PHPeSeller or by PHPSecureArea.\u00a0 Both of these have sales history displays but you may<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/\">Read more <span class=\"screen-reader-text\">Extracting data from myPHPAdmin<\/span><span class=\"meta-nav\"> &#8250;<\/span><\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[],"class_list":["post-207","post","type-post","status-publish","format-standard","hentry","category-php-eseller","category-php-securearea"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Extracting data from myPHPAdmin - PHP Web Applications<\/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.withinweb.com\/info\/extracting-data-from-myphpadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extracting data from myPHPAdmin - PHP Web Applications\" \/>\n<meta property=\"og:description\" content=\"A question I am often asked is how can I create better reports from the data that is in the mySQL database for transactions processed by PHPeSeller or by PHPSecureArea.\u00a0 Both of these have sales history displays but you may&hellip;Read more Extracting data from myPHPAdmin &#8250;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"PHP Web Applications\" \/>\n<meta property=\"article:published_time\" content=\"2009-05-30T19:42:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-04-17T12:02:12+00:00\" \/>\n<meta name=\"author\" content=\"paulv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"paulv\" \/>\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.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/\"},\"author\":{\"name\":\"paulv\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#\\\/schema\\\/person\\\/04da5531c302d55ffcd777fe81dbb93c\"},\"headline\":\"Extracting data from myPHPAdmin\",\"datePublished\":\"2009-05-30T19:42:00+00:00\",\"dateModified\":\"2010-04-17T12:02:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/\"},\"wordCount\":191,\"commentCount\":0,\"articleSection\":[\"PHP-eSeller\",\"PHP-SecureArea\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/\",\"url\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/\",\"name\":\"Extracting data from myPHPAdmin - PHP Web Applications\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#website\"},\"datePublished\":\"2009-05-30T19:42:00+00:00\",\"dateModified\":\"2010-04-17T12:02:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#\\\/schema\\\/person\\\/04da5531c302d55ffcd777fe81dbb93c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/extracting-data-from-myphpadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extracting data from myPHPAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#website\",\"url\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/\",\"name\":\"PHP Web Applications\",\"description\":\"Information and support for products of WithinWeb.com\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#\\\/schema\\\/person\\\/04da5531c302d55ffcd777fe81dbb93c\",\"name\":\"paulv\",\"url\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/author\\\/paulv\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extracting data from myPHPAdmin - PHP Web Applications","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.withinweb.com\/info\/extracting-data-from-myphpadmin\/","og_locale":"en_US","og_type":"article","og_title":"Extracting data from myPHPAdmin - PHP Web Applications","og_description":"A question I am often asked is how can I create better reports from the data that is in the mySQL database for transactions processed by PHPeSeller or by PHPSecureArea.\u00a0 Both of these have sales history displays but you may&hellip;Read more Extracting data from myPHPAdmin &#8250;","og_url":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/","og_site_name":"PHP Web Applications","article_published_time":"2009-05-30T19:42:00+00:00","article_modified_time":"2010-04-17T12:02:12+00:00","author":"paulv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"paulv","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/#article","isPartOf":{"@id":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/"},"author":{"name":"paulv","@id":"https:\/\/www.withinweb.com\/info\/#\/schema\/person\/04da5531c302d55ffcd777fe81dbb93c"},"headline":"Extracting data from myPHPAdmin","datePublished":"2009-05-30T19:42:00+00:00","dateModified":"2010-04-17T12:02:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/"},"wordCount":191,"commentCount":0,"articleSection":["PHP-eSeller","PHP-SecureArea"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/","url":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/","name":"Extracting data from myPHPAdmin - PHP Web Applications","isPartOf":{"@id":"https:\/\/www.withinweb.com\/info\/#website"},"datePublished":"2009-05-30T19:42:00+00:00","dateModified":"2010-04-17T12:02:12+00:00","author":{"@id":"https:\/\/www.withinweb.com\/info\/#\/schema\/person\/04da5531c302d55ffcd777fe81dbb93c"},"breadcrumb":{"@id":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.withinweb.com\/info\/extracting-data-from-myphpadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.withinweb.com\/info\/"},{"@type":"ListItem","position":2,"name":"Extracting data from myPHPAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.withinweb.com\/info\/#website","url":"https:\/\/www.withinweb.com\/info\/","name":"PHP Web Applications","description":"Information and support for products of WithinWeb.com","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.withinweb.com\/info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.withinweb.com\/info\/#\/schema\/person\/04da5531c302d55ffcd777fe81dbb93c","name":"paulv","url":"https:\/\/www.withinweb.com\/info\/author\/paulv\/"}]}},"_links":{"self":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts\/207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":4,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts\/207\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}