The tag has no usage guidance.

learn more… | top users | synonyms

7
votes
2answers
228 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
5answers
866 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 ...
6
votes
4answers
2k 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 ...
5
votes
2answers
1k 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
279 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
3answers
3k 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
578 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
2k 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
1k 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
1k 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
745 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
4k 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
419 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
110 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
607 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
285 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
2answers
38 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
135 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
808 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
401 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
544 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
12k 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
0answers
73 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
40 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
136 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
66 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
315 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
63 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
2answers
200 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
591 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
412 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
70 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
436 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
1k 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
150 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
472 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.
0
votes
2answers
309 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
33 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 ...
0
votes
2answers
29 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 = ...
0
votes
1answer
15 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
44 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
181 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 ...
0
votes
1answer
60 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
15 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: ...
0
votes
1answer
139 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; ...