Title: metadata database
Last modified: August 31, 2016

---

# metadata database

 *  [mae48](https://wordpress.org/support/users/mae48/)
 * (@mae48)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/metadata-database/)
 * Hi, I want to output all the information I stored to my rate table wp database…
   
   how can I do that using this code…?? Or am I doing it right?Thanks
 * // add the settings under ‘General’ sub-menu
    add_action( ‘woocommerce_product_options_general_product_data’,‘
   ayg_add_custom_settings’ ); function ayg_add_custom_settings() { global $woocommerce,
   $post; echo ‘<div class=”options_group”>’; // Create dropdown for via woocommerce_wp_select(
   array( ‘id’ => ‘ayg_via’, ‘label’ => __( ‘Via’, ‘woocommerce’ ), ‘required’ =
   > false, ‘clear’ => false, ‘type’ => ‘select’, ‘options’ => array( ‘option_a’
   => __(‘cebu’, ‘woocommerce’ ), ‘option_b’ => __(‘clark’, ‘woocommerce’ ), ‘option_c’
   => __(‘davao’, ‘woocommerce’ ), ‘option_d’ => __(‘Iloilo’, ‘woocommerce’ ), ‘
   option_d’ => __(‘Manila’, ‘woocommerce’ ) )));
 *  echo ‘</div>’;
    // Create location woocommerce_wp_text_input( array( ‘id’ =>‘
   ayg_location’, ‘label’ => __(‘location’, ‘woocommerce’), ‘desc_tip’ =>’true’,‘
   description’ =>__(‘Enter location’,’woocommerce’) )); // Create Hotel name woocommerce_wp_text_input(
   array( ‘id’ => ‘ayg_hotel’, ‘label’ => __(‘hotel’, ‘woocommerce’) )); woocommerce_wp_text_input(
   array( ‘id’ => ‘ayg_hotel_price’, ‘label’ => __(‘hotel price’, ‘woocommerce’),‘
   type’ => ‘number’, ‘custom_attributes’ => array( ‘step’ => ‘any’, ‘min’ => ‘0’)));
   woocommerce_wp_text_input( array( ‘id’ => ‘ayg_mark_up’, ‘label’ => __(‘Mark 
   Up’, ‘woocommerce’), ‘type’ => ‘number’, ‘custom_attributes’ => array( ‘step’
   => ‘any’, ‘min’ => ‘0’ ) ));
 * }
    add_action( ‘woocommerce_process_product_meta’, ‘ayg_save_custom_settings’);
   function ayg_save_custom_settings( $post_id ){ //via $woocommerce_via = $_POST[‘
   ayg_via’]; if( !empty( $woocommerce_via ) ) update_post_meta( $post_id, ‘ayg_via’,
   esc_attr( $woocommerce_via ) ); // location $woocommerce_location = $_POST[‘ayg_location’];
   if( !empty( $woocommerce_location ) ) update_post_meta( $post_id, ‘ayg_location’,
   esc_attr( $woocommerce_location ) ); // hotel name $woocommerce_hotel = $_POST[‘
   ayg_hotel’]; if( !empty( $woocommerce_hotel ) ) update_post_meta( $post_id, ‘
   ayg_hotel’, esc_attr( $woocommerce_hotel ) ); // hotel price $woocommerce_hotel_price
   = $_POST[‘ayg_hotel_price’]; if( !empty( $woocommerce_hotel_price ) ) update_post_meta(
   $post_id, ‘ayg_hotel_price’, esc_attr( $woocommerce_hotel_price ) ); // Mark 
   Up $woocommerce_markup = $_POST[‘ayg_mark_up’]; if( !empty( $woocommerce_markup))
   update_post_meta( $post_id, ‘ayg_mark_up’, esc_attr( $woocommerce_markup ) );
   add_action( ‘woocommerce_product_write_panel_tabs’, ‘woo_add_custom_admin_product_tab’);}

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Steve North](https://wordpress.org/support/users/tex0gen/)
 * (@tex0gen)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/metadata-database/#post-7263265)
 * You can echo out any data saved in post meta fields by using:
 * `get_post_meta( $post_id, $key, $single );`
 * In your case, to output the “markup” (As commented in code above):
 * `echo get_post_meta($post_id, 'ayg_mark_up', true);`
 * [See here for documentation on get_post_meta();](https://developer.wordpress.org/reference/functions/get_post_meta/)
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/metadata-database/#post-7263291)
 * You said the data is “stored to my rate table”. I assume there is more rate information
   than the price and markup stored in post meta, and this data is in some kind 
   of separate, custom table.
 * You’ll need to use [$wpdb](http://codex.wordpress.org/Class_Reference/wpdb) methods
   to access your custom table. Exactly how that is done depends on how your rate
   data relates to the product posts.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘metadata database’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [metadata](https://wordpress.org/support/topic-tag/metadata/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 2 replies
 * 3 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/metadata-database/#post-7263291)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics