{"id":55514,"date":"2014-11-13T21:56:16","date_gmt":"2014-11-13T21:56:16","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/db-access\/"},"modified":"2014-11-17T00:51:59","modified_gmt":"2014-11-17T00:51:59","slug":"db-access","status":"closed","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/db-access\/","author":10226297,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"0.8.7","stable_tag":"trunk","tested":"4.0.38","requires":"3.8","requires_php":"","requires_plugins":"","header_name":"db-access","header_author":"Jim Sward","header_description":"","assets_banners_color":"","last_updated":"2014-11-17 00:51:59","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"http:\/\/jimsward.com\/db-access","header_author_uri":"http:\/\/JimSward.com","rating":0,"author_block_rating":0,"active_installs":0,"downloads":2015,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["printing, manipulating the contents of HTML tables derived  ","description","installation","faq","screenshots","changelog"],"tags":[],"upgrade_notice":[],"ratings":[],"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":[],"screenshots":[]},"plugin_section":[],"plugin_tags":[],"plugin_category":[],"plugin_contributors":[],"plugin_business_model":[],"class_list":["post-55514","plugin","type-plugin","status-closed","hentry","plugin_committers-jimbob1953"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/db-access.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=printing, manipulating the contents of HTML tables derived  -->\nfrom tables found in your database.\n\n<!--section=description-->\n<p>The plugin gets a list of all the tables in your database - the standard tables created by WordPress and any other \ntables present - and creates a dropdown list. The user chooses one of the tables. A sortable HTML table is created. \nYou can filter the rows using regular expressions, change the contents of individual cells, choose which columns \nto display, and print the resulting table and\/or export it to a csv file to contemplate in a spreadsheet. \nPagination is possible - or not. All these features are optional and can be turned off\/on in the settings page.\nMost of the features are on by default. The feature that can change individual cells in the database is off\nby default due to the possible consequences of most any kind of change to the database. \nThere is a feature that hightlights the row and column of a cell when you mouseover the cell.<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the plugin to the <code>\/wp-content\/plugins\/<\/code> directory<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n<\/ol>\n\n<!--section=faq-->\n<p>= Is there a search function?<\/p>\n\n<p>You can filter any column by entering a regular expression in the box at the top of that column.<\/p>\n\n<p>= Can I make changes to the database?<\/p>\n\n<p>You can edit the contents of nearly any cell and it will be saved to the database. The first column in\neach row is not editable as it is the index field. This feature is turned off by default.\nUse the settings page to turn it on or to turn off any features you don't want\/need.\nWith the feature turned off, you can still make changes onscreen. But, they won't be saved to the database.\nIf you are going to make any changes, be sure to have a current backup of your database available.\nYou do regularly backup your database, don't you?<\/p>\n\n<!--section=screenshots-->\n<p>The table as it is typically displayed with captions describing various functions.<\/p>\n\n<!--section=changelog-->\n<h4>0.8.6<\/h4>\n\n<p>=\nMoved all the AJAX handlers to db-access.php\nSanitized contents of $_POST<\/p>\n\n<h4>0.8.5<\/h4>\n\n<p>=\nMinor housekeeping<\/p>\n\n<h4>0.8.4<\/h4>\n\n<p>=\nAgain with the dialog box<\/p>\n\n<h4>0.8.3<\/h4>\n\n<p>=\nFixed dialog box height\nReadme<\/p>\n\n<h4>0.8.2<\/h4>\n\n<p>=\nFixed headers problem<\/p>\n\n<h4>0.8.1<\/h4>\n\n<p>=\nPlugin doesn't need to know name of containing folder.<\/p>\n\n<h4>0.8.0<\/h4>\n\n<ul>\n<li>Added feature to change cells in the database.<\/li>\n<li>Added Crosshair, a jQuery plugin to highlight a cell's column and row on mouseover.<\/li>\n<\/ul>","raw_excerpt":"A tool for viewing, sorting, searching, exporting,","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/55514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=55514"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/jimbob1953"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=55514"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=55514"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=55514"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=55514"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=55514"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=55514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}