The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
12 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
30 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 ...
3
votes
1answer
35 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"...
1
vote
1answer
45 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
0answers
16 views

Sharing tables between 2 different websites based on the same database

I have 2 different websites installed on the same database. The 2 websites are sharing the users tables, but I want them to share the posts tables too. I tried to do it by editing wp-db.php. After ...
0
votes
1answer
53 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 ...
0
votes
0answers
26 views

INNODB Supports transactions, row-level locking, and foreign keys

When I try to create a table for a plugin (that was dropped in the past) I get the error: #1005 - Can't create table 'database_db.wordpress_popularpostssummary' (errno: -1) (Details…) And the ...
0
votes
0answers
14 views

Table showing data from posts

I have set up a custom post type, with several custom fields to store individual pieces of data. Is there a way to display the data from the posts in a table? Ideally I'd be able to implement search ...
1
vote
2answers
25 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
37 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
44 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
31 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?
0
votes
0answers
17 views

same users different websites other then wordpress

I am creating a network of sites. I have some wordpress installations as well as some other scripts installations. I know that i can use single wordpress users table for different wordpress ...
1
vote
1answer
50 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
44 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. ...
0
votes
0answers
20 views

Add a Filed to WordPress User Table

I am going to give points for users for their activities. I thought to add a field for user table. Is it a bad idea? I use my own function to update that field.
0
votes
0answers
22 views

Website keeps redirecting to Wordpress install page (install.php)

I hope someone here can help me as the problem I have is driving me insane. For the last few months I have been putting together a Wordpress portfolio and had almost finished it. Recently, out of ...
4
votes
1answer
81 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 ...
0
votes
1answer
36 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
39 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
70 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
26 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
118 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' ); ?> &...
0
votes
0answers
23 views

Access a WordPress Table from Outside Project

I have a PHP project on example.com and I have a WordPress installation on example.com/blog. I need to get data for my PHP project from one of My WordPress table. Is it possible? If it is possible ...
0
votes
0answers
14 views

dynamic table for post?

I want to display a list of items with pictures and a short description in a table on a wordpress page. The problem is that I want to the main future editor to be able to add new items at the start ...
0
votes
0answers
12 views

Do I need to worry about filling meta_value column in wp_postmeta table during migration?

I am migrating article/post data from a Joolma site running 'seblod', which has scattered the data across multiple database tables, so I can't use an off the shelf migration plugin. I am transfering ...
1
vote
1answer
74 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
143 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
105 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
53 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
34 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
43 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
38 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
0answers
104 views

Fill table in WordPress with MySQL data

I'm unsure on how to do this as I've never coded a MySQL database directly into a website, so I appreciate any help I can get. What I want to accomplish: I have a MySQL table in my website's ...
0
votes
2answers
86 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
0answers
56 views

Sortable tables with multiple header rows

I've been playing with TablePress and it's pretty nice, but I'm looking for a slightly more advanced table plugin. I need to have multiple header rows. The first header row describes the second row, ...
0
votes
1answer
74 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
161 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
48 views

Front-End Editable Table for NOT logged-in users

not logged in users can edit, modify, save data in a predifined table only on one page. They can enter predefined cells with text or checkmark and are able to add new rows. Preferably one user can ...
0
votes
0answers
28 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 ...
0
votes
0answers
52 views

Need a table not logged-in users can modify and/or edit

In a members area registered users can checkmark and / or enter data into cells of predifined rows and columns. Process should be as follows: User can register on the WP-Site He gets login data e.g. ...
2
votes
0answers
171 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 ...
0
votes
0answers
10 views

How do you get all the posts and generate a table automatically in page?

I am trying to make a page with all the interesting posts(tagged with "interesting") and make a searchable table using TablePress. First of all, is this possible? If so, 1) what is a function in ...
0
votes
1answer
73 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
51 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
0answers
105 views

Display posts list in a table with search

I am new to wordpress, and I need to display a table in the frontend with list of posts and a search functionality. Is there any custom code to do both the functionalites(listing and search)? NOTE : ...
0
votes
1answer
490 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'...
0
votes
1answer
87 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
116 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 ...
0
votes
0answers
478 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 ...