get TablePress IDs / Names

  • Resolved Clickadelic

    (@clickadelic)


    8 years, 11 months ago

    Hi,

    Thank you for creating Tablepress and sorry for asking this question. I’m writing a plugin and would like to integrate an option to attach a TablePress Table to my CPT.

    In order to do this, I would like to get all TablePress IDs with their attached name to it.

    I have found this topic:
    https://ww.wp.xz.cn/support/topic/where-is-tablepress-id-stored-in-db/

    My goal is very much like this plugin:
    https://ww.wp.xz.cn/plugins/acf-tablepress/

    Querying the database should be done with WPDB Object, right?

    I would like to make a dropdown <select> list with all tables (IDs) in it.

    My question:
    How do I query the options table for this?
    “SELECT * FROM WP_OPTIONS WHERE tablepress_tables ????”

    Thanks for a short hint

    Clickadelic

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 11 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    You should not have to use a direct SQL query here. To get that entry from the wp_options database table, the WordPress PHP function get_option() would be sufficient. However, you would only get the table IDs with that, not the table names.
    I therefore recommend to instead use the TablePress PHP function

    $table_ids = TablePress::$model_table->load_all( true );

    and then loop through this array with

    $tables = array();
foreach ( $table_ids as $table_id ) {
	// Load table, without table data, options, and visibility settings.
	$table = TablePress::$model_table->load( $table_id, false, false );
	$tables[ $table['id'] ] = $table['name'];
}

    to get an array of all tables.

    Regards,
    Tobias

    Thread Starter Clickadelic

    (@clickadelic)

    8 years, 11 months ago

    Thank you for your fast answer – this solution works like a charm and is exactly what I needed. I’m amazed. Thank you very much!

    • This reply was modified 8 years, 11 months ago by Clickadelic.
    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 11 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

    dhurgakrishnan

    (@dhurgakrishnan)

    8 years, 5 months ago

    Hi,

    How to get table datas

    I need mysql query to get particular data from tablepress in where condition

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 5 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Sorry, this is not possible, because TablePress does not directly use a mySQL table. Therefore, such queries are not possible.
    To show a table with only some rows, you can try https://tablepress.org/extensions/row-filter/

    Regards,
    Tobias

    dhurgakrishnan

    (@dhurgakrishnan)

    8 years, 5 months ago

    This is my link http://fimqatar.com/registration/?coursename=PMP(%20PMI-USA)
    i need to get particular details for course name PMP( PMI-USA)

    <?php
    $table_ids = TablePress::$model_table->load_all( true );

    foreach ( $table_ids as $table_id ) {
    // Load table, without table data, options, and visibility settings.
    $table = TablePress::$model_table->load( $table_id, true, false );
    $tables = $table[‘data’];

    }
    print_r($tables);
    ?>
    I used this codings. I need batch schedule for dynamic course name .please tell me is there any option to satisfy my requirement.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 5 months ago

    Hi,

    now that you have the table data in the $table['data'] array, you can loop through it and try to find the correct row.

    Regards,
    Tobias

    dhurgakrishnan

    (@dhurgakrishnan)

    8 years, 5 months ago

    Thank you for your reply

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 5 months ago

    Hi,

    sure, no problem!

    Best wishes,
    Tobias

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

The topic ‘get TablePress IDs / Names’ is closed to new replies.