wpdb

wpdb – SQL/WordPress, checking if column contains specific text (and then getting count) not working

Question

I have a table called wp_rsvp. Within this table I have a column called cot_needed which has the values of "yes" or "no". In my table, I have two rows, one where cot_needed is "yes" and one where cot_ne

Freddy 4 weeks 0 Answers 0 views

php – inner-wrap div pushing custom table far down on page

Question

I am working with code in a custom child-theme. My goal is to pull data from the wpdb and display it as a custom table. I have created and populated the custom wpdb table with the relevant data, and I am creating the table. However, in the parent theme h

user228625 1 month 0 Answers 0 views

mysql – Initialization of table in database using ‘CREATE … IF NOT EXISTS’

Question

Proceeding first plugin installation and activation, I've initialized a table in database for plugin-related data using the statement 'CREATE ... IF NOT EXISTS' : $init_query = 'CREATE TABLE IF NOT EXISTS `' . $this->db_prefix . $table_

brittle_spirit 1 month 0 Answers 0 views

terms – mysql to get related tags of a tag and order by intersection rate?

Question

What I try to do is create a wp plugin to get related tags of a tag and order by intersection rate. For example, in a WordPress site, data structure like below: 40 posts has tags B, 200 posts has tags C

cloudinstone 2 months 0 Answers 0 views

php – How to get data (not value or name) from radio options to POST to database

Question

I have a set of options that are generated based on database count. For example, if a group has 4 members, 4 radio option pairs of yes and no will show: Name 1 - Attending? Yes / No Name 2 - Attending? Yes / No etc

Freddy 2 months 0 Answers 0 views

php – Can’t send form data to wpdb when URL has query string

Question

I see a few issues with the code: First, the form action is not set correctly. It should be something like: <form action="<?php echo esc_url( get_the_permalink() ); ?>" method="post"> In the PHP code, you are using the wrong

Freddy 2 months 0 Answers 0 views

sql – query_vars doesn’t return query string (trying to get data from $wpdb)

Question

I have a ref query string which matches rows in my wp_invites table. In my wp_invites table, I have the following columns: Let's assume here is one of the rows: Lead name: Fred

Freddy 2 months 0 Answers 0 views

wpdb – WordPress Ajax – looping data into a table

Question

Can anyone tell me what I did wrong? I made an ajax call in wordpress to loop through data to display the results on a table. Here is my php: function DisplayInfo() { global $wpdb; $first_name = $_POST['first_name'];

John Lyons 3 months 0 Answers 0 views

How to display inputted data in Ajax without button or click event

Question

I am working with wordpress and using ajax to try and implement some input fields that upon submission show the results below. Is there a way in which one can display new entries submitted by the user without refreshing the page to see the results? Any helpful working examples or docum

John Lyons 3 months 0 Answers 0 views

$wpdb Ajax not redirecting to main page

Question

I'm having difficulty with redirecting a page once a person submits data. I made a form, and when the user clicks 'Add student', the data would be encoded through json, stored in the database. The page would be would be redirected and refreshed by a cust

John Lyons 3 months 0 Answers 0 views