You must specify values for column_offset and row_offset. For example: <?php $wpdb->get_var( null, 5, 0 ); ?> Will return “Hello World” (see attached image) But for that to work you had to have a previous query like this: <?php $wpdb->get_var( “SELECT * FROM $wpdb->posts” ); ?>
You’ll find details here: https://gist.github.com/lukecav/05afef12feaf980c121da9afb9291ad5 OR Another approach is https://github.com/woocommerce/woocommerce/wiki/wc_get_orders-and-WC_Order_Query . Use if….else and store order data in Arr[product_id] = OrderArr Kindly accept my answer if it is of any help.
It was my mistake, the loop can be accessed in the admin panel
$_SERVER[‘DOCUMENT_ROOT’]; is not going to include secondsite. So all the files, including wp-config.php with the database details, are coming from the root public directory. To get the current directory, including subdirectories, use any of these: getcwd(); dirname(__FILE__); basename(__DIR__); But if your file is in a deeper folder, you can’t find the secondsite directory without specifying … Read more
I had to load WordPress in order to use the wpdb function. How silly :p. To do so: $parse_uri = explode( ‘wp-content’, $_SERVER[‘SCRIPT_FILENAME’] ); require_once( $parse_uri[0] . ‘wp-load.php’ ); And then finally: global $wpdb;
(See comments) $wpdb->insert( ‘produse’, array( ‘id’ => $post_id, ‘pret’ => $produs[‘pret’], ‘gramaj’ => $produs[‘gramaj’], ‘numar_produs’ => $produs[‘numar_produs’] ), array( ‘%d’, ‘%s’, ‘%s’, ‘%d’ ) );
I see no reason why $_POST[‘delete’] should not be set assuming there are no page redirects involved. I can’t tell from your code if that is the case, but it superficially appears not to be. I do see other potential problems. You are setting your form action to an empty string. While that does sometimes … Read more
I’m not allowed to comment to ask for more information but try putting global $wpdb; on the line after the public function fetch($tableName,$where=””,$orderField=””,$groupByField=””,$sqlAddon=””){ line
Perhaps info on this page might help: http://codex.wordpress.org/Class_Reference/wpdb Other than that I would do the usual troubleshooting to start. Backup everything. Turn off all plugins. Switch to a standard WordPress theme like 2015. Then see what errors you are getting now that you have stripped down your install. Then slowly turn things back on until … Read more
Your problem is the constants OBJECT_K. In the documentation you can read that this constant ensures that duplicate keys are discarded. From the wordpress codex entry: Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants. With one of the first three, return an array of rows indexed from 0 by SQL result row number. … Read more