There are two things wrong. First, you have an error in your SQL syntax. The following do not have a type defined: streetaddress NOT NULL, suburbaddress NOT NULL, postcodeaddress NOT NULL, I would assume these are “text” but MySQL doesn’t know that š So you probably meant them to be: streetaddress text NOT NULL, suburbaddress … Read more
The above code should be placed in a function and then hook that with plugin activation hook? Here’s sample structure of plugin-name.php file. Note – Use CREATE TABLE IF NOT EXISTS instead only create table Code Updated on – 2012-08-04 <?php // this code goes into your my_plugin_name.php file function install_my_plugin() { global $wpdb; $table_name … Read more
The following query works. Note the quotes in AND blog_id != ‘1’ global $wpdb; $query = ” SELECT blog_id FROM $wpdb->blogs WHERE site_id = %d AND public=”1″ AND archived = ‘0’ AND mature=”0″ AND spam = ‘0’ AND deleted = ‘0’ AND blog_id != ‘1’ ORDER BY blog_id ASC”; $blogs = $wpdb->get_col( $wpdb->prepare( $query, $wpdb->siteid) … Read more
Doesn’t look like it’s possible, at least there doesn’t seem to be an elegant way. get_row() invokes query(), which uses mysql_fetch_object() with a single parameter, ie it’s not possible to pass anything to its class_name parameter. So, the only option left would be to extend the wpdb class, implement custom code so that it can … Read more
Logic of my function was all wrong, should have sorted the result in $trans_array before the foreach loop. Here is the updated code that worked, if anyone needs it: function rkm_translation_update() { global $wpdb; $trans_row = $wpdb->get_row(“SELECT * FROM id_item_lid”, OBJECT, 0); $id = $trans_row->id; $item = $trans_row->item_id; $lid = $trans_row->lid; $trans_array = $wpdb->get_results(“SELECT * … Read more
You can join to the comments table and use get_the_ID(): // set the meta_key to the appropriate custom field meta key $meta_key = ‘rating_total’; $ratingtotals = $wpdb->get_var( $wpdb->prepare( ” SELECT sum(cm.meta_value) FROM $wpdb->commentmeta AS cm JOIN $wpdb->comments AS c ON (c.comment_ID = cm.comment_id) WHERE cm.meta_key = %s AND c.comment_post_ID = %d “, $meta_key, get_the_ID() ) … Read more
Try something like this function insert_data_into_table () { global $wpdb; $table_name = $wpdb->prefix . “your_table_name”; //Check if table exists if($wpdb->get_var(“show tables like ‘$table_name'”) != $table_name) : //if not, create the table $sql = “CREATE TABLE ” . $table_name . ” ( (…) ) ENGINE=InnoDB;”; require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’); dbDelta($sql); else: foreach($emails as $mail): $insert = “INSERT … Read more
Upon testing this on my demo site it seems to work perfectly well simply storing DateTime columns as a %s (String). After inserting like this the database reports the DateTime column exactly as expected.
Are you running on Ubuntu? Library libc was recently updated, and if you have unattended-upgrades enabled, that will be the cause. A restart of PHP-FPM, Apache, Nginx will solve it. Even better if you could reboot the entire server to be sure. libc is the C implementation for Linux, and PHP runs on C.
In your first sentence i’m assuming you mean, you have a Custom Post Type (not time). So the post has a package connected, the package has a number of days alive setting. Reading your example code, i think you’re approaching this from the wrong angle. I would do something like this: // I don’t know … Read more