sql - Read For Learn

Adding profile data to database

To show extra fields in profile, use this hook: function myplugin_show_profile_extra_fields( $user ) { // echo your extra fields here } add_action( ‘show_user_profile’, ‘myplugin_show_profile_extra_fields’ ); add_action( ‘edit_user_profile’, ‘myplugin_show_profile_extra_fields’ ); And to save extra fields use following hook: function myplugin_save_profile_extra_fields( $user_id ) { if ( !current_user_can( ‘edit_user’, $user_id ) ) { return false; } update_usermeta( $user_id, … Read more

The page that displays Posts on homepage

The way you are thinking wordpress is, is not like that. You can’t find the query and alter it like you do in plain PHP. There are filters and actions and a whole architecture to play with pages and posts. I suggest you to read wordpress documentation and Codex. If you are a programmer then … Read more

SQL command to export post_content from wp_posts using phpMyAdmin

Use This Script <?php $servername = “localhost”; $username = YOUR_USER; $password = YOUR_PASSWORD; $dbname = YOUR_DB_NAME; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die(“Connection failed: ” . $conn->connect_error); } $a1 = ($_GET[‘id’]); $sql = “SELECT post_content FROM `wp_posts` where ID=’$a1′”; $result = $conn->query($sql); if ($result->num_rows > … Read more

If meta_key exists then don’t select this post?

There are a few ways you could do it- NOT IN, NOT EXISTS, IS NULL. Which method is best depends on your actual query. SELECT * FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = ‘somekey’ WHERE $wpdb->postmeta.post_id IS NULL

Get all the related data from WordPress DB

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

SQL Query : how copy all tags of post into their post content in wordpress by sql query

You can simply preprocess the content by adding a filter to the_content like that: function wpse_337486( $content ) { if ( is_single() ) { // Get the current post. global $post; // Get all post tags. Get only their names. $tags = wp_get_post_tags($post->ID, [‘fields’ => ‘names’]); // Append post tags to content. $content = $content … Read more

SQL query add only posts with custom field to array

Why don’t you just do: <?php global $post; $args = array( ‘post_type’ => ‘post’, ‘post_status’ = ‘publish’, ‘posts_per_page’ => ’10’, ‘meta_query’ => array( array( ‘key’ => ‘fruit’, ‘value’ => ‘apple’ ) ) ); $custom_query = new WP_Query( $args ); while( $custom_query->have_posts() ): $custom_query->the_post(); ?> <?php the_title(); ?> <?php endwhile; wp_reset_query(); ?>

query using wpdb in wordpress gets me no result

First of all, you escape that query incorrectly… You should use esc_like on the like part and prepare should be used a little bit different: $title1 = ‘Gocomma 10W QI Wireless Fast Charger Car Mount Holder – 2pcs (it)’; $sql = $wpdb->prepare( “SELECT * FROM {$wpdb->posts} WHERE post_title LIKE %s AND post_status=”publish””, ‘%’ . $wpdb->esc_like($title1) … Read more

wpdb prepare without placeholder

Short answer: You should use the way described in the documentation, sanitize anything that goes in an SQL query, and always use prepared statements. Slightly longer answer: The main use of $wpdb->prepare() is to prevent against SQL injection attacks. Here, we don’t know where ‘foo’, 1337 and ‘%bar’ come from. And that’s somewhat the deciding … Read more

SQL to transform all email addresses in my DB in lowercase [closed]

This is probably what you want: update wp_users set user_email = lower(user_email) where user_email is not null; However I’m surprised you need this: WordPress’s default collation is case-insensitive.

+ More