The tag has no wiki summary.

learn more… | top users | synonyms

7
votes
5answers
522 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
1answer
229 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
2answers
109 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 ...
3
votes
1answer
983 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
1k 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
295 views

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

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
1answer
84 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 ...
1
vote
2answers
73 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 ...
1
vote
1answer
624 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 ...
1
vote
1answer
107 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
569 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
694 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
587 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
273 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
131 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
3k 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
2answers
365 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: ...
1
vote
0answers
19 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
0answers
129 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
156 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 ...
1
vote
1answer
341 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
0
votes
1answer
778 views

How to update BuddyPress xprofile fields programmatically?

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?
0
votes
2answers
75 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
2answers
35 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
114 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
33 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
126 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
163 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
137 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
298 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
1answer
818 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
73 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
276 views

Best tools for preparing and styling a table

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
62 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
171 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
74 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
38 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
98 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
178 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
90 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
115 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
88 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 ...
0
votes
1answer
60 views

What is wrong here? Issue with post_id and meta_value

I'm trying to create a loop to read all the meta_value records from a given post_id. The idea is to gather all the meta_value's data from wp_postmeta table related to post_id number and print them as ...
0
votes
1answer
90 views

Why doesn't my Table get created?

I am working on creating a table in the DB for a plugin but cannot figure out why the table is not being created. Here's my code: global $ds_swoons_db_version; $ds_swoons_db_version = '1.0'; ...
0
votes
3answers
470 views

Custom Database Table and foreach

I have just created a custom database table and would now like to output every inserted row from it into a predefined format using a foreach statement. Some guidance in this matter would be great. ...
0
votes
1answer
22 views

MailPress plugin: table inline style tag removed when sending the newsletter

I have coded my own MailPress theme for my newsletter using tables and inline styling for good look and feel of my newsletter. I have in the files header.php and footer.php html table code with inline ...
0
votes
0answers
20 views

wp-admin: Sort users by surname

Is it possible to alter this table in the backend so I can sort users by Name and Surname? I have dozens of users on my multisite that need to be sorted by Surname. Can anyone help me out here? ...
0
votes
0answers
15 views

Cant create table if including the file in main script

I want to create a table by including the script that creates it in the main plugin file. I have this: register_activation_hook( __FILE__, 'vkrwps_agt' ); function vkrwps_agt() { global $wpdb; ...
0
votes
0answers
35 views

Custom Post Type & Post Meta or Custom Table for Serial Number Delivery Project

I've trawled a ton of articles here, on wordpress.org, makeuseof.com, code.tutsplus.com, etc. - all very informative but I'm still not sure whether to use a custom table with my plugin project or not. ...
0
votes
1answer
204 views

How to display Shop Products in a Table Format with Column Headings as Custom Attributes in WooCommerce WordPress [on hold]

I have already entered my products along with their custom attributes into my WooCommerce system and am looking to customize the look and layout of the Shop page to display products in a tabular ...