Initial thoughts are that it depends where your load_marque.php file is located. I assume within a theme or plugin. If so, what happens when the file is called directly. If there are some errors, these will be shown on the page. Based on the on here https://codex.wordpress.org/Class_Reference/wpdb your query your query may need to be … Read more
The ID can’t be empty. If you have created your table and set your ID as auto increment, you don’t have to insert it, it will be generated automatically. So all you have to do is the following: $result = $wpdb->insert(‘pagos’, array( “nombre” => $nombre, “tipo” => $tipo, “monto” => $monto), array(“%s”, “%s”, “%d”));
If you suspect content-specific issue, I’d first try to start with clean site and set of test content instead ( official Theme Unit Test data for example). If processing content is indeed at fault this is quite unusual issue. If you can narrow it down to specific function it might be possible to build some … Read more
if i understand correctly you want to get a list of albums (posts) of a specific artist(taxonomy) and that are have ihaveit term. if so the its a simple query using tax_query: $args = array( ‘posts_per_page’ => -1, //get all ‘post_type’ => ‘album’, ‘tax_query’ => array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘artist’, ‘field’ => … Read more
this should work… <?php global $wpdb; $sql = “SELECT comment_ID FROM “. $wpdb->prefix .”comments WHERE comment_parent = 0 AND comment_ID NOT IN(SELECT comment_parent FROM “. $wpdb->prefix .”comments);”; $results = $wpdb->get_results($sql); ?>
You will need to restore the database prefix after using it , with something like this global $wpdb; $previousPrefix=$wpdb->prefix; $wpdb->prefix=”mainsiteprefix_”; //Database access goes here $wpdb->prefix=$previousPrefix; or you can create a new wpdb object like this: $wpdb2 = new wpdb( DB_USER, DB_PASSWORD, DB_NAME, DB_HOST );
$args is a variable and as such should not be wrapped in quotes in the arguments array of query_posts(). Now that should be what’s causing the whole thing to fail. That being said, there are a few more flaws I see in your code: I’d recommend using the WP_Query class instead of query_posts() (why is … Read more
I think you will need to include some type of WP core file into the save.php file (I could be wrong). Since this file isn’t being called specifically by your plugin (or WP for that matter), it won’t have all of the variables that WP has to offer. Try adding this to the top of … Read more
Use switch_to_blog( $new_blog_id ) instead. You can find the function in wp-includes/ms-blogs.php. Update $wpdb->set_blog_id() doesn’t change the global variable $blog_id which is returned by get_current_blog_id(). switch_to_blog() does change the global variable.
In general I try to avoid custom SQL queries as much as i can and use the native WordPress functions but in some cases its much better/faster to use custom queries. if the case is just get a list of posts the you can use the WP_Query or get_posts which will work almost as fast … Read more