I want to select the from values from database in WordPress? [closed]

Read the wpdb docs and don’t forget to protect your query:

global $wpdb;
$table_name = $wpdb->prefix . "item"; 
$login_name = sanitize_user( $_POST['login_name'] ); //assuming you're dealing with username

$prepare = $wpdb->prepare( "SELECT * FROM $table_name WHERE uname = %s", $login_name );

$myrows = $wpdb->get_results( $prepare );

//output results
echo '<pre>' . print_r( $myrows, true ) . '</pre>';

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->delete column values IN ARRAY()?
  4. Custom query to get post names beginning with a digit
  5. WordPress get pagination on wpdb get_results
  6. Ajax $wpdb not returning table data
  7. Converting MYSQL to WordPress $WPDB
  8. Why is variable not working on custom sql query using wpdb?
  9. Show MySQL errors that occur when I excute $wpdb->insert()
  10. Can’t get wp_insert_post to work
  11. WSoD being caused by this piece of code
  12. Update results, Before deleting the related category [closed]
  13. wp query foreach deleting record returning only first or last item
  14. Database query works fine outside WordPress
  15. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  16. $wpdb->insert() does not Insert record in a table
  17. Help with a $wpdb MySQL Query
  18. Custom array from a query only write the last row of the query
  19. $wpdb returns duplicate posts
  20. Mixing variables into an array when inserting values
  21. Use $wpdb or other PHP script method to find/replace in WP database
  22. How can I add a new row in a separate database when someone registers via WordPress?
  23. Basic wpdb update question
  24. I can’t update my data through $wpdb
  25. Output: “Array”
  26. How to use mysql LIKE with wpdb?
  27. How do I prepare strings for insertions as values into a MySQL table?
  28. How to use AJAX in WordPress in MYSQL query?
  29. form $_post action value gets truncated after it passes through two forms
  30. Why won’t this wpdb get_results query return results?
  31. WPDB secure custom form
  32. Add row to custom database Table and delete all rows older than 1 day
  33. select a single val though a table in wordpress
  34. populate select options from extra mysql table data
  35. Query the links Database
  36. MySQL Query Returns Array () In Shortcode
  37. Passing in MySQL prepare statement parameter separately throwing error
  38. Convert a column of a table containing an Array as response in HTML
  39. Database SQL query error
  40. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  41. Conditional formatting on data fetched from MYSQL
  42. What is the correct way to search 3 custom fields only in WordPress?
  43. Using wpdb to connect to a different database is not working
  44. Rewrite SQL query as a prepared statement and use in foreach loop
  45. Advanced WordPress SQL Query
  46. MySQL query in WordPress with AJAX
  47. Passed variable gets undefined variable error on insert on next page
  48. MySQL queries in WordPress
  49. Using the same shortcode to show any table from the database
  50. MySQL database migration to WordPress
  51. Error resetting database index using ALTER TABLE in $wpdb->query
  52. Putting form result in my database
  53. How can I update a value of a field depending on outside source?
  54. Custom SQL query to get List of posts with featured image url
  55. Delete post revisions on post publish
  56. Problems migrating WordPress to localhost
  57. How to display only first value of database column in WordPress
  58. database interactions using OOP
  59. How to display data from custom table in wordpress phpmyadmin
  60. How WordPress reacts to a lack of memory of the server [closed]
  61. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  62. Using custom tables for old posts
  63. Multiple meta_key in one global $wpdb;
  64. WordPress member notification
  65. Moving wordpress site from localhost to live server using GoDaddy cPanel
  66. How does WP work in conjunction with a web server?
  67. Location of core code for database connection and get_header
  68. Wpdb->insert() doesn’t insert new row after the last one
  69. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  70. Most commented posts by time period (last 12h, last 24h and etc)
  71. How to get specific attribute from DB
  72. Hide posts if user is added to it WP_query
  73. How to unserialize data from MySQL
  74. PHP -> SQL Query with Summing
  75. How to insert wp_users ->user login name to wp_terms when a new user registering?
  76. Known Issues in WordPress When Upgrading PHP to ver 7
  77. Change MySQL PDO connection to a WPDB connection
  78. $wpdb->get_results breaking page?
  79. Get the id of the row from database on click of a button [closed]
  80. Call to a member function get_row() on a non-object, Unable to use global $wbdp inside a plugin
  81. SQL error with custom query
  82. Modify WooCommerce used to get all orders in dashboard
  83. WordPress SQL Prepare
  84. Weird fonts showing which are coming from database
  85. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  86. WordPress Bad Request Error 400
  87. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  88. cant insert data in a custom table in phpmyadmin
  89. autocomplete in wordpress using ajax with json-data
  90. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  91. Query doesn’t display text data with apostrophes
  92. I want show only data for today
  93. SQL Query Search page
  94. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  95. Get null from POST
  96. How to pass username into form that sends data to database
  97. Insert into db with foreach problem
  98. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  99. inner-wrap div pushing custom table far down on page
  100. running an existing WordPress site from Visual Studio Code?