Can you verify that $_POST[‘name’] is obtaining a value. I suggest echoing it out to the page for debugging (maybe in comment tags if site is live). If $_POST[‘name’] is empty, then all results will be returned because the query will say user_nicename LIKE ‘%’ Just as a precaution in any case, you should do … Read more
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.