0
votes
1answer
18 views

Changing starting number of User ID

I've got a client who would like their online user registration to match their current database. Thus they'd like their wordpress sign ups to start with 00100, I can't seem to find a plugin that ...
3
votes
1answer
134 views

Using Vagrant for customizable Wordpress Multi-sites

Background: My partner and I have a goal to create a customizable vagrant project that uses Wordpress multi site, as a local development environment. Ideal Use Case: Various developers on our team ...
0
votes
1answer
49 views

Given two custom post types: Automatically add meta fields from one custom post type to another

Custom post type "Company" has: Restaurant name field Restaurant description field ..and other more fields Custom post type "Restaurant" has: Restaurant name field Restaurant description field ...
0
votes
1answer
199 views

How to delete all records from or empty a custom database table?

I can't seem to find a simple reliable way to do this - perhaps?: // delete row ## global $wpdb; $delete = $wpdb->query( $wpdb->prepare( "DELETE * FROM `wp_table_name`" ) ); ...
0
votes
0answers
47 views

Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet

Why do developers make it so darn hard to use the tools they develop? Don't answer, I already know :) Have had some success using this: https://github.com/bainternet/Admin-Page-Class ...to develop a ...
0
votes
2answers
91 views

Share WordPress Database

Does the WordPress installation has to use an exclusive database? I'm building a website with custom pages, that access a MySQL database. But the site will also have a WordPress installation. Can I ...
-2
votes
1answer
34 views

Create a plugin to create a new page in wordpress for each time a record is added into the database

I am new to wordpress and would like to get a way forward for a particular problem. I have a database table A with various columns. For each record in table A a wordpress page needs to be created in ...
1
vote
1answer
88 views

How to use default WP form elements to interact with custom DB table?

I know about the use of Custom Post Types, 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'd like to ...
0
votes
0answers
38 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
123 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 ...
0
votes
0answers
43 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
61 views

WordPress Multisite platform for different city for single db

I have One WordPress Multisite installation. myplatform.com (Main platform) have custom post list for different city say city1, city2 & city3. Now What I want is on city1.myplatform.com (city1 ...
0
votes
2answers
86 views

Your thoughts on the interaction with one custom database table from WP?

Short version: Step 1/ i am using contact form 7 to collect some user data and i insert the data into a custom database table. Step 2/ only the custom table needs to be altered/updated. In fact at ...
0
votes
1answer
81 views

Accessing + retrieving custom database in WordPress

I am looking for something really simple(?). I am using WordPress as a CMS. I created a new page in which I added a form (questionnaire). Inside WordPress' database (the same database in which all ...
1
vote
1answer
904 views

Custom search page and search by title, content and tag

Can someone review my code , I need to know better solutions or any bug. Okey ! , I made a PHP file to get search results by parameters and search by title , content and tag PHP's head look like: ...
0
votes
2answers
880 views

Theme Activation, Create Database Tables

I have been tasked with creating a theme that will be a base to list the site owners ebay store products. I have fleshed most of the project out in plain old php to get everything working as regards ...
0
votes
1answer
45 views

Plugin: database creation

Can someone tell me what's wrong with this function? function xattachments_db_install() { global $wpdb; $xattachments_db_version = "1.0"; $table_name = $wpdb->prefix ."xattachments"; ...
1
vote
2answers
361 views

How to create and work with custom data / tables (i.e., for arbitrary data)?

Getting started on Wordpress just today. I noticed that Wordpress created tables in a mySql database (with name *.wrdp1) when I first set it up. These tables cover comments, posts, users, and some ...
2
votes
2answers
1k views

Have multiple local wordpress installs share a wp-content folder and database

On my local machine, I have multiple wordpress versions installed so I can test the themes and plugins I develop. I was wondering if I could somehow create a central wp-content folder and database, ...
2
votes
2answers
2k views

Edit Custom Database Tables in Wordpress

I have a site that uses custom database tables to manage info that is inserted by a process completely independent from Wordpress. The data from the table is used in the Wordpress site but it is not ...
0
votes
3answers
468 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. ...
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 ...
0
votes
1answer
500 views

How to use multiple check-box values to work in a function and insert values in database

I am working on a custom theme where there is option to upload images . I have certain check-boxes in the form which the users select as per where the image has to go. My form code is as follows : ...
0
votes
1answer
358 views

How Can I Always Display A Particular Post First Using WP_Query?

My apologies if this question has already been asked somewhere else, I searched but couldn't find anything. I am working on a tours website, there will be individual package pages that show some text, ...
3
votes
2answers
3k views

How to delete outdated, wrongly sized images in _wp_attachment_metadata?

I've got several custom image sizes for my blog. One of these is setup as add_image_size( 'slide', 640, 290, true );. These are used in a header slideshow. My problem is I've upped the dimensions of ...
1
vote
3answers
2k views

How to retrieve the value stored in a multi-dimensional array and SUM the entries?

I'm trying to retrieve multidimensional values stored in user_meta where the meta key is my_posts and the meta_value is a:3:{i:0;s:2:"23";i:1;s:2:"20";i:2;s:1:"9";} Somewhere in the admin page ...
4
votes
3answers
254 views

Is it possible to switch the data layer within WordPress?

WordPress is undoubtely very customizable using plugins, but every customization possibility surely has limits defined by the underlying architecture. For those familiar with WP architecture and ...