After facing problems with exhausted memory and time consuming queries i’ve tried a different way bulk importing. The idea isn’t new but but to show a possible way i want to share my solution. Keep in mind, i’m not a professional in PHP/MySQL, so maybe there is a more effective or better way to accomplish … Read more
It appears that switch_to_blog might be too unpredictable to rely on for major site design. Here’s my first attempt at a SQL-based solution. function get_intro_post($blogid, $thumb_size=””) { global $wpdb, $post; // Get the system defined table prefix $prefix = $wpdb->prefix; // Create a full table prefix by combining the system prefix with the blogid $tbl … Read more
Simply add an post__not_in argument and use the get_post_thumbnail_id() function. $args = array( ‘post_type’ => ‘attachment’, ‘post_parent’ => $product_id, ‘post_mime_type’ => ‘image’, ‘orderby’ => ‘menu_order’, ‘order’ => ‘ASC’, ‘numberposts’ => -1, ‘post__not_in’ => array(get_post_thumbnail_id($product_id)) ); $attachments = get_posts($args);
You say “However, I know this is not a good way to do this” in your self answer. One thing I could add answering your question and using your answer is, you can use SQL_CALC_FOUND_ROWS with $wpdb $result = $wpdb->get_results( “SELECT SQL_CALC_FOUND_ROWS * FROM `wp_table` WHERE 1 LIMIT 10;” ); $total_count = $wpdb->get_var( “SELECT FOUND_ROWS();” … Read more
$emailusers = $wpdb->get_results( “SELECT p.ID AS post_id, p.post-title, u.user_email ” . “FROM $wpdb->posts AS p ” . “INNER JOIN $wpdb->users AS u ON p.post_author = u.ID ” . “WHERE p.post_type=”sales” AND HOUR( TIMEDIFF( NOW( ) , p.post_date_gmt ) ) >=1)” ); foreach ($emailusers as $user) { // do wp_mail stuff from here // $emailusers->post_title; // … Read more
You Can use This solution.. How to delete all records from or empty a custom database table? In this solution First delete all records an then insert new records (your table should be have records before to delete query because If run $delete you give error ‘No find row’ ) and No need to use … Read more
Should I be creating an interface for my new table? How do I go about that? Unfortunately, there is no interface to implement, you’re going to have to build everything from scratch. This includes: The admin pages The edit screens The saving and updating and deleting All the classes and functions will need building from … Read more
Just to clarify the get_var() method of $wpdb does work just fine in this context: global $wpdb; $helloworld_id = $wpdb->get_var(“SELECT ID FROM wp_posts WHERE post_name=”hello-world””); echo $helloworld_id; Actually it is more practical in this context, because a single variable is returned, which is what is actually wanted.
Assuming that $member_details->user_login is already a user in the wp_users table, then you could use the following to get their email address: $user = get_user_by( $member_details->user_login, ‘login’ ); From there, you have the user’s email address and can use wp_mail() to email them: $subject = “My email subject”; $message = “My message body…”; wp_mail( $user->user_email, … Read more
It is probably better to upgrade the old installation to a current wp version and reapply the changes. Unless it is a very big site you are probably going to waste more time in researching , coding and debugging an automatic solution then what it will take you to manually edit the posts.