The DB_ constant prefix in WordPress is generally considered reserved for DB_NAME, DB_HOST, DB_USER and DB_PASS. Using it for plugin-specific constants is, in my opinion, not a great idea. The only implication it might pose is if other plugins try to use the constants, but that’s purely theoretical. The proper way to do this is … Read more
Here is exmaple code,You will change as per your requirement $wpdb->query( ” UPDATE $wpdb->posts SET post_parent = 7 WHERE ID = 15 AND post_status=”static” ” );
You need to include the “wp-load.php” file at the top of the code
With everything moving towards OOP programming with classes and the use of objects increasing and favored above the use of arrays as such, I would definitely go with returning results as an object. This just makes everything easier for future use But at the end of the day, you should always use what you are … Read more
I guess you can do with get_users, something like: $topusers = get_users( array ( ‘meta_key’ => ‘todayuserclicks’, ‘meta_value’ => ”, ‘meta_compare’ => ‘!=’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘DESC’, ‘number’ => ’10’, ) );
The table name needs to be in quotes on the line where you’re checking if it exists. I tested it, and after that was fixed, the table was successfully created. Here is the full code: function mm_booking_activate() { global $wpdb; $mm_booking_table_name = $wpdb->prefix . “mm_booking”; $mm_booking_db_version = ‘1.0’; $charset_collate = $wpdb->get_charset_collate(); if ( $wpdb->get_var( “SHOW … Read more
[Note: @marwyk87 posted his answer while I was composing this, which represents another way to fix the problem] You’ve got a simple syntax error in your SQL, because of the way you’re referencing the table name. You should just say $sql = $wpdb->prepare( ” SELECT * FROM {$wpdb->prefix}quotes ORDER BY RAND() LIMIT 1 “); and … Read more
you’ve got a simple typo, it should read $dbresult = $wpdb->update($wpdb->posts, …) ; that is, $wpdb->posts with a ‘s’, instead of `$wpdb->post’.
Here’s your problem: if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $result is not a mysqli_result object, it’s literally the results of the query. Since you never passed a second parameter to the get_results method specifying what format you wanted them in, it’ll assume “OBJECT”, so the correct … Read more
With WordPress to make a custom SQL query, you should always use the dedicated WPDB Class and related methods as get_results(), this way: global $wpdb; $results = $wpdb->get_results( ” SELECT attribute_name FROM {$wpdb->prefix}woocommerce_attribute_taxonomies ” ); if ( count($results) > 0) { $data = []; // Initializing // Loop through results objects foreach( $results as $result … Read more