Select query for a login

You can use wp_signon function

Here is an example

    $creds = array();
    $creds['user_login'] = 'example';
    $creds['user_password'] = 'plaintextpw';
    $creds['remember'] = true;
    $user = wp_signon( $creds, false );
    if ( is_wp_error($user) )
        echo $user->get_error_message();

Related Posts:

  1. Select Query demand excesive resources [closed]
  2. Nested select statements not working
  3. How to display SQL query that ran in query?
  4. Get all image from single page using this query
  5. Add multiple value to a query variable in WordPress
  6. How to tune search argument in WP_Query to show only exactly the same results?
  7. Very slow query
  8. Search Terms – Querying on either description__like OR name__like in the same Term Query?
  9. Count user posts by user ID, Post type and Post status
  10. How to get category link without a database query
  11. search through post-type attachments titles
  12. cron job to auto delete posts of a specific post type older than x days
  13. get post id using the $query_vars variable
  14. Most effective use of DB querys
  15. mysql query paging
  16. Is there a conditional tag for latest post or do i need a query?
  17. Two differents queries in archive page
  18. How do I find if a page has a template?
  19. get_posts() loop returns the same the_title() for each post
  20. How to set back query var author_name after unset it?
  21. My SQL function to change user_name
  22. How select a specific query when setting offset?
  23. Change media attachment author via mysql query
  24. Temporarily storing main search result
  25. Help with MySQL to $WPDB query
  26. Ordering by a metadata subfield in WordPress?
  27. sql select query in wordpress ‘page’ [closed]
  28. wpdb->term_taxonomy count posts from both published and private posts?
  29. Query based on title, with ‘compare’ => ‘IN’
  30. Issue with using add_rewrite_rule() for post querying custom fields
  31. Group custom post listing in admin section
  32. Plugin will sort users by usermeta
  33. problem with sql query in wordpress plugin
  34. Attempt to improve WP search, can someone check my SQL query?
  35. Searching With Apostrophe
  36. Multiple Category Query
  37. list all categories that have a certain word in title
  38. Passing parameters to a static front page
  39. wp_list_pages() refuses to output posts
  40. List author’s posts with SQL
  41. Where is the query in wp-login.php
  42. Can’t seem to do combined query AND sort?
  43. Order posts by recent comments
  44. query if page has not child
  45. sort query results by newest
  46. How to reset usual $query on search page to push custom $wpdb query there?
  47. Order by meta value pro first then meta value free in my search function
  48. Order by title – but now built in wordpress func, sort the_title
  49. pre saved posts query from db options table
  50. Custom Query returns array, but I can’t see it’s elements
  51. How to delete all posts, categories and tags from WordPress database
  52. Ideas how to search & replace post_content when string contains a newline?
  53. How to insert Collate into WordPress search query?
  54. Combine “Exclude” Query in functions.php
  55. Query the WordPress database to get data together with replaced information
  56. $wpdb->prepare affecting the query?
  57. WordPress SQL search, how to handle SQL Injection?
  58. Optimize slow SQL query for multiple meta values
  59. prepare function sql safe method
  60. Display posts by combining multiple meta key
  61. Query for Custom Post Type UI Does Not Loop All the Post
  62. Custom select query two tables by a meta key
  63. Updating with $qpdb->query() always returns 0 rows affected
  64. How to manage a particular “order by” for get_search_query()?
  65. Query to view scheduled or draft post
  66. How to return count of custom post type posts with a specific custom field value via $wpdb?
  67. Help with Related Posts Function
  68. Trying to use WP_Query to return post with and without meta values
  69. How to add a Variable to post query
  70. Sort a list of a CPT ( job) if a meta is empty
  71. How to delete all images from code in all post_content
  72. Restrict WordPress search to a single ACF field
  73. SQL query to delete users with multiple meta keys and comments
  74. Restore WordPress Backup Locally?
  75. Trouble migrating custom post types from non-wordpress cms
  76. “order” does not affect order of custom query
  77. Create a new post on a specified publish date via link?
  78. Exclude Posts from a Widget
  79. New custom post type entries are not sorted correctly in admin using pre_get_posts
  80. Query String for the WP_QUERY parameters
  81. $wpdb query for price in custom field value
  82. Run an update query in a function
  83. Add generic page to WP_Query
  84. Advanced Custom Fields Query with Different Values of the Same Key
  85. No results for taxonomy archive page
  86. Multiple terms not working on taxonomy
  87. Sorting of coupons in the right way
  88. excludeCat function reverses order of blog posts
  89. Slow query when joining wp_posts with a lookup-table?
  90. Run search query again without pagination gives no results?
  91. Filter the feed page post limit
  92. Mysql query and odd results
  93. Using wp_list_table how to trigger update function “inline”?
  94. Filter multiple different main queries on custom pages
  95. WP_Query orderby meta key/value suddely stopped working
  96. WP_Query older new links navigation?
  97. Where can I find the SQL to get the most used information by wordpress database?
  98. WooCommerce Total # orders [closed]
  99. How to show sticky posts on all pages of the pagination, not just the first page?
  100. Help with query