protected function _insertTestData()
{
register_taxonomy('public_taxonomy_a', array('post', 'page'), array('public' => true));
register_taxonomy('private_taxonomy_a', array('post'), array('public' => false));
$post_id_a = wp_insert_post(array('post_status' => 'publish', 'post_type' => 'post', 'post_author' => 1, 'post_parent' => 0, 'menu_order' => 0, 'post_content_filtered' => '', 'post_excerpt' => 'This is the excerpt.', 'post_content' => 'This is the content.', 'post_title' => 'Hello World A!', 'post_date' => '2013-04-30 20:33:36', 'post_date_gmt' => '2013-04-30 20:33:36', 'comment_status' => 'open'));
$post_id_b = wp_insert_post(array('post_status' => 'publish', 'post_type' => 'post', 'post_author' => 1, 'post_parent' => 0, 'menu_order' => 0, 'post_content_filtered' => '', 'post_excerpt' => 'This is the excerpt.', 'post_content' => 'This is the content.', 'post_title' => 'Hello World B!', 'post_date' => '2013-04-30 20:33:36', 'post_date_gmt' => '2013-04-30 20:33:36', 'comment_status' => 'open'));
$term_a = wp_create_term('Term In Both', 'public_taxonomy_a');
$term_b = wp_create_term('Term In A', 'public_taxonomy_a');
$term_c = wp_create_term('Term In B', 'public_taxonomy_a');
$term_d = wp_create_term('Term In None', 'public_taxonomy_a');
$term_e = wp_create_term('Term In Private', 'private_taxonomy_a');
wp_set_object_terms($post_id_a, array(intval($term_a['term_id']), intval($term_b['term_id'])), 'public_taxonomy_a');
wp_set_object_terms($post_id_b, array(intval($term_c['term_id'])), 'public_taxonomy_a');
wp_set_object_terms($post_id_a, array(intval($term_e['term_id'])), 'private_taxonomy_a');
return compact('post_id_a', 'post_id_b', 'term_a', 'term_b', 'term_c', 'term_d', 'term_e');
}
/**
* Add a new tag to the database if it does not already exist.
*
* @since 2.3.0
*
* @param int|string $tag_name
* @return array|WP_Error
*/
function wp_create_tag($tag_name)
{
return wp_create_term($tag_name, 'post_tag');
}
/**
* Save our data once the user publishes or saves their post.
*/
function wanderlist_save_metabox_data($post_id, $post, $update)
{
// Make sure our nonce has been correctly set.
if (!isset($_POST['meta-box-nonce']) || !wp_verify_nonce($_POST['meta-box-nonce'], basename(__FILE__))) {
return $post_id;
}
// Make sure the user has permissions to edit this post.
if (!current_user_can('edit_post', $post_id)) {
return $post_id;
}
// If we're autosaving, don't worry about it right now.
if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
return $post_id;
}
// Check to ensure that our post type is the same as our meta box post type.
if ('wanderlist-location' !== $post->post_type) {
return $post_id;
}
// If we've passed all those checks, we should be good to save! Let's go.
if (isset($_POST['wanderlist-geolocation'])) {
$geolocation_value = sanitize_text_field($_POST['wanderlist-geolocation']);
// Store city name, lat and long as post meta.
$lng_value = sanitize_text_field($_POST['wanderlist-lng']);
$lat_value = sanitize_text_field($_POST['wanderlist-lat']);
$city_value = sanitize_text_field($_POST['wanderlist-city']);
$region_value = sanitize_text_field($_POST['wanderlist-region']);
// Store our country as a term in our custom "country" taxonomy.
$country_value = sanitize_text_field($_POST['wanderlist-country']);
// This creates a term if one doesn't already exist, or selects the existing term.
$country_term = wp_create_term($country_value, 'wanderlist-country');
// Make sure our term id is a string (because nobody wants to go to "148" country).
if (is_string($country_term['term_id'])) {
$country_term['term_id'] = (int) $country_term['term_id'];
}
// Remove all country associations and set our new country.
wp_set_object_terms($post_id, $country_term['term_id'], 'wanderlist-country');
// Update post meta.
update_post_meta($post_id, 'wanderlist-location-string', $geolocation_value);
update_post_meta($post_id, 'wanderlist-city', $city_value);
update_post_meta($post_id, 'wanderlist-region', $region_value);
update_post_meta($post_id, 'wanderlist-lat', $lat_value);
update_post_meta($post_id, 'wanderlist-lng', $lng_value);
} else {
$geolocation_value = '';
$lng_value = '';
$lat_value = '';
$city_value = '';
}
if (isset($_POST['wanderlist-arrival-date'])) {
$arrival_date_value = sanitize_text_field($_POST['wanderlist-arrival-date']);
} else {
$arrival_date_value = '';
}
if (isset($_POST['wanderlist-departure-date'])) {
$departure_date_value = sanitize_text_field($_POST['wanderlist-departure-date']);
} else {
$depature_date_value = '';
}
update_post_meta($post_id, 'wanderlist-arrival-date', $arrival_date_value);
update_post_meta($post_id, 'wanderlist-departure-date', $departure_date_value);
}
include "../wp-admin/includes/taxonomy.php";
include "adodb5/adodb.inc.php";
include "adodb5/adodb-exceptions.inc.php";
$DB = ADONewConnection($dbdriver);
# eg 'mysql' or 'postgres'
$DB->debug = false;
$DB->SetCharSet('utf8');
// for mysql
$DB->SetFetchMode(2);
// for mysql
$DB->Connect($server, $user, $password, $database);
$subjects = $DB->GetAll("SELECT * FROM `subject`");
global $wpdb;
foreach ($subjects as $subject) {
$tag_id = $wpdb->get_var("SELECT MAX(`term_id`) FROM `wp_terms`");
$tag = wp_create_term($subject['name']);
echo $tag_id;
// $DB->query("INSERT INTO `subject_to_tag` (`subject_id`, `tag_id`) VALUES (".$subject['id'].", ".$tag_id.")");
}
$count = $DB->GetOne("SELECT COUNT(*) FROM `subject_to_tag`");
?>
<html>
<head>
<meta charset='UTF-8' />
</head>
<body>
<?php
echo $count;
?>
