Can’t successfully check if post with title exist in database

You have typing mistake. You are using the double quotation mark instead of single quotation mark at the end of the code post_status = "publish"

Please use post_status="publish" instead of post_status="publish" and then use double quotation mark at the end of query.

And also make sure that dynamic values are correctly entered in the query by printing the query before execution.

Related Posts:

  1. How to return number of found rows from SELECT query
  2. what is the use of /wp-includes/SimplePie?
  3. Inserting dynamic content into a page
  4. Check if post of title already exists
  5. How to export/import theme customizer settings?
  6. $wpdb->delete column values IN ARRAY()?
  7. Inserting choice in database table
  8. WP API V2 returning Invalid User ID
  9. How To Make Connection To WordPress Data Base In A Plugin?
  10. Has anyone tried putting PHP ActiveRecord on WordPress?
  11. How to auto login user again after change user_login
  12. Export User Info to CSV from Front End
  13. WordPress admin never finishes saving page on site with large page count
  14. Retrieving and Displaying Data From a Table
  15. Duplicate domain database to local – How?
  16. error importing localhost export file to server
  17. How to sort results from a custom database table
  18. How can I call a row of user specific data from a custom table added to the WP Database
  19. How to merge local and live databases?
  20. How to track a users progress through pages by inserting data into WordPress Database?
  21. WPDB: how to get the value of a field in a custom database table
  22. Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  23. Access/update database with jQuery
  24. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  25. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  26. How to create and work with custom data / tables (i.e., for arbitrary data)?
  27. Add custom php database code above
  28. wp_insert_post not working
  29. Prevent Data Resubmission On Page refresh
  30. SQL QUERY – Select a value directly from the database
  31. Any possible way to make $wpdb->get_results() return anything else than array?
  32. database interactions using OOP
  33. Transferring working local PHP site to wordpress – with database (MySQL)
  34. Accessing the database from a plugin outside of action hooks
  35. Getting id of poll from WP database
  36. Storing Array from returned database query and using the array in a new query
  37. WordPress not reflecting changed of the database
  38. How does WordPress know wich language is chosen when there is a database connection error
  39. How can I save unique user data on my site? [closed]
  40. Dynamic content in template
  41. Using custom tables for old posts
  42. Databases – Submitting data from inputs to database [closed]
  43. db converts decimal number wrong
  44. Is it best to avoid using $wpdb for security issues?
  45. How can I import an excel column into wordpress database?
  46. WordPress Block developer from exporting Database via PHP
  47. Execute a function every hour in the background
  48. Create page with custom php script and fetched data
  49. Should I use WordPress to skin a database website?
  50. How do I display offsite database info on my wordpress site?
  51. Creating Database Table vs. Adding MetaData to Post & User
  52. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  53. Most commented posts by time period (last 12h, last 24h and etc)
  54. Cant connect to database with php 7.3
  55. How to get image from url from the database?
  56. Set default Database Storage Engine when creating tables with plugins?
  57. Wpdb get->results to out the the month from the db
  58. Filter results from a serialized string to use on statistics
  59. How to add data to a custom field at the wp_users table?
  60. Creating custom page template from existing PHP site
  61. wordpress site – using custom database and PHP
  62. SQL error with custom query
  63. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  64. Change wordpress’ database data using ajax – how to get current user id?
  65. Error establishing a database connection (Set-up locally)
  66. add role on WordPress in PHP on a second database
  67. Create a new account on site B with data from the purchase of site A
  68. How to search order using database frontend short code WordPress
  69. Limiting posts based on nested meta_query
  70. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  71. wp_update_post gives 500 internal error
  72. Unable to insert two value in two different columns (WordPress database)
  73. Retrieving and Displaying Data From a Table
  74. why not selecting multiple rows of same standard_id using SQL query from database?
  75. Using custom php to connect to database blocks wp from accessing galery pictures
  76. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  77. Updating the database after parsing CSV document
  78. getting the values of hidden inputs to use them in a php mysql query
  79. wp-login.php?redirect_to=https problem
  80. Front end/Database connection in WP
  81. Issue in url update when using wordpress update query
  82. can’t delete a row from post_meta table
  83. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  84. AJAX Not Working With WordPress Database properly
  85. How to fetch results from database
  86. Manipulate database of WordPress site with my own scripts
  87. How to connect database table to each registered wordpress user.
  88. Problems with plugin that fetches data from database with ajax
  89. Let users register weight each day and save it in DB
  90. Query specific posts per user selections from dropdown menus
  91. Create an unique ID number after submit form
  92. Fetching wpdb data from a php file seems to break?
  93. How to pass username into form that sends data to database
  94. Insert into db with foreach problem
  95. Create custom table for wordpress custom registration flow
  96. Custom form that stores data in mysql database
  97. How to get data (not value or name) from radio options to POST to database
  98. How to get the last date updated of postmeta?
  99. Putting form result in my database
  100. Bulk data save in custom table