This constant is actually never defined in core code at all. You can define it yourself in wp-config.php configuration if you need to, but core doesn’t need it defined for normal operation. It only exists for re–configuring into running untypical setup.
It may be because group doesn’t exist in the postmeta table. Your meta_key is probably called group and has a meta_value of bicyclegroup. This is assuming you haven’t modified the postmeta table. What you could try is: $sql = “SELECT * FROM $wpdb->postmeta WHERE meta_key = ‘group’ AND meta_value=”$group””; This will return: meta_id post_id meta_key … Read more
I would use a custom query like this: $amsterdamstore_args = array( ‘post_type’ => ‘store’, // This is your custom post type ‘tax_query’ => array( array( ‘taxonomy’ => ‘city’, // This is your custom taxonomy ‘terms’ => ‘Amsterdam’, // The term you search for ‘field’ => ‘name’, // Check against the term’s name (you might use … Read more
You can still use get_posts: $parents = get_posts( array( ‘posts_per_page’ => -1, ‘post_type’ => ‘my_custom_post_type’, ‘fields’ => ‘ids’, // Just get IDs, not objects ‘tax_query’ => array( array( ‘taxonomy’ => ‘my_custom_tax’, ‘field’ => ‘slug’, ‘terms’ => array( ‘foo’, ‘bar’, ), ), ), ) ); $post_ids = get_posts( array( ‘posts_per_page’ => -1, ‘post_parent__in’ => $parents, ‘post_type’ … Read more
Numbered placeholders don’t work as you’d expect, and are going to be removed altogether at some point in the future, so should be considered invalid syntax. So with this in mind, the error describes the problem- your query has 7 placeholders, but you only pass 4 values. For the repeated values, you just need to … Read more
There are several problems with your function. For example, $tablename points to a table that does not exist. And you don’t need it anyway. If you are trying to create a new user if that email does not exist then try this: function register_user() { global $wpdb; $name = $_POST[‘name’]; $email = $_POST[’email’]; $password = … Read more
Read the Codex: The get_var function returns a single variable from the database. Though only one variable is returned, the entire result of the query is cached for later use. Returns NULL if no result is found. <?php $wpdb->get_var( ‘query’, column_offset, row_offset ); ?> So for you its: $name = $wpdb->get_var(“SELECT name FROM testTable WHERE … Read more
You have a problem with your query which is you can’t use GROUP BY and ORDER BY before WHERE replace FROM tablename GROUP BY submit_time ORDER BY submit_time DESC with FROM tablename This is your query $results = $wpdb->get_results( ‘SELECT DATE_FORMAT(FROM_UNIXTIME(submit_time), “%b %e, %Y %l:%i %p”) AS Submitted, MAX(IF(field_name=”Name”, field_value, NULL )) AS “Name”, MAX(IF(field_name=”Email”, … Read more
Found the solution: $currentProducts = $wpdb->get_results(“SELECT feedid, id, size, price FROM products WHERE shopid = $shopid”, OBJECT_K); The OBJECT_K parameter makes an associative array with feedid as key: https://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results
The issue is that in My/SQL table names are not strings. So ‘wp_product_codes’ is being interpreted as a string instead of as an actual table. This is why you usually don’t see tables passed into wpdb::prepare() – you should know the table names as they won’t change where wpdb::prepare() is meant for data that you … Read more