You are usgin an undefined $post->ID variable because there is no reference to any $post object in your code; instead, use the $post_ID variable retrieved in the function: function on_jobs_publish( $post_ID ) { global $wpdb; $wpdb->insert( ‘iCrewzWp_postmeta’, array( ‘post_id’ => $post_ID, ‘meta_key’ => ‘_yoast_wpseo_sitemap-include’, ‘meta_value’ => ‘always’ ), array( ‘%d’, ‘%s’, ‘%s’ ) ); } … Read more
Try this. Hopefully I’ve interpreted your output correctly. I’d recommend a good read of the $wpdb codex, particularly in relation to the get_col() method – http://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Column global $wpdb; // You won’t need this unless this code is within a function $query = $wpdb->prepare( ‘SELECT %1$s.guid FROM %1$s’, $wpdb->posts ); $results = $wpdb->get_col($query); $counter = 1; … Read more
You have a problem with your code formatting and syntax at the very least: function ref_access(){ global $error; if (is_user_logged_in()) // <– problem here… $newdb = new wpdb( ‘user’, ‘pass’, ‘db’, ‘localhost’ ); global $newdb; $hf_username = wp_get_current_user(); $inputValue = $_POST[$quanid]; $wpdb->insert( $table, array( ‘ItemID’ => $quanid ‘Price’ => $inputValue ‘user’ => $hf_username ), ); … Read more
prepare() is used to escape the values for example in the WHERE-statement. Usually it is anticipated the table selection is “hardcoded”. If you can’t use for example $wpdb->posts or the other “table”-functions, you could whitelist the allowed tables and check if $table_name is on this white list: <?php $allowed_tables = array( $wpdb->prefix . ‘nametbl’, $wpdb->prefix … Read more
You just need to add a DISTINCT to your SQL query, something like: $cities = $wpdb->get_col(“SELECT DISTINCT(meta_value) FROM $wpdb->usermeta WHERE meta_key = ‘my_cities_meta_key'” ); Alternatively, if you want to do it with php for some reason (if you want to know that a city is listed twice before displaying only unique entries) $cities = $wpdb->get_col(“SELECT … Read more
The function you are looking for is wp_update_post(). You would want to have your posts which you want to update, then set up a loop to update each one individually. // However you get your posts, ID’s, etc. $posts = get_posts( array( ‘post_type’ => ‘post’ ) ); for ( $posts as $post ) { wp_update_post( … Read more
In your code, if an email is set and validated (which I suppose should be the normal case), your code will exit at wp_die(), and never reaches the $wpdb->insert. Your $wpdb->insert statement will only ever be reached if an email is not set, or if “validation” is false. You might want to get rid of … Read more
Sounds like you are trying hard to shot yourself and you will likely succeed. Every framework has its own assumptions and limitation so if the assumptions of wordpress do not fit your needs then just don’t use wordpress for the project. If you (ok, probably the client) have decided that for reasons of cost, delivery … Read more
Just separate query with ; as if you would be writting them in the normal sql editor. it should work. I assume your query are not reading query (returning results). they should be for CREATE, UPDATE, DELETE, ALTERsuch kind of queries not SELECT
The first problem I spotted is that you aren’t setting $latest_pollid but you are nonetheless trying to use that as the poll id. You should have something like: $latest_pollid = polls_latest_id(); before that line in order to set the value. There are big problems with what you are doing though. Hooking to after_setup_theme means that … Read more