Questions tagged [table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
2k views

Database with mixed collation (utf8mb4 & utf8_general_ci)

Each time I was uploading my WP install from offline to online, I was noticing strange characters in text and digging a bit I have discovered that wp-config.php on the online server was set to define('...
0
votes
2answers
659 views

Customizing WP tables or adding new ones?

I would like to extend user data, adding picture, department, phone, etc. You may achieve this adding custom fields to the usermeta, however I wonder if this techniques is deprecated and it would be ...
2
votes
1answer
56 views

stdObject stored in database. How does one convert it to usable format?

So I logged on phpmyadmin, went to check out how data is stored in a table and saw it''s 'data' columns contents (pasted below): a:8:{i:2;O:8:"stdClass":2:{s:5:"label";s:6:"Vardas";s:5:"value";s:1:"A"...
4
votes
1answer
3k views

How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table

I am trying to implement WP_List_Table for my plugin. I have gone through this tutorial and using its sample plugin. I have installed this plugin and just changed table name and done slightly ...
0
votes
1answer
371 views

Pagination in html table is not working

I have a custom page template and I found a a PHP snippet that create a pagination in html table. But the code is not working properly. UPDATE: I change the code. But still the code is not working ...
1
vote
2answers
1k views

How to update an existing table while updating plugin?

I have added a new field (time_last_seen) in my plugin (v1.1) table then uploaded my plugin as version 1.2 to wordpress svn repository. When I update my plugin from admin panel, it is not creating ...
0
votes
2answers
318 views

Change options table prefix only

I am not able to find, How can I change the only options table prefix. I do not want to change other tables prefix only need to change options prefix. Please guide me. Thanks
0
votes
1answer
500 views

Is there alternative to WP_List_Table?

I need to create html tables in a admin pages. It should be responsive. After a research I find the WP_List_Table. But in codex page, This class's access is marked as private. That means it is ...
0
votes
2answers
198 views

How to Use Resposive Tables in WordPress ADMIN Pages?

I have created a custom ADMIN page using add_menu_page. There is a HTML table in that page. I need to make it responsive. Is there way to do it?
1
vote
1answer
496 views

How to create a form and display its content as table in admin panel?

I am new to Wordpress CMS and have been into a problem and don't know how to go about it. The problem is I want to create a form with first name, last name, phone number and a submit button. On ...
0
votes
1answer
859 views

Dynamic data table from external json feed

First of all, while I'm fairly comfortable with code, I'm also quite new to Wordpress development, JS, and PHP so please forgive me if this is not explained very well, or a real rookie-type question. ...
6
votes
1answer
1k views

Wordpress Unit Testing - Cannot Create Tables

I'm using PHPUnit to Unit Test my WP plugin on top of the WP testing suite. Everything works fine except that when I try to create a table via the setUp method, the table doesn't get created. Here's ...
1
vote
1answer
1k views

Accessing data from a non-WP database/table within a page content

I'm trying to convert a home built (PHP / MySQL) set of web pages to WP. I've installed the theme I want and have some basic pages working OK. However, I have a set of data within a MySQL database ...
0
votes
1answer
895 views

DBDelta: “table doesn't exist” for a table that was just created

When I run the following code: global $wpdb; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); $table_tags = $wpdb->prefix . "tags_tb"; $sql = "CREATE TABLE $table_tags ( ...
0
votes
1answer
3k views

WooCommerce - Order_itemmeta - Need to add meta_keys to table

I need to add 3 meta values to each order_item to the woocommerce_order_itemmeta table. Any suggestions how to create new meta_keys to be included in the table for all order items?
1
vote
0answers
106 views

Show all data in database table and make it into an interactive table

I have to make a table where my data from my database can be stored and rearranged with every row. The name of every row should be a link to the function mymanual_edit(). Look at the image for ...
-2
votes
2answers
1k views

How to get value from wp_usermeta table in database?

I ad a custom field to registration form: function wooc_extra_register_fields() { <p class="form-row form-row-first"> <label for="billing_cpf"><?php _e( 'CPF', 'woocommerce' ); ?> &...
1
vote
1answer
651 views

WP_List_Table error on WordPress 4.4

I've read the thread here : Fatal error after 4.4 upgrade class-wp-list-table He was experiencing same problem with me, WordPress won't shows its native table. But unfortunately the given solution in ...
0
votes
1answer
11k views

Change colour of table td based on value

I have this code in my table calling in a number <tr> <td>Total: <?php echo $total_credit;?></td> </tr> I would like to change the background colour or the text ...
0
votes
1answer
1k views

How to insert dash (-) into database using wpdb and new_to_publish hook?

I am saving titles of posts in a separate table for a specific use. The titles are saved to the database when a post is published. code is: add_action('future_to_publish', 'send_emails_on_new_event');...
1
vote
0answers
161 views

Least expensive way to get table prefix in multisite installation

I am writing an api that will have to handle extremely high volumes of calls so, in short, I can not afford to load the WordPress core every call. I have no problem building the API to use the ...
0
votes
2answers
63 views

Should I store arrays in custom fields or create custom tables?

I am developing a website where I have modified the comment form to have review rating capabilities. I ask them to rate them on food, service and location. For each of those option there is “bad”(1),”...
0
votes
1answer
90 views

Need help for creating custom table on wordpress

I'm trying to learn how to create and use custom tables on wpdb for a plugin that I'm going to build. So far I've seen a bunch of tutorials and know how to create a table but I'm facing problems ...
2
votes
1answer
40 views

Why majority of fileds in wp_posts table prefixed with post_?

Why for example field in wp_posts table is called "post_title" instead of "title"? Is this somehow related to b2cafelog legacy code for backward capability? Or is there other explanation for this? ...
0
votes
2answers
484 views

CSS for Table Rows and Columns

I have a simple table layout as per below: <table> <tr> <td>1</td> <td>2</td> </tr> <tr> <td>3</td> <td>4</...
0
votes
1answer
645 views

Show a table from data submitted by a form from a user

I would like to show a table on my wordpress site, which is filled by registered users. How can I realize this? So my thoughts are: Registered users should be able to submit 2 variables through a ...
1
vote
0answers
557 views

Create a table with wordpress plugin boilerplate

I am a new wordpress developer and i would like to create my first wordpress plugin based to wp plugin boilerplate template plugin. My plugin will have to do with my clients data so for this reason i ...
0
votes
0answers
47 views

Adding list of Indexes in wordpress document

I have been exploring wordpress to use it for documentation puposes. I'm stuck at a point where I am unable to add a list of Indexes to the document. Can I add indexes to a wordpress document the way ...
3
votes
0answers
604 views

Visual Editor freezing on text highlight since 4.3

Ever since I updated my website to 4.3 my visual editor is freezing every time I try to highlight a piece of text, or even place my cursor someplace random. This only seems to be happening on the text ...
1
vote
1answer
977 views

Wordpress mysql table double prefixes

Currently working on updating a wordpress website for a client of mine. The wordpress mysql database has double prefixes in it though. The standard wp_ prefix and her own custom prefix for the tables....
0
votes
1answer
730 views

How to use TOC with ACF?

I'm using ACF advanced custom fields plugin to create custom fields for my CPT where i replaced the content editor of my CPTs with a custom Wysiwyg Editor field (field name: full_text) from ACF in ...
0
votes
1answer
3k views

Custom select query two tables by a meta key

I'm using an event plugin which creates wp_ftcalendar_events table in database with start_datetime column. Here's image of whole table: I want to query my posts by start_datetime. I know that I can't ...
0
votes
1answer
893 views

Include custom table in query

Im using event calendar plugin where I can set event date for posts and it shows in calendar widget. Everything is working as inteded but I would also like to query post by event date. Problem is ...
0
votes
3answers
2k views

Can I create a table on my DB without creating a plugin?

I have a built in form I created on my WP website . I want to store the inputs to a table on my DB. All tutorials that explane how to create a talke include the fact that I have to create a plugin ...
1
vote
0answers
2k views

Creating custom database table with crud operation

I am new to wordpress. I going to work on one project that is having 400 pages. Out of that only 3-4 pages are the dynamic pages and rest are the static pages. What I meant to say by this, most of ...
0
votes
2answers
962 views

Loop posts in a table ordered by a custom field value

I'm trying to generate a table for a custom post type events, in which I have a few custom fields, one of these is the date. I want to display the posts in the table and order them by the Date value. ...
0
votes
1answer
1k views

how to create table during plugin installation in side a class

I am creating oop base plugin. So how to create table during plugin installation in side a class.But I could not create table. This is my approach.What wrong with me. class Notification { ...
0
votes
1answer
59 views

MySQL swap one table for another?

So I have a situation with this WordPress site I'm doing where I have to swap the positions of my featured images. I have two per post thanks to the Multiple Post Thumbnails plugin, but now whatever ...
0
votes
0answers
191 views

Query post by meta key of another table

Im using event calendar plugin where I can set event date for posts and it shows in calendar widget. Everything is working as inteded but I would also like to query post by event date. I know how to ...
0
votes
2answers
47 views

Table is not created in WAMP

I don't know where the mistake is. My code is not creating a table in WAMP: function subscribe_table() { global $wpdb; $table_name = $wpdb->prefix.'_databasesubs'; $charset_collate = ...
18
votes
2answers
19k views

Is it mandatory to use $wpdb->prefix in custom tables

Sorry if this question is trivial. I'm just beginning to develop plugins in WordPress. In all the tutorials I found this: while creating the custom tables, $wpdb->prefix is used. Example: $...
0
votes
1answer
303 views

dbDelta not installing database

I'm not sure why this isn't running. When I output dbDelta it says that it created the table, but it doesn't. I think my SQL is valid. Taking everything out between id and UNIQUE KEY results in the ...
0
votes
1answer
130 views

Use members from 1 site on another one

I have two different wordpress installations and want to use the same users, I have Site_A with all the users logins with buddypress and bbpress, Site_B will be capable of letting the users from ...
0
votes
1answer
438 views

Google does not index data from custom table used for a plugin

I've got an online shop plugin (made on my own) which uses custom tables for storing data about products. For list of product and for product detail I created WordPress pages and used shortcode to ...
0
votes
1answer
587 views

Plugin does not create a custom table upon activation

I have a problem as the title says. My plugin does not create a custom table when it's activated. My code is: function bsp_create_update_table() { global $wpdb; //geting the acces to a wp tables $...
0
votes
1answer
3k views

Can i set css class for table via TinyMCE [closed]

I'm using TinyMCE plugin. And now i need to set css class for table. I found some info on http://www.tinymce.com/wiki.php/Configuration:table_class_list . But how can i apply it in TinyMCE plugin for ...
2
votes
2answers
928 views

how to change appearence of the content of default post list columns?

Speaking about backoffice here. I usually add columns and filters to the backoffice for certain custom post types. No problem here. BUt what if I would simply like to change something on the content ...
0
votes
1answer
1k views

dbDelta not creating tables with composite keys

I've been trying to figure this one out for 3 days now, reading every reference on dbDelta I can find. My ultimate goal is to create a table of unique ad_id, ad_trigger pairs. This does not create a ...
0
votes
1answer
35 views

How to avoid repeating similar properties for all tds of a table in a wordpress post

Consider the following table. <table> <tbody> <tr> <td style="text-align: right; direction: ltr;">1</td> <td style="text-align: right; direction: ltr;">2</td>...
0
votes
2answers
668 views

Add pagination to table generated by wp_query

I spent hours trying to find a solution to this, but I am not able to figure it out. I have a table that shows user's data and I am trying to add pagination to it. I have tried by adding "paged" in ...