mysql query – how to escape apostrophe?

Use esc_html() when outputting a string value inside tags. Use esc_attr() when you’re outputting a string value inside an attribute="". If you’re outputting a URL, use esc_url() instead of those two.

if ($tenantsInfo) {
        foreach ($tenantsInfo as $tenant) { 
           echo "<h2>Welcome, " . esc_html( $tenant->tenant_name ) . "</h2>";
        }
}

Related Posts:

  1. Multipart/formatted MySQL query problem
  2. wpdb COALESCE won’t work
  3. Get posts from category with custom query
  4. Valid SQL query return empty
  5. Updating with $qpdb->query() always returns 0 rows affected
  6. How to return count of custom post type posts with a specific custom field value via $wpdb?
  7. WordPress Mysql query and Duplicate
  8. Help with Related Posts Function
  9. Mysql query and odd results
  10. Return only Count from a wp_query request?
  11. Differences between wpdb->get_results() and wpdb->query()
  12. simple sql query on wp_postmeta very slow
  13. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  14. wpdb get posts by taxonomy SQL
  15. How many WordPress SQL Queries per page?
  16. Custom $wpdb Query for Custom Post Type by Category
  17. Can’t pass table to $wpdb->prepare
  18. Are database queries created using WordPress filters protected from SQL injection?
  19. Most effective use of DB querys
  20. Grouping related postmeta data via SQL query
  21. Mysql / WordPress killing my server with 80k users [closed]
  22. Slow meta_query with about 4 milion record on wp_postmeta
  23. wpdb::prepare() isn’t working
  24. Select User by Joining Multiple Meta Value Results
  25. mySQL query. ORDER BY meta_key
  26. Strange string in console from wpdb query
  27. Using $wpdb->update but confused on the WHERE in and SET
  28. Update slug (URL) of pending posts via phpMyAdmin
  29. My SQL function to change user_name
  30. You have an error in your SQL syntax – Help with query
  31. What’s wrong with my $wpdb prepare?
  32. Make one query for adding entries to database
  33. Why is variable not working on custom sql query using wpdb?
  34. MySQL variable in query
  35. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  36. Alter a specific query on WordPress
  37. how would I create a custom query to get all users, and a related post based on a postmeta field?
  38. Help with MySQL to $WPDB query
  39. SQL query to select posts from multiple categories
  40. Alter query with posts_clauses to retrieve NULL values last
  41. wpdb->term_taxonomy count posts from both published and private posts?
  42. wpdb print all post meta
  43. Plugin will sort users by usermeta
  44. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  45. MySql Query very slow
  46. Searching With Apostrophe
  47. wpdb query problem to access previous 3 days posts
  48. WordPress Query wp-terms SLOW
  49. How to write: $wpdb->update having WHERE NOT value pair in the array
  50. Use mysql_query instead of $wpdb query
  51. Custom Query – Based on user input
  52. Custom WordPress Table wpdb
  53. Custom SQL Query passing array to WHERE p.id
  54. Best practice to limit results in get_row()?
  55. Placing a widget with $wpdb query
  56. Custom Query returns array, but I can’t see it’s elements
  57. how to insert missing tags into the posts through mySQL?
  58. Ideas how to search & replace post_content when string contains a newline?
  59. Query Column of Specific ID from Database Table
  60. Query the WordPress database to get data together with replaced information
  61. $wpdb->prepare affecting the query?
  62. Optimize slow SQL query for multiple meta values
  63. prepare function sql safe method
  64. WordPress Insert not working with ajax
  65. wpdb update multiple row?
  66. Formatting a date/time returned from a custom $wpdb query
  67. Improve performance of slow query
  68. How to delete all images from code in all post_content
  69. How do I get specific readable results from this query and array results
  70. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  71. Displaying data from custom table
  72. Get 2 meta values from meta key column
  73. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  74. SQL query to delete users with multiple meta keys and comments
  75. OR condition not working
  76. Trouble migrating custom post types from non-wordpress cms
  77. implementing my wp_query using $wpdb class
  78. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  79. Exclude Posts from a Widget
  80. Fastest and most efficient SQL query to check if UID exists
  81. How to make MySQL search queries with quotes
  82. Use $wpdb->get_results with filter based on array
  83. $wpdb query for price in custom field value
  84. Display result from custom post meta query
  85. Wpdb empty result only if language is Russian
  86. Run an update query in a function
  87. How to fix this insert? Don’t work for me!
  88. Function returning queried meta value based on current post ID
  89. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  90. Update vs Insert logic but the last key is always inserted?
  91. Custom MySQL Query for Post and Post Meta
  92. $wpdb: how to use a query as a base for another query?
  93. Wpdb generates too many queries
  94. Custom Query for searching through custom fields
  95. Access Tables with number prefix
  96. How to reference same column name but different table in custom db query
  97. Retrieving custom field array value through db query
  98. How to get one result using wpdb class?
  99. Delete query won’t run
  100. update $wpdb one query