This works if add this code in functions.php? if ( ! function_exists( ‘test_setup’ ) ) : function test_setup() { $ar = array( ‘price_content’ => ‘hello’ ); $result = $wpdb->insert(‘hs_prices’, $ar); // insert ‘hello’ into ‘price_content’ } add_action( ‘after_setup_theme’, ‘test_setup’ );
How to add more custom fields in user meta table simultaneously
$leader_result = $wpdb->get_results(“SELECT user_first_name, user_last_name FROM “.$wpdb->prefix.”mro_attendees WHERE event_id = “.$project_id.” AND user_role=”team_leader” LIMIT 0,1″) foreach($leader_result as $row=>$value) { echo $value->column_name; }
Edit your code thusly: $meta_key = ‘agency_email’; $agency_emails = $wpdb->get_col( $wpdb->prepare( “SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = %s”, $meta_key ) ); var_dump( $agency_emails ); foreach ( $agency_emails as $ae ) { echo $ae; }
The ‘wp_insert_post’ action is fired for each post that is inserted and passed the ID of the inserted post to the callback function, so I think your $wpdb query is unnecessary – in fact, I think you’re running the “custom function” portion for all published posts, not just the inserted post (which may or may … Read more
Fire query on ajax post url page
It depends upon the requirement how the form submission entries is going to work afterwards. if you want to collect info from front end and log them to database (with listing in admin panel), separate db table could be the way. if you want to display the data submitted in the form to the front … Read more
You need to use “OR” instead of “AND”, <?php // Get years that have posts $years = $wpdb->get_results( “SELECT YEAR(post_date) AS year FROM wp_posts WHERE post_type=”post” AND (post_status=”publish” or post_status=”future”) GROUP BY year DESC” ); // For each year, do the following foreach ( $years as $year ) { // Get all posts for the … Read more
The Codex is written by humans, so it could be wrong. But what you are missing is the column »Null« beforehand, as you can see it is empty or yes. To determine what that does mean we are taking a look into the source. This you should do first if you are in doubt about … Read more
Please, post your code because the problem is not the one you guessed. Actually, $wpdb is available very early: it is inited by the function require_wp_db() located in the file wp_settings.php at line #79. The hook ‘plugins_loaded’ is fired in the same wp_settings.php file, but at line #237, so pretty after $wpdb is available.