Tagged Questions

WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

2
votes
1answer
151 views

What are these entries in the database? Looks similar to JSON

So I have been wondering for a while now what these entries are and what they do, also what the format of them are. They look similar to JSON but are definitely not JSON. ...
0
votes
0answers
15 views

$wpdb error : call to a member function insert() on a non-object

I'd like to add data to my custom wordpress table of my plugin, here is my code: <?php global $wpdb; $data = $_POST['name']; $wpdb->insert('ct_data' , array( 'name' => $data ), array( "%s" ...
0
votes
1answer
24 views

Creating dynamic pages from custom table including location and map [on hold]

For a non-profit project I hope to get recommendations for a possible solution. I am building a site with pages dedicated to individual locations (potentially with subpages with galleries with images) ...
0
votes
1answer
39 views

Select data from database and list it in Loop (Wordpress)

your Answear helped me but i stuck again. here is what i have done now : <?PHP define( 'WP_USE_THEMES', false ); get_header(); global $wpdb; $sql = "SELECT vehicle_id, manufacturer, series, ...
0
votes
0answers
15 views

Get results from wordpress data custom table

Firstly i created a custom table into the wpdb : global $wpdb; $table_name = $wpdb->prefix . 'countdown_table'; $sql = ' `id` int(11) NOT NULL AUTO_INCREMENT, `styleName` varchar(255) ...
0
votes
1answer
10 views

I moved my site to another server, wp admin works so does the front page, but posts don't work

Pretty much summed up everything in the title. I can see the posts in wp admin, but when I hit the "View" link they return a 404 not found. Do you have any idea why this is happening? As a note: I ...
0
votes
1answer
19 views

Options table - where does my values go?

