SQL errors when querying for something with apostrophes

Using the wpdb::prepare() method is recommended for creating queries properly and avoiding SQL injection.

For a basic solution, use the addslashes() function, but this is not sufficient for preventing SQL injection.

See Mysql + php with special characters like ‘(Apostrophe) and ” (Quotation mark).

Related Posts:

  1. Advanced SELECT query with condtional statements
  2. Custom WordPress Table wpdb
  3. Best practice to limit results in get_row()?
  4. Query Column of Specific ID from Database Table
  5. WordPress Database Query works in phpMyAdmin but not in the code
  6. Using wpdb to connect to a separate database
  7. get_results using wpdb
  8. How to fetch Data in WordPress using MySQLi or $wpdb
  9. wpdb->insert multiple record at once
  10. How to define composite keys with dbDelta()
  11. Export wordpress table to excel
  12. Inserting Post Meta From SQL
  13. Why does dbDelta() not catch MysqlErrors?
  14. What causes the “max_user_connections” warning on WordPress frontend?
  15. Change all http to https in mysql databse?
  16. WooCommerce – Query for ordered products
  17. How to execute mulitple statement SQL queries using $wpdb->query?
  18. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  19. Database slowdown after update to 3.4.1
  20. Query WordPress database by registered date and role
  21. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  22. Select Multiple meta_value from WP DB; Single Query
  23. wpdb_prepare with multiple or condition
  24. WordPress database error – Error in SQL syntax – I can’t identify any error?
  25. CRUD operations using WordPress database API
  26. Select two sums with single get_var statement
  27. Redirecting to old domain after migration website
  28. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  29. Create table from array with prepare
  30. How Can I Put Meta_Compare in the Database-Query?
  31. WordPress running SQL query to update database from form
  32. Query multiple tables at once?
  33. Have working sql query… trying to adjust it to use $wpdb
  34. $wpdb->query can’t insert data
  35. Trouble running $wpdb->query() with last_insert_id
  36. Connecting to a different database
  37. SQL query to set posts in bulk based on the post content
  38. How to create more than one new wpdb object?
  39. How to connect and insert data in database of wordpress?
  40. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  41. How to insert a value to decimal type field using wpdb->prepare?
  42. Insert NULL value using prepare()
  43. “BS_” rows in postmeta table
  44. Where is the HTML-handler part in the wpdb class?
  45. insert data from a form:: Warning Empty query mysqli::query()
  46. How can I get $wpdb to show MySQL warnings?
  47. How To connect to the same WordPress database with different database user
  48. Should I Use only wpdb Class to Write Custom Queries?
  49. using same mysql user with many databases
  50. Pulling values from a sepcific row in table
  51. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  52. Uploading to WordPress Database
  53. Generating an HTML table from an array based on dynamic key values
  54. How to extract some part of WordPress full source code
  55. Mysql Queries per Visit – Crazy High
  56. Call to a member function insert()
  57. Missing latest posts and options after DB migration via phpMyAdmin
  58. I have include wp-config, should I add global $wpdb also?
  59. Processing a lot of $wpdb isn’t insert all the data
  60. wpdb get_results() returns only 2 rows
  61. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  62. Get multisite count without php?
  63. WP_Query always returning the last custom post
  64. Check if a database is well installed
  65. Create a new table on the database and save parameters from a contact form
  66. live site do not update after importing sql database
  67. Function returning queried meta value based on current post ID
  68. Why is converting my database to UTF-8 truncating entries?
  69. Widgets with *internal* links do not display after database migration
  70. Write mysql credentials in plugin
  71. How do i get value from wp_postmeta?
  72. How can I retrieve data from alternate database using wpdb class?
  73. “MySQL server has gone away” since update to 3.8
  74. Why are my WordPress post queries so slow?
  75. featured image not showing up with mysql_connect
  76. Creating Tables in WordPress Database
  77. MySQL Database User: Which Privileges are needed?
  78. Import Excel (or csv) Table with user-data as subscribers to wordpress
  79. Using class id from array for query
  80. Inserting into data into external DB using WPDB
  81. MySQL database migration to WordPress
  82. Print output of Table Creation
  83. Mysql query and odd results
  84. Insert Extra fields added in the front end registration form to DB
  85. How to back-up a database on IIS
  86. How to use remote db tables in current config? [duplicate]
  87. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  88. export individual posts to text files or a single csv file
  89. $wpdb->insert not working for last select option
  90. SQL query : Select a thumbnail for a media
  91. $wpdb->prepare returns empty array
  92. How to delete field using WPDB?
  93. PHP Warning: Error while sending QUERY packet
  94. database search feature
  95. Importing Concrete5 content to WordPress
  96. Custom wordpress SQL statement for a website
  97. why you don’t Implement PDO for access every thing to database
  98. SQL query to rewrite all media URLs to end with .webp
  99. How do I find users by password?
  100. WordPress database connection failed, while mysql client is working [closed]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)