The tag has no usage guidance.

learn more… | top users | synonyms

8
votes
2answers
854 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: ...
7
votes
4answers
3k views

Where are wordpress custom types stored?

Where are custom types stored? Because when a custom type is created, in wp_posts, the post type is set to the <new_custom_post_type>. But where are the details of the new custom post type ...
7
votes
5answers
1k views

Use a separate custom table (not posts) to handle file upload data

The Problem: Website that has over 100 photos per post. Could possibly swell posts-table beyond 100K entries within a few years. The Dilemma: Would much rather stick to default WP UI for handling ...
5
votes
2answers
2k views

What for is the table “wp_commentmeta” exactly?

I have been reading about the Database Description of Wordpress. I haven't understood the meaning to the use of the table wp_commentmeta. The documentation says: Each comment features information ...
5
votes
1answer
301 views

When is it appropriate to create a new table in the WordPress database?

For a client we'll need 29,000 terms (all the highschool's in the US) and each term needs 6 meta items (address, phone...). My initial thought was to store the term meta information as suggested in ...
4
votes
1answer
65 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 ...
4
votes
3answers
4k views

Whats the best way to share user data across multiple Wordpress websites?

First of all, Multisite isn't what I'm looking for. I have 5 websites using Wordpress all on separate domains that I would like to enable user accounts for. I need user data to be shared across the ...
3
votes
1answer
3k views

Create a formatted table-like menu

I've just put the site up a couple weeks ago and adding some more things to it for my friend however there's got to be an easier way to lay content out over wordpress. I've having a hard time with it ...
3
votes
1answer
730 views

BuddyPress: What's the use of wp_bp_xprofile_data table and how does it get updated? [closed]

I have a questions related to BuddyPress: What's the use of wp_bp_xprofile_data table? How does the data in the table get updated? And when any user updates his information - does the data in this ...
2
votes
2answers
3k views

Save custom post type in different table

I need to store custom post type post data into a custom table, not in wp_posts and wp_postmeta. Is it possible? anyone help please. Actually, I have created two custom post type named "truck" and ...
2
votes
1answer
3k views

How to update BuddyPress xprofile fields programmatically? [closed]

I update user info using wp_update_user function. I also need to update the table wp_bp_xprofile_data. Is there any function, where I can update data on wp_bp_xprofile_data table?
2
votes
2answers
2k views

Should I global $wpdb outside of any of my plugin's functions scope?

I know that the general advice to global variables is to not use them at all. Still, when doing something with the Wordpress database, it is required to do global $wpdb; to access the methods ...
2
votes
1answer
36 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? ...
2
votes
1answer
2k views

How do you display posts in a dynamic table?

I'm currently using a plug-in called SortTable Post. It automatically takes your posts and puts them into a table that you like. It's a great idea, but the issue is that the plug-in hasn't been ...
2
votes
2answers
857 views

The plugin generated x characters of unexpected output, $wpdb not defined

I've written a simple Wordpress plugin to create a new database table. The new table ought to be created when the plugin is activated. When I try to activate the plugin, I get the following error: ...
2
votes
1answer
5k views

Creating search form for custom database table

I have a custom table in the WP database which I can display fine, with pagination, using the following code: <?php global $wpdb; $rows_per_page = 50; $current = (intval(get_query_var('paged'))) ...
2
votes
1answer
535 views

Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id

I have created a category "Book" with a sub category "comics", to check how wordpress is maintaining the hierarchy structure. When i check the table "wp_term_taxonomy", I found that such term with a ...
2
votes
1answer
117 views

What table is the media's sort order stored?

I see that your can sort media by a numbered order in the media gallery for a post. But what table is this order stored in? I want to use this order to also order the images the same way in my ...
2
votes
1answer
750 views

Include custom table into search results

How can I include custom tables into search results. My all custom tables has qa_ prefix and wordpress has default wp_ prefix
2
votes
0answers
145 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
2answers
469 views

Creating table with plugin is not working

After reading many question and answers and many had asked the same question I have been following the same instruction as the people instructed but my bad it's not working I have used ...
1
vote
2answers
83 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 ...
1
vote
1answer
653 views

Removing filter dropdown in posts table (in this case Yoast SEO)

I don’t need Yoast SEO meta box for one post type so I removed it with remove_meta_box(). Removed unneeded columns in post table by unsetting columns with manage_edit-custom_post_columns, but drop ...
1
vote
1answer
141 views

Hiding posts and pages in panel

