ka2

Yes, normally you can set up from plugin’s management console. If you want to change the number of rows that displayed on one page, you press the Alter table button of change table schema column from the “Setting” > “Enable tables list”.
Then, you enter any number in the item of “Show Max Records” and press “Modify table” button in the Modify table tab.

In addition, because pagination of data list will be generated automatically, you do not must set the anything.

Otherwise, option is to use a shortcode of “cdbt-extract” that was added in version 1.1.7.
Format will be as follows.

[cdbt-extract table="{string}" bootstrap_style="{boolean}" display_index_row="{boolean}" narrow_keyword="{string[,string,...]}" display_cols="{string[,string,...]}" order_cols="{string[,string,...]}" sort_order="{string[,string,...]}" limit_items="{int}" add_class="{string[ string...]}" ]

In this shortcode, You can specify the number of data that displayed on one page to the attribute value of “limit_items”.

Detailed specification of this shortcode have describing here (Sorry, currently Japanese only).

Thanks for the question!

Sorry, the current version does not correspond with the connection to the external database other than the database that WordPress is installed.

However, in future, probably in about version 1.2.x, I have thought want to add feature as follows that connect to an external database table and manage WordPress core table, manage the database other than MySQL.

Thank you for your question!

The following is the answer.

Unfortunately, customization of registration and edit form is not possible at this version. I plan to add the edit function of the entry form in future versions. Until then, you can customize by adding your own CSS and JavaScript by using, for example, “bootstrap_style=false” and “add_class=<class name>” into attribute in the shortcode of [cdbt-entry].

Please wait until the version with that add feature.

Finally, I could grasp the cause of the defect.
It was a failure of jQuery UI of only in a particular browser.

Sortable content of jQuery UI in some browsers, such as Firefox is I have resolved the problem that no longer can be selected.

The latest version 1.1.8 you have bug fixes has been released. Please try by all means to check the operation.

I’m sorry reply becomes slow.

The edit button in the content that is output in the shortcode of cdbt-edit is not display, because in the target page specified “entry_page=375″ (page of post ID 375) does not have the shortcode of [cdbt-entry table=”wp_aptos”].

However, since in the admin panel is shortcodes with each other [cdbt-edit] and [cdbt-entry] will not cooperate. It will may work if you include pages is wrote a shortcode in the IFRAME.

Hmm. I’m sorry.

If you had a JavaScript error when the component as table creator does not work, Please tell me the error contents.

Thank you for your inquiry.

I have adjusted the JavaScript reading order of the management panel in the release version 1.1.6 on today. I might have eliminated problems caused by JavaScript conflicts Maybe in this version.

Sorry to trouble you but, please try the movement of the plugin in the new version.

I also pity that you did not go well.

I would like to introduce in detail the same procedure with the screenshot images. However, I can not paste the image in this support forum.

So, I had to slip issuance the topic to the plug-ins of the official forum.
URL is here.

https://ka2.org/cdbt-forum/topic/frontend-editable-table/

* SQL is a reliable best if you could use it to copy and paste.

Multiply sorry to trouble you, but, again, please try.

Thanks for the question.

I’ve tried your request in the custom database tables plugin.

In the beginning create a table.
SQL to create table is follows

CREATE TABLE Koordinates (
player varchar(100) NOT NULL COMMENT 'Player',
alliance varchar(100) NOT NULL COMMENT 'Alliance',
position varchar(12) NOT NULL COMMENT 'Position',
last_position varchar(12) NOT NULL COMMENT 'Last Position',
edited_by varchar(100) COMMENT 'Edited By',
 INDEX index_1 (alliance)
)

In addition, you should be set “all users” (all of viewing, registration, editing) access to the table.

Next, You change the table structure that you have created.
SQL to alter table is follows

ALTER TABLE Koordinates
MODIFY updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Edit' AFTER last_position

Create static pages or posts using the shortcodes of the table. Page of viewing, registration and editing must be created new.
Shortcodes are follows

viewing table page
[cdbt-view table="Koordinates" display_list_num="false" exclude_cols="created"]

entry data page
[cdbt-entry table="Koordinates"]

edit data page
[cdbt-edit table="Koordinates" entry_page="test-entry" display_list_num="false" exclude_cols="created"]

I made sure that could be registration and search of the table data, and editing from the page of shortcodes, even a non-administrator user.

So finish in here.

I’m glad if I to meet the needs of you. How about that?

Sorry to keep you waiting.
I’ve released a version of plugin fixes a bug that function of incorporating the external table, please try.

Sorry to keep you waiting.
I’ve released a version of plugin fixes a bug that function of incorporating the external table, please try.

Thank you for your report.
I am aware that there is a failure to resume processing of the external database, bug fixes has been delayed to not take the time. Sorry, please wait a little more.

Also I apologize that the text of the interface is not appropriate as well.
English is not good at me. If you can tell me a bad place to be translated, I will correspond.

Thank you for your report.
I am aware that there is a failure to resume processing of the external database, bug fixes has been delayed to not take the time. Sorry, please wait a little more.

It’s good work inquiries again!

I do not know a legitimate answer to your question, but will answer hasten.

Instead of the click event of the search button, if you want to use a key press event, please add the following JavaScript.

$('input[name="search_key"]').keypress(function(event) {
  if (event.which == 13) {
    event.preventDefault();
    $('.controller-form input[name="mode"]').val('list');
    $('.controller-form input[name="action"]').val('search');
    $('.controller-form').submit();
  }
});

Search process is done by submitting after added each “search” to “action”, “list” to “mode” of the hidden-forms in form that class name is “.controller-form”.

Yes, is answer.

1) How hide the table name that’s shown about the table?

Please add attribute of “display_title” in shortcode.
example:
[cdbt-view table="table_name" display_title="false"]

2) How hide the “No.” column? My table does not have that column,that’s why i don’t know what to write in order to exclude that.

Please add attribute of “display_list_num” in shortcode.
example:
[cdbt-view table="table_name" display_list_num="false"]