I just got my hand into wordpress and wp theme development. I know to create basic wordpress themes from scratch but I wondered how to get into custom theme options. My custom theme options (custom ...
0
votes
2answers
28 views

Multiple instance of data in plugin custom database table on plugin activation

I'm creating a plugin that adds some data to a custom table created by my plugin on plugin activations. I also created a settings page with a form that users can insert their own data to the ...
0
votes
1answer
22 views

Is it risky if I update all url in the database due to my site url changed?

Let's say I have a wordpress site on a subdomain. Initially, I created the site with "www." >>> www.mysite.mainsite.com Now, I'd like to change site url to only mysite.mainsite.com without www ...
0
votes
0answers
14 views

Use existing client information database in wordpress site

Our company's website is being completely redone, this time with wordpress. We have an existing client database where clients can log in and get the information they have permission to view. This ...
-3
votes
0answers
16 views

is it possible to create Banking application with already created database [closed]

I have an Reconciliation application. In this application one or more bank's(i.e. HSBC, SCB, IDBI, SBI etc.) daily account deatils in the excel sheet. These excel sheet data will be uploaded into the ...
0
votes
1answer
13 views

What's the database relationship between a post and its attachments

I'm creating a custom import script to migrate CSV data into wordpress. Each post has a series of attachments that must come with it. Following chapter 14 (importing via a custom mysql script) in the ...
0
votes
1answer
38 views

importing data into wordpress db

Hi I am currently using wordpress 4.0 multisite(bitnami multisite stack) and am using WPMU directory plugin to create business reviews directory. Have some custom fields created using custompress ...
0
votes
1answer
28 views

How to fetch results from database

I'm attempting to customize a wordpress theme. I've added custom field cp_job with form submission. This indicates if the ad is either Buyer(Buying services) or Seller(selling services), which is now ...
0
votes
0answers
13 views

Any way to calculate distance between 2 addresses based on custom fields?

I'm working on a directory database theme, and I wonder if there is any way to calculate distance between 2 addresses or lat/long.... It can be a straight line calculation, and direction (bearing) ...
0
votes
1answer
12 views

How to have WP Search widget index dynamically generated content?

I'm working on an adoption site and the company has a database that contains all their adoptive families. I have a page that contains a small line of shortcode which pulls every family within the ...
0
votes
0answers
16 views

Unable to replace text string across site

There is a text string (a little over 1000 characters with spaces) that needs to be replaced across the entire of my website. The text recurs over 300 times on my site, is identical, and was been ...
0
votes
1answer
10 views

$wpdb variable throw this error Call to a member function get_results() on a non-object in

I've this error "Call to a member function get_results() on a non-object in" from this code: require_once($_SERVER['DOCUMENT_ROOT'] . $folder . '/wp-config.php'); ...
0
votes
0answers
19 views

Preventing concurrent update of data

I have to implement the update of some metadata. An algorithm try alter some global variables in order to minimize a global error function. This algorithm is triggered by users who ratings each other. ...
0
votes
1answer
37 views

List of ways to access WordPress database?

I'm trying to get a complete understanding of how WordPress works with databases. I've read the documentation but I'm getting confused by all the different approaches available. So far my ...
2
votes
2answers
41 views

WordPress unresponsive after calling wp_update_comment()

In the admin panel's "Edit Comment" page, for some reason after I click "Update" the Edit page goes into infinite loop/loading (the spinner icon in the Google Chrome tab never stops spinning). My ...
0
votes
1answer
23 views

How to sort results from a custom database table

I've created a custom WordPress database table which I'm using to store 'likes'. The columns I have are: id post_id user_id I'm now trying to get an array of post IDs that a particular user has ...
0
votes
1answer
44 views

Best way to move live site local

I'm trying to move a big site that's currently live onto my local machine so I can edit locally. I'm using Wamp Server. I've tried using the Duplicator plugin but I'm getting several warnings and ...
2
votes
0answers
64 views

Is there a way to improve or optimize this query_posts query? It's very slow

I have a fairly large database - 113,299 rows in wp_posts and 216,0649 rows in wp_postmeta. There is one custom query that I run after a post is added or edited, which appears in MySQL's slow-log ...
0
votes
1answer
67 views

Create page with custom php script and fetched data

I created WP page and I need to show a table with some information. This information is hold in a database (hosted on the same server). To be more detailed, I'll try to split my question. I'm new to ...
0
votes
1answer
29 views

Which is less DB intensive in the loop: custom taxonomies or meta fields?

If I'm checking for a certain variable for each post in the loop, is it less DB intensive to specify that variable using custom taxonomies or meta fields?
0
votes
0answers
18 views

Get User data from external site

I would like to pull user data into a mobile app. I would create a simple login in the app and send the username and password to my wordpress site. The site would authenticate the user and return user ...
0
votes
1answer
27 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
0answers
3 views

Is it possible to use multiple sub domains using only one WordPress install [closed]

I'm helping a friend of mine with his website, he's an artist and he makes music and films. He wants to have 2 separate websites using sub domains e.g: music.example.com films.example.com I want ...
0
votes
0answers
15 views

Using one WordPress installation for two sub domains

I'm helping a friend of mine with his website. He's an artist and he's making music & films. he wants to have 2 separate website using subdomains. like this : music.hiswebsitename.com ...
0
votes
1answer
28 views

Migrating Multisite - Database error, missing wp_blogs table

I am trying to duplicate my WordPress multisite on local with Xampp, but I get error. This are the steps I follow(I will use example instead of my website name): Copy all WordPress 4.0 files to ...
0
votes
1answer
23 views

No users table in WordPress's database

I am inside a database and there is no users table in it. Is it possible that the site running using WordPress has no users table? Please guide. Thanks.
1
vote
0answers
10 views

Store partial database to an archive database time to time

As the community knows me that I'm not a PHP Developer by core, but trying to be one. With the company I'm working, I developed many WordPress powered News Portals, where- They publish at least 30 - ...
0
votes
2answers
19 views

When creating a metabox do you have to create DB fields for the data?

I'm just getting to grips with metaboxes for the first time and after reading up on them one of the main question i have is do you need to specify fields in the DB to store the data got input. i.e. if ...
0
votes
1answer
33 views

How to write to wp-users table

I'm trying to modify a login plugin to make new users to to enter the display name to show on the site when they register. I know that the display name is located in the wp-users table of the ...
0
votes
0answers
29 views

Manipulate database of WordPress site with my own scripts

I love WordPress as it provides plenty of great themes, good SEO and overall content management. But I'm not always happy with WordPress's original "Add post" and "Edit post" features as it required ...
0
votes
1answer
20 views

How to share User Database between Two Multisite Installations + More

My situation is a bit different to the other questions/answers I have read online here. Currently I have a Wordpress Multisite Installation on Server A. Server A is almost full in terms of ...
0
votes
0answers
44 views

Inserting data into custom tables

I am trying to create custom input tables to send data into custom tables on the wp database. I cannot get my script to do anything. The user will enter a type of liquor, like vodka or whiskey, ...
0
votes
1answer
20 views

Outputting query results

I am trying to make plugin, and i followed codex, i am not a OOP literate, hence i a blank. I tried to run this query $myrows = $wpdb->get_results( "SELECT question FROM wp_quiz" ); while i tried ...
0
votes
0answers
16 views

Possible to remove settings from wp_customize?

So, really basic setting here. function Ari_customize_register( $wp_customize ) { $wp_customize->add_setting('header_position', array()); $wp_customize->add_control('header_position', array( ...
0
votes
0answers
32 views

Is removing orphaned wp_postmeta records safe?

I am using woocommerce as a shopping cart on a wordpress site. Products and Product Variations are each stored as records in the wp_posts table. Each of these Variations have aprox. 15-20 associated ...
0
votes
1answer
24 views

How to create bulk page and content? [closed]

I am creating a website about cars. I want to have a page for each car, with subpages (i.e. Gallery, Specs, etc...) for each car page. I have the content on my hard drive for each car. Doing this ...
0
votes
0answers
13 views

Change Custom Menu Header Manually

I am working on a legacy site and typically don't work with Wordpress, so I'm crashing very hard into the WP world here. Basically, from what I can tell the site has these Custom Menus set up. I want ...
0
votes
2answers
70 views

Storing textbox values in Database

I am new to WordPress but I am good with PHP programmings, if I wanted to get value from the textbox and store it in the database in WordPress can I do? for ex form1.html <form name="form" ...
0
votes
1answer
35 views

How does Wordpress store data?

I have looked inside Wordpress database. Example: In wp_options table, option_name column, active_plugins row, its option_value is ...
1
vote
1answer
28 views

How to prevent/delay MySQL connections when an object cache is used?

We are using an object cache backed by memcached, however I think that WordPress will still connect to MySQL on every page load, which shouldn't be needed if all queries can be handled by the object ...
0
votes
1answer
35 views

Images not showing after moving site

I've tried all the options suggested in other similar questions, and I'm stuck. My images are not showing after moving a site from my local machine to another server. I've searched the database, and ...
0
votes
1answer
23 views

Function to get the name in database table from the comma separated string

I already created admin column in WP using this code: add_filter('manage_pages_columns', 'page_custom_cols', 10); function page_custom_cols($pages_columns, $post_type) { $pages_columns['user_group'] ...
0
votes
0answers
26 views

Convert from .htaccess to web.config?

When I convert to web.config. It shows an error: <rewrite> <!--This directive was not converted because it is not supported by IIS: RewriteBase /.--> <rules> <rule ...
0
votes
1answer
38 views

Help With a Large Wordpress Based MySQL Database on Shared Hosting

I have close to 500K posts in my WordPress database. The site is not yet live, I have the data on my local computer. I was reading about the WOrdpress' https://wordpress.org/plugins/hyperdb/ plugin ...