I found out this code and works ok for hide pages in admin page listing, but I need someway to do this to thousand pages: add_action( 'pre_get_posts' ,'hide_pages_87ff65f5f' ); function ...
1
vote
1answer
909 views

Table for plugin-list-category-post? [closed]

I'm using the list-category-post plugin - is it possible to display the list of posts in a table? I want to have a dynamic table showing all the posts in a category, so a user can search the table ...
1
vote
2answers
1k views

Can't pass table to $wpdb->prepare

I'm having trouble passing a table variable to $wpdb->prepare(); Here is functioning code: $table = $wpdb->get_blog_prefix( $blog_id ) . 'my_table'; $voters = ...
1
vote
1answer
53 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 ...
1
vote
1answer
767 views

What is the use of to_ping and pinged column?

Can anyone explain or show a reference for the use of to_ping and pinged column in the wp_posts table? It seems that my Googling skills have failed me. I wanted to do an experiment using the pinged ...
1
vote
1answer
19k views

Insert data in database using form

I am writing a simple plugin that create a table with name "newsletter" in database and provide a shortcode to put a registration form in pages. the form contain "name" and "email". i have problem ...
1
vote
1answer
24 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 ...
1
vote
0answers
21 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 ...
1
vote
0answers
51 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 ...
1
vote
0answers
135 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 ...
1
vote
0answers
88 views

Pull data and display as rows and columns

I am a noob when it comes to pulling data from tables and fields of a WP database so I'll explain it as best as I can without it running into a thesis. I have a table called WP_answer. In that table ...
1
vote
1answer
42 views

Obtaining user table for one site on multisite set up

I'm trying to select only users that are registered for a specific site on my multisite set up and see that the table for the users has collected everyone that is on the network. Is there away I can ...
1
vote
1answer
192 views

Custom fields on a virtual page

I've used Dave Jesch's solution for making virtual pages (from content temporarily saved in a custom database table, updated from an RSS every four hours). See more here: ...
1
vote
0answers
77 views

Custom table naming/access convention for multisite: $table_prefix vs base_prefix or other?

After WP3.8.1 upgraded, two plugins I made for my networks both stopped working. Each runs on a separate multisite install. I posted the error report on the Wordpress form: ...
1
vote
1answer
413 views

Create custom column in post table in wordpress

I want to add two custom field to table wp_posts, and that I need for my plugin. now to enable these fields I have changed core file of wordpress wordpress/wp-admin/post.php $data = compact( array( ...
0
votes
3answers
95 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
1answer
47 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
2answers
282 views

putting wp_query data into html table

I needed to display some data in a simple html table so I started with very basics of table. As shown in the code, the data needed was a list of custom-field-values of a meta_key submitdate, from ...
0
votes
1answer
2k views

How to get user ID on the registration and add in to custom table

I am trying to get user ID on registration and automatically add that ID to my custom table. I am using wp-members plugin for registration. So is it possible to get user ID on the fly while ...
0
votes
2answers
882 views

How to insert more than one row of data into a table at one time

I would like to populate a custom table, with more than one row of data at one time. If I delete the second array, it will insert one row of data. It won't add both rows at the same time though. How ...
0
votes
1answer
633 views

How to populate custom tables with rows of data

I'm trying to populate a custom table called countries, with two rows of data. The custom table is created when the plugin is activated. The rows need to be added when the plugin is activated. The ...
0
votes
1answer
88 views

Create new database through static page code

I want to create a new table in current database of word press through create a static page. I write code for this as below, but there was no result. Why is that, and how can I get this right? ...
0
votes
1answer
528 views

Multiple Rows in a <table> using wp_query

I am displaying posts in a grid (4 posts wide by 2 posts high). I am using a table. In order to get the content to display on the second row, I am using two wp_queries (one on each row) because I ...
0
votes
1answer
2k views

Query multiple tables at once?

I want to query all of the posts in my WordPress multi-site set-up looking for a certain string. This is only being done in Sequel Pro (on the command line) for my own inquisitive purposes but there ...
0
votes
1answer
155 views

Search within table?

I have a nice plugin that is called Select WP-Table Reloaded and that works well, except the contents don't show up in a useful manner. The page the table is embedded shows up in a search, but not ...
0
votes
1answer
531 views

Get multiple db prefix with $wpdb

I have installed wordpress with question2answer as a single signon. The database created by wordpress with wp_ prefix and question2answer prefix is qa_ Now wordpress tables doesnt required to define ...
0
votes
2answers
80 views

HTML tables in content areas

Is there a plugin that would allow me to create and edit tables within the content block in posts and pages? I suppose a bit like the 'insert table' command in MS Word.