Alternative to mysql_real_escape_string

When working with database in WordPress you should never use the low lever mysql_* or mysqli_* functions.

Always use $wpdb methods, in your case you should use prepare():

$query = $wpdb->prepare(
  "SELECT post_title from $wpdb->posts
  WHERE post_title LIKE %s",
  "%" . $myTitle . "%"
);

Moreover, once you are getting a single column, you have easier life using get_col instead of get_results:

$myposttitle = get_col( $query );

Related Posts:

  1. How do you properly prepare a %LIKE% SQL statement?
  2. $wpdb and MySQL Create Trigger
  3. wpdb->prepare function remove single quote for %s in SQL statment
  4. Increment value (value = value+1) of $wpdb->update
  5. wpdb Custom Meta Data with 2 conditions
  6. wpdb prepare syntax
  7. SQL query not working in alphabetical post title/content search
  8. MySQL LIKE not working
  9. Proper way to work with wpdb to get user’s firstname
  10. How to check for empty and not a failure
  11. Database: Custom table: sprintf value for DateTime column
  12. Converting mysql to $wpdb
  13. WP_USE_EXT_MYSQL
  14. wpdb insert and boolean fields
  15. Join new table with SQL query
  16. writing inner join in wpdb
  17. How to split the a table in database?
  18. MySQL Rank & $wpdb
  19. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  20. How do I join a $wpdb query with user meta using default value if not exist?
  21. How to translate this mySQL query to $wpdb query
  22. $wpdb select all meta for each post
  23. $wpdb to insert html form information
  24. Proper usage of $wpdb->update()?
  25. WordPress(wpdb class) and mysql stored procedures
  26. Can’t run database query
  27. Using WPDB->Insert()
  28. Active DB queries in WordPress?
  29. How to stop $wpdb from prepending database name
  30. WordPress $wpdb get posts from category and sort by custom meta
  31. How to get INSERT errors from $wpdb?
  32. Getting Error Trying to Create Table
  33. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  34. Understanding custom php that reads from WP MYSQL
  35. How to insert dash (-) into database using wpdb and new_to_publish hook?
  36. $wpdb->get_var multiple queries in one database check
  37. List users with the most posts in the last 30 days
  38. Insert two row in wordpress database
  39. WordPress $wpdb no result
  40. PHP variables in mysql query
  41. MySQL ‘duplicate entry’ error
  42. User set date and time from frontend doesn’t get stored into database
  43. Wpdb query with dynamic table name
  44. get posts whether meta_key exists or not
  45. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  46. How to search usermeta table
  47. How to add virtual column in wpdb get_result statement
  48. wpdb insert into point column in db
  49. WPDB delivers wrong results from complex queries
  50. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  51. CONCAT_WS in custom sql query
  52. Geographical proximity query using post_meta
  53. MySQL Select within WP Page template
  54. Saving custom term value to the database in new table
  55. why is $wpdb->update() causing a DB error from within wp_set_password()
  56. $wpdb->get_var returns 0
  57. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  58. Not unique table/alias
  59. Install mysql-python (Windows)
  60. MySQL WHERE IN ()
  61. How can I prevent SQL injection in PHP?
  62. Best way to store an array in MySQL database?
  63. How to grant remote access permissions to mysql server for user?
  64. #1062 – Duplicate entry for key ‘PRIMARY’
  65. How can I convert a string to a float in mysql?
  66. Is there a Profiler equivalent for MySql?
  67. How to use greater than operator with date?
  68. How to return number of found rows from SELECT query
  69. How to replace the domain name in a WordPress database?
  70. What causes the “max_user_connections” warning on WordPress frontend?
  71. WordPress Deadlock Error
  72. How to do a MySQL dump from production site without using a search and replace script for local development?
  73. Concurrent / simultaneous MySQL connections
  74. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  75. Advanced SELECT query with condtional statements
  76. Replacing link URL ending strings via MySQL
  77. Problem with admin login after deployment
  78. Find out how many times the user has logged in
  79. Placing a widget with $wpdb query
  80. How can I add a new row in a separate database when someone registers via WordPress?
  81. Get posts from category with custom query
  82. How to use mysql LIKE with wpdb?
  83. Best approach for a custom database filling in WP custom post types
  84. How to use AJAX in WordPress in MYSQL query?
  85. WordPress Insert not working with ajax
  86. Passing in MySQL prepare statement parameter separately throwing error
  87. Database SQL query error
  88. How to Bulk find and replace MySQL for post image url
  89. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  90. update multiple rows in mysqli table base on two values
  91. Not getting ajax success response on insert/update row to database
  92. How can I verify WordPress nonce from the following code?
  93. What is the cron doing?
  94. Apache Redirect based on WordPress permissions
  95. SQL error on restoring database
  96. MySQL database gives blank page (white screen of death)
  97. Datatabase error: Commands out of sync
  98. Global MySQL replacing of text patterns/matches
  99. Why does the MySQL command line tool ignore the –port parameter?
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment