WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
0answers
6 views
How to use default WP form elements to ineract with custom db table?
I know about the use of custom_post_type, but in this case i do need to use a custom database table (fyi: it's a table that is ip-based shared with another non-WP website).
In wp-admin i like to use ...
0
votes
1answer
26 views
Same theme with different settings
i have a wordpress website.. (no multi site or anything) just one simple worpdress website..
i have a theme which comes with many options which are shown in the admin area..
Changing the settings ...
1
vote
1answer
55 views
Formatting of curly brackets array from WP database to get more readable output
E.g. when I want to edit something in my WP database, I get a headache, literally. Because I see something like this:
...
1
vote
1answer
17 views
Accessing two databases
I have two databases on my server, and wanted to know is there a way to access both databases from wordpress? My thought is adding the second set of credentials to the wp-config.php.
0
votes
1answer
24 views
Best practice to limit results in get_row()?
This is my query to check if a title exists (it's in a loop, therefore [$i]).
$wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A');
Anyway, I would ...
0
votes
1answer
17 views
Split WP_POST table based on post types
I was wondering if it's possible to get my posts from 2 databases depending on the post type.
I'm using HyperDB but can't seem to get it to specify the database based on post type. I Basically need ...
0
votes
0answers
10 views
How to export/import theme customizer settings?
I am wondering if it is possible to export theme customizer settings(theme_mods) to be imported into another install of the same theme. I know that the settings are saved into the database so I am ...
1
vote
1answer
18 views
Extracting post categories
I'm in the middle of assisting a colleague in reconfiguring a Wordpress database for use on another platform. The database is essentially details regarding all the posts and accompanying metadata, ...
0
votes
2answers
18 views
Is database deleted on clicking “reinstall” button in Wordpress updates?
I have a blog made with WordPress. If I click "Re-install" button present in WordPress updates page, will all the database be dropped and created again? Will my posts be deleted?
1
vote
1answer
37 views
Is it possible to create Custom Post plug-in?
I understand that Wordpress allows you to create Custom Post Types with Custom Fields, but is it possible to create a custom Plug-In that creates and maintains its own Custom Post type (outside of ...
0
votes
0answers
18 views
Plugin for organizing and sharing information collected from contactforms
I would really appreciate to get some help with a wordpress page that I'm creating.
I want to create a page where people who are interested to be contacted for a service I'm providing are sending in ...
0
votes
1answer
35 views
How do I find posts?
I am a new website administrator and I am having issues with posts not showing on dashboard. Posts All(21) Published (13) Pending (8). This is a listing site and the posts used to show up. Any ...
0
votes
1answer
17 views
Is the wordpress user-model changed in wpmu?
I'm running wpmu on heroku using a postgres extension. It works great, but I have a plugin that needs to get the userId based on the e-mail-adress. This is how it does it:
$sql = 'SELECT id FROM ' . ...
0
votes
1answer
23 views
WordPress database error Unknown column
I get this error in my database log:
[05-May-2013 21:13:31 UTC] WordPress database error
Unknown column 'region' in 'order clause' for query
SELECT * FROM tmp1db_wpuf_customfields ORDER BY ...
1
vote
1answer
38 views
Separate table or usermeta
We are creating custom fields for users like annual income, gender, city, country, etc. There are about 10 odd new fields. We will be importing approx. 30,000 records for each user in a month through ...
0
votes
0answers
16 views
Using Zoho Creator Database inside Wordpress Frame
Our agency network has an existing Wordpress-based website, and we would like to use Zoho Creator sort of like an intranet which is accessed through the Wordpress site. Basically, something along the ...
0
votes
1answer
36 views
Insert data in custom table during new post creation
I want to in insert data in my custom db table when creating a post.
Suppose there are three categories (php, wordpress & jquery). When i create a post in wordpress, i want to insert post id and ...
0
votes
0answers
7 views
update other databases when main databases update
WPMU membership plugin on three WP websites and want to have update the other two sites automatically when someone joins the main website. Do not want to use Multisite.
content on each site is ...
0
votes
2answers
28 views
What is the best way to store a few fields?
I'm researching what it would take to develop a custom Wordpress plugin. The plugin is a pretty small one. We just need to persist 2 fields of integer information. It's a pretty basic progress bar ...
2
votes
1answer
43 views
Filter WordPress posts by between parameter
How to filter WordPress posts by a taxonomy and between parameter? Consider a mobile website with "memory size" taxonomy, I need to show posts that have more than 256 mb memory and less than 768 mb.
...
0
votes
1answer
33 views
Print output of Table Creation
I am creating a few tables and I getting the following message:
The plugin generated 440 characters of unexpected output during
activation. If you notice “headers already sent” messages, ...
0
votes
0answers
37 views
Host does not allow remote connection, so how do I transfer data to my WordPress site?
I spent the last week trying to get my PHP code on my website to connect to my remote "personal" computer to display some data on a webpage. I just found out today from my web host (ipage)
"our ...
0
votes
0answers
45 views
Install WordPress with SQL database
I am very new to WordPress. I didn't even know it existed until I had to do it for my work. So I started in with a WAMP server with WordPress. That worked fine until we needed multiple sites with ...
1
vote
2answers
66 views
Error establishing database connection - high traffic?
I have a WordPress 3.5.1 site that's getting a little bit of traffic (80 concurrent visitors, ~5 clicks/pageviews per second). The site runs fine until it spikes to ~85 visitors. There are usually 4 ...
0
votes
0answers
41 views
Trying to post information from a remote database to wordpress page
I'm fairly new to Wordpress and looking for some help.
Goal: I would like to stream data from my personal computer's Mysql database and display it on a webpage in my offsite Wordpress hosted site. ...
0
votes
0answers
15 views
Create a generic post type and define its metadata via another one used for categorization
Ok, I would like to share with you an idea I had and ask you what do you think about it and possible drawbacks I'm not able to forsee.
I'm building a database for an association with many kind of ...
0
votes
0answers
24 views
Create hundreds of users with just ID in phpMyAdmin
I'm trying to do the same as this post. But I have a problem with the
insert records into your wp_users table containing all the ID's of the
members you want to import
Right now, I have 3 ...
0
votes
0answers
59 views
Custom query on Wordpress custom table
I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
-1
votes
0answers
108 views
Need help to retrive data from MYSQL based on dropdown selection
I am displaying a list of country in the drop down list, retrive it from the database . and i need to display price for the selected country based on the options chosen by the customers in the drop ...
1
vote
2answers
73 views
Where to store custom tagging data associated with a custom post type
My application allows users to add tags to an image (similar to facebook). Each tag can consist of up to 8 attributes and there is currently no limit on the amount of tags a user can add.
At the ...
0
votes
0answers
35 views
how to display the contact form details after user selects date?
Iam using contact form 7 in my wordpress.
I want to display the form details after selecting the dates i.,e when i select 2 dates i have to get the stored details of form between those dates...
I am ...
0
votes
0answers
33 views
Wordpress and BigDump
I am having a bit of a nightmare situation. I was given a testarea on a subdirectory of a friend's client server as a temporary favor in order to test my wordpress site. The path is as follows:
...
1
vote
1answer
51 views
Extend the wp_users table
I'd like to to extend the wp_users table in my WordPress' database.
Why? I want people to add more information about themselves when they sing up at my website.
I know how to extend it, but I'm ...
0
votes
1answer
29 views
Check in function on custom page
I have a website about places and attractions in my country. Each place/attraction is a different custom post. On this page, i would like to add a button with the value "Check In" and if clicked by a ...
0
votes
1answer
40 views
Clipper theme needs database?
I have used clipper theme for my coupon site designing. is it necessary to create a database for this or shall i upload my wordpress files to the webserver?
Happy Coding
Dinesh
0
votes
3answers
30 views
Fetch a single row from a custom table for to a given ID
When I want to get a single row from a custom table of my WordPress database by providing a username through function call, it does not work. When I mention the username in where clause of the query, ...
0
votes
1answer
57 views
Hook to be used when creating a database table
I read the Codex and some other tutorials describing the process of creating a new table for WordPress.
I thing that the steps are pretty straightforward; however, I'm encountering a small problem.
...
0
votes
2answers
69 views
MySQL Syntax Error upon restoring database from backup
Performed a bad import to my Wordpress install and decided to restore from the mqSQL backup (full export) I had made minutes earlier.
Dropped all tables in the database and then did an import from my ...
1
vote
1answer
35 views
Is it possible to store visitors IPs in wp_postmeta table?
Or in any of the other 11 Wordpress tables. I also need to store: submission date, name, contact number in the same table.
What approach would be best? A custom table or using a standard table?
0
votes
0answers
21 views
MySQL Engine vs. Charset
I am attempting to have my plugin create a new table. I am fairly new to SQL. I have found two different method for creating tables:
Method I
$table_name = $wpdb->prefix . 'cool_table';
$sql = ...
0
votes
1answer
46 views
Creating Database Table vs. Adding MetaData to Post & User
I am creating some event functionality for my wordpress site.
Each event will have a set of tickets associated with it.
A user who is purchased at least one ticket will additionally have a set of ...
0
votes
1answer
51 views
PHP variable in WordPress database query
When running the following code :
$voucher = 'MK0186';
$is_in_database = $wpdb->get_results( "SELECT * FROM my_codes_table WHERE code =" . $voucher );
I get : WordPress database error: [Unknown ...
0
votes
1answer
27 views
Database create or redirect
I am working on a site ABC.com, I have only access to the root folder. I am planning to install wordpress. I need to somehow create a database without any cPanel.
or the second option that comes in ...
0
votes
0answers
25 views
How to add drop down sub menu from database fields in the particular menu slug
I am creating a menu(not in admin panel) in wordpress, and I want to add drop down menu from my database table fields in a particular menu slug?
How can I achieve that, using code?
I found the ...
2
votes
0answers
62 views
Plugin development with unit tests
One of the things that my plugin does is creates a number of SQL tables as part of a versioning function (that is run under the admin_init hook as I couldn't find a better wordpress way of doing ...
0
votes
1answer
77 views
Query specific posts per user selections from dropdown menus
This may be a little different than most people do. I'm trying to show certain posts that are determined by 4 different "categories." I have a large database table full of "products" (I'm using the WP ...
0
votes
0answers
35 views
Wordpress DB collation for hebrew site
My current db collation is utf8_bin with utf8 charset.
When I add image title via admin (attachment plugin) in hebrew language I got something like "u05e9u05dcu05d5u05dd".
What I have to do to fix ...
0
votes
1answer
47 views
Import custom database into wp and keep the post id
Hello guys I have a project where I need to import an old database to wp but I need a solution to keep the old id's as posts id so i can make the links look the same as the old website in this way we ...
1
vote
2answers
33 views
Getting all the users who have author privilege
Can anyone tell me how to get all the users who have author privileges by querying the DB in WordPress and order them by number of posts written by them.
I use the following query to get all the ...
3
votes
3answers
80 views
How many users can WordPress handle?
I want to design a member login site in WP but I have a doubt that is WordPress can handle more than 40000 users on same database?
I am not sure about this so I am stooping my work here. So please ...
