I have a site with many users and many of them have the same last name. I want to get the emails of all the users with the same last name (IE: Smith) that has a post related to a particular taxonomy term (IE: Baseball). So far I have this code that works great in … Read more
I’m using the following code to create the database table using plugin. However, the table is neither getting created nor I’m getting any error message. The code is as follows: global $wpdb; $table_name = “tbllb_club”; $sql = “create table $table_name ( club_id int(11) NOT NULL auto_increment, project_name varchar(500) NOT NULL, first_name varchar(100) NOT NULL, school_status … Read more
I found this really cool function to list all the blogs on a multisite network install. Because the original multisite list blogs function was depreciated :/ So I am using this function below which is great because it is so flexible. But the only thing I can’t seem to work out is how to re-order … Read more
Is it possible to make wpdb->get_row return an object of a my own custom class instead of stdClass? 2 Answers 2 Doesn’t look like it’s possible, at least there doesn’t seem to be an elegant way. get_row() invokes query(), which uses mysql_fetch_object() with a single parameter, ie it’s not possible to pass anything to its … Read more
I am migrating non-wp database to WordPress (for the first time in my life, and hopefully the last). As both new and old websites are multilingual, one of the tasks for me is to connect the articles with its translations. I am using WPML plugin for multi language support on WordPress. This plugin creates a … Read more
I have a comment meta field that displays a rating for each comment, I was wondering if there is any way I can query the database to get the sum total of these ratings for each post. I have included the following code in my single.php, but it obviously gives the total from all the … Read more
Hi i am trying to insert data in database but $wpdb->insert insert two rows. my code for insert data is global $wpdb; $tablename = $wpdb->prefix . ‘<TABLE NAME>’; for ($i = 0; $i < sizeof($emails); $i++) { $data = array(“post_id” => $post_id, “user_id” => $user_id, “email” => $emails[$i], “status” => 1 ); $wpdb->insert($tablename, $data); } … Read more
I am creating an insert query following the insert example on the wpdb class reference. What sprintf like placeholder should be used for a DateTime column on a custom table? Allowed placeholders seem to be %s (string), %d (integer) and %f (float). In my example below I have set the DateTime column to use a … Read more
Closed. This question is off-topic. It is not currently accepting answers. Questions that are too localized (such as syntax errors, code with restricted access, hacked sites, hosting or support issues) are not in scope. See how do I ask a good question? Closed 5 years ago. Improve this question new in wordpress world. My wordpress … Read more
I have a custom post time that has an expiration date. The expiration date is derived by getting the package_type pf the post (each package type has a different number of days before expiration, referred to as “Alive days”), extracting the value for alive_days, and adding that to the post_date. I’m wondering if there’s a … Read more
