silbinarywolf/php-wordpress-database-tools

A set of classes for connecting to a Wordpress database and querying it. The point of this library is to easily and effeciently iterate over Wordpress data and import into other CMS systems.

1.1.0 2016-08-09 03:23 UTC

README

A set of classes for connecting to a Wordpress database and querying it. The point of this library is to easily and effeciently iterate over Wordpress data and import into other CMS systems.

Quick Start

  • Set Wordpress Database config details
<?php
$wpDB = new WordpressDatabase(array(
    'database'       => 'wordpress-database',
    'username'       => 'root',
    'password'       => '',
    'table_prefix'   => 'wp'
));
  • Loop over Wordpress data and do what you want with it.
<?php
foreach ($wpDB->getPages() as $wpData) {
    $wpMeta = $wpDB->attachAndGetPostMeta($wpData);

    $newRecord = array();
    $newRecord['Title'] = $wpDB->process('post_title', $wpData['post_title']);
    $newRecord['Permalink'] = $wpData['post_name'];
    $newRecord['Content'] = $wpDB->process('post_content', $wpData['post_content']);
    $newRecord['Created'] = $wpData['post_date'];
    $newRecord['LastEdited'] = $wpData['post_modified'];
    $newRecord['WordpressData'] = $wpData; // Since 'attachAndGetPostMeta' attaches the meta to $wpData, it'll store that too.
}