The tag has no wiki summary.

learn more… | top users | synonyms

7
votes
5answers
709 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
602 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
264 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 ...
3
votes
1answer
2k 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
2answers
2k 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
439 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
800 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
2answers
568 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
2answers
838 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 ...
2
votes
2answers
616 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
98 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
478 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
1
vote
2answers
65 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
1answer
2k 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?
1
vote
1answer
121 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
679 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
897 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
2k 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'))) ...
1
vote
1answer
645 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 ...
1
vote
1answer
314 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
8k 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
33 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
79 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
47 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
229 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( ...
1
vote
1answer
300 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 ...
0
votes
2answers
114 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
1k 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
266 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
283 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
50 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
247 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
773 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
144 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
384 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
76 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.
0
votes
2answers
295 views

Best tools for preparing and styling a table [closed]

What are the best tools for preparing and styling a table in Wordpress easily? Update: I want to prepare and publish the tables in any page or post. So I think it might be easier if they can be ...
0
votes
1answer
8 views

Wordpress admin Tables use to display own data - In admin WP

I want to display results in a table. Is it possible to use the wordpress tables like the one in the post and page section which shows all posts and pages in the admin section. global $wpdb; ...
0
votes
1answer
34 views

Creating a Restaurant Menu

I have an html menu on a site for a client. I'm trying to transition it to WP so he can edit it. I'm having trouble with the menu. Here's an image to show my current setup. I assume this can be ...
0
votes
1answer
29 views

Should I use an additional column in the DB?

I'm building a site for a client. They need a functionality where WordPress can tell if a logged in user has viewed a post in order that they might serve a notice or hide the original content. I ...
0
votes
1answer
114 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 ...
0
votes
1answer
92 views

Table appears in Visual mode of editor but not in preview or after publish

I'm using compare theme and I am facing a problem with the tables. I have created a HTML table, which when I go to Visual mode appears to be correct. But when I preview/publish it then I don't see ...
0
votes
2answers
315 views

Show recent posts in a table format

In the index.php template I want to display posts in 3columns in a table format. How can I do this? I don't want a list format cause I have variable hight image sizes
0
votes
1answer
105 views

Table not getting created upon activation of WP Theme

This is the code I am using to create a custom table named "prefix" + zillow--> where prefix is the wp table prefix for the site. register_activation_hook(__FILE__,'CreateTable'); The actual ...
0
votes
1answer
42 views

more tables created when create a new site

Can someone suggest me an idea on this? I am using Wordpress MU. And as per my requirement every user who register on main site will have a sub-site for them. And it is working correctly. I ...
0
votes
1answer
101 views

Interface needed to transfer contents in a table on a web page to the Add New Product interface

I will attempt to clarify this situation since the initial feedback was that it wasn't a question/or was vague. I am having an e-commerce site built. The developer is using a WP template purchased ...
0
votes
1answer
264 views

Can't create tables with my plugin

Here is the code: <?php /* Plugin Name: MyPluggin Plugin URI: http://localhost/ Description: Version: 0.0.2 Author: localhost Author URI: http://localhost/ License: GPL2 */ ...
0
votes
1answer
103 views

Will adding & modifying default Wordpress table index break future Wordpress update

I've some specific use case for certain default wordrpess tables, which I need to add a few indexes to certain columns to improve performance. I'm wondering will adding these indexes break future ...
0
votes
1answer
136 views

Shortcode for tables which can include comma and linebreaks

Is it possible to make a shortcode for table which can include commas and linebreaks for its content? I've been trying to output something like this with shortcode: But it seems difficult. I tried ...
0
votes
1answer
99 views

Need to add/remove group of options and display them as rows

I am creating a plugin which has 5 textbox for options. What I need to do is to treat these 5 options as 1 item, and being able to add more items. I've always worked with static hardcoded options for ...