is $wpdb->get_results() safe enough

You have to always use $wpdb->prepare() before $wpdb->query() or $wpdb->get_results() if your queries depend on dynamic variables

Related Posts:

  1. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  2. Oracle SQL query for Date format
  3. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  4. Can I have multiple primary keys in a single table?
  5. get_results using wpdb
  6. Database connection close
  7. How to create bulk page and content? [closed]
  8. Importing posts from old website to new conflicting post ID’s?
  9. Transient RSS feeds in wp_options not removed automatically?
  10. Best way to move live site local
  11. The revisions table in my database is at 70% capacity and growing. What should I do?
  12. WordPress for a very large website
  13. How to use multiple database in wordpress?
  14. Database location in WordPress
  15. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  16. WP_list_table bulk_action get edit and delete
  17. How to display data from custom table in wordpress database?
  18. Is removing orphaned wp_postmeta records safe?
  19. Change SQL get_results to search for posts with custom term in custom taxonomy
  20. How to diagnose and keep in check encoding issues?
  21. Add search Value to wp_list_table pagination
  22. stdObject stored in database. How does one convert it to usable format?
  23. I have a table I created, how do I make a form for a user to filter the data?
  24. What ALL can cause “Another update is currently in progress.”? [closed]
  25. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  26. Trigger Plugin database update after git pull
  27. Does WordPress ever need multiple databases?
  28. Why are no posts showing despite my apparently correct DB restoration?
  29. Cannot update custom database table row
  30. SQL Error wp_commentmeta – incorrect table definition
  31. Change WordPress prefix for only one table?
  32. Two websites one database, administrator not working on second website
  33. Multiple wp_options tables to share content across installs
  34. Select two sums with single get_var statement
  35. How to get the SQL of the changes made to the database from an update or upgrade?
  36. How can i add custom fields into the contact form 7 [closed]
  37. Is there a smart way to obtain a list of only some selected user meta data?
  38. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  39. Permit Login if table row exists
  40. Make an Items attribute searchable (taxonomy using existing attribute)
  41. What would Repair and Optimize WordPress Database do?
  42. Store partial database to an archive database time to time
  43. Saving zero as meta value
  44. Migration: Copying database content to a different server
  45. Connection refused on locahost after importing database?
  46. When to use custom DB tables or add_option?
  47. Have working sql query… trying to adjust it to use $wpdb
  48. Best host for running large mem and processor intensive WordPress sites?
  49. Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
  50. In which format the data is stored in WordPress Databases?
  51. creating new field on mysql
  52. Does WordPress store the username as a primary key in the database?
  53. Strange characters added to the database
  54. Is it possible to rebuild the website while not accesseing the original database?
  55. Error message on blog posts only on my local environment [closed]
  56. Database Update Required – Update from command-line
  57. After database migration, theme mods don’t show [closed]
  58. SQL query to set posts in bulk based on the post content
  59. Automate WordPress website setup with prefilled data
  60. Remote database connection and local development
  61. Custom search query by category id
  62. Website displays old version of page
  63. Image link issues after importing a database backup to my local web server
  64. multiple wordpress installs w/shared user database but separate content databases
  65. Updating seperate database when post attachment is changed
  66. add featured image dialog box disappear
  67. Displaying table data on a page
  68. muliple wordpress installs (network) on different databases
  69. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  70. How to get a list of articles related to a particular category from my other WordPress website?
  71. Whats the best practise on how to store json data from a custom settings page?
  72. /wp-admin not accessible after migrating to local host (no plugin issue)
  73. Job and Employee Performance Tracking with Product Safety
  74. set_transient fails if the value has more than 60.000 characters
  75. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  76. error establishing database connection (WAMP + filezilla)
  77. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  78. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  79. How to optimize wp_option table?
  80. How do I update a WordPress wp_postmeta meta_value that contains many options
  81. How can I get $wpdb to show MySQL warnings?
  82. About wp database hooks (error establishing connection)
  83. Database for JQuery Autocomplete field
  84. How to extract some part of WordPress full source code
  85. Create Tables in WordPress
  86. Catchable fatal error in formatting.php
  87. Wrong url for the images while using same database for two WordPress installations
  88. Error establishing a database connection for some files
  89. Hash user emails in database?
  90. WordPress Failed to Login (DB Error)
  91. Share WordPress Database
  92. DB access blocked when initializing WP externally
  93. Saving data to database and exporting to excel
  94. Site does not work right, pages not showing up, even for root admin
  95. ERROR: “Table Prefix” must not be empty
  96. How do you build a database-centric site in WP?
  97. WordPress: Interact with Database Query Data and Login
  98. Attach posts based on category and position
  99. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  100. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
error code: 523