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 do I make an HTML table from a database table?
  2. Inserting dynamic content into a page
  3. Check if post of title already exists
  4. $wpdb->delete column values IN ARRAY()?
  5. Does WordPress cache get_user_meta() results?
  6. Export User Info to CSV from Front End
  7. WordPress admin never finishes saving page on site with large page count
  8. Retrieving and Displaying Data From a Table
  9. Refresh page after update_post_meta
  10. Search and Replace in database: How to replace data in SQL dump file on Windows?
  11. error importing localhost export file to server
  12. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  13. How to sort results from a custom database table
  14. Why WordPress uses 4 tables to manage terms
  15. WP database error for comments_popup_link()
  16. No wp-config.php file on local install of wordpress – site still displays
  17. How to create Sub Sub domain Multi User blogs?
  18. How to find the output of contact form 7 shortcode? [closed]
  19. Issue with foreach on duplicate meta_key’s
  20. Different database query in function.php using mysqli
  21. How to generate page content from database the right way?
  22. Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
  23. Store and Work with huge array in WP [closed]
  24. Adding Custom Forms
  25. Why is the post meta[] empty when I make a call to the wordpress rest api?
  26. Is it necessary to sanitize wp_set_password user input?
  27. database interactions using OOP
  28. Accessing the database from a plugin outside of action hooks
  29. Trying to establish connection to External Database
  30. Create WP_Query to search for posts by their categories or their parent/child categories
  31. How to save checkbox values for logged in users?
  32. Update results, Before deleting the related category [closed]
  33. How WordPress reacts to a lack of memory of the server [closed]
  34. Split reads to a different connection string
  35. custom user role wordpress – grant guest access to edit.php without insert/update/delete
  36. Execute long and heavy processes
  37. database sent to a JSON file
  38. inserting a post from an extern php file but post content doesn’t show on wp site
  39. Databases – Submitting data from inputs to database [closed]
  40. db converts decimal number wrong
  41. Filtering a Database Query
  42. Is it best to avoid using $wpdb for security issues?
  43. Blob file download problem
  44. How to retrieve the data from the sever and displaying it in a page?
  45. wpdb prepare insert table doesn’t work
  46. Should I use WordPress to skin a database website?
  47. Creating Database Table vs. Adding MetaData to Post & User
  48. How can I find the cause of a 500 server error?
  49. I can’t update my data through $wpdb
  50. Lost in trying to create user database system
  51. Delete database record using plugin from admin panel
  52. How to get image from url from the database?
  53. Wpdb get->results to out the the month from the db
  54. Filter results from a serialized string to use on statistics
  55. How to add data to a custom field at the wp_users table?
  56. Creating custom page template from existing PHP site
  57. wordpress site – using custom database and PHP
  58. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  59. Add row to custom database Table and delete all rows older than 1 day
  60. Using PHP Code Snippets to query a database, $dbconnection->get_results is outputting nothing
  61. Database entry removed on browser refresh, Ajax PHP jQuery
  62. Please help! I have a problem with getting wordpress databas
  63. Change wordpress’ database data using ajax – how to get current user id?
  64. Error establishing a database connection (Set-up locally)
  65. add role on WordPress in PHP on a second database
  66. Limiting posts based on nested meta_query
  67. Preserving backslashes in post_content
  68. Error establishing a database connection (configuration)
  69. Retrieving and Displaying Data From a Table
  70. Using custom php to connect to database blocks wp from accessing galery pictures
  71. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  72. Updating the database after parsing CSV document
  73. How do I fetch a data from an external database into my wordpress homepage
  74. Full search and replace isn’t enough to make all pictures to be loaded with https
  75. How to display post_content from database in different on template page?
  76. Generate random access token to a post page
  77. Issue in url update when using wordpress update query
  78. direct query to post_meta table
  79. can’t delete a row from post_meta table
  80. special characters not supporting in wordpress
  81. How to set max users to 17.000
  82. How to fetch results from database
  83. Unserializeing multiple column values that are stored in one database results variable
  84. Best way to define a database with product codes and back-end support?
  85. How to connect database table to each registered wordpress user.
  86. Querying multiple meta_keys in WordPress SQL query
  87. Trying to post information from a remote database to wordpress page
  88. Create an unique ID number after submit form
  89. PHP Call to External Database
  90. How do I empty a specific meta_value for all users in PHP
  91. Create custom table for wordpress custom registration flow
  92. Custom form that stores data in mysql database
  93. How to get data (not value or name) from radio options to POST to database
  94. Creating a table via dbDelta
  95. wpbd to connect to a VPS mysql database
  96. Retrieve data from external database and insert back in
  97. How to get the last date updated of postmeta?
  98. Putting form result in my database
  99. Issue with WordPress Plugin Activation Hook and Table Creation
  100. How to improve the performance when using a flat-file dataset and PHP for implementing advanced search function?