So i think I’ve found the answer to my own question. I modified the code in the original tablequerytest.php which queries the custom table and stores results from this: <?php global $wpdb; //Accessing WP Database (non-WP Table) use code below. $results = $wpdb->get_results(‘SELECT alias FROM wp_revslider_sliders’); foreach ($results as $result) { $revchoices = array(“text” => … Read more
I tried this in local, and I think you have multiple fields inside $fields so I’ve added them in array. Just look at the code below; it works fine as tested: add_action(‘your_hook’, ‘createTableFromFields’); function createTableFromFields($tablename) { $wpdb = $this->db; $tablename = $wpdb->prefix . $tablename; $fields = array(‘PersonID’,’LastName’); $sql=”CREATE TABLE IF NOT EXISTS %s (id INT(6) … Read more
Changing sort order for presentation by Jetpack infinite scroll
SQL Database, repeated tables?
Getting too long for a comment, sooo in my super simple test overriding up-sells.php on a fresh WC install with a WP_Query, I can change the orderby and order parameters and the products display in the order of my array of product ids: $meta_query = WC()->query->get_meta_query(); $my_upsells = [171, 170, 172]; $args = array( ‘post_type’ … Read more
To do that with WordPress functions, you can try that $users = get_users(); ?> <table> <tr> <th>Customer Name</th> <th>Customer Details</th> </tr> <?php foreach ($users as $u) {?> <tr> <td> <?php echo htmlspecialchars($u->display_name);?> </td> <td> <?php echo htmlspecialchars($u->description); // retrieve the meta “description”?> </td> </tr> <?php }?> </table> <?php
WordPress Database Huge wp_usermeta Table
dbDelta not creating table (yes, once more)
As noted in the documentation meta_value, when not used inside a meta query, needs to be a string. Normally if you want to query based on multiple meta values you need to add a meta_query argument. But also as noted in the documentation regarding value: It can be an array only when compare is ‘IN’, … Read more
I am not sure why you are creating a UNIQUE constraint for your “ID”, which can be a primary key. Also, please note that the dbDelta fails in certain versions of MariaDB when you create a table with a Unique Key Index or a Composite Key or any other indexes except the Primary Key. The … Read more