If you are merely trying to get a count, $wpdb->get_var(); along with using COUNT() in your sql will be better: ### Search for IP in database function postviews_get_ip($id, $ip) { global $post, $wpdb; $rowcount = $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->wp_postviews_ips WHERE postid = $id AND ip = ‘$ip'”); return $rowcount; } postviews_get_ip($id, $_SERVER[‘REMOTE_ADDR’]); //both $id and … Read more
You can look at the docs, but you’ll probably end up reading the real documentation: the source code. If you do, you’ll find that: GFFormsModel::get_leads($form_id) returns a list of entries for a form (maybe you know that one already), where each item in the array is itself an array, an “Entry object“ GFFormsModel::get_form_meta($form_id) returns a … Read more
In the wp_options table there is a record where option_name = “permalink_structure”. However, the true, ultimate control of url rewriting is controlled by the WP_Rewrite API which saves/caches its information in the rewrite_rules wordpress option (also found in the wp_options table). EDIT: Also, when editing a page/post, you can change the “permalink” for that page/post … Read more
I finally found the custom post type data. It is stored in the wp_post table where post_type = custom post type (e.g. “products”). The field (column) data is stored in wp_postmeta where the meta_key is the column name and meta_value is the column value. This query will bring back all data associated with the custom … Read more
See the Codex’s WordPress Taxonomy documentation. WordPress 2.3 replaced the previous categories, post2cat, and link2cat tables with three a more flexible set of taxonomy tables. wp_terms wp_term_relationships wp_term_taxonomy wp_terms– holds the basic information about single terms. term_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) NOT NULL default ”, slug varchar(200) NOT NULL default ”, term_group … Read more
I asked this question over a year ago, and during that time we’ve added more people to our team and developed a much larger number of sites in WordPress. I wanted to walk through our process in case it might help anyone else. Everything in Git This was something I was doing even as I … Read more
First, you are using prepare incorrectly. You seem to have $wpdb->update‘s arguments wrapped in $wpdb->prepare like that. That won’t work. In effect, you are passing update a single argument– the output of prepare. Try something simple like the following and you will see why that won’t work: $post_id = 123; $item_stock = 567; var_dump( $wpdb->prepare( … Read more
Well, if I take the hat of a WP script kiddie, my answer would be: use post_meta, always. However, I happen to know a thing or two about databases, so my answer is: never, ever, ever, use an EAV (aka the post_meta table) to store data that you might to need to query. On the … Read more
Every post update in WordPress is handled by the wp_update_post function. This function has some defaults, and for post_content_filtered the default value is ” (empty string). Once the defaults are merged with args passed to function via wp_parse_args it means that every time a post is updated and post_content_filtered is not explicitly passed, it is … Read more
There are 3 options from easiest –> Use only one remote database that you all connect to with lots of backups. That way you just have to worry about files and not the db. Use the import and export functionality built into WordPress and throw it into your version control right into the wp root … Read more