Basic wpdb update question

I think the line should be:

$selected_candidate = $_POST['candidat']; 
=> 
$selected_candidate = $_POST['selectCandidate']

Btw. You are using “prepare” in the wrong way. You are not protecting yourself from sql injections, use it like this:

$wpdb->query( $wpdb->prepare("UPDATE pp_candidates SET candidate_approved = 1  WHERE candidate_ID = %d", $selected_candidate));

Related Posts:

  1. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  2. How to return number of found rows from SELECT query
  3. Can i use php sql functions instead of $wpdb?
  4. $wpdb->delete column values IN ARRAY()?
  5. Custom query to get post names beginning with a digit
  6. Add value to usermeta without removing previous values?
  7. WordPress get pagination on wpdb get_results
  8. How to create and work with custom data / tables (i.e., for arbitrary data)?
  9. Ajax $wpdb not returning table data
  10. Converting MYSQL to WordPress $WPDB
  11. Why is variable not working on custom sql query using wpdb?
  12. Show MySQL errors that occur when I excute $wpdb->insert()
  13. database interactions using OOP
  14. Remove one value in dismissed_wp_pointers?
  15. Can’t get wp_insert_post to work
  16. Accessing data from a non-WP database/table within a page content
  17. WSoD being caused by this piece of code
  18. I want to select the from values from database in WordPress? [closed]
  19. How to check if a meta value has already been assigned to any user?
  20. Update results, Before deleting the related category [closed]
  21. Weird 404 URL Problem – domain name being placed at end of urls
  22. wp query foreach deleting record returning only first or last item
  23. Database query works fine outside WordPress
  24. $wpdb->insert() does not Insert record in a table
  25. Help with a $wpdb MySQL Query
  26. Custom array from a query only write the last row of the query
  27. $wpdb returns duplicate posts
  28. Mixing variables into an array when inserting values
  29. Use $wpdb or other PHP script method to find/replace in WP database
  30. How can I add a new row in a separate database when someone registers via WordPress?
  31. I can’t update my data through $wpdb
  32. Output: “Array”
  33. How to use mysql LIKE with wpdb?
  34. How do I prepare strings for insertions as values into a MySQL table?
  35. How to use AJAX in WordPress in MYSQL query?
  36. form $_post action value gets truncated after it passes through two forms
  37. Why won’t this wpdb get_results query return results?
  38. WPDB secure custom form
  39. Add row to custom database Table and delete all rows older than 1 day
  40. select a single val though a table in wordpress
  41. populate select options from extra mysql table data
  42. Query the links Database
  43. MySQL Query Returns Array () In Shortcode
  44. Passing in MySQL prepare statement parameter separately throwing error
  45. Convert a column of a table containing an Array as response in HTML
  46. Database SQL query error
  47. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  48. Conditional formatting on data fetched from MYSQL
  49. What is the correct way to search 3 custom fields only in WordPress?
  50. Using wpdb to connect to a different database is not working
  51. Rewrite SQL query as a prepared statement and use in foreach loop
  52. Advanced WordPress SQL Query
  53. Add two or multiple functions in WordPress Post or Page
  54. MySQL query in WordPress with AJAX
  55. Passed variable gets undefined variable error on insert on next page
  56. MySQL queries in WordPress
  57. Using the same shortcode to show any table from the database
  58. MySQL database migration to WordPress
  59. Error resetting database index using ALTER TABLE in $wpdb->query
  60. Putting form result in my database
  61. How can I update a value of a field depending on outside source?
  62. Fatal error: Call to undefined function mysql_connect()
  63. Why have on every line
  64. simple wordpress ajax plugin not working when not logged in
  65. Insert post without actions/hooks
  66. Import 10,000 Users into WordPress WITH a specific ID for each user
  67. Query String being Removed Creating a Pagination Issue within a Custom Plugin
  68. Custom Plugin For Converting CSV To MySQL
  69. Trying to establish connection to External Database
  70. Can I install/embed WordPress on a ‘single page’?
  71. $wpdb->update with multiple parameters gives error
  72. Custom posts in different columns style
  73. $wpdb->wp_users returning empty value for
  74. Add data-id attribute to child page links
  75. What file have I to create in my custom WordPress theme to show all the post belonging to a specific category?
  76. Force Users To Relogin
  77. wpdb Cannot Update column in Database
  78. Check class_exists before class definition / Doxygen problem
  79. Extract links from content
  80. Custom Registration username_exists / email_exists
  81. WPDB – Read and write value from / to database
  82. Is it possible to add a custom page to a free WordPress site? [closed]
  83. How to Fix an Archive.php That Displays All Posts?
  84. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  85. WP-Bakery – Add custom colors to buttons with template colors
  86. WordPress low speed after migrating to new host
  87. call to undefined function mysql_connect
  88. How to edit content in WordPress and the Polylang – plugin? – with demosite
  89. Search only for posts with specific metadata?
  90. Is there a way to have chunks of a page’s content expire?
  91. Showing the project type in HREF
  92. My customizer’s setting doesn’t set to the default and needed to click the control’s “Default” button before it’ll be set
  93. Run insert if no entry otherwise run update with ajax
  94. WordPress upload images not displaying
  95. Pagination on Custom Loop
  96. MySQL Engine vs. Charset
  97. Query Concatenation
  98. Display total count of products in orders of a specific order status
  99. inner-wrap div pushing custom table far down on page
  100. running an existing WordPress site from Visual Studio Code?
tech