Title: Frontend editable Table
Last modified: August 22, 2016

---

# Frontend editable Table

 *  [DonJuanSon](https://wordpress.org/support/users/donjuanson/)
 * (@donjuanson)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/frontend-editable-table/)
 * Hey there,
 * i have a website for a game where i need a table wich is shown in the frontend
   and all members can create an entry (put new data in) and edit existing entry
   just from the frontend (except for the admin no other user can see the backend,
   just the finished website like it isnt a wordpress generated site)
    the table
   should look like
 * Koordinates
 * Player Alliance Position Last_Position Last_Edit Edited_By
    PlayerA AlliB 352/
   458 352/458 24.10.2014 Don(userName) PlayerB Thepanthers 455/600 210/599 23.10.2014
   one other member
 * and so on, it should be shown like this and it should be able to filter and search
   for players or a specific alli and then shown all members of that alli.
 * Its new for me and i hav created my website without any knowledge so sry if ask
   for a very great task =)
 * can i solve my problem with your plugin and if yea how?
    Thank you for your help
 * [https://wordpress.org/plugins/custom-database-tables/](https://wordpress.org/plugins/custom-database-tables/)

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

 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/frontend-editable-table/#post-5418531)
 * 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?
 *  Thread Starter [DonJuanSon](https://wordpress.org/support/users/donjuanson/)
 * (@donjuanson)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/frontend-editable-table/#post-5418554)
 * same problem as i had if i want to create the table it says “create table SQL
   is invalid? what am i doing wrong?
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/frontend-editable-table/#post-5418584)
 * 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.
 * [http://ka2.org/cdbt-forum/topic/frontend-editable-table/](http://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.

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

The topic ‘Frontend editable Table’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-database-tables_e4e2e2.svg)
 * [Custom DataBase Tables](https://wordpress.org/plugins/custom-database-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-database-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-database-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-database-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-database-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-database-tables/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [ka2](https://wordpress.org/support/users/ka2/)
 * Last activity: [11 years, 6 months ago](https://wordpress.org/support/topic/frontend-editable-table/#post-5418584)
 * Status: not resolved