In the name of bad practices, I’m going to advise that you immediately rule out these using raw SQL queries with remote databases in the same page. It would be slow, insecure, and a hassle to maintain. That you’ve landed yourself in a predicament where a combination of hyperDB+multisite is not an option demonstrates that … Read more
$wpdb counts the queries ran and saves the value in the $num_queries class variable. $num_queries The number of queries that have been executed. https://codex.wordpress.org/Class_Reference/wpdb All you need to do is retrieve it: echo $wpdb->num_queries; You may also be interested in the $queries class variable. $queries You may save all of the queries run on the … Read more
The userid will not exist until the user is inserted, you would need to do a second update for that. You may be better off using PHP’s uniqid(), perhaps with the user’s email as a salt/prefix to avoid a race condition (however unlikely).
Try this: $order_id = 012345; $sql = $wpdb->prepare(“SELECT payStatus FROM test_table WHERE ref = %s”,$order_id);//<– this doesn’t work var_dump($sql); echo ‘<br/>’; $sql = $wpdb->prepare(“SELECT payStatus FROM test_table WHERE ref = %d”,$order_id);//<– this doesn’t work var_dump($sql); echo ‘<br/>’; $sql = $wpdb->prepare(“SELECT payStatus FROM test_table WHERE ref = %f”,$order_id);//<– this doesn’t work var_dump($sql); echo ‘<br/>’; $sql = … Read more
Is this what you’re trying to do? // WP_Query arguments $args = array ( ‘post_type’ => array( ‘project’ ), ‘meta_query’ => array( array( ‘key’ => ‘meta_key’, ‘value’ => ‘%$query%’, ), ), ); // The Query $query = new WP_Query( $args );
You have the following for the table name: $wpdb->prefix . “wp_list_press” Check your actual prefix and table name. In a WP installation using “wp_” as the prefix, the above would result in “wp_wp_list_press”. Is that the table name in the db or is it just “wp_list_press”? If the table in the db is “wp_list_press” then … Read more
It seems that you in your INNER JOIN, you are joining on wp_term_relationships.object_id == wp_posts.post_title which is erroneous, since object_id is the post-id in this case-scenario. I want all IDs (post-ids) SELECT ID FROM $wpdb->posts Who have a record in the wp_term_relationships table // Now we are comparing the correct columns INNER JOIN $wpdb->term_relationships ON … Read more
Use the IN operator for arrays. When using $wpdb->prepare() you don’t have to use quotes around the string placeholder %s. The string placeholder will be quoted automatically. That’s also the reason why you have to take precautions when using $wpdb->prepare() with the IN operator if the array values are strings. This first example doesn’t use … Read more
Read the Codex: The get_var function returns a single variable from the database. Though only one variable is returned, the entire result of the query is cached for later use. Returns NULL if no result is found. <?php $wpdb->get_var( ‘query’, column_offset, row_offset ); ?> So for you its: $name = $wpdb->get_var(“SELECT name FROM testTable WHERE … Read more
You have a problem with your query which is you can’t use GROUP BY and ORDER BY before WHERE replace FROM tablename GROUP BY submit_time ORDER BY submit_time DESC with FROM tablename This is your query $results = $wpdb->get_results( ‘SELECT DATE_FORMAT(FROM_UNIXTIME(submit_time), “%b %e, %Y %l:%i %p”) AS Submitted, MAX(IF(field_name=”Name”, field_value, NULL )) AS “Name”, MAX(IF(field_name=”Email”, … Read more